RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
3847553 3847553 PRJEB14803_P_NODE_12264_length_357_cov_1.850932_g11799_i0 PRJEB14803 12264 357 1.850932 6.60782724 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 56.5 0.003   NTclustered gi|2814788339|emb|OY761475.2| 2910147 g11799 i0 96.97 0.092436974789916 33 1 9 0 210 242 6285066 6285098 MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1 blastn 33 56.5 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
6399576 6399576 PRJEB14803_P_NODE_24406_length_226_cov_2.926702_g23940_i0 PRJEB14803 24406 226 2.926702 6.61434652 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 110 1.18e-19   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g23940 i0 81.022 5.00884955752212 137 26 61 0 1 137 2596596 2596460 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 1132 110 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
19147044 19147044 PRJEB14803_P_NODE_6236_length_545_cov_53.903922_g5800_i0 PRJEB14803 6236 545 53.903922 293.7763749 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 54.7 0.015   NTclustered gi|2874253959|emb|OY970284.1| 2651171 g5800 i0 96.97 0.0605504587155963 33 0 6 1 504 536 70778 70809 MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 blastn 33 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
22973418 22973418 PRJEB14803_P_NODE_27199_length_211_cov_1.136364_g26733_i0 PRJEB14803 27199 211 1.136364 2.39772804 Sulfidibacter corallicola 2818388 Bacteria Bacteria 154 4.94e-33   NTclustered gi|2013124720|gb|CP071793.1| 2818388 g26733 i0 82.659 8.5260663507109 173 30 82 0 14 186 2334315 2334487 Sulfidibacter corallicola strain M133 chromosome, complete genome blastn 1799 154 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Acanthopleuribacterales Acanthopleuribacteraceae Sulfidibacter Sulfidibacter corallicola
24247332 24247332 PRJEB14803_P_NODE_38400_length_170_cov_1.059259_g37934_i0 PRJEB14803 38400 170 1.059259 1.8007403 Edaphobacter sp. 4G125 2763071 Bacteria Bacteria 54.7 0.004   NTclustered gi|1895667655|gb|CP060393.1| 2763071 g37934 i0 100 0.170588235294118 29 0 17 0 100 128 3779318 3779290 Edaphobacter sp. 4G125 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp. 4G125

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);;