RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA800053 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
14824529 14824529 PRJNA800053_P_NODE_12272_length_285_cov_1.452830_g12108_i0 PRJNA800053 12272 285 1.45283 4.1405655 Sphagnum balticum 128184 Plants Plants 152 2.3e-45   NR CAM6001057.1 128184 g12108 i0 85.4 0.936842105263158 89 13 93.7 0 5 271 28 116 CAM6001057.1 unnamed protein product [Sphagnum balticum] diamond 267 152 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
19071644 19071644 PRJNA800053_P_NODE_23515_length_241_cov_1.476190_g23351_i0 PRJNA800053 23515 241 1.47619 3.5576179 Aegilops tauschii subsp. strangulata 200361 Plants Plants 78.2 1.01e-14   NR XP_040244011.1 200361 g23351 i0 66.7 1.49377593360996 60 19 73.4 1 3 179 1 60 XP_040244011.1 proline-rich protein 36-like [Aegilops tauschii subsp. strangulata] diamond 360 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
20346274 20346274 PRJNA800053_P_NODE_20596_length_246_cov_0.890173_g20432_i0 PRJNA800053 20596 246 0.890173 2.18982558 Rosales 3744 Plants Plants 161 9.53e-45   NR PON43221.1 3476 g20432 i0 96.3 2.92682926829268 80 3 97.6 0 242 3 353 432 PON43221.1 Pectinesterase inhibitor domain containing protein [Parasponia andersonii] diamond 720 162 0.993827160493827 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Parasponia Parasponia andersonii
27275385 27275385 PRJNA800053_P_NODE_23383_length_242_cov_0.887574_g23219_i0 PRJNA800053 23383 242 0.887574 2.14792908 Ficus carica 3494 Plants Plants 68.9 2.23e-13   NR GMN50239.1 3494 g23219 i0 58.8 0.84297520661157 68 15 73.1 2 185 9 1 64 GMN50239.1 hypothetical protein TIFTF001_019411 [Ficus carica] diamond 204 68.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
27347674 27347674 PRJNA800053_P_NODE_22043_length_244_cov_0.900585_g21879_i0 PRJNA800053 22043 244 0.900585 2.1974274 Magnoliopsida 3398 Plants Plants 58.9 7.72e-9   NR CAA0833912.1 68872 g21879 i0 45.5 1.94262295081967 55 30 67.6 0 242 78 7 61 CAA0833912.1 Unknown protein, partial [Striga hermonthica] diamond 474 59.3 0.993254637436762 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
27591389 27591389 PRJNA800053_P_NODE_19524_length_248_cov_0.880000_g19360_i0 PRJNA800053 19524 248 0.88 2.1824 Trifolium repens 3899 Plants Plants 74.3 2.89e-13   NR KAK2353155.1 3899 g19360 i0 66 0.568548387096774 47 16 56.9 0 100 240 378 424 KAK2353155.1 putative mitochondrial protein [Trifolium repens] diamond 141 74.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens
28317394 28317394 PRJNA800053_P_NODE_13886_length_273_cov_2.020000_g13722_i0 PRJNA800053 13886 273 2.02 5.5146 Picea glauca 3330 Plants Plants 55.1 2.26e-6   NR KUM45767.1 3330 g13722 i0 44.1 0.648351648351648 59 33 64.8 0 2 178 66 124 KUM45767.1 hypothetical protein ABT39_MTgene2333 [Picea glauca] diamond 177 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea glauca
29296164 29296164 PRJNA800053_P_NODE_18049_length_250_cov_0.870056_g17885_i0 PRJNA800053 18049 250 0.870056 2.17514 Sphagnum balticum 128184 Plants Plants 116 5.56e-28   NR CAM6003897.1 128184 g17885 i0 67.1 1.968 82 27 98.4 0 3 248 522 603 CAM6003897.1 unnamed protein product [Sphagnum balticum] diamond 492 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
29336731 29336731 PRJNA800053_P_NODE_21769_length_244_cov_0.900585_g21605_i0 PRJNA800053 21769 244 0.900585 2.1974274 Fabaceae 3803 Plants Plants 79.7 3.59e-15   NR KAK7291564.1 3830 g21605 i0 54.2 8.91393442622951 72 30 84.8 2 5 211 397 468 KAK7291564.1 hypothetical protein RIF29_06809 [Crotalaria pallida] diamond 2175 80.1 0.995006242197254 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Crotalaria Crotalaria pallida
29359409 29359409 PRJNA800053_P_NODE_21189_length_245_cov_0.895349_g21025_i0 PRJNA800053 21189 245 0.895349 2.19360505 Cryptomeria japonica 3369 Plants Plants 50.8 5.26e-5   NR XP_059066486.1 3369 g21025 i0 42.4 0.808163265306122 66 33 78.4 2 213 22 19 81 XP_059066486.1 glutamate receptor 3.5-like [Cryptomeria japonica] diamond 198 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
29453687 29453687 PRJNA800053_P_NODE_17930_length_250_cov_1.220339_g17766_i0 PRJNA800053 17930 250 1.220339 3.0508475 Taxus chinensis 29808 Plants Plants 49.3 3.79e-5   NR KAH9288922.1 29808 g17766 i0 50 1.692 42 21 50.4 0 137 12 19 60 KAH9288922.1 hypothetical protein KI387_033039, partial [Taxus chinensis] diamond 423 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
29453689 29453689 PRJNA800053_P_NODE_22390_length_243_cov_0.905882_g22226_i0 PRJNA800053 22390 243 0.905882 2.20129326 Trema orientale 63057 Plants Plants 80.9 1.5e-16   NR PON72428.1 63057 g22226 i0 81.6 1.44444444444444 49 9 60.5 0 40 186 166 214 PON72428.1 cotton fiber protein [Trema orientale] diamond 351 80.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Trema Trema orientale
30496561 30496561 PRJNA800053_P_NODE_16633_length_255_cov_1.379121_g16469_i0 PRJNA800053 16633 255 1.379121 3.51675855 Taxus chinensis 29808 Plants Plants 102 4.6099999999999997e-23   NR KAH9312457.1 29808 g16469 i0 60.7 0.988235294117647 84 33 98.8 0 252 1 679 762 KAH9312457.1 hypothetical protein KI387_027492, partial [Taxus chinensis] diamond 252 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
30496562 30496562 PRJNA800053_P_NODE_20713_length_246_cov_0.890173_g20549_i0 PRJNA800053 20713 246 0.890173 2.18982558 Capsicum annuum 4072 Plants Plants 93.2 3.39e-21   NR XP_016556466.2 4072 g20549 i0 61.5 1.90243902439024 78 30 95.1 0 11 244 7 84 XP_016556466.2 uncharacterized protein LOC107855984 [Capsicum annuum] diamond 468 93.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum annuum
30726450 30726450 PRJNA800053_P_NODE_10534_length_302_cov_0.969432_g10370_i0 PRJNA800053 10534 302 0.969432 2.92768464 root 1 Root_unresolved Root_unresolved 86.7 2.81e-17   NR CAK9251616.1 128206 g10370 i0 38.8 2.91059602649007 98 60 97.4 0 300 7 249 346 CAK9251616.1 unnamed protein product [Sphagnum jensenii] diamond 879 86.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
31136982 31136982 PRJNA800053_P_NODE_8935_length_321_cov_38.294355_g8771_i0 PRJNA800053 8935 321 38.294355 122.92487955 Magnoliopsida 3398 Plants Plants 50.1 2.24e-4   NR KAK7285922.1 43366 g8771 i0 42.2 1.72897196261682 90 41 83.2 3 320 54 266 345 KAK7285922.1 hypothetical protein RJT34_20710 [Clitoria ternatea] diamond 555 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Clitoria Clitoria ternatea
31444514 31444514 PRJNA800053_P_NODE_14076_length_272_cov_1.286432_g13912_i0 PRJNA800053 14076 272 1.286432 3.49909504 Hevea brasiliensis 3981 Plants Plants 105 4.42e-27   NR XP_021678631.2 3981 g13912 i0 69.9 0.915441176470588 83 20 87.1 3 35 271 1 82 XP_021678631.2 uncharacterized protein LOC110663581 [Hevea brasiliensis] diamond 249 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
31769719 31769719 PRJNA800053_P_NODE_21397_length_245_cov_0.895349_g21233_i0 PRJNA800053 21397 245 0.895349 2.19360505 Malvaceae 3629 Plants Plants 48.5 3.33e-4   NR EOY09440.1 3641 g21233 i0 44.4 9.91836734693878 81 33 96.7 3 245 9 259 329 EOY09440.1 Ribosomal protein L6 family protein, putative [Theobroma cacao] diamond 2430 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Theobroma Theobroma cacao
32812608 32812608 PRJNA800053_P_NODE_24540_length_233_cov_2.162500_g24376_i0 PRJNA800053 24540 233 2.1625 5.038625 Magnoliopsida 3398 Plants Plants 42.7 0.0327   NR WJX29891.1 3899 g24376 i0 36.4 2.02145922746781 55 35 70.8 0 169 5 282 336 WJX29891.1 hypothetical protein P8452_18488 [Trifolium repens] diamond 471 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens

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