RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1148190" and tax_clade = "Candidatus Halobeggiatoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Candidatus Halobeggiatoa · 3 ✖

bioproject 1

  • PRJNA1148190 · 3 ✖

analysis 1

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
6676117 6676117 PRJNA1148190_P_NODE_625246_length_249_cov_0.875000_g614073_i0 PRJNA1148190 625246 249 0.875 2.17875 Candidatus Halobeggiatoa sp. HSG11 3055495 Bacteria Bacteria 133 9.08e-36   NR MDM8566148.1 3055495 g614073 i0 68.7 1.98795180722892 83 26 100 0 1 249 89 171 MDM8566148.1 electron transport complex subunit RsxD [Candidatus Halobeggiatoa sp. HSG11] diamond 495 133 1 Bacteria Candidatus Halobeggiatoa Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Thiotrichaceae   Candidatus Halobeggiatoa sp. HSG11
27027956 27027956 PRJNA1148190_P_NODE_569902_length_253_cov_1.566667_g558729_i0 PRJNA1148190 569902 253 1.566667 3.96366751 Bacteria 2 Bacteria Bacteria 104 6.74e-24   NR MDM8564118.1 3055495 g558729 i0 63.5 3.02371541501976 85 30 99.6 1 1 252 255 339 MDM8564118.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Candidatus Halobeggiatoa sp. HSG11] diamond 765 104 1 Bacteria Candidatus Halobeggiatoa Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Thiotrichaceae   Candidatus Halobeggiatoa sp. HSG11
27450734 27450734 PRJNA1148190_P_NODE_491983_length_268_cov_1.492308_g480810_i0 PRJNA1148190 491983 268 1.492308 3.99938544 Candidatus Halobeggiatoa sp. HSG11 3055495 Bacteria Bacteria 97.1 3.53e-24   NR MDM8564847.1 3055495 g480810 i0 58 0.906716417910448 81 34 90.7 0 26 268 1 81 MDM8564847.1 hypothetical protein [Candidatus Halobeggiatoa sp. HSG11] diamond 243 97.1 1 Bacteria Candidatus Halobeggiatoa Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Thiotrichaceae   Candidatus Halobeggiatoa sp. HSG11

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