RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA902848 · 14 ✖

analysis 1

  • diamond · 14 ✖

tax_clade 0

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
27024182 27024182 PRJNA902848_P_NODE_15302_length_250_cov_0.881356_g15252_i0 PRJNA902848 15302 250 0.881356 2.20339 Armatimonadota bacterium 2033014 Bacteria Bacteria 110 4.05e-26   NR HJN18041.1 2033014 g15252 i0 62.7 0.996 83 29 99.6 1 250 2 248 328 HJN18041.1 hypothetical protein [Armatimonadota bacterium] diamond 249 110 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
27055961 27055961 PRJNA902848_P_NODE_9382_length_292_cov_1.287671_g9332_i0 PRJNA902848 9382 292 1.287671 3.75999932 Armatimonadota bacterium 2033014 Bacteria Bacteria 208 1.39e-64   NR MBP8952319.1 2033014 g9332 i0 96.9 0.996575342465753 97 3 99.7 0 2 292 129 225 MBP8952319.1 Gfo/Idh/MocA family oxidoreductase [Armatimonadota bacterium] diamond 291 208 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
27277242 27277242 PRJNA902848_P_NODE_13443_length_253_cov_0.866667_g13393_i0 PRJNA902848 13443 253 0.866667 2.19266751 Armatimonadota bacterium 2033014 Bacteria Bacteria 60.5 1.49e-8   NR HCA46512.1 2033014 g13393 i0 42.3 0.924901185770751 78 43 92.5 2 19 252 117 192 HCA46512.1 hypothetical protein [Armatimonadota bacterium] diamond 234 60.5 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
27498359 27498359 PRJNA902848_P_NODE_16983_length_247_cov_0.896552_g16933_i0 PRJNA902848 16983 247 0.896552 2.21448344 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 130 5.08e-34   NR MBZ0212913.1 2682144 g16933 i0 100 0.777327935222672 64 0 77.7 0 1 192 333 396 MBZ0212913.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 192 130 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
28887365 28887365 PRJNA902848_P_NODE_16068_length_248_cov_1.337143_g16018_i0 PRJNA902848 16068 248 1.337143 3.31611464 Armatimonadota bacterium 2033014 Bacteria Bacteria 69.7 4.5e-12   NR MBI2264303.1 2033014 g16018 i0 48.6 0.846774193548387 70 36 84.7 0 220 11 45 114 MBI2264303.1 C39 family peptidase [Armatimonadota bacterium] diamond 210 69.7 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
29329489 29329489 PRJNA902848_P_NODE_18809_length_244_cov_0.912281_g18759_i0 PRJNA902848 18809 244 0.912281 2.22596564 Armatimonadota bacterium 2033014 Bacteria Bacteria 89.7 1.85e-20   NR KAA0237595.1 2033014 g18759 i0 100 0.55327868852459 45 0 55.3 0 3 137 123 167 KAA0237595.1 MAG: hypothetical protein EDM74_09075 [Armatimonadota bacterium] diamond 135 89.7 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
30529701 30529701 PRJNA902848_P_NODE_20093_length_242_cov_0.923077_g20043_i0 PRJNA902848 20093 242 0.923077 2.23384634 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 132 7.95e-35   NR MEX2243799.1 2682144 g20043 i0 84.4 0.954545454545455 77 12 95.5 0 11 241 1 77 MEX2243799.1 type IV pilus assembly protein PilM [Fimbriimonadaceae bacterium] diamond 231 132 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
30972239 30972239 PRJNA902848_P_NODE_13774_length_252_cov_0.871508_g13724_i0 PRJNA902848 13774 252 0.871508 2.19620016 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 145 3.559999999999999e-42   NR MBZ0214261.1 2682144 g13724 i0 82.1 1 84 15 100 0 252 1 20 103 MBZ0214261.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 252 145 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
31035625 31035625 PRJNA902848_P_NODE_14015_length_252_cov_0.871508_g13965_i0 PRJNA902848 14015 252 0.871508 2.19620016 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 113 2.88e-27   NR HVL38310.1 2682144 g13965 i0 70.2 1 84 25 100 0 1 252 230 313 HVL38310.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 252 113 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
31573010 31573010 PRJNA902848_P_NODE_13696_length_252_cov_0.871508_g13646_i0 PRJNA902848 13696 252 0.871508 2.19620016 Armatimonadota bacterium 2033014 Bacteria Bacteria 110 3.18e-26   NR MBU0607446.1 2033014 g13646 i0 66.7 1 84 28 100 0 1 252 258 341 MBU0607446.1 phage portal protein [Armatimonadota bacterium] diamond 252 110 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31857393 31857393 PRJNA902848_P_NODE_19997_length_242_cov_0.923077_g19947_i0 PRJNA902848 19997 242 0.923077 2.23384634 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 152 4.72e-42   NR MBW7926698.1 2682144 g19947 i0 98.8 0.991735537190083 80 1 99.2 0 241 2 360 439 MBW7926698.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 240 152 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
32269004 32269004 PRJNA902848_P_NODE_10678_length_277_cov_1.333333_g10628_i0 PRJNA902848 10678 277 1.333333 3.69333241 Armatimonadota bacterium 2033014 Bacteria Bacteria 124 1.04e-31   NR HEY3416425.1 2033014 g10628 i0 66.3 1.93862815884477 92 31 99.6 0 276 1 298 389 HEY3416425.1 hypothetical protein [Armatimonadota bacterium] diamond 537 124 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32332460 32332460 PRJNA902848_P_NODE_19019_length_244_cov_0.912281_g18969_i0 PRJNA902848 19019 244 0.912281 2.22596564 Chthonomonas sp. 2282153 Bacteria Bacteria 153 6.13e-42   NR GMV87834.1 2282153 g18969 i0 100 0.995901639344262 81 0 99.6 0 2 244 238 318 GMV87834.1 MAG: hypothetical protein AMXMBFR81_07650 [Chthonomonas sp.] diamond 243 153 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas sp.
32553889 32553889 PRJNA902848_P_NODE_16439_length_248_cov_0.891429_g16389_i0 PRJNA902848 16439 248 0.891429 2.21074392 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 162 2.6299999999999996e-47   NR MBZ0212815.1 2682144 g16389 i0 98.8 0.991935483870968 82 1 99.2 0 247 2 35 116 MBZ0212815.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 246 162 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium

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