RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA608660 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
5688630 5688630 PRJNA608660_P_NODE_6405_length_584_cov_2.682243_g6086_i0 PRJNA608660 6405 584 2.682243 15.66429912 Magnoliopsida 3398 Plants Plants 67 4.13e-9   NR XP_022891965.1 158386 g6086 i0 44 3.10787671232877 84 41 40.1 1 390 157 607 690 XP_022891965.1 uncharacterized protein LOC111406828 [Olea europaea var. sylvestris] diamond 1815 67.4 0.99406528189911 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
8237932 8237932 PRJNA608660_P_NODE_4867_length_656_cov_4.990115_g4571_i0 PRJNA608660 4867 656 4.990115 32.7351544 Cocos nucifera 13894 Plants Plants 247 8.52e-73   NR KAG1346323.1 13894 g4571 i0 58.6 11.3917682926829 227 85 99.7 2 654 1 240 466 KAG1346323.1 ABC2 [Cocos nucifera] diamond 7473 247 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Arecales Arecaceae Cocos Cocos nucifera
10788784 10788784 PRJNA608660_P_NODE_13769_length_396_cov_7.953890_g13418_i0 PRJNA608660 13769 396 7.95389 31.4974044 Magnoliopsida 3398 Plants Plants 176 1.77e-49   NR KAF2301532.1 3981 g13418 i0 75 32.2651515151515 104 26 78.8 0 83 394 9 112 KAF2301532.1 hypothetical protein GH714_025566 [Hevea brasiliensis] diamond 12777 177 0.994350282485876 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
14613482 14613482 PRJNA608660_P_NODE_12452_length_420_cov_10.654987_g12105_i0 PRJNA608660 12452 420 10.654987 44.7509454 Heracleum sosnowskyi 360622 Plants Plants 209 7.57e-60   NR KAK1378019.1 360622 g12105 i0 78 1.8 127 28 90.7 0 10 390 782 908 KAK1378019.1 CCHC-type domain-containing protein [Heracleum sosnowskyi] diamond 756 209 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
23536976 23536976 PRJNA608660_P_NODE_10679_length_457_cov_1.877451_g10333_i0 PRJNA608660 10679 457 1.877451 8.57995107 Tanacetum cinerariifolium 118510 Plants Plants 293 1.54e-93   NR GEV93426.1 118510 g10333 i0 100 0.984682713347921 150 0 98.5 0 452 3 68 217 GEV93426.1 cytochrome b, mitochondrial [Tanacetum cinerariifolium] diamond 450 293 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
26700062 26700062 PRJNA608660_P_NODE_22301_length_293_cov_2.127049_g21945_i0 PRJNA608660 22301 293 2.127049 6.23225357 Phaseolus vulgaris 3885 Plants Plants 49.7 2.11e-4   NR XP_068492178.1 3885 g21945 i0 60 0.757679180887372 40 16 41 0 251 132 187 226 XP_068492178.1 uncharacterized protein [Phaseolus vulgaris] diamond 222 49.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Phaseolus Phaseolus vulgaris
26998180 26998180 PRJNA608660_P_NODE_9542_length_483_cov_2.889401_g9199_i0 PRJNA608660 9542 483 2.889401 13.95580683 Magnoliopsida 3398 Plants Plants 139 1.29e-34   NR XP_038690817.1 458696 g9199 i0 48.6 8.63975155279503 144 73 88.8 1 438 10 56 199 XP_038690817.1 importin subunit beta-1-like [Tripterygium wilfordii] diamond 4173 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Celastrales Celastraceae Tripterygium Tripterygium wilfordii
28027747 28027747 PRJNA608660_P_NODE_32125_length_223_cov_3.201149_g31769_i0 PRJNA608660 32125 223 3.201149 7.13856227 Paspalum notatum var. saurae 547442 Plants Plants 122 2e-30   NR WVZ54475.1 547442 g31769 i0 93.7 0.847533632286996 63 4 84.8 0 34 222 595 657 WVZ54475.1 hypothetical protein U9M48_005262 [Paspalum notatum var. saurae] diamond 189 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
28261654 28261654 PRJNA608660_P_NODE_40586_length_186_cov_1.401460_g40229_i0 PRJNA608660 40586 186 1.40146 2.6067156 root 1 Root_unresolved Root_unresolved 53.5 2.66e-6   NR NP_001289452.1 4098 g40229 i0 60 8.75806451612903 35 14 56.5 0 181 77 561 595 NP_001289452.1 probable methylenetetrahydrofolate reductase [Nicotiana tomentosiformis] diamond 1629 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana tomentosiformis
28533034 28533034 PRJNA608660_P_NODE_43087_length_177_cov_1.218750_g42730_i0 PRJNA608660 43087 177 1.21875 2.1571875 Tanacetum cinerariifolium 118510 Plants Plants 112 3.2600000000000004e-27   NR GEV93423.1 118510 g42730 i0 100 0.983050847457627 58 0 98.3 0 3 176 1946 2003 GEV93423.1 NADH dehydrogenase subunit 5, mitochondrial [Tanacetum cinerariifolium] diamond 174 112 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
29448228 29448228 PRJNA608660_P_NODE_23330_length_283_cov_2.957265_g22974_i0 PRJNA608660 23330 283 2.957265 8.36905995 Camellia sinensis 4442 Plants Plants 42 0.0258   NR CAL5408580.1 4442 g22974 i0 37.3 0.879858657243816 83 42 86.9 3 1 246 14 87 CAL5408580.1 unnamed protein product [Camellia sinensis] diamond 249 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
29511517 29511517 PRJNA608660_P_NODE_25590_length_265_cov_1.717593_g25234_i0 PRJNA608660 25590 265 1.717593 4.55162145 Aegilops tauschii subsp. strangulata 200361 Plants Plants 53.9 5.54e-6   NR XP_020178509.1 200361 g25234 i0 50.9 0.6 53 23 60 1 210 52 374 423 XP_020178509.1 uncharacterized protein LOC109764079 [Aegilops tauschii subsp. strangulata] diamond 159 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
30156184 30156184 PRJNA608660_P_NODE_10072_length_470_cov_4.916865_g9727_i0 PRJNA608660 10072 470 4.916865 23.1092655 Phaseolus 3883 Plants Plants 115 1.42e-27   NR XP_068502317.1 3885 g9727 i0 78.7 1.91489361702128 75 14 47.9 1 466 242 257 329 XP_068502317.1 uncharacterized protein [Phaseolus vulgaris] diamond 900 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Phaseolus Phaseolus vulgaris
30585482 30585482 PRJNA608660_P_NODE_23973_length_278_cov_1.580786_g23617_i0 PRJNA608660 23973 278 1.580786 4.39458508 Vigna radiata var. radiata 3916 Plants Plants 61.6 1.17e-8   NR XP_014519826.1 3916 g23617 i0 88.2 0.366906474820144 34 4 36.7 0 157 56 56 89 XP_014519826.1 putative fasciclin-like arabinogalactan protein 20 [Vigna radiata var. radiata] diamond 102 61.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna radiata
30946503 30946503 PRJNA608660_P_NODE_36074_length_204_cov_2.000000_g35718_i0 PRJNA608660 36074 204 2 4.08 Magnoliopsida 3398 Plants Plants 53.5 3.4e-6   NR KAK1577206.1 4024 g35718 i0 51 2.44117647058824 51 25 75 0 50 202 345 395 KAK1577206.1 hypothetical protein Q3G72_019775 [Acer saccharum] diamond 498 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
31407453 31407453 PRJNA608660_P_NODE_30676_length_231_cov_4.087912_g30320_i0 PRJNA608660 30676 231 4.087912 9.44307672 Panicum hallii var. hallii 1504633 Plants Plants 42.4 0.0439   NR PUZ55070.1 1504633 g30320 i0 35.4 1.02597402597403 79 44 93.5 1 13 228 64 142 PUZ55070.1 hypothetical protein GQ55_5G182400 [Panicum hallii var. hallii] diamond 237 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum hallii
32230051 32230051 PRJNA608660_P_NODE_39358_length_191_cov_1.014085_g39001_i0 PRJNA608660 39358 191 1.014085 1.93690235 Closterium sp. NIES-54 3014311 Plants Plants 42 0.0359   NR CAI7886728.1 3014311 g39001 i0 37.9 0.910994764397906 58 32 91.1 1 7 180 751 804 CAI7886728.1 unnamed protein product [Closterium sp. NIES-54] diamond 174 42 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. NIES-54
32797985 32797985 PRJNA608660_P_NODE_46920_length_167_cov_0.881356_g46563_i0 PRJNA608660 46920 167 0.881356 1.47186452 Eucalyptus grandis 71139 Plants Plants 41.6 0.0261   NR XP_039165860.1 71139 g46563 i0 43.8 0.574850299401198 32 18 57.5 0 105 10 144 175 XP_039165860.1 lachrymatory-factor synthase-like [Eucalyptus grandis] diamond 96 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Myrtaceae Eucalyptus Eucalyptus grandis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;