RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA513467 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
4313601 4313601 PRJNA513467_S_NODE_3284_length_209_cov_3.854651_g3261_i0 PRJNA513467 3284 209 3.854651 8.05622059 Acer negundo 4023 Plants Plants 151 1.17e-40   NR KAI9192096.1 4023 g3261 i0 100 1.96650717703349 69 0 99 0 2 208 326 394 KAI9192096.1 hypothetical protein LWI28_018258 [Acer negundo] diamond 411 151 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
9414869 9414869 PRJNA513467_S_NODE_7788_length_154_cov_2.000000_g7765_i0 PRJNA513467 7788 154 2 3.08 Poaceae 4479 Plants Plants 75.5 2.8e-14   NR XP_021306043.1 4558 g7765 i0 82.1 6.81818181818182 39 7 76 0 154 38 217 255 XP_021306043.1 uncharacterized protein LOC110431336 [Sorghum bicolor] diamond 1050 75.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Sorghum Sorghum bicolor
14515588 14515588 PRJNA513467_S_NODE_192_length_633_cov_2.755034_g170_i0 PRJNA513467 192 633 2.755034 17.43936522 Acer yangbiense 1000413 Plants Plants 323 4.02e-105   NR TXG50366.1 1000413 g170 i0 52.3 1.83886255924171 388 7 99.5 1 3 632 116 503 TXG50366.1 hypothetical protein EZV62_022890 [Acer yangbiense] diamond 1164 323 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
15789443 15789443 PRJNA513467_S_NODE_853_length_354_cov_2.583596_g830_i0 PRJNA513467 853 354 2.583596 9.14592984 Acer negundo 4023 Plants Plants 212 2.26e-66   NR KAK4858849.1 4023 g830 i0 98.3 1.98305084745763 117 2 99.2 0 3 353 162 278 KAK4858849.1 hypothetical protein QYF36_022933 [Acer negundo] diamond 702 212 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
26602081 26602081 PRJNA513467_S_NODE_941_length_339_cov_3.228477_g918_i0 PRJNA513467 941 339 3.228477 10.94453703 Humulus lupulus 3486 Plants Plants 111 9.03e-26   NR XP_062090156.1 3486 g918 i0 79.4 1.17699115044248 68 14 60.2 0 337 134 533 600 XP_062090156.1 ankyrin repeat protein SKIP35-like [Humulus lupulus] diamond 399 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
27155372 27155372 PRJNA513467_S_NODE_7782_length_154_cov_2.333333_g7759_i0 PRJNA513467 7782 154 2.333333 3.59333282 Acer 4022 Plants Plants 50.8 8.86e-6   NR KAI9177399.1 4023 g7759 i0 100 0.857142857142857 22 0 42.9 0 3 68 176 197 KAI9177399.1 hypothetical protein LWI28_014700 [Acer negundo] diamond 132 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
27203357 27203357 PRJNA513467_S_NODE_82_length_888_cov_3.003525_g65_i0 PRJNA513467 82 888 3.003525 26.671302 Marchantia polymorpha 3197 Plants Plants 139 4.56e-36   NR PTQ32525.1 3197 g65 i0 41.1 1.29054054054054 192 100 64.5 6 3 575 34 213 PTQ32525.1 hypothetical protein MARPO_0097s0012 [Marchantia polymorpha] diamond 1146 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Marchantiaceae Marchantia Marchantia polymorpha
27835123 27835123 PRJNA513467_S_NODE_1804_length_262_cov_2.497778_g1781_i0 PRJNA513467 1804 262 2.497778 6.54417836 Tanacetum cinerariifolium 118510 Plants Plants 68.9 2.13e-12   NR GFC71341.1 118510 g1781 i0 72.7 0.629770992366412 55 15 63 0 2 166 96 150 GFC71341.1 hypothetical protein [Tanacetum cinerariifolium] diamond 165 68.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
27866710 27866710 PRJNA513467_S_NODE_2925_length_219_cov_1.071429_g2902_i0 PRJNA513467 2925 219 1.071429 2.34642951 Hordeum vulgare subsp. vulgare 112509 Plants Plants 43.1 0.0195   NR BAK03491.1 112509 g2902 i0 39.6 2.23287671232877 53 32 72.6 0 60 218 18 70 BAK03491.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 489 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27866711 27866711 PRJNA513467_S_NODE_5365_length_176_cov_2.151079_g5342_i0 PRJNA513467 5365 176 2.151079 3.78589904 Sesamum angolense 2727404 Plants Plants 47.4 1.08e-4   NR KAK4406526.1 2727404 g5342 i0 40.4 0.801136363636364 47 27 80.1 1 175 35 81 126 KAK4406526.1 hypothetical protein Sango_0659100 [Sesamum angolense] diamond 141 47.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum angolense
27945426 27945426 PRJNA513467_S_NODE_6905_length_161_cov_1.532258_g6882_i0 PRJNA513467 6905 161 1.532258 2.46693538 Eukaryota 2759 Plants Plants 101 5.31e-26   NR GFD13738.1 118510 g6882 i0 90.6 3.95031055900621 53 5 98.8 0 2 160 6 58 GFD13738.1 hypothetical protein [Tanacetum cinerariifolium] diamond 636 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
28151200 28151200 PRJNA513467_S_NODE_4745_length_184_cov_1.775510_g4722_i0 PRJNA513467 4745 184 1.77551 3.2669384 Acer negundo 4023 Plants Plants 113 1.26e-28   NR KAK4858849.1 4023 g4722 i0 98.4 0.994565217391304 61 1 99.5 0 184 2 116 176 KAK4858849.1 hypothetical protein QYF36_022933 [Acer negundo] diamond 183 113 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
28308960 28308960 PRJNA513467_S_NODE_1026_length_327_cov_2.979310_g1003_i0 PRJNA513467 1026 327 2.97931 9.7423437 Acer saccharum 4024 Plants Plants 72.4 1.58e-13   NR KAK1582366.1 4024 g1003 i0 94.6 0.339449541284404 37 2 33.9 0 216 326 71 107 KAK1582366.1 hypothetical protein Q3G72_014301 [Acer saccharum] diamond 111 72.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
29161616 29161616 PRJNA513467_S_NODE_1649_length_271_cov_2.931624_g1626_i0 PRJNA513467 1649 271 2.931624 7.94470104 Acer yangbiense 1000413 Plants Plants 81.6 1.07e-15   NR TXG50366.1 1000413 g1626 i0 95.7 0.520295202952029 47 2 52 0 1 141 495 541 TXG50366.1 hypothetical protein EZV62_022890 [Acer yangbiense] diamond 141 81.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
29350905 29350905 PRJNA513467_S_NODE_769_length_368_cov_3.223565_g746_i0 PRJNA513467 769 368 3.223565 11.8627192 Acer negundo 4023 Plants Plants 248 3.08e-74   NR KAI9162436.1 4023 g746 i0 99.2 0.994565217391304 122 1 99.5 0 2 367 267 388 KAI9162436.1 hypothetical protein LWI28_027338 [Acer negundo] diamond 366 248 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
29729446 29729446 PRJNA513467_S_NODE_1150_length_312_cov_3.665455_g1127_i0 PRJNA513467 1150 312 3.665455 11.4362196 Klebsormidium nitens 105231 Plants Plants 64.3 5.22e-10   NR GAQ90597.1 105231 g1127 i0 80 0.384615384615385 40 8 38.5 0 1 120 154 193 GAQ90597.1 hypothetical protein KFL_006600020 [Klebsormidium nitens] diamond 120 64.3 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens
30029489 30029489 PRJNA513467_S_NODE_6751_length_162_cov_2.064000_g6728_i0 PRJNA513467 6751 162 2.064 3.34368 Acer 4022 Plants Plants 90.1 2.48e-19   NR KAK0599343.1 4024 g6728 i0 91.1 1.66666666666667 45 4 83.3 0 20 154 32 76 KAK0599343.1 hypothetical protein LWI29_004435 [Acer saccharum] diamond 270 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
30487923 30487923 PRJNA513467_S_NODE_1273_length_299_cov_2.770992_g1250_i0 PRJNA513467 1273 299 2.770992 8.28526608 Acer saccharum 4024 Plants Plants 116 3.58e-28   NR KAK0570662.1 4024 g1250 i0 94.7 0.57190635451505 57 3 57.2 0 297 127 399 455 KAK0570662.1 hypothetical protein LWI29_004608 [Acer saccharum] diamond 171 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
30819289 30819289 PRJNA513467_S_NODE_7834_length_154_cov_1.333333_g7811_i0 PRJNA513467 7834 154 1.333333 2.05333282 Closterium 34145 Plants Plants 50.8 1.56e-5   NR CAI5517931.1 2996811 g7811 i0 43.2 6 44 25 85.7 0 153 22 1660 1703 CAI5517931.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 924 50.8 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1
30993504 30993504 PRJNA513467_S_NODE_3034_length_216_cov_1.452514_g3011_i0 PRJNA513467 3034 216 1.452514 3.13743024 Citrus unshiu 55188 Plants Plants 107 1.08e-28   NR GAY61104.1 55188 g3011 i0 75.7 0.972222222222222 70 17 97.2 0 210 1 13 82 GAY61104.1 hypothetical protein CUMW_207170, partial [Citrus unshiu] diamond 210 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus unshiu
31594382 31594382 PRJNA513467_S_NODE_836_length_359_cov_2.993789_g813_i0 PRJNA513467 836 359 2.993789 10.74770251 Acer negundo 4023 Plants Plants 152 1.0199999999999999e-43   NR KAI9201471.1 4023 g813 i0 100 0.626740947075209 75 0 62.7 0 358 134 140 214 KAI9201471.1 hypothetical protein LWI28_023937 [Acer negundo] diamond 225 152 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo

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