RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
26949590 26949590 PRJNA474426_P_NODE_28582_length_180_cov_2.793893_g28377_i0 PRJNA474426 28582 180 2.793893 5.0290074 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 76.3 6.69e-16   NR MEN6536664.1 2212468 g28377 i0 66.7 0.9 54 17 90 1 19 180 17 69 MEN6536664.1 DUF2829 domain-containing protein [Bryobacteraceae bacterium] diamond 162 76.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27044666 27044666 PRJNA474426_P_NODE_35142_length_164_cov_0.886957_g34937_i0 PRJNA474426 35142 164 0.886957 1.45460948 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 70.5 2.1e-12   NR MCU0237952.1 2283092 g34937 i0 59.3 1.95731707317073 54 19 98.8 1 2 163 755 805 MCU0237952.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 321 70.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27329255 27329255 PRJNA474426_P_NODE_14663_length_271_cov_2.283784_g14458_i0 PRJNA474426 14663 271 2.283784 6.18905464 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 69.3 8.86e-12   NR HXT10452.1 2976921 g14458 i0 60 0.608856088560886 55 22 60.9 0 167 3 5 59 HXT10452.1 acyltransferase [Candidatus Angelobacter sp.] diamond 165 69.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
27550088 27550088 PRJNA474426_P_NODE_5624_length_455_cov_3.453202_g5423_i0 PRJNA474426 5624 455 3.453202 15.7120691 Bryobacter aggregatus 360054 Bacteria Bacteria 279 5.47e-85   NR WP_031497699.1 360054 g5423 i0 84.7 6.92307692307692 150 23 98.9 0 6 455 179 328 WP_031497699.1 PSD1 and planctomycete cytochrome C domain-containing protein [Bryobacter aggregatus] diamond 3150 279 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Bryobacter Bryobacter aggregatus
27739987 27739987 PRJNA474426_P_NODE_1204_length_823_cov_10.638243_g1083_i0 PRJNA474426 1204 823 10.638243 87.55273989 Chloracidobacterium sp. 2099375 Bacteria Bacteria 179 3.54e-48   NR MBK8467752.1 2099375 g1083 i0 55.9 0.554070473876063 152 66 55 1 453 1 91 242 MBK8467752.1 hypothetical protein [Chloracidobacterium sp.] diamond 456 179 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
28150261 28150261 PRJNA474426_P_NODE_30885_length_172_cov_1.235772_g30680_i0 PRJNA474426 30885 172 1.235772 2.12552784 Blastocatellia bacterium 2052146 Bacteria Bacteria 56.2 2.06e-7   NR HEU0174549.1 2052146 g30680 i0 49 1.7093023255814 49 24 85.5 1 2 148 207 254 HEU0174549.1 hypothetical protein [Blastocatellia bacterium] diamond 294 56.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28687139 28687139 PRJNA474426_P_NODE_31887_length_169_cov_0.866667_g31682_i0 PRJNA474426 31887 169 0.866667 1.46466723 Acidobacteriota bacterium 1978231 Bacteria Bacteria 80.5 2.81e-18   NR MDE2963407.1 1978231 g31682 i0 82.4 3.63905325443787 51 9 90.5 0 16 168 19 69 MDE2963407.1 KH domain-containing protein [Acidobacteriota bacterium] diamond 615 80.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28844549 28844549 PRJNA474426_P_NODE_34948_length_164_cov_0.904348_g34743_i0 PRJNA474426 34948 164 0.904348 1.48313072 Kocuria sp. cx-455 2771377 Bacteria Bacteria 58.5 3.36e-8   NR WP_190806976.1 2771377 g34743 i0 90.3 0.567073170731707 31 3 56.7 0 93 1 1 31 WP_190806976.1 bifunctional NAD(P)/FAD-dependent oxidoreductase/class I SAM-dependent methyltransferase [Kocuria sp. cx-455] diamond 93 58.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Kocuria sp. cx-455
28971079 28971079 PRJNA474426_P_NODE_15708_length_260_cov_1.748815_g15503_i0 PRJNA474426 15708 260 1.748815 4.546919 Candidatus Polarisedimenticolia bacterium 3069555 Bacteria Bacteria 43.1 0.00338   NR HXS68308.1 3069555 g15503 i0 58.3 0.415384615384615 36 15 41.5 0 123 16 5 40 HXS68308.1 hypothetical protein [Candidatus Polarisedimenticolia bacterium] diamond 108 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Candidatus Polarisedimenticolia       Candidatus Polarisedimenticolia bacterium
29192172 29192172 PRJNA474426_P_NODE_20009_length_223_cov_3.482759_g19804_i0 PRJNA474426 20009 223 3.482759 7.76655257 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.1 0.00293   NR HET6890493.1 2283092 g19804 i0 43.8 0.645739910313901 48 25 61.9 1 44 181 138 185 HET6890493.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 144 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29286646 29286646 PRJNA474426_P_NODE_2189_length_665_cov_5.996753_g2040_i0 PRJNA474426 2189 665 5.996753 39.87840745 Geothrix sp. 1962974 Bacteria Bacteria 278 7.71e-84   NR MDP1831006.1 1962974 g2040 i0 59.5 1.0015037593985 222 84 97.4 1 655 8 414 635 MDP1831006.1 carboxypeptidase regulatory-like domain-containing protein [Geothrix sp.] diamond 666 278 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
29871264 29871264 PRJNA474426_P_NODE_33471_length_166_cov_0.888889_g33266_i0 PRJNA474426 33471 166 0.888889 1.47555574 Granulicella 940557 Bacteria Bacteria 94.7 3.33e-21   NR WP_089406354.1 474952 g33266 i0 80 5.96385542168675 55 11 99.4 0 165 1 299 353 WP_089406354.1 pyridoxal phosphate-dependent aminotransferase [Granulicella rosea] diamond 990 95.5 0.991623036649215 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella rosea
30013189 30013189 PRJNA474426_P_NODE_3351_length_570_cov_3.247601_g3172_i0 PRJNA474426 3351 570 3.247601 18.5113257 Terriglobia bacterium 2081523 Bacteria Bacteria 75.1 4.67e-12   NR MBZ5499058.1 2081523 g3172 i0 30.8 0.631578947368421 120 77 63.2 1 188 547 2 115 MBZ5499058.1 hypothetical protein [Terriglobia bacterium] diamond 360 75.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
30739732 30739732 PRJNA474426_P_NODE_9854_length_342_cov_1.955631_g9649_i0 PRJNA474426 9854 342 1.955631 6.68825802 Blastocatellia bacterium 2052146 Bacteria Bacteria 178 5.01e-52   NR MCI0487222.1 2052146 g9649 i0 84.5 0.903508771929825 103 15 90.4 1 3 311 306 407 MCI0487222.1 hypothetical protein [Blastocatellia bacterium] diamond 309 178 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30771530 30771530 PRJNA474426_P_NODE_10374_length_333_cov_1.528169_g10169_i0 PRJNA474426 10374 333 1.5281690000000001 5.08880277 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 66.6 6.28e-11   NR HZS57567.1 2212468 g10169 i0 59.2 0.441441441441441 49 17 41.4 1 181 44 101 149 HZS57567.1 hypothetical protein [Bryobacteraceae bacterium] diamond 147 66.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31024180 31024180 PRJNA474426_P_NODE_29115_length_178_cov_2.077519_g28910_i0 PRJNA474426 29115 178 2.077519 3.69798382 Acidobacteriota bacterium 1978231 Bacteria Bacteria 53.9 1.79e-6   NR MEY4636518.1 1978231 g28910 i0 75 0.539325842696629 32 8 53.9 0 109 14 1 32 MEY4636518.1 hypothetical protein [Acidobacteriota bacterium] diamond 96 53.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31024181 31024181 PRJNA474426_P_NODE_29655_length_176_cov_1.992126_g29450_i0 PRJNA474426 29655 176 1.992126 3.50614176 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 105 2.61e-25   NR MDX1984980.1 2212468 g29450 i0 86.8 1.82386363636364 53 7 90.3 0 18 176 288 340 MDX1984980.1 sulfite dehydrogenase [Bryobacteraceae bacterium] diamond 321 105 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31213284 31213284 PRJNA474426_P_NODE_19855_length_224_cov_5.640000_g19650_i0 PRJNA474426 19855 224 5.64 12.6336 Terriglobia bacterium 2081523 Bacteria Bacteria 49.7 1.07e-4   NR MBZ5643996.1 2081523 g19650 i0 49.1 0.709821428571429 53 26 71 1 10 168 617 668 MBZ5643996.1 MBG domain-containing protein [Terriglobia bacterium] diamond 159 49.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31593464 31593464 PRJNA474426_P_NODE_35776_length_163_cov_0.903509_g35571_i0 PRJNA474426 35776 163 0.903509 1.47271967 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 75.1 4.87e-14   NR MBX7169406.1 2283092 g35571 i0 68 1.84049079754601 50 16 92 0 14 163 396 445 MBX7169406.1 argininosuccinate lyase [Pyrinomonadaceae bacterium] diamond 300 75.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31751275 31751275 PRJNA474426_P_NODE_25977_length_191_cov_1.063380_g25772_i0 PRJNA474426 25977 191 1.06338 2.0310558 Acidobacteriota bacterium 1978231 Bacteria Bacteria 94.7 9.68e-22   NR MBM3754242.1 1978231 g25772 i0 93.5 0.722513089005236 46 3 72.3 0 190 53 149 194 MBM3754242.1 sugar phosphate isomerase/epimerase [Acidobacteriota bacterium] diamond 138 94.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32226144 32226144 PRJNA474426_P_NODE_5338_length_466_cov_2.908873_g5142_i0 PRJNA474426 5338 466 2.908873 13.55534818 Acidobacteriota bacterium 1978231 Bacteria Bacteria 201 1.65e-56   NR MBM3760503.1 1978231 g5142 i0 71 1.87982832618026 145 41 93.3 1 15 449 967 1110 MBM3760503.1 hypothetical protein [Acidobacteriota bacterium] diamond 876 201 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32257984 32257984 PRJNA474426_P_NODE_19298_length_228_cov_1.960894_g19093_i0 PRJNA474426 19298 228 1.960894 4.47083832 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 42.7 0.0292   NR HEY2435485.1 2910147 g19093 i0 35.6 0.776315789473684 59 37 77.6 1 223 47 267 324 HEY2435485.1 inorganic phosphate transporter [Vicinamibacterales bacterium] diamond 177 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32352818 32352818 PRJNA474426_P_NODE_13319_length_287_cov_2.159664_g13114_i0 PRJNA474426 13319 287 2.159664 6.19823568 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.4 0.00738   NR NBO64410.1 1978231 g13114 i0 31.4 0.731707317073171 70 37 69 2 283 86 817 879 NBO64410.1 hypothetical protein [Acidobacteriota bacterium] diamond 210 45.4 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);;