RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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

  • PRJNA1111448 · 2 ✖

analysis 1

  • diamond · 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
28109980 28109980 PRJNA1111448_S_NODE_105925_length_265_cov_1.604167_g105102_i0 PRJNA1111448 105925 265 1.604167 4.25104255 Pedosphaera parvula 1032527 Bacteria Bacteria 43.5 0.0259   NR WP_202796881.1 1032527 g105102 i0 45.7 0.520754716981132 46 22 49.8 2 159 28 374 418 WP_202796881.1 alpha-amylase family glycosyl hydrolase [Pedosphaera parvula] diamond 138 43.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
28331065 28331065 PRJNA1111448_S_NODE_77966_length_299_cov_0.893805_g77143_i0 PRJNA1111448 77966 299 0.893805 2.67247695 Opitutales bacterium 2026772 Bacteria Bacteria 45.1 0.00423   NR HKK18438.1 2026772 g77143 i0 32.1 0.561872909698997 56 38 56.2 0 287 120 73 128 HKK18438.1 Hsp20/alpha crystallin family protein [Opitutales bacterium] diamond 168 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales 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);;