RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA799842 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
794149 794149 PRJNA799842_P_NODE_178681_length_243_cov_0.905882_g177108_i0 PRJNA799842 178681 243 0.905882 2.20129326 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 233 7.289999999999999e-57   NTclustered gi|1850839647|gb|CP053446.1| 2026749 g177108 i0 84.016 1.00411522633745 244 38 100 1 1 243 1704429 1704672 Ignavibacteriae bacterium isolate IGN2 chromosome blastn 244 233 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
4622608 4622608 PRJNA799842_P_NODE_182604_length_242_cov_0.911243_g181031_i0 PRJNA799842 182604 242 0.911243 2.20520806 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 307 4.21e-79   NTclustered gi|1958088527|gb|CP065001.1| 2049428 g181031 i0 89.627 0.995867768595041 241 25 99 0 2 242 534384 534144 Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome blastn 241 307 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales bacterium
10147305 10147305 PRJNA799842_P_NODE_148468_length_249_cov_0.875000_g146895_i0 PRJNA799842 148468 249 0.875 2.17875 Pseudomonadati 3379134 Bacteria Bacteria 60.2 1.35e-4   NTclustered gi|1958088527|gb|CP065001.1| 2049428 g146895 i0 91.304 17.0963855421687 46 0 18 3 11 56 1789587 1789546 Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome blastn 4257 60.2 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales bacterium
17371480 17371480 PRJNA799842_P_NODE_120534_length_267_cov_1.056701_g118961_i0 PRJNA799842 120534 267 1.056701 2.82139167 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 176 1.39e-39   NTclustered gi|1850839647|gb|CP053446.1| 2026749 g118961 i0 86.503 0.715355805243446 163 19 60 3 108 267 1290180 1290018 Ignavibacteriae bacterium isolate IGN2 chromosome blastn 191 176 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
19920587 19920587 PRJNA799842_P_NODE_157716_length_247_cov_0.885057_g156143_i0 PRJNA799842 157716 247 0.885057 2.18609079 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 230 9.61e-56   NTclustered gi|1958088527|gb|CP065001.1| 2049428 g156143 i0 85.202 0.902834008097166 223 33 90 0 1 223 2105273 2105495 Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome blastn 223 230 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales 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);;