contig_metadata
13 rows where bioproject = "PRJNA382558" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1075711 | 1075711 | PRJNA382558_S_NODE_9841_length_173_cov_13.308824_g9837_i0 | PRJNA382558 | 9841 | 173 | 13.308824 | 23.02426552 | Solanum | 4107 | Plants | Plants | 318 | 1.3e-82 | NTclustered | gi|2839189686|ref|XR_011219713.1| | 4081 | g9837 | i0 | 100 | 98.849710982659 | 172 | 0 | 99 | 0 | 2 | 173 | 2623 | 2452 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138346999), rRNA | blastn | 17101 | 318 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 3626436 | 3626436 | PRJNA382558_S_NODE_1663_length_282_cov_14.616327_g1659_i0 | PRJNA382558 | 1663 | 282 | 14.616327 | 41.21804214 | Eukaryota | 2759 | Plants | Plants | 516 | 7.67e-142 | NTclustered | gi|2839186375|ref|XR_011216401.1| | 4081 | g1659 | i0 | 100 | 99.9255319148936 | 279 | 0 | 99 | 0 | 3 | 281 | 626 | 904 | PREDICTED: Solanum lycopersicum 18S ribosomal RNA (LOC138343606), rRNA | blastn | 28179 | 516 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 6178727 | 6178727 | PRJNA382558_S_NODE_8465_length_181_cov_10.659722_g8461_i0 | PRJNA382558 | 8465 | 181 | 10.659722 | 19.29409682 | Solanaceae | 4070 | Plants | Plants | 335 | 1.36e-87 | NTclustered | gi|2839189188|ref|XR_011219215.1| | 4081 | g8461 | i0 | 100 | 100 | 181 | 0 | 100 | 0 | 1 | 181 | 1523 | 1703 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138346485), rRNA | blastn | 18100 | 335 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 6782629 | 6782629 | PRJNA382558_S_NODE_4186_length_222_cov_5.908108_g4182_i0 | PRJNA382558 | 4186 | 222 | 5.908108 | 13.11599976 | Triticum aestivum | 4565 | Plants | Plants | 311 | 2.94e-80 | NTclustered | gi|1251765982|dbj|AK447493.1| | 4565 | g4182 | i0 | 91.892 | 42.9009009009009 | 222 | 18 | 100 | 0 | 1 | 222 | 3749 | 3528 | Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring | blastn | 9524 | 311 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 6782631 | 6782631 | PRJNA382558_S_NODE_4326_length_220_cov_6.896175_g4322_i0 | PRJNA382558 | 4326 | 220 | 6.896175 | 15.171585 | Triticum aestivum | 4565 | Plants | Plants | 340 | 3.71e-89 | NTclustered | gi|1251765982|dbj|AK447493.1| | 4565 | g4322 | i0 | 94.545 | 78.2818181818182 | 220 | 12 | 100 | 0 | 1 | 220 | 5326 | 5545 | Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring | blastn | 17222 | 340 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 11883574 | 11883574 | PRJNA382558_S_NODE_310_length_415_cov_9.092593_g306_i0 | PRJNA382558 | 310 | 415 | 9.092593 | 37.73426095 | Triticum aestivum | 4565 | Plants | Plants | 267 | 1.31e-66 | NTclustered | gi|1251765982|dbj|AK447493.1| | 4565 | g306 | i0 | 81.633 | 25.6795180722892 | 343 | 43 | 81 | 14 | 1 | 337 | 5190 | 4862 | Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring | blastn | 10657 | 267 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 14433616 | 14433616 | PRJNA382558_S_NODE_15492_length_151_cov_8.219298_g15488_i0 | PRJNA382558 | 15492 | 151 | 8.219298 | 12.41113998 | Solanum lycopersicum | 4081 | Plants | Plants | 279 | 5.19e-71 | NTclustered | gi|2839189188|ref|XR_011219215.1| | 4081 | g15488 | i0 | 100 | 100 | 151 | 0 | 100 | 0 | 1 | 151 | 1306 | 1456 | PREDICTED: Solanum lycopersicum 28S ribosomal RNA (LOC138346485), rRNA | blastn | 15100 | 279 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 16378169 | 16378169 | PRJNA382558_S_NODE_12473_length_162_cov_3.120000_g12469_i0 | PRJNA382558 | 12473 | 162 | 3.12 | 5.0544 | Eukaryota | 2759 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|1191786913|ref|XM_021111817.1| | 130454 | g12469 | i0 | 89.13 | 0.654320987654321 | 46 | 4 | 28 | 1 | 67 | 112 | 89 | 45 | PREDICTED: Arachis ipaensis uncharacterized LOC110266799 (LOC110266799), mRNA | blastn | 106 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis ipaensis | |
| 18256284 | 18256284 | PRJNA382558_S_NODE_10435_length_170_cov_9.285714_g10431_i0 | PRJNA382558 | 10435 | 170 | 9.285714 | 15.7857138 | Triticum aestivum | 4565 | Plants | Plants | 231 | 1.6999999999999997e-56 | NTclustered | gi|1251765982|dbj|AK447493.1| | 4565 | g10431 | i0 | 91.176 | 98.4764705882353 | 170 | 15 | 100 | 0 | 1 | 170 | 3150 | 3319 | Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring | blastn | 16741 | 231 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 19530874 | 19530874 | PRJNA382558_S_NODE_9116_length_177_cov_9.800000_g9112_i0 | PRJNA382558 | 9116 | 177 | 9.8 | 17.346 | Triticum aestivum | 4565 | Plants | Plants | 248 | 1.7799999999999998e-61 | NTclustered | gi|1251765982|dbj|AK447493.1| | 4565 | g9112 | i0 | 92.045 | 84.4971751412429 | 176 | 14 | 99 | 0 | 2 | 177 | 5704 | 5879 | Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring | blastn | 14956 | 248 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 22752531 | 22752531 | PRJNA382558_S_NODE_11518_length_165_cov_16.500000_g11514_i0 | PRJNA382558 | 11518 | 165 | 16.5 | 27.225 | Magnoliopsida | 3398 | Plants | Plants | 298 | 1.61e-76 | NTclustered | gi|1878849229|gb|MT796565.1| | 3505 | g11514 | i0 | 99.39 | 99.3939393939394 | 164 | 1 | 99 | 0 | 1 | 164 | 2715 | 2878 | Betula pendula isolate DM301 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16400 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Betula | Betula pendula | |
| 31514446 | 31514446 | PRJNA382558_S_NODE_10396_length_171_cov_4.395522_g10392_i0 | PRJNA382558 | 10396 | 171 | 4.395522 | 7.51634262 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 3.31e-7 | NR | GEU28503.1 | 118510 | g10392 | i0 | 58 | 1.80701754385965 | 50 | 20 | 86 | 1 | 166 | 20 | 1056 | 1105 | GEU28503.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 309 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 32793037 | 32793037 | PRJNA382558_S_NODE_3520_length_232_cov_8.184615_g3516_i0 | PRJNA382558 | 3520 | 232 | 8.184615 | 18.9883068 | Triticum aestivum | 4565 | Plants | Plants | 42.4 | 0.0419 | NR | KAF7031199.1 | 4565 | g3516 | i0 | 44 | 0.646551724137931 | 50 | 28 | 64.7 | 0 | 15 | 164 | 119 | 168 | KAF7031199.1 hypothetical protein CFC21_042570 [Triticum aestivum] | diamond | 150 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum |
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);;