RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1101946" 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

  • PRJNA1101946 · 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
7863960 7863960 PRJNA1101946_S_NODE_14867_length_209_cov_1.593750_g14768_i0 PRJNA1101946 14867 209 1.59375 3.3309375 Ceratodon purpureus 3225 Plants Plants 102 3.18e-26   NR KAG0569633.1 3225 g14768 i0 83.9 2.68421052631579 62 10 89 0 187 2 43 104 KAG0569633.1 hypothetical protein KC19_6G103800 [Ceratodon purpureus] diamond 561 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
27383828 27383828 PRJNA1101946_S_NODE_1963_length_398_cov_10.558739_g1864_i0 PRJNA1101946 1963 398 10.558739 42.02378122 Tanacetum cinerariifolium 118510 Plants Plants 91.3 2e-18   NR GFA39473.1 118510 g1864 i0 63.4 2.1105527638191 82 30 61.8 0 1 246 361 442 GFA39473.1 aminoglycoside resistance protein, chloroplastic [Tanacetum cinerariifolium] diamond 840 91.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
27501536 27501536 PRJNA1101946_S_NODE_12703_length_224_cov_5.874286_g12604_i0 PRJNA1101946 12703 224 5.874286 13.15840064 root 1 Root_unresolved Root_unresolved 59.3 1.74e-8   NR KAL4298921.1 3818 g12604 i0 55.6 3.53571428571429 54 24 72.3 0 2 163 115 168 KAL4298921.1 hypothetical protein AHAS_Ahas17G0049200 [Arachis hypogaea] diamond 792 59.7 0.993299832495812 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
27668050 27668050 PRJNA1101946_S_NODE_5804_length_298_cov_3.546185_g5705_i0 PRJNA1101946 5804 298 3.546185 10.5676313 Acer yangbiense 1000413 Plants Plants 56.6 9.25e-7   NR TXG61427.1 1000413 g5705 i0 100 0.261744966442953 26 0 26.2 0 3 80 661 686 TXG61427.1 hypothetical protein EZV62_012790 [Acer yangbiense] diamond 78 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
28267631 28267631 PRJNA1101946_S_NODE_3846_length_333_cov_4.971831_g3747_i0 PRJNA1101946 3846 333 4.971831 16.55619723 Lithocarpus litseifolius 425828 Plants Plants 54.3 1.69e-6   NR KAL0007654.1 425828 g3747 i0 69.7 0.891891891891892 33 10 29.7 0 301 203 72 104 KAL0007654.1 hypothetical protein SO802_009156 [Lithocarpus litseifolius] diamond 297 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Lithocarpus Lithocarpus litseifolius
28638206 28638206 PRJNA1101946_S_NODE_9827_length_249_cov_5.865000_g9728_i0 PRJNA1101946 9827 249 5.865 14.60385 Magnoliopsida 3398 Plants Plants 50.1 5.82e-5   NR CAL5358755.1 4442 g9728 i0 75 2.66265060240964 32 8 38.6 0 3 98 81 112 CAL5358755.1 unnamed protein product [Camellia sinensis] diamond 663 50.4 0.994047619047619 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
28772891 28772891 PRJNA1101946_S_NODE_10487_length_243_cov_2.891753_g10388_i0 PRJNA1101946 10487 243 2.891753 7.02695979 Acer yangbiense 1000413 Plants Plants 148 1.44e-41   NR TXG56728.1 1000413 g10388 i0 97.3 0.901234567901235 73 2 90.1 0 220 2 1 73 TXG56728.1 hypothetical protein EZV62_018041 [Acer yangbiense] diamond 219 148 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
28867681 28867681 PRJNA1101946_S_NODE_10148_length_246_cov_5.177665_g10049_i0 PRJNA1101946 10148 246 5.177665 12.7370559 Rhodamnia argentea 178133 Plants Plants 62.8 5.77e-10   NR XP_030525429.1 178133 g10049 i0 71.8 0.475609756097561 39 11 47.6 0 245 129 127 165 XP_030525429.1 olee1-like protein [Rhodamnia argentea] diamond 117 62.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Myrtaceae Rhodamnia Rhodamnia argentea
29080139 29080139 PRJNA1101946_S_NODE_7848_length_271_cov_2.297297_g7749_i0 PRJNA1101946 7848 271 2.297297 6.22567487 Sapindaceae 23672 Plants Plants 92 2.36e-19   NR KAK0599231.1 4024 g7749 i0 78.8 1.70479704797048 52 11 57.6 0 266 111 54 105 KAK0599231.1 hypothetical protein LWI29_003455 [Acer saccharum] diamond 462 92 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
29435734 29435734 PRJNA1101946_S_NODE_4610_length_317_cov_17.914179_g4511_i0 PRJNA1101946 4610 317 17.914179 56.78794743 Tanacetum cinerariifolium 118510 Plants Plants 75.1 3.74e-13   NR GFA39473.1 118510 g4511 i0 73.4 3.30283911671924 64 17 60.6 0 235 44 331 394 GFA39473.1 aminoglycoside resistance protein, chloroplastic [Tanacetum cinerariifolium] diamond 1047 75.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
29656659 29656659 PRJNA1101946_S_NODE_3530_length_340_cov_2.628866_g3431_i0 PRJNA1101946 3530 340 2.628866 8.9381444 Dipteronia dyeriana 168575 Plants Plants 70.9 1.68e-13   NR KAK2633849.1 168575 g3431 i0 84.2 0.335294117647059 38 6 33.5 0 339 226 41 78 KAK2633849.1 hypothetical protein Ddye_028641 [Dipteronia dyeriana] diamond 114 70.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia dyeriana
29742877 29742877 PRJNA1101946_S_NODE_550_length_571_cov_16.923372_g463_i0 PRJNA1101946 550 571 16.923372 96.63245412 Eukaryota 2759 Plants Plants 104 4.079999999999999e-24   NR KAK9002571.1 183260 g463 i0 47.1 2.51138353765324 121 64 63.6 0 570 208 33 153 KAK9002571.1 hypothetical protein V6N11_025242 [Hibiscus sabdariffa] diamond 1434 105 0.990476190476191 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus sabdariffa
29878241 29878241 PRJNA1101946_S_NODE_4031_length_329_cov_6.289286_g3932_i0 PRJNA1101946 4031 329 6.289286 20.69175094 Acer yangbiense 1000413 Plants Plants 55.5 4.96e-7   NR TXG56149.1 1000413 g3932 i0 91.8 0.556231003039514 61 5 55.6 0 329 147 70 130 TXG56149.1 hypothetical protein EZV62_017462 [Acer yangbiense] diamond 183 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
30225570 30225570 PRJNA1101946_S_NODE_2732_length_364_cov_8.292063_g2633_i0 PRJNA1101946 2732 364 8.292063 30.18310932 Dipteronia dyeriana 168575 Plants Plants 102 1.05e-24   NR KAK2641243.1 168575 g2633 i0 88.2 0.56043956043956 68 8 56 0 2 205 91 158 KAK2641243.1 hypothetical protein Ddye_023006 [Dipteronia dyeriana] diamond 204 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia dyeriana
30415545 30415545 PRJNA1101946_S_NODE_11093_length_237_cov_5.425532_g10994_i0 PRJNA1101946 11093 237 5.425532 12.85851084 Olea europaea subsp. europaea 158383 Plants Plants 100 1.32e-23   NR CAA2984339.1 158383 g10994 i0 85.2 1.36708860759494 54 8 68.4 0 235 74 250 303 CAA2984339.1 probable pectate lyase P59 [Olea europaea subsp. europaea] diamond 324 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
30794263 30794263 PRJNA1101946_S_NODE_14834_length_209_cov_3.181250_g14735_i0 PRJNA1101946 14834 209 3.18125 6.6488125 Abeliophyllum distichum 126358 Plants Plants 42.4 0.0321   NR KAL2525341.1 126358 g14735 i0 44.4 0.645933014354067 45 24 64.6 1 75 209 331 374 KAL2525341.1 F-box protein [Abeliophyllum distichum] diamond 135 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Abeliophyllum Abeliophyllum distichum
30794264 30794264 PRJNA1101946_S_NODE_15914_length_201_cov_51.000000_g15815_i0 PRJNA1101946 15914 201 51 102.51 Amborella trichopoda 13333 Plants Plants 42 0.0117   NR ERN04487.1 13333 g15815 i0 31.8 0.985074626865672 66 38 88.1 1 20 196 5 70 ERN04487.1 hypothetical protein AMTR_s00081p00045240 [Amborella trichopoda] diamond 198 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Amborellales Amborellaceae Amborella Amborella trichopoda
31363402 31363402 PRJNA1101946_S_NODE_23296_length_166_cov_62.051282_g23197_i0 PRJNA1101946 23296 166 62.051282 103.00512812 Populus alba x Populus x berolinensis 444605 Plants Plants 40.8 0.0367   NR KAJ6914787.1 444605 g23197 i0 42.1 1.37349397590361 38 22 68.7 0 44 157 90 127 KAJ6914787.1 hypothetical protein NC651_016922 [Populus alba x Populus x berolinensis] diamond 228 40.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus alba x Populus x berolinensis

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