RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2925 · 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
26780156 26780156 PRJEB2925_P_NODE_9181_length_394_cov_3.169916_g7914_i0 PRJEB2925 9181 394 3.169916 12.48946904 Phycisphaerales bacterium 2052180 Bacteria Bacteria 45.1 0.0306   NR MCC6660190.1 2052180 g7914 i0 40 0.609137055837564 80 38 60.2 3 17 253 60 130 MCC6660190.1 hypothetical protein [Phycisphaerales bacterium] diamond 240 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27697037 27697037 PRJEB2925_P_NODE_15864_length_250_cov_1.069767_g14586_i0 PRJEB2925 15864 250 1.069767 2.6744175 Planctomycetota bacterium 2026780 Bacteria Bacteria 56.2 7.54e-8   NR MFN0008317.1 2026780 g14586 i0 64.3 0.504 42 15 50.4 0 245 120 75 116 MFN0008317.1 helix-turn-helix domain-containing protein [Planctomycetota bacterium] diamond 126 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;