contig_metadata
22 rows where 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 | |
| 8100719 | 8100719 | PRJNA474911_P_NODE_7367_length_207_cov_0.876712_g7240_i0 | PRJNA474911 | 7367 | 207 | 0.876712 | 1.81479384 | Magnoliopsida | 3398 | Plants | Plants | 108 | 1.53e-25 | NR | KAK9683990.1 | 3572 | g7240 | i0 | 73.1 | 24.3188405797101 | 67 | 18 | 97.1 | 0 | 6 | 206 | 295 | 361 | KAK9683990.1 hypothetical protein RND81_10G179400 [Saponaria officinalis] | diamond | 5034 | 108 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Saponaria | Saponaria officinalis | |
| 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 | |
| 15125024 | 15125024 | PRJNA474911_P_NODE_5532_length_240_cov_1.072626_g5405_i0 | PRJNA474911 | 5532 | 240 | 1.072626 | 2.5743024 | Selaginella moellendorffii | 88036 | Plants | Plants | 92.4 | 6.1e-20 | NR | XP_002985543.1 | 88036 | g5405 | i0 | 60.6 | 4.625 | 71 | 28 | 88.8 | 0 | 213 | 1 | 181 | 251 | XP_002985543.1 obg-like ATPase 1 [Selaginella moellendorffii] | diamond | 1110 | 92.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 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 | |
| 17024903 | 17024903 | PRJNA474911_P_NODE_7354_length_207_cov_0.876712_g7227_i0 | PRJNA474911 | 7354 | 207 | 0.876712 | 1.81479384 | Magnoliopsida | 3398 | Plants | Plants | 114 | 8.72e-31 | NR | XP_062169893.1 | 3517 | g7227 | i0 | 75.4 | 7 | 69 | 17 | 100 | 0 | 1 | 207 | 28 | 96 | XP_062169893.1 small ribosomal subunit protein eS19x [Alnus glutinosa] | diamond | 1449 | 114 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Alnus | Alnus glutinosa | |
| 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 | |
| 29019024 | 29019024 | PRJNA474911_P_NODE_7168_length_208_cov_0.870748_g7041_i0 | PRJNA474911 | 7168 | 208 | 0.870748 | 1.81115584 | Asteraceae | 4210 | Plants | Plants | 53.9 | 2.64e-6 | NR | XP_023756589.1 | 4236 | g7041 | i0 | 52.9 | 5.8125 | 51 | 24 | 73.6 | 0 | 200 | 48 | 972 | 1022 | XP_023756589.1 uncharacterized protein LOC111905146 [Lactuca sativa] | diamond | 1209 | 54.3 | 0.992633517495396 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Lactuca | Lactuca sativa | |
| 29065894 | 29065894 | PRJNA474911_P_NODE_8268_length_201_cov_0.914286_g8141_i0 | PRJNA474911 | 8268 | 201 | 0.914286 | 1.83771486 | Striga asiatica | 4170 | Plants | Plants | 84.7 | 3.01e-19 | NR | GER57402.1 | 4170 | g8141 | i0 | 71.2 | 1.80597014925373 | 59 | 17 | 88.1 | 0 | 182 | 6 | 4 | 62 | GER57402.1 60S ribosomal protein L31 [Striga asiatica] | diamond | 363 | 84.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Striga | Striga asiatica | |
| 29871268 | 29871268 | PRJNA474911_P_NODE_2011_length_440_cov_1.823219_g1886_i0 | PRJNA474911 | 2011 | 440 | 1.823219 | 8.0221636 | Eukaryota | 2759 | Plants | Plants | 157 | 7.56e-45 | NR | BBG98548.1 | 3755 | g1886 | i0 | 61.4 | 49.9704545454545 | 140 | 53 | 95.5 | 1 | 440 | 21 | 28 | 166 | BBG98548.1 Translation protein SH3-like family protein [Prunus dulcis] | diamond | 21987 | 158 | 0.993670886075949 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus dulcis | |
| 30534670 | 30534670 | PRJNA474911_P_NODE_4813_length_262_cov_1.258706_g4686_i0 | PRJNA474911 | 4813 | 262 | 1.258706 | 3.29780972 | Eukaryota | 2759 | Plants | Plants | 82 | 5.98e-18 | NR | XP_024369179.1 | 3218 | g4686 | i0 | 58 | 9.76717557251908 | 88 | 34 | 97.3 | 2 | 256 | 2 | 4 | 91 | XP_024369179.1 60S ribosomal protein L36-2-like [Physcomitrium patens] | diamond | 2559 | 82 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 30771540 | 30771540 | PRJNA474911_P_NODE_7934_length_203_cov_0.901408_g7807_i0 | PRJNA474911 | 7934 | 203 | 0.901408 | 1.82985824 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 97.4 | 3.71e-24 | NR | BAF17818.2 | 39947 | g7807 | i0 | 70.1 | 6.91625615763547 | 67 | 20 | 99 | 0 | 1 | 201 | 47 | 113 | BAF17818.2 Os05g0490800, partial [Oryza sativa Japonica Group] | diamond | 1404 | 97.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 32305689 | 32305689 | PRJNA474911_P_NODE_4339_length_279_cov_1.628440_g4212_i0 | PRJNA474911 | 4339 | 279 | 1.62844 | 4.5433476 | Eukaryota | 2759 | Plants | Plants | 101 | 8.52e-25 | NR | KAB1201704.1 | 262757 | g4212 | i0 | 56.3 | 2.96774193548387 | 96 | 35 | 100 | 3 | 279 | 1 | 58 | 149 | KAB1201704.1 60S ribosomal protein L21-2 [Morella rubra] | diamond | 828 | 101 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Myricaceae | Morella | Morella rubra |
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);;