RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA999747", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA999747 · 5 ✖

analysis 1

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
12459745 12459745 PRJNA999747_S_NODE_1910_length_218_cov_5.711230_g1878_i0 PRJNA999747 1910 218 5.71123 12.4504814 Acidobacteriota bacterium 1978231 Bacteria Bacteria 326 1.0299999999999999e-84   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g1878 i0 94.34 102.5 212 12 97 0 1 212 4649073 4649284 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 22345 326 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
17558476 17558476 PRJNA999747_S_NODE_2354_length_200_cov_6.355030_g2322_i0 PRJNA999747 2354 200 6.35503 12.71006 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 309 9.34e-80   NTclustered gi|2874254091|emb|OY970174.1| 171953 g2322 i0 94.5 158.975 200 11 100 0 1 200 4357949 4358148 MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 blastn 31795 309 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20107133 20107133 PRJNA999747_S_NODE_2356_length_200_cov_5.946746_g2324_i0 PRJNA999747 2356 200 5.946746 11.893492 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 217 5.82e-52   NTclustered gi|76574288|gb|DQ139436.1| 171953 g2324 i0 88.172 66.78 186 16 92 6 18 200 3 185 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 13356 217 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
21382737 21382737 PRJNA999747_S_NODE_2637_length_191_cov_2.681250_g2605_i0 PRJNA999747 2637 191 2.68125 5.1211875 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 316 5.28e-82   NTclustered gi|2874253760|emb|OY969701.1| 2283092 g2605 i0 97.312 207.638743455497 186 5 97 0 5 190 3174613 3174428 MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 blastn 39659 316 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
21382757 21382757 PRJNA999747_S_NODE_57_length_775_cov_6.873656_g44_i0 PRJNA999747 57 775 6.873656 53.270834 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 913 0   NTclustered gi|2874253692|emb|OY969418.1| 171953 g44 i0 88.312 112.522580645161 770 78 99 12 6 771 4233297 4232536 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 87205 913 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured 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);;