contig_metadata
17 rows where bioproject = "PRJNA383995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3626525 | 3626525 | PRJNA383995_P_NODE_17663_length_163_cov_0.894737_g17564_i0 | PRJNA383995 | 17663 | 163 | 0.894737 | 1.45842131 | Triticum | 4564 | Plants | Plants | 248 | 1.61e-61 | NTclustered | gi|300681419|emb|FN564427.1| | 4565 | g17564 | i0 | 94.41 | 27.0736196319018 | 161 | 9 | 100 | 0 | 2 | 162 | 590177 | 590337 | Triticum aestivum chromosome 3B-specific BAC library, contig ctg0079b | blastn | 4413 | 250 | 0.992 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 3626541 | 3626541 | PRJNA383995_P_NODE_9663_length_209_cov_2.468750_g9564_i0 | PRJNA383995 | 9663 | 209 | 2.46875 | 5.1596875 | Vigna | 3913 | Plants | Plants | 387 | 4.42e-103 | NTclustered | gi|2688570838|gb|CP144689.1| | 3915 | g9564 | i0 | 100 | 157.052631578947 | 209 | 0 | 100 | 0 | 1 | 209 | 1386921 | 1387129 | Vigna mungo isolate Urdbean chloroplast, partial sequence | blastn | 32824 | 387 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna mungo | |
| 5508962 | 5508962 | PRJNA383995_P_NODE_17605_length_163_cov_0.894737_g17506_i0 | PRJNA383995 | 17605 | 163 | 0.894737 | 1.45842131 | Oryza sativa | 4530 | Plants | Plants | 300 | 4.39e-77 | NTclustered | gi|30725921|gb|AC099043.6| | 39947 | g17506 | i0 | 100 | 6.20245398773006 | 162 | 0 | 99 | 0 | 2 | 163 | 70206 | 70045 | Oryza sativa chromosome 3 BAC OSJNBa0079B15 genomic sequence, complete sequence | blastn | 1011 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 9333359 | 9333359 | PRJNA383995_P_NODE_6248_length_254_cov_1.180488_g6149_i0 | PRJNA383995 | 6248 | 254 | 1.180488 | 2.99843952 | Ananas comosus | 4615 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|1885257722|emb|LR862139.1| | 296719 | g6149 | i0 | 100 | 0.114173228346457 | 29 | 0 | 11 | 0 | 5 | 33 | 19294046 | 19294018 | Ananas comosus var. bracteatus genome assembly, chromosome: 11 | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 11883968 | 11883968 | PRJNA383995_P_NODE_7270_length_237_cov_1.803191_g7171_i0 | PRJNA383995 | 7270 | 237 | 1.803191 | 4.27356267 | Cannabis sativa | 3483 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2748541248|gb|CP158646.1| | 3483 | g7171 | i0 | 100 | 0.379746835443038 | 30 | 0 | 13 | 0 | 119 | 148 | 75903640 | 75903611 | Cannabis sativa cultivar ERBxHO40_23 chromosome 3 | blastn | 90 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 13159003 | 13159003 | PRJNA383995_P_NODE_19171_length_161_cov_0.910714_g19072_i0 | PRJNA383995 | 19171 | 161 | 0.910714 | 1.46624954 | Allium sativum | 4682 | Plants | Plants | 171 | 3.54e-38 | NTclustered | gi|2221770600|gb|MK770769.1| | 4682 | g19072 | i0 | 93.103 | 0.720496894409938 | 116 | 8 | 72 | 0 | 1 | 116 | 116 | 1 | Allium sativum satellite AsatSAT189 sequence | blastn | 116 | 171 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Amaryllidaceae | Allium | Allium sativum | |
| 13829288 | 13829288 | PRJNA383995_P_NODE_9731_length_209_cov_1.093750_g9632_i0 | PRJNA383995 | 9731 | 209 | 1.09375 | 2.2859375 | Poaceae | 4479 | Plants | Plants | 52.8 | 0.018 | NTclustered | gi|1897958810|ref|XR_004853261.1| | 4577 | g9632 | i0 | 100 | 0.669856459330144 | 28 | 0 | 13 | 0 | 155 | 182 | 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 | |
| 16378297 | 16378297 | PRJNA383995_P_NODE_18433_length_162_cov_0.902655_g18334_i0 | PRJNA383995 | 18433 | 162 | 0.902655 | 1.4623011 | Poaceae | 4479 | Plants | Plants | 300 | 4.36e-77 | NTclustered | gi|2155905707|emb|OV049916.1| | 4529 | g18334 | i0 | 100 | 101 | 162 | 0 | 100 | 0 | 1 | 162 | 49167 | 49006 | Oryza rufipogon genome assembly, organelle: plastid:chloroplast | blastn | 16362 | 300 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza rufipogon | |
| 16378299 | 16378299 | PRJNA383995_P_NODE_18993_length_161_cov_0.910714_g18894_i0 | PRJNA383995 | 18993 | 161 | 0.910714 | 1.46624954 | Magnoliopsida | 3398 | Plants | Plants | 298 | 1.56e-76 | NTclustered | gi|2646016675|ref|XR_009883389.1| | 3486 | g18894 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 1452 | 1612 | PREDICTED: Humulus lupulus 18S ribosomal RNA (LOC133811861), rRNA | blastn | 16100 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 18256770 | 18256770 | PRJNA383995_P_NODE_13195_length_181_cov_1.515152_g13096_i0 | PRJNA383995 | 13195 | 181 | 1.515152 | 2.74242512 | Triticum aestivum | 4565 | Plants | Plants | 335 | 1.36e-87 | NTclustered | gi|2123746588|ref|XR_006435168.1| | 4565 | g13096 | i0 | 100 | 2 | 181 | 0 | 100 | 0 | 1 | 181 | 5608 | 5428 | PREDICTED: Triticum aestivum homeobox protein cut-like 1 (LOC123072473), transcript variant X4, misc_RNA | blastn | 362 | 335 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 18256782 | 18256782 | PRJNA383995_P_NODE_16555_length_165_cov_0.879310_g16456_i0 | PRJNA383995 | 16555 | 165 | 0.87931 | 1.4508615 | Cicer arietinum | 3827 | Plants | Plants | 305 | 9.59e-79 | NTclustered | gi|1535865752|ref|XM_004494231.3| | 3827 | g16456 | i0 | 100 | 53.3393939393939 | 165 | 0 | 100 | 0 | 1 | 165 | 105 | 269 | PREDICTED: Cicer arietinum 60S ribosomal protein L35a-1-like (LOC101514440), mRNA | blastn | 8801 | 305 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Cicer | Cicer arietinum | |
| 22081734 | 22081734 | PRJNA383995_P_NODE_18558_length_162_cov_0.902655_g18459_i0 | PRJNA383995 | 18558 | 162 | 0.902655 | 1.4623011 | Malus domestica | 3750 | Plants | Plants | 52.8 | 0.013 | NTclustered | gi|2810943380|gb|CP168778.1| | 3750 | g18459 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 18 | 45 | 20799741 | 20799714 | Malus domestica cultivar Golden Delicious chromosome 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 24631669 | 24631669 | PRJNA383995_P_NODE_18280_length_162_cov_0.902655_g18181_i0 | PRJNA383995 | 18280 | 162 | 0.902655 | 1.4623011 | Triticum monococcum | 4568 | Plants | Plants | 246 | 5.76e-61 | NTclustered | gi|2581912921|emb|OY737857.1| | 4568 | g18181 | i0 | 98.561 | 121.493827160494 | 139 | 2 | 86 | 0 | 24 | 162 | 33139502 | 33139364 | Triticum monococcum genome assembly, chromosome: UA | blastn | 19682 | 246 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum monococcum | |
| 29253885 | 29253885 | PRJNA383995_P_NODE_6869_length_244_cov_1.041026_g6770_i0 | PRJNA383995 | 6869 | 244 | 1.041026 | 2.54010344 | Tarenaya hassleriana | 28532 | Plants | Plants | 45.8 | 0.00199 | NR | XP_010548418.1 | 28532 | g6770 | i0 | 37.2 | 0.959016393442623 | 78 | 39 | 92.2 | 3 | 237 | 13 | 100 | 170 | XP_010548418.1 PREDICTED: protein DCL, chloroplastic-like [Tarenaya hassleriana] | diamond | 234 | 45.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Cleomaceae | Tarenaya | Tarenaya hassleriana | |
| 29411887 | 29411887 | PRJNA383995_P_NODE_17749_length_163_cov_0.894737_g17650_i0 | PRJNA383995 | 17749 | 163 | 0.894737 | 1.45842131 | Vitis vinifera | 29760 | Plants | Plants | 63.5 | 5.8e-10 | NR | RVW92637.1 | 29760 | g17650 | i0 | 64.3 | 5.50306748466258 | 42 | 15 | 77.3 | 0 | 1 | 126 | 722 | 763 | RVW92637.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Vitis vinifera] | diamond | 897 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 30265060 | 30265060 | PRJNA383995_P_NODE_12392_length_187_cov_0.978261_g12293_i0 | PRJNA383995 | 12392 | 187 | 0.978261 | 1.82934807 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 52.8 | 5.26e-6 | NR | BAF23632.1 | 39947 | g12293 | i0 | 46.8 | 2.82352941176471 | 47 | 25 | 75.4 | 0 | 142 | 2 | 286 | 332 | BAF23632.1 Os08g0389500 [Oryza sativa Japonica Group] | diamond | 528 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 30391588 | 30391588 | PRJNA383995_P_NODE_15393_length_167_cov_0.864407_g15294_i0 | PRJNA383995 | 15393 | 167 | 0.864407 | 1.44355969 | Oryza meyeriana var. granulata | 110450 | Plants | Plants | 41.6 | 0.014 | NR | KAF0896620.1 | 110450 | g15294 | i0 | 46.8 | 0.844311377245509 | 47 | 24 | 84.4 | 1 | 163 | 23 | 14 | 59 | KAF0896620.1 hypothetical protein E2562_026320 [Oryza meyeriana var. granulata] | diamond | 141 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza meyeriana |
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);;