RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 14 ✖

bioproject 1

  • PRJNA861969 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
26833678 26833678 PRJNA861969_P_NODE_32881_length_249_cov_0.875000_g32650_i0 PRJNA861969 32881 249 0.875 2.17875 Cornus florida 4283 Plants Plants 44.7 0.00789   NR XP_059635498.1 4283 g32650 i0 42.9 0.590361445783133 49 28 59 0 206 60 174 222 XP_059635498.1 uncharacterized protein LOC132277673 [Cornus florida] diamond 147 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Cornaceae Cornus Cornus florida
27149506 27149506 PRJNA861969_P_NODE_40402_length_242_cov_0.911243_g40171_i0 PRJNA861969 40402 242 0.911243 2.20520806 Vicia faba 3906 Plants Plants 45.4 0.00413   NR CAI8588773.1 3906 g40171 i0 56.4 0.483471074380165 39 17 48.3 0 1 117 64 102 CAI8588773.1 unnamed protein product [Vicia faba] diamond 117 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vicia Vicia faba
27915937 27915937 PRJNA861969_P_NODE_36085_length_246_cov_0.890173_g35854_i0 PRJNA861969 36085 246 0.890173 2.18982558 Cannabaceae 3481 Plants Plants 47.4 8.7e-4   NR KAF4370815.1 3483 g35854 i0 48.9 1.5609756097561 45 23 54.9 0 60 194 385 429 KAF4370815.1 hypothetical protein F8388_011798 [Cannabis sativa] diamond 384 47.8 0.99163179916318 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
28697478 28697478 PRJNA861969_P_NODE_40847_length_242_cov_0.911243_g40616_i0 PRJNA861969 40847 242 0.911243 2.20520806 Camellia lanceoleosa 1840588 Plants Plants 40.8 0.0464   NR KAI8029891.1 1840588 g40616 i0 36 0.619834710743802 50 27 55.8 1 97 231 37 86 KAI8029891.1 hypothetical protein LOK49_LG01G02350 [Camellia lanceoleosa] diamond 150 40.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia lanceoleosa
29013341 29013341 PRJNA861969_P_NODE_38568_length_244_cov_0.900585_g38337_i0 PRJNA861969 38568 244 0.900585 2.1974274 Taxus chinensis 29808 Plants Plants 105 4.39e-24   NR KAH9317323.1 29808 g38337 i0 64.9 2.84016393442623 77 27 94.7 0 234 4 837 913 KAH9317323.1 hypothetical protein KI387_019092 [Taxus chinensis] diamond 693 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
29171046 29171046 PRJNA861969_P_NODE_31149_length_251_cov_0.865169_g30918_i0 PRJNA861969 31149 251 0.865169 2.17157419 Glycine soja 3848 Plants Plants 113 5.57e-31   NR KAG5029422.1 3848 g30918 i0 100 0.633466135458167 53 0 63.3 0 1 159 18 70 KAG5029422.1 hypothetical protein JHK87_012936 [Glycine soja] diamond 159 113 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine soja
29265431 29265431 PRJNA861969_P_NODE_7529_length_469_cov_2.313131_g7298_i0 PRJNA861969 7529 469 2.313131 10.84858439 Vigna unguiculata 3917 Plants Plants 218 1.24e-70   NR QCE13674.1 3917 g7298 i0 100 0.716417910447761 112 0 71.6 0 429 94 1 112 QCE13674.1 hypothetical protein DEO72_LG11g669 [Vigna unguiculata] diamond 336 218 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna unguiculata
30086619 30086619 PRJNA861969_P_NODE_34052_length_248_cov_0.880000_g33821_i0 PRJNA861969 34052 248 0.88 2.1824 Olea europaea var. sylvestris 158386 Plants Plants 42.7 0.0381   NR XP_022859956.1 158386 g33821 i0 40.3 0.931451612903226 77 42 90.7 4 8 232 286 360 XP_022859956.1 uncharacterized protein LOC111380584 [Olea europaea var. sylvestris] diamond 231 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
30600260 30600260 PRJNA861969_P_NODE_40553_length_242_cov_0.911243_g40322_i0 PRJNA861969 40553 242 0.911243 2.20520806 Magnoliopsida 3398 Plants Plants 82 5.44e-16   NR XP_039052637.1 106335 g40322 i0 46.9 16.6363636363636 81 41 99.2 2 241 2 838 917 XP_039052637.1 pumilio homolog 2-like isoform X1 [Hibiscus syriacus] diamond 4026 82.8 0.990338164251208 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus syriacus
31295525 31295525 PRJNA861969_P_NODE_37215_length_245_cov_0.895349_g36984_i0 PRJNA861969 37215 245 0.895349 2.19360505 Magnoliopsida 3398 Plants Plants 43.5 0.0119   NR XP_022143643.1 3673 g36984 i0 36.6 6.72244897959184 41 26 50.2 0 88 210 48 88 XP_022143643.1 uncharacterized protein LOC111013504 [Momordica charantia] diamond 1647 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Momordica Momordica charantia
31635271 31635271 PRJNA861969_P_NODE_736_length_1693_cov_4.145062_g621_i0 PRJNA861969 736 1693 4.145062 70.17589966 Lewinskya incana 2564002 Plants Plants 52 0.0102   NR YP_009629030.1 2564002 g621 i0 24.2 1.37152982870644 467 257 66.8 16 1515 385 594 1049 YP_009629030.1 Ycf2 [Lewinskya incana] diamond 2322 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Orthotrichales Orthotrichaceae Lewinskya Lewinskya incana
31698619 31698619 PRJNA861969_P_NODE_41617_length_241_cov_0.916667_g41386_i0 PRJNA861969 41617 241 0.916667 2.20916747 Olea europaea var. sylvestris 158386 Plants Plants 54.7 1.44e-6   NR XP_022883457.1 158386 g41386 i0 55.2 0.83402489626556 67 10 58.5 2 185 45 141 207 XP_022883457.1 uncharacterized protein LOC111400270 [Olea europaea var. sylvestris] diamond 201 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31824933 31824933 PRJNA861969_P_NODE_22857_length_285_cov_1.452830_g22626_i0 PRJNA861969 22857 285 1.45283 4.1405655 Miscanthus lutarioriparius 422564 Plants Plants 75.1 2.59e-13   NR CAD6228797.1 422564 g22626 i0 69.1 1.16842105263158 55 17 57.9 0 45 209 718 772 CAD6228797.1 unnamed protein product [Miscanthus lutarioriparius] diamond 333 75.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Miscanthus Miscanthus lutarioriparius
31928146 31928146 PRJNA861969_P_NODE_33457_length_249_cov_0.875000_g33226_i0 PRJNA861969 33457 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 46.2 0.00246   NR CAA3011742.1 158383 g33226 i0 43.6 0.975903614457831 39 22 47 0 76 192 605 643 CAA3011742.1 ferric reduction oxidase 6-like [Olea europaea subsp. europaea] diamond 243 46.6 0.991416309012876 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea

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