RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA556992" 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

  • PRJNA556992 · 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
1799019 1799019 PRJNA556992_P_NODE_112622_length_390_cov_10.441640_g110436_i0 PRJNA556992 112622 390 10.44164 40.722396 Ignavibacteria bacterium 2053306 Bacteria Bacteria 187 9.79e-43   NTclustered gi|1938788434|gb|CP054181.1| 2053306 g110436 i0 91.304 6.07948717948718 138 11 35 1 3 140 2488197 2488333 Ignavibacteria bacterium isolate H1_BAC2 chromosome blastn 2371 187 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
3085947 3085947 PRJNA556992_P_NODE_942663_length_236_cov_4.134969_g940473_i0 PRJNA556992 942663 236 4.134969 9.75852684 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 431 2.33e-116   NTclustered gi|1938792964|gb|CP054182.1| 2049428 g940473 i0 99.576 1 236 1 100 0 1 236 1629900 1629665 Ignavibacteriales bacterium isolate H2_BAC3 chromosome, complete genome blastn 236 431 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales     Ignavibacteriales bacterium
9459117 9459117 PRJNA556992_P_NODE_589868_length_259_cov_6.500000_g587679_i0 PRJNA556992 589868 259 6.5 16.835 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 191 4.79e-44   NTclustered gi|1850842921|gb|CP053447.1| 2026749 g587679 i0 81.328 281.988416988417 241 39 91 5 6 241 429213 428974 Ignavibacteriae bacterium isolate IGN3 chromosome blastn 73035 191 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
14558706 14558706 PRJNA556992_P_NODE_518292_length_265_cov_4.880208_g516103_i0 PRJNA556992 518292 265 4.880208 12.9325512 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 211 3.78e-50   NTclustered gi|1850839647|gb|CP053446.1| 2026749 g516103 i0 83.628 1.65283018867925 226 35 85 2 1 225 3441611 3441387 Ignavibacteriae bacterium isolate IGN2 chromosome blastn 438 211 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
19656740 19656740 PRJNA556992_P_NODE_577376_length_260_cov_8.251337_g575187_i0 PRJNA556992 577376 260 8.251337 21.4534762 Ignavibacteriales bacterium 2049428 Bacteria Bacteria 154 6.31e-33   NTclustered gi|1958088527|gb|CP065001.1| 2049428 g575187 i0 81.967 5.00769230769231 183 31 70 2 45 226 3073792 3073611 Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome blastn 1302 154 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);;