RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA797655 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
26673726 26673726 PRJNA797655_S_NODE_57081_length_301_cov_3.089147_g56476_i0 PRJNA797655 57081 301 3.089147 9.29833247 Hibiscus cannabinus 229543 Plants Plants 44.7 0.0144   NR KAL4354741.1 229543 g56476 i0 32.3 1.29568106312292 65 34 58.8 2 242 66 296 356 KAL4354741.1 hypothetical protein GQ457_06G044330 [Hibiscus cannabinus] diamond 390 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus cannabinus
26705472 26705472 PRJNA797655_S_NODE_194521_length_181_cov_2.217391_g193916_i0 PRJNA797655 194521 181 2.217391 4.01347771 Iris pallida 29817 Plants Plants 42 0.0075   NR KAJ6835979.1 29817 g193916 i0 45.5 0.546961325966851 33 7 54.7 1 42 140 70 91 KAJ6835979.1 extensin [Iris pallida] diamond 99 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Iridaceae Iris Iris pallida
26832435 26832435 PRJNA797655_S_NODE_114801_length_232_cov_2.793651_g114196_i0 PRJNA797655 114801 232 2.793651 6.48127032 Camellia lanceoleosa 1840588 Plants Plants 42 0.0456   NR KAI7989092.1 1840588 g114196 i0 42.9 0.633620689655172 49 28 63.4 0 28 174 121 169 KAI7989092.1 hypothetical protein LOK49_LG13G00129 [Camellia lanceoleosa] diamond 147 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia lanceoleosa
27749163 27749163 PRJNA797655_S_NODE_90684_length_255_cov_4.169811_g90079_i0 PRJNA797655 90684 255 4.169811 10.63301805 Smallanthus sonchifolius 185202 Plants Plants 41.6 0.0146   NR KAI3798521.1 185202 g90079 i0 44.1 0.4 34 16 40 1 55 156 2 32 KAI3798521.1 hypothetical protein L1987_33798 [Smallanthus sonchifolius] diamond 102 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
27780591 27780591 PRJNA797655_S_NODE_147004_length_208_cov_1.745455_g146399_i0 PRJNA797655 147004 208 1.745455 3.6305464 Striga hermonthica 68872 Plants Plants 43.5 0.0126   NR CAA0813919.1 68872 g146399 i0 35.7 1.00961538461538 70 41 96.6 2 1 201 292 360 CAA0813919.1 zinc finger protein-related [Striga hermonthica] diamond 210 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
28010798 28010798 PRJNA797655_S_NODE_126745_length_222_cov_3.754190_g126140_i0 PRJNA797655 126745 222 3.75419 8.3343018 Eukaryota 2759 Plants Plants 42.4 0.0375   NR KAI5428339.1 3888 g126140 i0 46 1.51351351351351 50 24 63.5 2 76 216 130 179 KAI5428339.1 hypothetical protein KIW84_033366 [Pisum sativum] diamond 336 42.7 0.992974238875878 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lathyrus Lathyrus oleraceus
28010800 28010800 PRJNA797655_S_NODE_258625_length_155_cov_1.491071_g258020_i0 PRJNA797655 258625 155 1.491071 2.31116005 root 1 Root_unresolved Root_unresolved 41.2 0.04   NR XBH89344.1 4565 g258020 i0 53.8 1.3741935483871 39 18 75.5 0 12 128 726 764 XBH89344.1 hypothetical protein VPH35_081267 [Triticum aestivum] diamond 213 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
28064598 28064598 PRJNA797655_S_NODE_118805_length_229_cov_1.806452_g118200_i0 PRJNA797655 118805 229 1.806452 4.13677508 Striga asiatica 4170 Plants Plants 43.5 0.0167   NR GER36692.1 4170 g118200 i0 35.4 0.62882096069869 48 27 57.6 2 1 132 474 521 GER36692.1 tumor susceptibility gene 101 family protein [Striga asiatica] diamond 144 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga asiatica
29201426 29201426 PRJNA797655_S_NODE_104689_length_241_cov_3.297980_g104084_i0 PRJNA797655 104689 241 3.29798 7.9481318 Carica papaya 3649 Plants Plants 42.4 0.0488   NR XP_021886922.1 3649 g104084 i0 27.9 0.846473029045643 68 35 67.2 1 66 227 496 563 XP_021886922.1 ABC transporter G family member 22 [Carica papaya] diamond 204 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Caricaceae Carica Carica papaya
29832761 29832761 PRJNA797655_S_NODE_110171_length_236_cov_3.196891_g109566_i0 PRJNA797655 110171 236 3.196891 7.54466276 Oryza sativa Japonica Group 39947 Plants Plants 42.7 0.0225   NR BAD22326.1 39947 g109566 i0 43.9 0.724576271186441 57 28 67.4 2 191 33 52 108 BAD22326.1 hypothetical protein [Oryza sativa Japonica Group] diamond 171 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
29896073 29896073 PRJNA797655_S_NODE_174731_length_191_cov_2.554054_g174126_i0 PRJNA797655 174731 191 2.554054 4.87824314 Helianthus annuus 4232 Plants Plants 48.9 1.19e-4   NR XP_021986260.1 4232 g174126 i0 40.4 2.13612565445026 52 27 81.7 1 4 159 181 228 XP_021986260.1 uncharacterized protein LOC110882583 [Helianthus annuus] diamond 408 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
30180197 30180197 PRJNA797655_S_NODE_188412_length_184_cov_2.042553_g187807_i0 PRJNA797655 188412 184 2.042553 3.75829752 Gossypium trilobum 34281 Plants Plants 43.1 0.0127   NR MBA0764641.1 34281 g187807 i0 43.2 0.717391304347826 44 20 65.2 3 4 123 297 339 MBA0764641.1 hypothetical protein [Gossypium trilobum] diamond 132 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium trilobum
30243589 30243589 PRJNA797655_S_NODE_124972_length_224_cov_1.591160_g124367_i0 PRJNA797655 124972 224 1.59116 3.5641984 Solanum verrucosum 315347 Plants Plants 43.5 0.0157   NR WMV48613.1 315347 g124367 i0 32.7 0.65625 49 33 65.6 0 224 78 32 80 WMV48613.1 hypothetical protein MTR67_041998 [Solanum verrucosum] diamond 147 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum verrucosum
30559196 30559196 PRJNA797655_S_NODE_143133_length_210_cov_5.568862_g142528_i0 PRJNA797655 143133 210 5.568862 11.6946102 Trema orientale 63057 Plants Plants 42.7 0.0238   NR PON83281.1 63057 g142528 i0 39 1.68571428571429 59 30 75.7 1 173 15 63 121 PON83281.1 Autophagy-related protein [Trema orientale] diamond 354 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Trema Trema orientale
31033680 31033680 PRJNA797655_S_NODE_200315_length_178_cov_4.711111_g199710_i0 PRJNA797655 200315 178 4.711111 8.38577758 Stylosanthes scabra 79078 Plants Plants 41.2 0.0269   NR MED6148271.1 79078 g199710 i0 37 0.775280898876405 46 29 77.5 0 165 28 22 67 MED6148271.1 hypothetical protein [Stylosanthes scabra] diamond 138 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Stylosanthes Stylosanthes scabra
31412761 31412761 PRJNA797655_S_NODE_162416_length_198_cov_2.309677_g161811_i0 PRJNA797655 162416 198 2.309677 4.57316046 Smallanthus sonchifolius 185202 Plants Plants 45.4 0.0023   NR KAI3726424.1 185202 g161811 i0 39 0.893939393939394 59 35 87.9 1 193 20 269 327 KAI3726424.1 hypothetical protein L1987_66221 [Smallanthus sonchifolius] diamond 177 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
31444364 31444364 PRJNA797655_S_NODE_68976_length_282_cov_4.000000_g68371_i0 PRJNA797655 68976 282 4 11.28 Closterium sp. NIES-53 3014310 Plants Plants 43.1 0.0429   NR CAI7785286.1 3014310 g68371 i0 33.9 0.659574468085106 62 40 66 1 38 223 440 500 CAI7785286.1 unnamed protein product [Closterium sp. NIES-53] diamond 186 43.1 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. NIES-53
31571067 31571067 PRJNA797655_S_NODE_143896_length_210_cov_1.724551_g143291_i0 PRJNA797655 143896 210 1.724551 3.6215571 Benincasa hispida 102211 Plants Plants 42.7 0.0236   NR XP_038881131.1 102211 g143291 i0 51.4 0.528571428571429 37 18 52.9 0 86 196 175 211 XP_038881131.1 transcription factor bHLH112-like isoform X2 [Benincasa hispida] diamond 111 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Benincasa Benincasa hispida
31697411 31697411 PRJNA797655_S_NODE_95737_length_250_cov_2.318841_g95132_i0 PRJNA797655 95737 250 2.318841 5.7971025 Dendrobium catenatum 906689 Plants Plants 43.9 0.00598   NR PKU84429.1 906689 g95132 i0 41.5 0.636 53 31 63.6 0 16 174 35 87 PKU84429.1 hypothetical protein MA16_Dca002942 [Dendrobium catenatum] diamond 159 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Orchidaceae Dendrobium Dendrobium catenatum
32172180 32172180 PRJNA797655_S_NODE_103658_length_242_cov_3.140704_g103053_i0 PRJNA797655 103658 242 3.140704 7.60050368 Tanacetum cinerariifolium 118510 Plants Plants 42.7 0.0369   NR GEX25358.1 118510 g103053 i0 40.3 0.830578512396694 67 33 81.8 2 200 3 156 216 GEX25358.1 ribonuclease H-like domain-containing protein [Tanacetum cinerariifolium] diamond 201 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
32298898 32298898 PRJNA797655_S_NODE_163199_length_198_cov_1.238710_g162594_i0 PRJNA797655 163199 198 1.23871 2.4526458 Ipomoea batatas 4120 Plants Plants 41.6 0.0192   NR GMC91664.1 4120 g162594 i0 43.2 0.666666666666667 44 25 66.7 0 162 31 68 111 GMC91664.1 hypothetical protein Iba_chr05aCG3660 [Ipomoea batatas] diamond 132 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
32551944 32551944 PRJNA797655_S_NODE_174599_length_191_cov_2.837838_g173994_i0 PRJNA797655 174599 191 2.837838 5.42027058 Brassica napus 3708 Plants Plants 67.8 1.55e-12   NR WZZ19390.1 3708 g173994 i0 63.8 0.910994764397906 58 21 91.1 0 11 184 71 128 WZZ19390.1 hypothetical protein YC2023_112479 [Brassica napus] diamond 174 67.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus

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