contig_metadata
21 rows where bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 509533 | 509533 | PRJNA543299_P_NODE_14461_length_197_cov_1.851351_g14304_i0 | PRJNA543299 | 14461 | 197 | 1.851351 | 3.64716147 | Avellara fistulosa | 1940801 | Plants | Plants | 52.8 | 0.017 | NTclustered | gi|2918395469|emb|OZ238147.1| | 1940801 | g14304 | i0 | 100 | 0.284263959390863 | 28 | 0 | 14 | 0 | 44 | 71 | 10220001 | 10219974 | Avellara fistulosa genome assembly, chromosome: 6 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Avellara | Avellara fistulosa | |
| 1118542 | 1118542 | PRJNA543299_P_NODE_5141_length_322_cov_6.600733_g4985_i0 | PRJNA543299 | 5141 | 322 | 6.600733 | 21.25436026 | Quercus | 3511 | Plants | Plants | 580 | 3.119999999999999e-161 | NTclustered | gi|1878849159|gb|MT796506.1| | 38865 | g4985 | i0 | 99.375 | 99.3788819875776 | 320 | 2 | 99 | 0 | 3 | 322 | 2729 | 2410 | Quercus petraea isolate DM324 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 | 32000 | 580 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus petraea | |
| 1784952 | 1784952 | PRJNA543299_P_NODE_16022_length_187_cov_3.362319_g15865_i0 | PRJNA543299 | 16022 | 187 | 3.362319 | 6.28753653 | Quercus robur | 38942 | Plants | Plants | 340 | 3.0499999999999998e-89 | NTclustered | gi|2293066863|ref|XR_007649123.1| | 38942 | g15865 | i0 | 99.465 | 100 | 187 | 1 | 100 | 0 | 1 | 187 | 3307 | 3121 | PREDICTED: Quercus robur 28S ribosomal RNA (LOC126707822), rRNA | blastn | 18700 | 340 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus robur | |
| 4336626 | 4336626 | PRJNA543299_P_NODE_23304_length_164_cov_0.886957_g23147_i0 | PRJNA543299 | 23304 | 164 | 0.886957 | 1.45460948 | Quercus suber | 58331 | Plants | Plants | 298 | 1.59e-76 | NTclustered | gi|2743661911|ref|XM_024063294.2| | 58331 | g23147 | i0 | 99.39 | 6.97560975609756 | 164 | 1 | 100 | 0 | 1 | 164 | 790 | 627 | PREDICTED: Quercus suber uncharacterized LOC112030619 (LOC112030619), mRNA | blastn | 1144 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus suber | |
| 4946809 | 4946809 | PRJNA543299_P_NODE_3364_length_393_cov_4.633721_g3212_i0 | PRJNA543299 | 3364 | 393 | 4.633721 | 18.21052353 | Quercus | 3511 | Plants | Plants | 721 | 0 | NTclustered | gi|1878849159|gb|MT796506.1| | 38865 | g3212 | i0 | 99.746 | 100.002544529262 | 393 | 1 | 100 | 0 | 1 | 393 | 2859 | 3251 | Quercus petraea isolate DM324 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 | 39301 | 721 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus petraea | |
| 6222249 | 6222249 | PRJNA543299_P_NODE_11885_length_217_cov_1.440476_g11728_i0 | PRJNA543299 | 11885 | 217 | 1.440476 | 3.12583292 | root | 1 | Root_unresolved | Root_unresolved | 401 | 1.6499999999999994e-107 | NTclustered | gi|2037096431|gb|MW582695.1| | 28930 | g11728 | i0 | 100 | 134.52534562212 | 217 | 0 | 100 | 0 | 1 | 217 | 90541 | 90325 | Fagus sylvatica isolate FSYLV_37_PL_JAMY mitochondrion, complete genome | blastn | 29192 | 401 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Fagus | Fagus sylvatica | |
| 6222253 | 6222253 | PRJNA543299_P_NODE_17405_length_180_cov_1.320611_g17248_i0 | PRJNA543299 | 17405 | 180 | 1.320611 | 2.3770998 | Magnoliopsida | 3398 | Plants | Plants | 327 | 2.2699999999999996e-85 | NTclustered | gi|66969368|gb|DQ008780.1| | 3429 | g17248 | i0 | 99.444 | 140.205555555556 | 180 | 1 | 100 | 0 | 1 | 180 | 1548 | 1369 | Calycanthus floridus large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 25237 | 327 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Calycanthaceae | Calycanthus | Calycanthus floridus | |
| 7496783 | 7496783 | PRJNA543299_P_NODE_20586_length_167_cov_0.864407_g20429_i0 | PRJNA543299 | 20586 | 167 | 0.864407 | 1.44355969 | Quercus | 3511 | Plants | Plants | 309 | 7.53e-80 | NTclustered | gi|2293057058|ref|XM_050402800.1| | 38942 | g20429 | i0 | 100 | 69.5988023952096 | 167 | 0 | 100 | 0 | 1 | 167 | 870 | 1036 | PREDICTED: Quercus robur glyceraldehyde-3-phosphate dehydrogenase, cytosolic (LOC126703720), mRNA | blastn | 11623 | 309 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus robur | |
| 11321713 | 11321713 | PRJNA543299_P_NODE_6369_length_291_cov_13.830579_g6213_i0 | PRJNA543299 | 6369 | 291 | 13.830579 | 40.24698489 | Eukaryota | 2759 | Plants | Plants | 538 | 1.6999999999999994e-148 | NTclustered | gi|1878849207|gb|MT796543.1| | 3512 | g6213 | i0 | 100 | 100 | 291 | 0 | 100 | 0 | 1 | 291 | 1949 | 1659 | Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 | 29100 | 538 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 12597643 | 12597643 | PRJNA543299_P_NODE_10050_length_235_cov_1.053763_g9893_i0 | PRJNA543299 | 10050 | 235 | 1.053763 | 2.47634305 | Magnoliopsida | 3398 | Plants | Plants | 429 | 8.33e-116 | NTclustered | gi|2127863804|ref|NC_058644.1| | 4217 | g9893 | i0 | 99.574 | 130 | 235 | 1 | 100 | 0 | 1 | 235 | 156443 | 156677 | Arctium lappa mitochondrion, complete genome | blastn | 30550 | 429 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Arctium | Arctium lappa | |
| 13872504 | 13872504 | PRJNA543299_P_NODE_21811_length_166_cov_0.863248_g21654_i0 | PRJNA543299 | 21811 | 166 | 0.863248 | 1.43299168 | Gnetum | 3380 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|2689329997|dbj|LC783598.1| | 33153 | g21654 | i0 | 100 | 0.337349397590361 | 28 | 0 | 17 | 0 | 26 | 53 | 39038 | 39065 | Gnetum parvifolium Chaw1607 mitochondrial DNA, complete sequence, note: sequence_id: chr4 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Gnetopsida | Gnetales | Gnetaceae | Gnetum | Gnetum parvifolium | |
| 17696590 | 17696590 | PRJNA543299_P_NODE_3994_length_362_cov_10.105431_g3839_i0 | PRJNA543299 | 3994 | 362 | 10.105431 | 36.58166022 | Fagaceae | 3503 | Plants | Plants | 662 | 0 | NTclustered | gi|1878849207|gb|MT796543.1| | 3512 | g3839 | i0 | 99.723 | 99.7237569060773 | 361 | 1 | 99 | 0 | 2 | 362 | 5300 | 4940 | Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 | 36100 | 662 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 18970171 | 18970171 | PRJNA543299_P_NODE_10755_length_227_cov_7.859551_g10598_i0 | PRJNA543299 | 10755 | 227 | 7.859551 | 17.84118077 | Quercus | 3511 | Plants | Plants | 420 | 4.81e-113 | NTclustered | gi|1878849159|gb|MT796506.1| | 38865 | g10598 | i0 | 100 | 100.330396475771 | 227 | 0 | 100 | 0 | 1 | 227 | 4309 | 4535 | Quercus petraea isolate DM324 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 | 22775 | 420 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus petraea | |
| 20245103 | 20245103 | PRJNA543299_P_NODE_5956_length_300_cov_4.756972_g5800_i0 | PRJNA543299 | 5956 | 300 | 4.756972 | 14.270916 | Quercus | 3511 | Plants | Plants | 555 | 1.7399999999999995e-153 | NTclustered | gi|1878849159|gb|MT796506.1| | 38865 | g5800 | i0 | 100 | 100.006666666667 | 300 | 0 | 100 | 0 | 1 | 300 | 83 | 382 | Quercus petraea isolate DM324 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 | 30002 | 555 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus petraea | |
| 21520701 | 21520701 | PRJNA543299_P_NODE_24637_length_162_cov_1.707965_g24480_i0 | PRJNA543299 | 24637 | 162 | 1.707965 | 2.7669033 | Streptophyta | 35493 | Plants | Plants | 272 | 9.51e-69 | NTclustered | gi|2306646691|gb|OK323375.1| | 4639 | g24480 | i0 | 98.701 | 177.172839506173 | 154 | 0 | 94 | 2 | 1 | 153 | 111130 | 110978 | Ensete ventricosum cultivar Bedadeti chloroplast, complete genome | blastn | 28702 | 272 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Ensete | Ensete ventricosum | |
| 22186404 | 22186404 | PRJNA543299_P_NODE_20638_length_167_cov_0.864407_g20481_i0 | PRJNA543299 | 20638 | 167 | 0.864407 | 1.44355969 | Quercus lobata | 97700 | Plants | Plants | 298 | 1.63e-76 | NTclustered | gi|1757564352|ref|XM_031104873.1| | 97700 | g20481 | i0 | 98.802 | 36.4610778443114 | 167 | 2 | 100 | 0 | 1 | 167 | 1257 | 1423 | PREDICTED: Quercus lobata putative ABC transporter C family member 15 (LOC115982314), mRNA | blastn | 6089 | 298 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus lobata | |
| 24070611 | 24070611 | PRJNA543299_P_NODE_22199_length_165_cov_0.879310_g22042_i0 | PRJNA543299 | 22199 | 165 | 0.87931 | 1.4508615 | Magnoliopsida | 3398 | Plants | Plants | 292 | 7.47e-75 | NTclustered | gi|1198229794|emb|LT855379.1| | 3505 | g22042 | i0 | 98.78 | 103.769696969697 | 164 | 2 | 99 | 0 | 1 | 164 | 473441 | 473278 | Betula pendula genome assembly, organelle: mitochondrion | blastn | 17122 | 292 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Betula | Betula pendula | |
| 24735605 | 24735605 | PRJNA543299_P_NODE_22600_length_165_cov_0.879310_g22443_i0 | PRJNA543299 | 22600 | 165 | 0.87931 | 1.4508615 | Triticum aestivum | 4565 | Plants | Plants | 283 | 4.4899999999999995e-72 | NTclustered | gi|1282798539|gb|MG560142.1| | 4565 | g22443 | i0 | 97.576 | 10.9333333333333 | 165 | 4 | 100 | 0 | 1 | 165 | 1109388 | 1109224 | Triticum aestivum omega gliadin-D1, omega gliadin-D2, omega gliadin-D3, gamma gliadin-D1, delta gliadin-D1, gamma gliadin-D2, gamma gliadin-D3, gamma gliadin-D4, LMW-D1, LMW-D2, LMW-D3, LMW-D6, and LMW-D7 genes, complete cds | blastn | 1804 | 283 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 29351641 | 29351641 | PRJNA543299_P_NODE_12549_length_211_cov_1.654321_g12392_i0 | PRJNA543299 | 12549 | 211 | 1.654321 | 3.49061731 | Shorea laevis | 152420 | Plants | Plants | 40.4 | 0.0365 | NR | GLT50214.1 | 152420 | g12392 | i0 | 44.2 | 0.611374407582938 | 43 | 22 | 61.1 | 1 | 158 | 30 | 7 | 47 | GLT50214.1 hypothetical protein SLA2020_237160 [Shorea laevis] | diamond | 129 | 40.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Dipterocarpaceae | Shorea | Shorea laevis | |
| 31278476 | 31278476 | PRJNA543299_P_NODE_14715_length_195_cov_9.006849_g14558_i0 | PRJNA543299 | 14715 | 195 | 9.006849 | 17.56335555 | Calluna vulgaris | 13385 | Plants | Plants | 40 | 0.0367 | NR | CAM5845482.1 | 13385 | g14558 | i0 | 42.2 | 0.692307692307692 | 45 | 16 | 69.2 | 1 | 166 | 32 | 34 | 68 | CAM5845482.1 unnamed protein product [Calluna vulgaris] | diamond | 135 | 40 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 31310124 | 31310124 | PRJNA543299_P_NODE_17375_length_180_cov_1.557252_g17218_i0 | PRJNA543299 | 17375 | 180 | 1.557252 | 2.8030536 | Arachis hypogaea | 3818 | Plants | Plants | 43.1 | 0.00314 | NR | RYQ90665.1 | 3818 | g17218 | i0 | 72 | 0.416666666666667 | 25 | 7 | 41.7 | 0 | 3 | 77 | 80 | 104 | RYQ90665.1 hypothetical protein Ahy_B09g096697 [Arachis hypogaea] | diamond | 75 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea |
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);;