RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB75017" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 17 ✖

bioproject 1

  • PRJEB75017 · 17 ✖

analysis 1

  • diamond · 17 ✖

tax_kingdom 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
2685374 2685374 PRJEB75017_P_NODE_10503_length_284_cov_1.175355_g10374_i0 PRJEB75017 10503 284 1.175355 3.3380082 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 60.8 2.23e-8   NR MCA9326149.1 2026720 g10374 i0 45.2 0.654929577464789 62 34 65.5 0 2 187 170 231 MCA9326149.1 DUF21 domain-containing protein [Candidatus Saccharibacteria bacterium] diamond 186 60.8 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
26590683 26590683 PRJEB75017_P_NODE_7021_length_337_cov_1.125000_g6892_i0 PRJEB75017 7021 337 1.125 3.79125 Candidatus Babelota bacterium 2030827 Bacteria Bacteria 60.5 6.84e-8   NR MBA2306871.1 2030827 g6892 i0 42.2 0.908011869436202 102 49 90.8 3 307 2 402 493 MBA2306871.1 hypothetical protein [Candidatus Dependentiae bacterium] diamond 306 60.5 1 Bacteria Bacteria candidate phyla             Candidatus Babelota bacterium
26685832 26685832 PRJEB75017_P_NODE_11281_length_276_cov_1.980296_g11152_i0 PRJEB75017 11281 276 1.980296 5.46561696 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 53.1 1.2e-5   NR HEY2107207.1 2785449 g11152 i0 62.5 0.869565217391304 40 14 43.5 1 271 152 163 201 HEY2107207.1 protein kinase [Candidatus Binataceae bacterium] diamond 240 53.1 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae bacterium
26907592 26907592 PRJEB75017_P_NODE_14922_length_250_cov_1.706215_g14793_i0 PRJEB75017 14922 250 1.706215 4.2655375 Candidatus Saccharimonas sp. 1917697 Bacteria Bacteria 54.7 2.54e-6   NR RKW02782.1 1917697 g14793 i0 64.9 0.888 37 13 44.4 0 1 111 589 625 RKW02782.1 MAG: hypothetical protein D8B38_02570 [Candidatus Saccharimonas sp.] diamond 222 54.7 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales Candidatus Saccharimonadaceae Candidatus Saccharimonas Candidatus Saccharimonas sp.
27287013 27287013 PRJEB75017_P_NODE_17343_length_244_cov_2.684211_g17214_i0 PRJEB75017 17343 244 2.684211 6.54947484 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 52.8 1.11e-5   NR MBM3320908.1 2212470 g17214 i0 35.4 1.97950819672131 65 42 79.9 0 228 34 118 182 MBM3320908.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] diamond 483 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
27603054 27603054 PRJEB75017_P_NODE_9184_length_299_cov_1.035398_g9055_i0 PRJEB75017 9184 299 1.035398 3.09584002 Candidatus Rokuibacteriota bacterium 2053607 Bacteria Bacteria 43.1 0.0325   NR PYN03199.1 2053607 g9055 i0 34.3 1.9866220735786 99 56 90.3 2 290 21 21 119 PYN03199.1 MAG: 16S rRNA (guanine(527)-N(7))-methyltransferase RsmG [Candidatus Rokuibacteriota bacterium] diamond 594 43.1 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota bacterium
27729529 27729529 PRJEB75017_P_NODE_18444_length_242_cov_0.923077_g18315_i0 PRJEB75017 18444 242 0.923077 2.23384634 Parcubacteria group bacterium CG_4_1 2026774 Bacteria Bacteria 141 1.26e-39   NR PIY78822.1 2014315 g18315 i0 88.8 0.991735537190083 80 9 99.2 0 240 1 95 174 PIY78822.1 MAG: hypothetical protein COY82_00450, partial [Parcubacteria group bacterium CG_4_10_14_0_8_um_filter_35_7] diamond 240 141 1 Bacteria Bacteria candidate phyla             Parcubacteria group bacterium CG_4_10_14_0_8_um_filter_35_7
27848067 27848067 PRJEB75017_P_NODE_8404_length_311_cov_0.983193_g8275_i0 PRJEB75017 8404 311 0.983193 3.05773023 Pseudomonadati 3379134 Bacteria Bacteria 67 2.48e-10   NR MBI3893590.1 2053640 g8275 i0 49.3 3.45337620578778 69 34 65.6 1 6 209 125 193 MBI3893590.1 tetratricopeptide repeat protein [Candidatus Wallbacteria bacterium] diamond 1074 67 1 Bacteria Bacteria candidate phyla   Candidatus Walliibacteriota         Candidatus Wallbacteria bacterium
29213381 29213381 PRJEB75017_P_NODE_8689_length_306_cov_1.218884_g8560_i0 PRJEB75017 8689 306 1.218884 3.72978504 candidate division Kazan bacterium RIFCSPHIGHO2_ 2202143 Bacteria Bacteria 52 2.03e-5   NR OGB75379.1 1798537 g8560 i0 50.9 1.33333333333333 57 28 55.9 0 271 101 95 151 OGB75379.1 MAG: hypothetical protein A2810_02960 [candidate division Kazan bacterium RIFCSPHIGHO2_01_FULL_49_10] diamond 408 52 1 Bacteria Bacteria candidate phyla             candidate division Kazan bacterium RIFCSPHIGHO2_01_FULL_49_10
30223679 30223679 PRJEB75017_P_NODE_9552_length_294_cov_1.009050_g9423_i0 PRJEB75017 9552 294 1.00905 2.966607 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 43.1 0.0496   NR HZP43321.1 2838779 g9423 i0 45.8 0.602040816326531 59 30 58.2 1 68 238 689 747 HZP43321.1 thrombospondin type 3 repeat-containing protein [Candidatus Binatia bacterium] diamond 177 43.1 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
30350639 30350639 PRJEB75017_P_NODE_13492_length_255_cov_1.318681_g13363_i0 PRJEB75017 13492 255 1.318681 3.36263655 Candidatus Acetothermia bacterium 2053493 Bacteria Bacteria 60.5 2.41e-8   NR HDI10959.1 2053493 g13363 i0 47.6 2 82 43 96.5 0 5 250 493 574 HDI10959.1 molecular chaperone DnaK [Candidatus Acetothermia bacterium] diamond 510 60.5 1 Bacteria Bacteria candidate phyla   Candidatus Bipolaricaulota         Candidatus Acetothermia bacterium
30476651 30476651 PRJEB75017_P_NODE_16773_length_246_cov_0.901734_g16644_i0 PRJEB75017 16773 246 0.901734 2.21826564 Patescibacteria group bacterium 2052139 Bacteria Bacteria 78.2 6.08e-16   NR MBZ9572257.1 2052139 g16644 i0 60.6 1.47560975609756 66 26 80.5 0 199 2 95 160 MBZ9572257.1 RNA polymerase sigma factor [Patescibacteria group bacterium] diamond 363 78.2 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
30634289 30634289 PRJEB75017_P_NODE_15573_length_249_cov_0.886364_g15444_i0 PRJEB75017 15573 249 0.886364 2.20704636 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 47.8 2.98e-4   NR MET0151083.1 2838779 g15444 i0 42.9 1.65060240963855 63 31 74.7 2 1 186 35 93 MET0151083.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Binatia bacterium] diamond 411 47.8 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
30666026 30666026 PRJEB75017_P_NODE_9173_length_299_cov_1.230088_g9044_i0 PRJEB75017 9173 299 1.230088 3.67796312 Candidatus Poribacteria bacterium 2026781 Bacteria Bacteria 52.8 2.1e-5   NR RKU30739.1 2026781 g9044 i0 31.2 1.83612040133779 93 42 84.3 3 32 283 349 428 RKU30739.1 MAG: hypothetical protein C6497_03410 [Candidatus Poribacteria bacterium] diamond 549 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria bacterium
31108268 31108268 PRJEB75017_P_NODE_8335_length_312_cov_0.979079_g8206_i0 PRJEB75017 8335 312 0.979079 3.05472648 Candidatus Magasanikbacteria bacterium RIFOXYD2_FULL_36_9 1798707 Bacteria Bacteria 46.2 0.0027   NR OGH88571.1 1798707 g8206 i0 46.5 0.413461538461538 43 21 39.4 1 305 183 77 119 OGH88571.1 MAG: hypothetical protein A2537_00075 [Candidatus Magasanikbacteria bacterium RIFOXYD2_FULL_36_9] diamond 129 46.2 1 Bacteria Bacteria candidate phyla   Candidatus Magasanikiibacteriota         Candidatus Magasanikbacteria bacterium RIFOXYD2_FULL_36_9
31772480 31772480 PRJEB75017_P_NODE_5917_length_363_cov_0.913793_g5788_i0 PRJEB75017 5917 363 0.913793 3.31706859 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 66.6 2.24e-10   NR NTV81380.1 2052149 g5788 i0 43 0.768595041322314 93 52 76.9 1 279 1 53 144 NTV81380.1 hypothetical protein [Candidatus Aminicenantes bacterium] diamond 279 66.6 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes bacterium
32303463 32303463 PRJEB75017_P_NODE_18859_length_227_cov_2.480519_g18730_i0 PRJEB75017 18859 227 2.480519 5.63077813 Bacteria 2 Bacteria Bacteria 51.2 1.43e-5   NR MCZ6679473.1 2026781 g18730 i0 40.7 1.4273127753304 54 32 71.4 0 164 3 36 89 MCZ6679473.1 redoxin family protein [Candidatus Poribacteria bacterium] diamond 324 51.6 0.992248062015504 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria 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);;