RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA861969 · 11 ✖

analysis 1

  • diamond · 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
6340418 6340418 PRJNA861969_P_NODE_30885_length_251_cov_0.865169_g30654_i0 PRJNA861969 30885 251 0.865169 2.17157419 Acidobacteriota bacterium 1978231 Bacteria Bacteria 134 1.91e-35   NR MDQ6708045.1 1978231 g30654 i0 77.1 1.9840637450199201 83 19 99.2 0 2 250 76 158 MDQ6708045.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Acidobacteriota bacterium] diamond 498 134 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27907663 27907663 PRJNA861969_P_NODE_40725_length_242_cov_0.911243_g40494_i0 PRJNA861969 40725 242 0.911243 2.20520806 Acidobacteriota bacterium 1978231 Bacteria Bacteria 126 3.27e-35   NR MDQ3042618.1 1978231 g40494 i0 72.5 1.98347107438017 80 22 99.2 0 241 2 56 135 MDQ3042618.1 retroviral-like aspartic protease [Acidobacteriota bacterium] diamond 480 126 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28476297 28476297 PRJNA861969_P_NODE_29506_length_255_cov_1.692308_g29275_i0 PRJNA861969 29506 255 1.692308 4.3153854 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 99.8 3.79e-22   NR HEY0049768.1 2283092 g29275 i0 66.2 5.14117647058824 71 24 83.5 0 1 213 230 300 HEY0049768.1 serine/threonine-protein kinase [Pyrinomonadaceae bacterium] diamond 1311 99.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28665852 28665852 PRJNA861969_P_NODE_22307_length_288_cov_1.148837_g22076_i0 PRJNA861969 22307 288 1.148837 3.30865056 Terriglobales bacterium 2282142 Bacteria Bacteria 112 4.01e-27   NR HEX7893707.1 2282142 g22076 i0 59.8 0.958333333333333 92 37 95.8 0 1 276 223 314 HEX7893707.1 hypothetical protein [Terriglobales bacterium] diamond 276 112 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28981689 28981689 PRJNA861969_P_NODE_40628_length_242_cov_0.911243_g40397_i0 PRJNA861969 40628 242 0.911243 2.20520806 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 140 2.13e-38   NR HKE08990.1 3069120 g40397 i0 81.3 0.991735537190083 80 14 99.2 1 240 1 207 285 HKE08990.1 type I phosphomannose isomerase catalytic subunit [Candidatus Acidiferrum sp.] diamond 240 140 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
30876584 30876584 PRJNA861969_P_NODE_42174_length_238_cov_2.678788_g41943_i0 PRJNA861969 42174 238 2.678788 6.37551544 Terriglobales bacterium 2282142 Bacteria Bacteria 145 1.08e-39   NR HLB86308.1 2282142 g41943 i0 86.1 0.995798319327731 79 11 99.6 0 1 237 179 257 HLB86308.1 hypothetical protein [Terriglobales bacterium] diamond 237 145 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
31223965 31223965 PRJNA861969_P_NODE_27615_length_264_cov_0.916230_g27384_i0 PRJNA861969 27615 264 0.91623 2.4188472 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 100 7.35e-23   NR HEX8289060.1 2283092 g27384 i0 64.4 0.829545454545455 73 26 83 0 263 45 237 309 HEX8289060.1 histidine kinase [Pyrinomonadaceae bacterium] diamond 219 100 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31508987 31508987 PRJNA861969_P_NODE_23376_length_283_cov_1.166667_g23145_i0 PRJNA861969 23376 283 1.166667 3.30166761 Terriglobales bacterium 2282142 Bacteria Bacteria 76.3 9.69e-14   NR HUI50438.1 2282142 g23145 i0 55.2 1.22968197879859 58 25 60.4 1 283 113 453 510 HUI50438.1 ABC transporter substrate-binding protein [Terriglobales bacterium] diamond 348 76.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
31508988 31508988 PRJNA861969_P_NODE_32216_length_250_cov_0.870056_g31985_i0 PRJNA861969 32216 250 0.870056 2.17514 Acidobacteriota bacterium 1978231 Bacteria Bacteria 109 5.820000000000001e-26   NR MCI0661366.1 1978231 g31985 i0 64.2 0.972 81 29 97.2 0 245 3 359 439 MCI0661366.1 hypothetical protein [Acidobacteriota bacterium] diamond 243 109 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31761826 31761826 PRJNA861969_P_NODE_21877_length_290_cov_1.184332_g21646_i0 PRJNA861969 21877 290 1.184332 3.4345628 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 101 3.45e-24   NR MEQ1762575.1 2283092 g21646 i0 50 0.972413793103448 94 47 97.2 0 290 9 40 133 MEQ1762575.1 putative metallopeptidase [Pyrinomonadaceae bacterium] diamond 282 101 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32584604 32584604 PRJNA861969_P_NODE_37639_length_245_cov_0.895349_g37408_i0 PRJNA861969 37639 245 0.895349 2.19360505 Acidobacteriota bacterium 1978231 Bacteria Bacteria 166 1.42e-47   NR MEW6360570.1 1978231 g37408 i0 100 0.991836734693878 81 0 99.2 0 245 3 27 107 MEW6360570.1 hypothetical protein [Acidobacteriota bacterium] diamond 243 166 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);;