RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
364435 364435 PRJNA168635_P_NODE_23401_length_173_cov_1.370968_g22985_i0 PRJNA168635 23401 173 1.370968 2.37177464 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 206 1.05e-48   NTclustered gi|2874253742|emb|OY969585.1| 2026749 g22985 i0 89.157 283.242774566474 166 16 95 2 9 173 459590 459426 MAG: Ignavibacteriota bacterium isolate MFD03726.bin.c.11 genome assembly, chromosome: 1 blastn 49001 206 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
21456064 21456064 PRJNA168635_P_NODE_24557_length_170_cov_1.991736_g24141_i0 PRJNA168635 24557 170 1.991736 3.3859512 Pseudomonadati 3379134 Bacteria Bacteria 241 2.8300000000000007e-59   NTclustered gi|1938788434|gb|CP054181.1| 2053306 g24141 i0 92.771 103.517647058824 166 12 98 0 5 170 1603883 1604048 Ignavibacteria bacterium isolate H1_BAC2 chromosome blastn 17598 241 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
22041271 22041271 PRJNA168635_P_NODE_34258_length_155_cov_3.396226_g33842_i0 PRJNA168635 34258 155 3.396226 5.2641503 Ignavibacteriaceae bacterium 2651163 Bacteria Bacteria 63.9 5.89e-6   NTclustered gi|2621700951|emb|OY759785.1| 2651163 g33842 i0 100 0.219354838709677 34 0 22 0 107 140 3553048 3553015 MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1 blastn 34 63.9 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae   Ignavibacteriaceae 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);;