RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_phylum = "Candidatus Tectimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Tectimicrobiota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 3 ✖

analysis 1

  • diamond · 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
26600559 26600559 PRJNA429937_P_NODE_136121_length_212_cov_2.595628_g113494_i0 PRJNA429937 136121 212 2.595628 5.50273136 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 63.5 1.91e-10   NR HEY7495866.1 2528274 g113494 i0 85.7 0.495283018867925 35 5 49.5 0 210 106 93 127 HEY7495866.1 type II toxin-antitoxin system VapC family toxin [Candidatus Tectimicrobiota bacterium] diamond 105 63.5 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
27075717 27075717 PRJNA429937_P_NODE_79422_length_368_cov_2.651917_g57058_i0 PRJNA429937 79422 368 2.651917 9.75905456 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 87.8 1.23e-17   NR HEX2277039.1 2528274 g57058 i0 88.4 0.35054347826087 43 5 35.1 0 368 240 308 350 HEX2277039.1 cyclase family protein [Candidatus Tectimicrobiota bacterium] diamond 129 87.8 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
27265467 27265467 PRJNA429937_P_NODE_95083_length_317_cov_2.579861_g72488_i0 PRJNA429937 95083 317 2.579861 8.17815937 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 87.4 1.25e-17   NR HEX9868724.1 2528274 g72488 i0 71.4 0.529968454258675 56 16 53 0 260 93 209 264 HEX9868724.1 group II intron reverse transcriptase/maturase [Candidatus Tectimicrobiota bacterium] diamond 168 87.4 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota 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);;