RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA603943 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
9506323 9506323 PRJNA603943_P_NODE_64668_length_244_cov_0.900585_g64476_i0 PRJNA603943 64668 244 0.900585 2.1974274 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 56.5 0.002   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g64476 i0 96.97 0.364754098360656 33 1 14 0 179 211 6729796 6729764 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 89 56.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
18429642 18429642 PRJNA603943_P_NODE_54135_length_250_cov_1.576271_g53943_i0 PRJNA603943 54135 250 1.576271 3.9406775 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 287 5.7e-73   NTclustered gi|2874253885|emb|OY970060.1| 171953 g53943 i0 87.402 72.844 254 27 100 4 1 250 4840751 4840499 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 18211 287 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
21545212 21545212 PRJNA603943_P_NODE_65877_length_243_cov_1.358824_g65685_i0 PRJNA603943 65877 243 1.358824 3.30194232 Bacteria 2 Bacteria Bacteria 108 4.61e-19   NTclustered gi|2874253700|emb|OY969426.1| 2651171 g65685 i0 88.636 33.679012345679 88 10 36 0 156 243 3433815 3433902 MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 blastn 8184 108 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);;