RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093008 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28322222 28322222 PRJNA1093008_S_NODE_18006_length_384_cov_1.627010_g17679_i0 PRJNA1093008 18006 384 1.62701 6.2477184 Candidatus Merdousia 2840660 Bacteria Bacteria 130 6.59e-35   NR MBP3525086.1 2026772 g17679 i0 68.9 3.0234375 90 28 70.3 0 270 1 14 103 MBP3525086.1 YggS family pyridoxal phosphate-dependent enzyme [Opitutales bacterium] diamond 1161 131 0.99236641221374 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
28393964 28393964 PRJNA1093008_S_NODE_87906_length_246_cov_2.502890_g87579_i0 PRJNA1093008 87906 246 2.50289 6.1571094 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.7 0.0368   NR MES2597082.1 2026799 g87579 i0 27.7 1.23170731707317 101 51 96.3 2 5 241 59 159 MES2597082.1 acyltransferase [Verrucomicrobiota bacterium] diamond 303 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28709951 28709951 PRJNA1093008_S_NODE_16967_length_389_cov_5.126582_g16640_i0 PRJNA1093008 16967 389 5.126582 19.94240398 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 55.1 6.37e-6   NR HEU6449705.1 2499141 g16640 i0 44 0.77120822622108 100 44 73.3 4 359 75 18 110 HEU6449705.1 KGG domain-containing protein [Verrucomicrobiia bacterium] diamond 300 55.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29435679 29435679 PRJNA1093008_S_NODE_79390_length_253_cov_1.877778_g79063_i0 PRJNA1093008 79390 253 1.877778 4.75077834 Opitutus sp. 1913982 Bacteria Bacteria 45.1 0.00662   NR MSU23188.1 1913982 g79063 i0 38.3 0.557312252964427 47 29 55.7 0 1 141 203 249 MSU23188.1 RNA polymerase-associated protein RapA [Opitutus sp.] diamond 141 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp.

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