RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1218818" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA1218818 · 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
9261638 9261638 PRJNA1218818_P_NODE_1348_length_1001_cov_2.010776_g1302_i0 PRJNA1218818 1348 1001 2.010776 20.12786776 Flavobacterium oreochromis 2906078 Bacteria Bacteria 1633 0   NTclustered gi|2079163087|gb|CP067377.1| 2906078 g1302 i0 96.104 555.716283716284 1001 39 100 0 1 1001 3066 4066 Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome blastn 556272 1633 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium oreochromis
16910805 16910805 PRJNA1218818_P_NODE_17954_length_294_cov_1.914027_g17887_i0 PRJNA1218818 17954 294 1.914027 5.62723938 Candidatus Hydrogenedentota bacterium 2030809 Bacteria Bacteria 226 1.52e-54   NTclustered gi|2621786419|emb|OY782877.1| 2030809 g17887 i0 80.612 26.4047619047619 294 56 100 1 1 294 2441891 2441599 MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1 blastn 7763 226 1 Bacteria FCB group Pseudomonadati Candidatus Hydrogenedentota         Candidatus Hydrogenedentota bacterium
25272502 25272502 PRJNA1218818_P_NODE_20220_length_278_cov_0.995122_g20153_i0 PRJNA1218818 20220 278 0.995122 2.76643916 Emticicia 312278 Bacteria Bacteria 431 2.81e-116   NTclustered gi|470489174|ref|NR_076911.1| 312279 g20153 i0 94.604 288.579136690647 278 15 100 0 1 278 308 31 Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence blastn 80225 431 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Emticicia Emticicia oligotrophica

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