RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA674048", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 11 ✖

tax_kingdom 1

  • Pseudomonadati · 11 ✖

bioproject 1

  • PRJNA674048 · 11 ✖

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
1165866 1165866 PRJNA674048_P_NODE_14801_length_233_cov_2.211957_g14598_i0 PRJNA674048 14801 233 2.211957 5.15385981 Bacteria 2 Bacteria Bacteria 326 1.11e-84   NTclustered gi|2874253677|emb|OY969111.1| 171953 g14598 i0 91.736 98.6051502145923 242 9 100 7 1 233 715700 715461 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 blastn 22975 326 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
5746663 5746663 PRJNA674048_P_NODE_34025_length_153_cov_2.509615_g33822_i0 PRJNA674048 34025 153 2.509615 3.83971095 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 237 3.22e-58   NTclustered gi|2874254091|emb|OY970174.1| 171953 g33822 i0 94.737 138.790849673203 152 8 99 0 1 152 4357740 4357891 MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 blastn 21235 237 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
7021808 7021808 PRJNA674048_P_NODE_33146_length_160_cov_3.423423_g32943_i0 PRJNA674048 33146 160 3.423423 5.4774768 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 171 3.51e-38   NTclustered gi|2874254108|emb|OY970193.1| 171953 g32943 i0 91.87 141.86875 123 8 76 2 19 140 1690546 1690667 MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 blastn 22699 171 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
18495436 18495436 PRJNA674048_P_NODE_18735_length_204_cov_2.064516_g18532_i0 PRJNA674048 18735 204 2.064516 4.21161264 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 270 4.5099999999999985e-68   NTclustered gi|112980873|gb|DQ829677.1| 171953 g18532 i0 90.777 412 206 13 100 6 1 204 1814 1613 Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence blastn 84048 270 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19769958 19769958 PRJNA674048_P_NODE_22676_length_184_cov_4.059259_g22473_i0 PRJNA674048 22676 184 4.059259 7.46903656 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 220 4.06e-53   NTclustered gi|2874254159|emb|OY970389.1| 2283092 g22473 i0 90 73.4565217391304 170 17 92 0 1 170 2618324 2618155 MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1 blastn 13516 220 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
24117965 24117965 PRJNA674048_P_NODE_27339_length_169_cov_0.866667_g27136_i0 PRJNA674048 27339 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 143 8.139999999999998e-30   NTclustered gi|1886125103|gb|CP046444.1| 1617967 g27136 i0 85.926 82.3550295857988 135 17 79 2 31 164 2543462 2543595 Granulicella sp. 5B5 chromosome, complete genome blastn 13918 143 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella sp. 5B5
28881732 28881732 PRJNA674048_P_NODE_30328_length_165_cov_0.896552_g30125_i0 PRJNA674048 30328 165 0.896552 1.4793108 Candidatus Sulfotelmatobacter sp. 2771375 Bacteria Bacteria 58.5 3.35e-8   NR HTO91578.1 2771375 g30125 i0 64.7 0.927272727272727 51 17 92.7 1 12 164 338 387 HTO91578.1 trigger factor [Candidatus Sulfotelmatobacter sp.] diamond 153 58.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Candidatus Sulfotelmatobacter sp.
29197702 29197702 PRJNA674048_P_NODE_26009_length_172_cov_1.447154_g25806_i0 PRJNA674048 26009 172 1.447154 2.48910488 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 56.6 1.58e-7   NR HEX5426613.1 2952895 g25806 i0 45.6 0.994186046511628 57 31 99.4 0 1 171 100 156 HEX5426613.1 hypothetical protein [Candidatus Acidiferrales bacterium] diamond 171 56.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
29765717 29765717 PRJNA674048_P_NODE_25351_length_174_cov_1.664000_g25148_i0 PRJNA674048 25351 174 1.664 2.89536 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 90.1 2.24e-19   NR MBD0369927.1 2283092 g25148 i0 90 2.55172413793103 50 5 86.2 0 172 23 392 441 MBD0369927.1 beta-lactamase family protein [Pyrinomonadaceae bacterium] diamond 444 90.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30871595 30871595 PRJNA674048_P_NODE_30074_length_165_cov_0.896552_g29871_i0 PRJNA674048 30074 165 0.896552 1.4793108 Acidobacteriota bacterium 1978231 Bacteria Bacteria 58.5 2.78e-8   NR MBL8190196.1 1978231 g29871 i0 86.7 0.545454545454545 30 4 54.5 0 2 91 260 289 MBL8190196.1 NAD(+)/NADH kinase [Acidobacteriota bacterium] diamond 90 58.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31009917 31009917 PRJNA674048_P_NODE_28794_length_167_cov_0.881356_g28591_i0 PRJNA674048 28794 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 57.8 6.48e-8   NR PYQ65848.1 1978231 g28591 i0 62.7 7.1497005988024 51 16 91.6 1 14 166 205 252 PYQ65848.1 MAG: acetyl-CoA C-acetyltransferase [Acidobacteriota bacterium] diamond 1194 57.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;