contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA474911" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1097069 | 1097069 | PRJNA474911_P_NODE_2901_length_357_cov_3.783784_g2775_i0 | PRJNA474911 | 2901 | 357 | 3.783784 | 13.50810888 | Arachis | 3817 | Plants | Plants | 654 | 0 | NTclustered | gi|1666234238|ref|XR_003816680.1| | 3818 | g2775 | i0 | 99.721 | 100.280112044818 | 358 | 0 | 100 | 1 | 1 | 357 | 2197 | 1840 | PREDICTED: Arachis hypogaea 28S ribosomal RNA (LOC114926237), rRNA | blastn | 35800 | 654 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea | |
| 1722394 | 1722394 | PRJNA474911_P_NODE_6022_length_228_cov_8.473054_g5895_i0 | PRJNA474911 | 6022 | 228 | 8.473054 | 19.31856312 | Solanum tuberosum | 4113 | Plants | Plants | 422 | 1.34e-113 | NTclustered | gi|971579642|ref|XR_001471816.1| | 4113 | g5895 | i0 | 100 | 100 | 228 | 0 | 100 | 0 | 1 | 228 | 42 | 269 | PREDICTED: Solanum tuberosum uncharacterized LOC107058159 (LOC107058159), ncRNA | blastn | 22800 | 422 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum tuberosum | |
| 2372558 | 2372558 | PRJNA474911_P_NODE_2522_length_389_cov_4.402439_g2396_i0 | PRJNA474911 | 2522 | 389 | 4.402439 | 17.12548771 | Magnoliopsida | 3398 | Plants | Plants | 691 | 0 | NTclustered | gi|2839189697|ref|XR_011219724.1| | 4081 | g2396 | i0 | 98.715 | 1132.23136246787 | 389 | 5 | 100 | 0 | 1 | 389 | 1870 | 1482 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138347010), rRNA | blastn | 440438 | 697 | 0.991391678622669 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 2998367 | 2998367 | PRJNA474911_P_NODE_7943_length_203_cov_0.901408_g7816_i0 | PRJNA474911 | 7943 | 203 | 0.901408 | 1.82985824 | Lolium rigidum | 89674 | Plants | Plants | 370 | 4.3e-98 | NTclustered | gi|2212483262|ref|XM_047224862.1| | 89674 | g7816 | i0 | 99.507 | 6 | 203 | 1 | 100 | 0 | 1 | 203 | 601 | 803 | PREDICTED: Lolium rigidum disease resistance protein RGA2-like (LOC124691572), transcript variant X6, mRNA | blastn | 1218 | 370 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium rigidum | |
| 3648205 | 3648205 | PRJNA474911_P_NODE_3603_length_313_cov_8.873016_g3477_i0 | PRJNA474911 | 3603 | 313 | 8.873016 | 27.77254008 | Eukaryota | 2759 | Plants | Plants | 579 | 1.0899999999999999e-160 | NTclustered | gi|2217019617|ref|XR_007051663.1| | 4072 | g3477 | i0 | 100 | 101 | 313 | 0 | 100 | 0 | 1 | 313 | 733 | 1045 | PREDICTED: Capsicum annuum 18S ribosomal RNA (LOC124895330), rRNA | blastn | 31613 | 579 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 4925221 | 4925221 | PRJNA474911_P_NODE_6844_length_211_cov_1.280000_g6717_i0 | PRJNA474911 | 6844 | 211 | 1.28 | 2.7008 | Eukaryota | 2759 | Plants | Plants | 58.4 | 3.98e-4 | NTclustered | gi|1063459948|ref|XM_018118745.1| | 3641 | g6717 | i0 | 100 | 32.6255924170616 | 31 | 0 | 15 | 0 | 178 | 208 | 1681 | 1711 | PREDICTED: Theobroma cacao uncharacterized CRM domain-containing protein At3g25440, chloroplastic (LOC18612619), transcript variant X1, mRNA | blastn | 6884 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Theobroma | Theobroma cacao | |
| 11300311 | 11300311 | PRJNA474911_P_NODE_5869_length_232_cov_2.695906_g5742_i0 | PRJNA474911 | 5869 | 232 | 2.695906 | 6.25450192 | Solanum | 4107 | Plants | Plants | 429 | 8.2e-116 | NTclustered | gi|2839189697|ref|XR_011219724.1| | 4081 | g5742 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 2646 | 2415 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138347010), rRNA | blastn | 23200 | 429 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 12576055 | 12576055 | PRJNA474911_P_NODE_6870_length_210_cov_9.134228_g6743_i0 | PRJNA474911 | 6870 | 210 | 9.134228 | 19.1818788 | Magnoliopsida | 3398 | Plants | Plants | 385 | 1.5999999999999995e-102 | NTclustered | gi|2646016675|ref|XR_009883389.1| | 3486 | g6743 | i0 | 100 | 99.0571428571429 | 208 | 0 | 99 | 0 | 1 | 208 | 1435 | 1642 | PREDICTED: Humulus lupulus 18S ribosomal RNA (LOC133811861), rRNA | blastn | 20802 | 388 | 0.992268041237113 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 12576058 | 12576058 | PRJNA474911_P_NODE_7570_length_205_cov_1.555556_g7443_i0 | PRJNA474911 | 7570 | 205 | 1.555556 | 3.1888898 | Magnoliopsida | 3398 | Plants | Plants | 379 | 7.229999999999999e-101 | NTclustered | gi|1502965506|gb|MH603429.1| | 4634 | g7443 | i0 | 100 | 195 | 205 | 0 | 100 | 0 | 1 | 205 | 110175 | 110379 | Monocostus uniflorus voucher Zomlefer et al 2337 (FTG, GA, NY) isolate 2000-894H plastid, partial genome | blastn | 39975 | 379 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Costaceae | Monocostus | Monocostus uniflorus | |
| 15125022 | 15125022 | PRJNA474911_P_NODE_5392_length_244_cov_2.098361_g5265_i0 | PRJNA474911 | 5392 | 244 | 2.098361 | 5.12000084 | Myrtaceae | 3931 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2577862750|ref|NC_082025.1| | 178175 | g5265 | i0 | 100 | 4.86885245901639 | 29 | 0 | 12 | 0 | 25 | 53 | 9330 | 9302 | Syzygium australe chloroplast, complete genome | blastn | 1188 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Myrtaceae | Syzygium | Syzygium australe | |
| 16399661 | 16399661 | PRJNA474911_P_NODE_7473_length_206_cov_0.882759_g7346_i0 | PRJNA474911 | 7473 | 206 | 0.882759 | 1.81848354 | Poaceae | 4479 | Plants | Plants | 52.8 | 0.018 | NTclustered | gi|1897958810|ref|XR_004853261.1| | 4577 | g7346 | i0 | 100 | 0.679611650485437 | 28 | 0 | 14 | 0 | 152 | 179 | 182 | 209 | PREDICTED: Zea mays uncharacterized lncRNA (LOC118473579), transcript variant X2, ncRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 22124082 | 22124082 | PRJNA474911_P_NODE_2818_length_365_cov_2.855263_g2692_i0 | PRJNA474911 | 2818 | 365 | 2.855263 | 10.42170995 | Medicago truncatula | 3880 | Plants | Plants | 52.8 | 0.035 | NTclustered | gi|164498918|gb|AC183430.31| | 3880 | g2692 | i0 | 100 | 0.23013698630137 | 28 | 0 | 8 | 0 | 125 | 152 | 89972 | 89999 | Medicago truncatula chromosome 8 clone mth2-176i20, complete sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Medicago | Medicago truncatula | |
| 23399871 | 23399871 | PRJNA474911_P_NODE_4159_length_286_cov_1.133333_g4032_i0 | PRJNA474911 | 4159 | 286 | 1.133333 | 3.24133238 | Cucumis sativus | 3659 | Plants | Plants | 228 | 4.0899999999999984e-55 | NTclustered | gi|1784860984|ref|XM_004138916.3| | 3659 | g4032 | i0 | 88.021 | 66.8986013986014 | 192 | 23 | 67 | 0 | 1 | 192 | 1038 | 847 | PREDICTED: Cucumis sativus elongation factor 1-alpha (EF1), mRNA | blastn | 19133 | 228 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis sativus |
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);;