RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 0

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
15612738 15612738 PRJNA1160211_S_NODE_23593_length_686_cov_27.264274_g22553_i0 PRJNA1160211 23593 686 27.264274 187.03291964 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 210 2.48e-60   NR HYM33218.1 2952917 g22553 i0 58.4 0.756559766763848 173 71 75.7 1 168 686 24 195 HYM33218.1 ABC transporter ATP-binding protein/permease [Candidatus Cybelea sp.] diamond 519 210 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
29914229 29914229 PRJNA1160211_S_NODE_17991_length_724_cov_23.887865_g17029_i0 PRJNA1160211 17991 724 23.887865 172.9481426 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 258 4.24e-84   NR MFA5505376.1 3107663 g17029 i0 72 0.75414364640884 182 51 75.4 0 552 7 1 182 MFA5505376.1 50S ribosomal protein L10 [Vulcanimicrobiota bacterium] diamond 546 258 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
32821639 32821639 PRJNA1160211_S_NODE_277380_length_244_cov_0.900585_g276147_i0 PRJNA1160211 277380 244 0.900585 2.1974274 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 59.7 1.41e-9   NR HVA28692.1 2952909 g276147 i0 51.4 0.885245901639344 72 33 86.1 1 219 10 2 73 HVA28692.1 type II toxin-antitoxin system VapB family antitoxin [Candidatus Baltobacteraceae bacterium] diamond 216 59.7 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae 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);;