contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax_phylum = "Nematoda"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4848057 | 4848057 | PRJNA1102048_P_NODE_7584_length_315_cov_2.933884_g7480_i0 | PRJNA1102048 | 7584 | 315 | 2.933884 | 9.2417346 | Caenorhabditis | 6237 | Nematoda | Nematoda | 63.9 | 1.36e-5 | NTclustered | gi|1972228534|ref|NM_001316854.4| | 6239 | g7480 | i0 | 95 | 0.495238095238095 | 40 | 2 | 13 | 0 | 33 | 72 | 47 | 86 | Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.2), mRNA | blastn | 156 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9948190 | 9948190 | PRJNA1102048_P_NODE_8408_length_299_cov_3.628319_g8304_i0 | PRJNA1102048 | 8408 | 299 | 3.628319 | 10.84867381 | Metazoa | 33208 | Nematoda | Nematoda | 191 | 5.65e-44 | NTclustered | gi|1376154927|ref|XM_024651418.1| | 34506 | g8304 | i0 | 81.435 | 163.227424749164 | 237 | 40 | 79 | 4 | 34 | 268 | 235 | 1 | Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA | blastn | 48805 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15514451 | 15514451 | PRJNA1102048_P_NODE_9773_length_281_cov_1.326923_g9669_i0 | PRJNA1102048 | 9773 | 281 | 1.326923 | 3.72865363 | Micoletzkya palliati | 1250334 | Nematoda | Nematoda | 165 | 3.19e-36 | NTclustered | gi|410992319|gb|JX163988.1| | 1250334 | g9669 | i0 | 84.118 | 3.90391459074733 | 170 | 27 | 60 | 0 | 65 | 234 | 170 | 1 | Micoletzkya palliati large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 1097 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Micoletzkya | Micoletzkya palliati |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;