RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1087264", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1087264 · 7 ✖

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
14222694 14222694 PRJNA1087264_P_NODE_10732_length_193_cov_1.034722_g10650_i0 PRJNA1087264 10732 193 1.034722 1.99701346 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 145 2.6699999999999997e-30   NTclustered gi|2621704042|emb|OY760734.1| 2910147 g10650 i0 81.421 2.92227979274611 183 28 93 5 1 180 1145296 1145475 MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1 blastn 564 145 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27090612 27090612 PRJNA1087264_P_NODE_5522_length_272_cov_1.026906_g5440_i0 PRJNA1087264 5522 272 1.026906 2.79318432 Pseudomonadati 3379134 Bacteria Bacteria 54.3 4.4e-6   NR MEZ5401446.1 2212468 g5440 i0 35.4 2.95588235294118 99 52 99.3 3 270 1 266 361 MEZ5401446.1 DUF3395 domain-containing protein [Bryobacteraceae bacterium] diamond 804 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27320477 27320477 PRJNA1087264_P_NODE_9503_length_204_cov_1.903226_g9421_i0 PRJNA1087264 9503 204 1.903226 3.88258104 Blastocatellia bacterium 2052146 Bacteria Bacteria 57 1.83e-7   NR HEU4390898.1 2052146 g9421 i0 42.4 2.88235294117647 66 38 97.1 0 204 7 197 262 HEU4390898.1 queuosine salvage family protein [Blastocatellia bacterium] diamond 588 57 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
27415452 27415452 PRJNA1087264_P_NODE_19263_length_163_cov_0.894737_g19181_i0 PRJNA1087264 19263 163 0.894737 1.45842131 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.8 0.00105   NR MBN2431957.1 1978231 g19181 i0 39.6 0.975460122699387 53 32 97.5 0 163 5 527 579 MBN2431957.1 hypothetical protein [Acidobacteriota bacterium] diamond 159 45.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29057134 29057134 PRJNA1087264_P_NODE_14428_length_167_cov_0.864407_g14346_i0 PRJNA1087264 14428 167 0.864407 1.44355969 Blastocatellia bacterium 2052146 Bacteria Bacteria 60.5 7.34e-9   NR HEX4945165.1 2052146 g14346 i0 42.9 1.0059880239521 56 31 98.8 1 3 167 214 269 HEX4945165.1 hypothetical protein [Blastocatellia bacterium] diamond 168 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30225443 30225443 PRJNA1087264_P_NODE_3352_length_359_cov_1.141935_g3271_i0 PRJNA1087264 3352 359 1.141935 4.09954665 Acidobacteriota bacterium 1978231 Bacteria Bacteria 111 6.19e-29   NR MDQ7008654.1 1978231 g3271 i0 84.7 0.601671309192201 72 10 60.2 1 3 218 41 111 MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] diamond 216 111 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32185689 32185689 PRJNA1087264_P_NODE_2398_length_433_cov_2.309896_g2317_i0 PRJNA1087264 2398 433 2.309896 10.00184968 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 58.9 5.89e-7   NR HZF14297.1 2651171 g2317 i0 33.1 4.02540415704388 148 91 99.1 5 430 2 66 210 HZF14297.1 IPTL-CTERM sorting domain-containing protein [Thermoanaerobaculia bacterium] diamond 1743 58.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;