RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA596867" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA596867 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
3119016 3119016 PRJNA596867_P_NODE_14043_length_244_cov_0.900585_g13968_i0 PRJNA596867 14043 244 0.900585 2.1974274 Drosera rotundifolia 173423 Plants Plants 125 2.9599999999999996e-31   NR GAB2236277.1 173423 g13968 i0 70.4 3.98360655737705 81 24 99.6 0 243 1 424 504 GAB2236277.1 hypothetical protein Drorol1_Dr00028206, partial [Drosera rotundifolia] diamond 972 125 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Droseraceae Drosera Drosera rotundifolia
6946231 6946231 PRJNA596867_P_NODE_13006_length_247_cov_0.885057_g12931_i0 PRJNA596867 13006 247 0.885057 2.18609079 Stephania yunnanensis 152371 Plants Plants 129 5.85e-33   NR KAK9113524.1 152371 g12931 i0 75 13.4696356275304 80 20 97.2 0 3 242 171 250 KAK9113524.1 hypothetical protein Syun_020321 [Stephania yunnanensis] diamond 3327 129 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Menispermaceae Stephania Stephania yunnanensis
10772316 10772316 PRJNA596867_P_NODE_14249_length_243_cov_1.300000_g14174_i0 PRJNA596867 14249 243 1.3 3.159 Cornus florida 4283 Plants Plants 140 1.11e-36   NR XP_059635506.1 4283 g14174 i0 79 1 81 17 100 0 1 243 505 585 XP_059635506.1 uncharacterized protein LOC132277681 [Cornus florida] diamond 243 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Cornaceae Cornus Cornus florida
14596914 14596914 PRJNA596867_P_NODE_15012_length_241_cov_0.922619_g14937_i0 PRJNA596867 15012 241 0.922619 2.22351179 Fabaceae 3803 Plants Plants 130 4.92e-33   NR XP_054797549.1 364024 g14937 i0 75.6 19.4564315352697 78 19 97.1 0 236 3 661 738 XP_054797549.1 uncharacterized protein LOC129302668 [Prosopis cineraria] diamond 4689 131 0.99236641221374 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Prosopis Prosopis cineraria
17145637 17145637 PRJNA596867_P_NODE_10674_length_259_cov_0.865591_g10599_i0 PRJNA596867 10674 259 0.865591 2.24188069 Prunus 3754 Plants Plants 139 3.87e-36   NR BBH04774.1 3755 g10599 i0 78.8 36.6370656370656 85 18 98.5 0 256 2 606 690 BBH04774.1 Disease resistance protein CC-NBS-LRR class family [Prunus dulcis] diamond 9489 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
17145715 17145715 PRJNA596867_P_NODE_8534_length_284_cov_1.459716_g8459_i0 PRJNA596867 8534 284 1.459716 4.14559344 Lamiales 4143 Plants Plants 60.5 6.4e-10   NR GFQ01301.1 374723 g8459 i0 61.8 1.1830985915493 55 20 57 1 228 67 1 55 GFQ01301.1 hypothetical protein PHJA_002274000 [Phtheirospermum japonicum] diamond 336 60.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Phtheirospermum Phtheirospermum japonicum
17145718 17145718 PRJNA596867_P_NODE_8754_length_281_cov_6.389423_g8679_i0 PRJNA596867 8754 281 6.389423 17.95427863 Sesamum angolense 2727404 Plants Plants 102 4.36e-25   NR KAK4381290.1 2727404 g8679 i0 79.4 0.672597864768683 63 13 67.3 0 238 50 1 63 KAK4381290.1 hypothetical protein Sango_2980500 [Sesamum angolense] diamond 189 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum angolense
17145723 17145723 PRJNA596867_P_NODE_9334_length_274_cov_2.273632_g9259_i0 PRJNA596867 9334 274 2.273632 6.22975168 Paulownia fortunei 586722 Plants Plants 108 3.88e-28   NR KAI3466312.1 586722 g9259 i0 58.4 0.974452554744526 89 37 97.4 0 2 268 6 94 KAI3466312.1 hypothetical protein Pfo_022975, partial [Paulownia fortunei] diamond 267 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Paulowniaceae Paulownia Paulownia fortunei
20970224 20970224 PRJNA596867_P_NODE_11657_length_250_cov_0.870056_g11582_i0 PRJNA596867 11657 250 0.870056 2.17514 Magnoliopsida 3398 Plants Plants 125 3.2899999999999996e-31   NR XP_060962066.1 3483 g11582 i0 65.9 186.192 82 28 98.4 0 250 5 657 738 XP_060962066.1 uncharacterized protein LOC133032212 [Cannabis sativa] diamond 46548 125 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
27364600 27364600 PRJNA596867_P_NODE_13383_length_246_cov_0.890173_g13308_i0 PRJNA596867 13383 246 0.890173 2.18982558 Colocasia esculenta 4460 Plants Plants 74.7 6.47e-14   NR MQL95994.1 4460 g13308 i0 49.3 4.45121951219512 73 35 86.6 1 245 33 93 165 MQL95994.1 hypothetical protein [Colocasia esculenta] diamond 1095 74.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
27364601 27364601 PRJNA596867_P_NODE_14543_length_242_cov_2.609467_g14468_i0 PRJNA596867 14543 242 2.609467 6.31491014 Arabidopsis suecica 45249 Plants Plants 42.7 0.0368   NR KAG7563338.1 45249 g14468 i0 34.8 0.855371900826446 69 31 68.2 2 205 41 435 503 KAG7563338.1 Protein kinase C-like phorbol ester/diacylglycerol-binding domain [Arabidopsis suecica] diamond 207 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis suecica
27964166 27964166 PRJNA596867_P_NODE_11845_length_250_cov_0.870056_g11770_i0 PRJNA596867 11845 250 0.870056 2.17514 Kingdonia uniflora 39325 Plants Plants 43.1 0.0311   NR KAF6135486.1 39325 g11770 i0 40.7 0.708 59 34 69.6 1 190 17 373 431 KAF6135486.1 hypothetical protein GIB67_015339 [Kingdonia uniflora] diamond 177 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Circaeasteraceae Kingdonia Kingdonia uniflora
28722080 28722080 PRJNA596867_P_NODE_14627_length_242_cov_0.911243_g14552_i0 PRJNA596867 14627 242 0.911243 2.20520806 Linum tenue 586396 Plants Plants 43.5 0.0204   NR CAI0610673.1 586396 g14552 i0 39.5 0.942148760330578 76 41 88 3 235 23 1248 1323 CAI0610673.1 unnamed protein product [Linum tenue] diamond 228 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Linaceae Linum Linum tenue
31343832 31343832 PRJNA596867_P_NODE_3716_length_392_cov_0.887147_g3641_i0 PRJNA596867 3716 392 0.887147 3.47761624 Cornus florida 4283 Plants Plants 141 4.77e-36   NR XP_059671067.1 4283 g3641 i0 53.8 0.994897959183674 130 57 99.5 1 391 2 700 826 XP_059671067.1 uncharacterized protein LOC132316607 [Cornus florida] diamond 390 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Cornaceae Cornus Cornus florida
32324786 32324786 PRJNA596867_P_NODE_14059_length_244_cov_0.900585_g13984_i0 PRJNA596867 14059 244 0.900585 2.1974274 Actinidia eriantha 165200 Plants Plants 109 1.38e-25   NR XP_057501690.1 165200 g13984 i0 65 4.91803278688525 80 28 98.4 0 242 3 793 872 XP_057501690.1 uncharacterized protein LOC130785525 [Actinidia eriantha] diamond 1200 109 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Actinidiaceae Actinidia Actinidia eriantha
32829485 32829485 PRJNA596867_P_NODE_13000_length_247_cov_0.885057_g12925_i0 PRJNA596867 13000 247 0.885057 2.18609079 Papaver atlanticum 357466 Plants Plants 63.2 8.26e-10   NR KAI3856614.1 357466 g12925 i0 40.9 0.801619433198381 66 39 80.2 0 7 204 65 130 KAI3856614.1 hypothetical protein MKW98_002923 [Papaver atlanticum] diamond 198 63.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver atlanticum

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