RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJDB14275" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJDB14275 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
8632 8632 PRJDB14275_P_NODE_5701_length_200_cov_0.863354_g5642_i0 PRJDB14275 5701 200 0.863354 1.726708 Acidobacteriota bacterium 1978231 Bacteria Bacteria 217 5.82e-52   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g5642 i0 87.831 1099.8 189 18 93 5 16 200 4648679 4648492 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 219960 217 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
2558479 2558479 PRJDB14275_P_NODE_5963_length_193_cov_0.967532_g5904_i0 PRJDB14275 5963 193 0.967532 1.86733676 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 217 5.5799999999999996e-52   NTclustered gi|2874253852|emb|OY969908.1| 194844 g5904 i0 92.715 11.7253886010363 151 9 82 2 36 184 1784333 1784483 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1 blastn 2263 217 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
5111046 5111046 PRJDB14275_P_NODE_7125_length_168_cov_1.263566_g7066_i0 PRJDB14275 7125 168 1.263566 2.12279088 Tunturiibacter psychrotolerans 3069686 Bacteria Bacteria 132 1.7600000000000002e-26   NTclustered gi|2750702178|gb|CP132942.1| 3069686 g7066 i0 82.353 0.910714285714286 153 25 90 2 15 166 1031725 1031876 Tunturiibacter psychrotolerans strain X5P6 chromosome blastn 153 132 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Tunturiibacter Tunturiibacter psychrotolerans
6386923 6386923 PRJDB14275_P_NODE_7446_length_163_cov_1.427419_g7387_i0 PRJDB14275 7446 163 1.427419 2.32669297 uncultured Granulicella sp. 1241325 Bacteria Bacteria 97.1 6.19e-16   NTclustered gi|2836016419|emb|OZ196149.1| 1241325 g7387 i0 95.161 3.30674846625767 62 2 38 1 43 104 369609 369669 MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 2 blastn 539 97.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.
12762185 12762185 PRJDB14275_P_NODE_7751_length_159_cov_0.958333_g7692_i0 PRJDB14275 7751 159 0.958333 1.52374947 Edaphobacter sp. 12200R-103 2703788 Bacteria Bacteria 132 1.64e-26   NTclustered gi|1804497213|gb|CP048114.1| 2703788 g7692 i0 87.719 1.35220125786164 114 13 71 1 42 154 3266038 3265925 Edaphobacter sp. 12200R-103 chromosome, complete genome blastn 215 132 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp. 12200R-103
16585443 16585443 PRJDB14275_P_NODE_5914_length_194_cov_1.309677_g5855_i0 PRJDB14275 5914 194 1.309677 2.54077338 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 172 1.23e-38   NTclustered gi|2874253750|emb|OY969625.1| 194844 g5855 i0 84.239 0.948453608247423 184 22 93 6 1 180 979190 979010 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1 blastn 184 172 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae 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);;