RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA533623 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
8159380 8159380 PRJNA533623_P_NODE_43167_length_327_cov_7.609023_g41393_i0 PRJNA533623 43167 327 7.609023 24.88150521 Candidatus Methylacidiphilum infernorum 511746 Bacteria Bacteria 193 1.74e-44   NTclustered gi|189184875|gb|CP000975.1| 481448 g41393 i0 85.185 4.02446483180428 189 26 58 2 27 214 1875858 1875671 Methylacidiphilum infernorum V4, complete genome blastn 1316 193 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Methylacidiphilae Methylacidiphilales Methylacidiphilaceae Methylacidiphilum (ex Ratnadevi et al. 2023) Candidatus Methylacidiphilum infernorum
15810120 15810120 PRJNA533623_P_NODE_8753_length_791_cov_1.372603_g7266_i0 PRJNA533623 8753 791 1.372603 10.85728973 Candidatus Methylacidiphilum infernorum 511746 Bacteria Bacteria 508 3.92e-139   NTclustered gi|189184875|gb|CP000975.1| 481448 g7266 i0 83.045 28.8672566371681 578 80 73 11 220 791 1877017 1876452 Methylacidiphilum infernorum V4, complete genome blastn 22834 508 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Methylacidiphilae Methylacidiphilales Methylacidiphilaceae Methylacidiphilum (ex Ratnadevi et al. 2023) Candidatus Methylacidiphilum infernorum

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