RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

1 row where analysis = "blastn", bioproject = "PRJNA1104180" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 1 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1104180 · 1 ✖

analysis 1

  • blastn · 1 ✖
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
8673499 8673499 PRJNA1104180_P_NODE_2047_length_607_cov_1.986891_g1906_i0 PRJNA1104180 2047 607 1.986891 12.06042837 Candidatus Xiphinematobacter 134550 Bacteria Bacteria 664 0   NTclustered gi|939198278|gb|CP012665.1| 1704307 g1906 i0 89.827 134.505766062603 521 48 85 5 90 607 15161 15679 Candidatus Xiphinematobacter sp. Idaho Grape, complete genome blastn 81645 665 0.998496240601504 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria     Candidatus Xiphinematobacter Candidatus Xiphinematobacter sp. Idaho Grape

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