RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Microgenomatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Microgenomatota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 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
26953904 26953904 PRJNA630162_P_NODE_124542_length_172_cov_1.560976_g123019_i0 PRJNA630162 124542 172 1.560976 2.68487872 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 72 6.78e-13   NR MBI3983887.1 2093373 g123019 i0 60.7 0.976744186046512 56 22 97.7 0 172 5 311 366 MBI3983887.1 PAS domain S-box protein [Candidatus Microgenomates bacterium] diamond 168 72 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
27365587 27365587 PRJNA630162_P_NODE_70523_length_212_cov_2.797546_g69000_i0 PRJNA630162 70523 212 2.797546 5.93079752 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 53.1 4.49e-6   NR MBI3984210.1 2093373 g69000 i0 65.6 0.452830188679245 32 11 45.3 0 98 3 87 118 MBI3984210.1 histidine phosphatase family protein [Candidatus Microgenomates bacterium] diamond 96 53.1 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
30851670 30851670 PRJNA630162_P_NODE_71414_length_212_cov_2.319018_g69891_i0 PRJNA630162 71414 212 2.319018 4.91631816 Bacillati 1783272 Bacteria Bacteria 55.8 3.83e-7   NR MBI3984170.1 2093373 g69891 i0 66.7 2.80188679245283 33 11 46.7 0 210 112 166 198 MBI3984170.1 glutamine amidotransferase [Candidatus Microgenomates bacterium] diamond 594 56.2 0.99288256227758 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
32861724 32861724 PRJNA630162_P_NODE_114620_length_177_cov_1.890625_g113097_i0 PRJNA630162 114620 177 1.890625 3.34640625 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 43.5 0.00773   NR MBI4101018.1 2093373 g113097 i0 60 0.508474576271186 30 12 50.8 0 88 177 42 71 MBI4101018.1 hypothetical protein [Candidatus Microgenomates bacterium] diamond 90 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates 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);;