contig_metadata
23 rows where bioproject = "PRJEB2368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1297146 | 1297146 | PRJEB2368_P_NODE_9342_length_287_cov_1.424000_g9024_i0 | PRJEB2368 | 9342 | 287 | 1.424 | 4.08688 | Capsicum annuum | 4072 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|1700446406|dbj|LC434383.1| | 4072 | g9024 | i0 | 100 | 0.777003484320557 | 76 | 0 | 53 | 0 | 1 | 76 | 3694 | 3619 | Capsicum annuum DNA, retrotransposon: CopiaCa_06 | blastn | 223 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 2572766 | 2572766 | PRJEB2368_P_NODE_10083_length_287_cov_1.308000_g9765_i0 | PRJEB2368 | 10083 | 287 | 1.308 | 3.75396 | Cucumis melo | 3656 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|733601800|emb|LN681932.1| | 3656 | g9765 | i0 | 100 | 0.592334494773519 | 29 | 0 | 10 | 0 | 7 | 35 | 7001703 | 7001731 | Cucumis melo genomic scaffold, anchoredscaffold00001 | blastn | 170 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 3536946 | 3536946 | PRJEB2368_P_NODE_9283_length_287_cov_1.432000_g8965_i0 | PRJEB2368 | 9283 | 287 | 1.432 | 4.10984 | Musa | 4640 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|2008914241|emb|HG996476.1| | 214687 | g8965 | i0 | 100 | 1.32752613240418 | 76 | 0 | 53 | 0 | 212 | 287 | 24781412 | 24781487 | Musa acuminata subsp. malaccensis strain Doubled-haploid Pahang (DH-Pahang) genome assembly, chromosome: A10 | blastn | 381 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Musa | Musa acuminata | |
| 6089313 | 6089313 | PRJEB2368_P_NODE_10945_length_286_cov_1.514056_g10627_i0 | PRJEB2368 | 10945 | 286 | 1.514056 | 4.33020016 | Poaceae | 4479 | Plants | Plants | 134 | 9.18e-27 | NTclustered | gi|217426764|gb|FJ447462.1| | 4565 | g10627 | i0 | 98.667 | 392.744755244755 | 75 | 1 | 26 | 0 | 1 | 75 | 53457 | 53383 | Triticum aestivum cultivar Glenlea clone TaBAC703A9, complete sequence | blastn | 112325 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 7363980 | 7363980 | PRJEB2368_P_NODE_14386_length_165_cov_1.328125_g14067_i0 | PRJEB2368 | 14386 | 165 | 1.328125 | 2.19140625 | Eukaryota | 2759 | Plants | Plants | 128 | 2.23e-25 | NTclustered | gi|1117404786|ref|XM_019557156.1| | 3871 | g14067 | i0 | 87.963 | 14.0242424242424 | 108 | 13 | 65 | 0 | 11 | 118 | 320 | 213 | PREDICTED: Lupinus angustifolius peptidyl-prolyl cis-trans isomerase-like (LOC109325010), mRNA | blastn | 2314 | 128 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus angustifolius | |
| 7364086 | 7364086 | PRJEB2368_P_NODE_9466_length_287_cov_1.404000_g9148_i0 | PRJEB2368 | 9466 | 287 | 1.404 | 4.02948 | Poaceae | 4479 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|299109310|emb|FN564426.1| | 4565 | g9148 | i0 | 100 | 50.6132404181185 | 76 | 0 | 53 | 0 | 1 | 76 | 496401 | 496326 | Triticum aestivum chromosome 3B-specific BAC library, contig ctg0005b | blastn | 14526 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 9914516 | 9914516 | PRJEB2368_P_NODE_7828_length_287_cov_1.848000_g7510_i0 | PRJEB2368 | 7828 | 287 | 1.848 | 5.30376 | Triticum | 4564 | Plants | Plants | 128 | 4.29e-25 | NTclustered | gi|188038071|gb|EU660892.1| | 4565 | g7510 | i0 | 97.333 | 5.97909407665505 | 75 | 2 | 26 | 0 | 1 | 75 | 44908 | 44982 | Triticum aestivum clone BAC 1354M21 cytosolic acetyl-CoA carboxylase (Acc-2) and putative amino acid permeases genes, complete cds | blastn | 1716 | 128 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 11500932 | 11500932 | PRJEB2368_P_NODE_7150_length_287_cov_2.576000_g6832_i0 | PRJEB2368 | 7150 | 287 | 2.576 | 7.39312 | Brassica rapa | 3711 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|199579930|gb|AC189247.2| | 51351 | g6832 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 221 | 248 | 12274 | 12301 | Brassica rapa subsp. pekinensis cultivar Inbred line """"Chiifu"""" clone KBrB018K09, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 12776468 | 12776468 | PRJEB2368_P_NODE_10371_length_287_cov_1.236000_g10053_i0 | PRJEB2368 | 10371 | 287 | 1.236 | 3.54732 | Populus trichocarpa | 3694 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|164663928|gb|AC216604.1| | 3694 | g10053 | i0 | 100 | 0.101045296167247 | 29 | 0 | 10 | 0 | 215 | 243 | 73740 | 73712 | Populus trichocarpa clone POP097-J13, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus trichocarpa | |
| 12776470 | 12776470 | PRJEB2368_P_NODE_10591_length_287_cov_1.104000_g10273_i0 | PRJEB2368 | 10591 | 287 | 1.104 | 3.16848 | Glycine max | 3847 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|224923230|gb|AC235466.1| | 3847 | g10273 | i0 | 100 | 12.9477351916376 | 76 | 0 | 51 | 0 | 1 | 76 | 22258 | 22333 | Glycine max strain Williams 82 clone GM_WBb0172G11, complete sequence | blastn | 3716 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 12776488 | 12776488 | PRJEB2368_P_NODE_3151_length_463_cov_1.807512_g2850_i0 | PRJEB2368 | 3151 | 463 | 1.807512 | 8.36878056 | Mangifera indica | 29780 | Plants | Plants | 198 | 5.4599999999999996e-46 | NTclustered | gi|2118882533|ref|XM_044613347.1| | 29780 | g2850 | i0 | 84.925 | 46.5421166306695 | 199 | 26 | 43 | 4 | 257 | 453 | 1038 | 1234 | PREDICTED: Mangifera indica tubulin alpha chain-like (LOC123198624), mRNA | blastn | 21549 | 198 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Anacardiaceae | Mangifera | Mangifera indica | |
| 12776525 | 12776525 | PRJEB2368_P_NODE_9051_length_287_cov_1.472000_g8733_i0 | PRJEB2368 | 9051 | 287 | 1.472 | 4.22464 | Solanum lycopersicum | 4081 | Plants | Plants | 135 | 2.56e-27 | NTclustered | gi|401871087|gb|AC247102.3| | 4081 | g8733 | i0 | 98.684 | 49.9163763066202 | 76 | 1 | 53 | 0 | 212 | 287 | 30273 | 30198 | Solanum lycopersicum strain Heinz 1706 chromosome 11 clone slm-68p5 map 11, complete sequence | blastn | 14326 | 135 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 14050997 | 14050997 | PRJEB2368_P_NODE_10232_length_287_cov_1.276000_g9914_i0 | PRJEB2368 | 10232 | 287 | 1.276 | 3.66212 | Capsicum annuum | 4072 | Plants | Plants | 134 | 9.21e-27 | NTclustered | gi|1059048066|gb|KU997025.1| | 4072 | g9914 | i0 | 98.667 | 4.08710801393728 | 75 | 1 | 53 | 0 | 213 | 287 | 156126 | 156200 | Capsicum annuum, 6 clones, complete sequence | blastn | 1173 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 14051019 | 14051019 | PRJEB2368_P_NODE_13772_length_174_cov_1.708029_g13453_i0 | PRJEB2368 | 13772 | 174 | 1.708029 | 2.97197046 | Trichophorum cespitosum | 76515 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|2919515580|emb|OZ238279.1| | 76515 | g13453 | i0 | 100 | 0.160919540229885 | 28 | 0 | 16 | 0 | 7 | 34 | 3206494 | 3206521 | Trichophorum cespitosum genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Trichophorum | Trichophorum cespitosum | |
| 16599754 | 16599754 | PRJEB2368_P_NODE_9214_length_287_cov_1.440000_g8896_i0 | PRJEB2368 | 9214 | 287 | 1.44 | 4.1328 | Solanum lycopersicum | 4081 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|347582692|gb|AC245354.4| | 4081 | g8896 | i0 | 100 | 0.529616724738676 | 76 | 0 | 53 | 0 | 212 | 287 | 62584 | 62509 | Solanum lycopersicum strain Heinz 1706 chromosome 10 clone sle-50l24 map 10, complete sequence | blastn | 152 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 17874524 | 17874524 | PRJEB2368_P_NODE_8435_length_287_cov_1.628000_g8117_i0 | PRJEB2368 | 8435 | 287 | 1.628 | 4.67236 | Solanum lycopersicum | 4081 | Plants | Plants | 130 | 1.19e-25 | NTclustered | gi|308044643|gb|AC233126.17| | 4081 | g8117 | i0 | 97.368 | 8.44947735191638 | 76 | 2 | 53 | 0 | 1 | 76 | 60422 | 60347 | Solanum lycopersicum strain Heinz 1706 chromosome 1 clone hba-162g22 map 1, complete sequence | blastn | 2425 | 130 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 20112918 | 20112918 | PRJEB2368_P_NODE_7476_length_287_cov_2.052000_g7158_i0 | PRJEB2368 | 7476 | 287 | 2.052 | 5.88924 | Glycine | 3846 | Plants | Plants | 141 | 5.510000000000001e-29 | NTclustered | gi|2027451349|ref|XM_003519057.5| | 3847 | g7158 | i0 | 100 | 3.17770034843206 | 76 | 0 | 26 | 0 | 1 | 76 | 320 | 245 | PREDICTED: Glycine max uncharacterized protein (LOC100805715), mRNA | blastn | 912 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 21388485 | 21388485 | PRJEB2368_P_NODE_9097_length_287_cov_1.464000_g8779_i0 | PRJEB2368 | 9097 | 287 | 1.464 | 4.20168 | Poaceae | 4479 | Plants | Plants | 130 | 1.19e-25 | NTclustered | gi|194239064|emb|AM932682.1| | 4565 | g8779 | i0 | 97.368 | 30.9268292682927 | 76 | 2 | 26 | 0 | 1 | 76 | 166215 | 166290 | Triticum aestivum 3B chromosome, clone BAC TA3B63B7 | blastn | 8876 | 130 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 21699620 | 21699620 | PRJEB2368_P_NODE_15138_length_157_cov_1.566667_g14819_i0 | PRJEB2368 | 15138 | 157 | 1.566667 | 2.45966719 | Lolium perenne | 4522 | Plants | Plants | 62.1 | 2.15e-5 | NTclustered | gi|2922430240|ref|XR_011750182.1| | 4522 | g14819 | i0 | 100 | 21.0445859872611 | 33 | 0 | 21 | 0 | 1 | 33 | 2252 | 2220 | PREDICTED: Lolium perenne 28S ribosomal RNA (LOC139834477), rRNA | blastn | 3304 | 62.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 24248708 | 24248708 | PRJEB2368_P_NODE_10960_length_286_cov_1.489960_g10642_i0 | PRJEB2368 | 10960 | 286 | 1.48996 | 4.2612856 | Triticum aestivum | 4565 | Plants | Plants | 139 | 1.9699999999999999e-28 | NTclustered | gi|1282798539|gb|MG560142.1| | 4565 | g10642 | i0 | 100 | 42.0734265734266 | 75 | 0 | 53 | 0 | 212 | 286 | 1073828 | 1073754 | 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 | 12033 | 139 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 27722165 | 27722165 | PRJEB2368_P_NODE_15764_length_152_cov_1.365217_g15445_i0 | PRJEB2368 | 15764 | 152 | 1.365217 | 2.07512984 | Eukaryota | 2759 | Plants | Plants | 61.6 | 2.32e-9 | NR | PTQ32829.1 | 3197 | g15445 | i0 | 60 | 63.0789473684211 | 50 | 20 | 98.7 | 0 | 150 | 1 | 207 | 256 | PTQ32829.1 hypothetical protein MARPO_0094s0010 [Marchantia polymorpha] | diamond | 9588 | 62 | 0.993548387096774 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Marchantiaceae | Marchantia | Marchantia polymorpha | |
| 29047993 | 29047993 | PRJEB2368_P_NODE_15568_length_153_cov_2.094828_g15249_i0 | PRJEB2368 | 15568 | 153 | 2.094828 | 3.20508684 | Closterium | 34145 | Plants | Plants | 54.3 | 7.61e-7 | NR | CAI5488445.1 | 2996811 | g15249 | i0 | 49 | 3.84313725490196 | 49 | 25 | 96.1 | 0 | 147 | 1 | 86 | 134 | CAI5488445.1 unnamed protein product [Closterium sp. Naga37s-1] | diamond | 588 | 54.7 | 0.992687385740402 | Eukaryota | Viridiplantae | Streptophyta | Zygnematophyceae | Desmidiales | Closteriaceae | Closterium | Closterium sp. Naga37s-1 | ||
| 32720018 | 32720018 | PRJEB2368_P_NODE_12740_length_196_cov_1.798742_g12421_i0 | PRJEB2368 | 12740 | 196 | 1.798742 | 3.5255343200000002 | Klebsormidium nitens | 105231 | Plants | Plants | 64.7 | 2.73e-10 | NR | GAQ78914.1 | 105231 | g12421 | i0 | 47.6 | 0.964285714285714 | 63 | 33 | 96.4 | 0 | 7 | 195 | 192 | 254 | GAQ78914.1 hypothetical protein KFL_000200670 [Klebsormidium nitens] | diamond | 189 | 64.7 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium nitens |
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);;