RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Candidatus Latescibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Latescibacterota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB11748 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27285771 27285771 PRJEB11748_P_NODE_351543_length_197_cov_2.992647_g349360_i0 PRJEB11748 351543 197 2.992647 5.89551459 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 92 5.29e-20   NR MSR82164.1 2053570 g349360 i0 76.4 1.65989847715736 55 13 83.8 0 18 182 142 196 MSR82164.1 FtsX-like permease family protein [Candidatus Latescibacterota bacterium] diamond 327 92 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
27948894 27948894 PRJEB11748_P_NODE_245165_length_250_cov_1.851852_g242982_i0 PRJEB11748 245165 250 1.851852 4.62963 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 71.6 9.37e-13   NR HCP99413.1 2053570 g242982 i0 48.6 1.716 72 35 85.2 2 234 22 11 81 HCP99413.1 hypothetical protein [Candidatus Latescibacterota bacterium] diamond 429 71.6 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
28896093 28896093 PRJEB11748_P_NODE_59128_length_553_cov_4.583333_g56998_i0 PRJEB11748 59128 553 4.583333 25.34583149 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 220 2.7099999999999998e-67   NR MSR82125.1 2053570 g56998 i0 86.8 0.656419529837251 121 16 65.6 0 23 385 272 392 MSR82125.1 aminopeptidase P family protein [Candidatus Latescibacterota bacterium] diamond 363 220 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
30475441 30475441 PRJEB11748_P_NODE_83893_length_458_cov_3.085642_g81728_i0 PRJEB11748 83893 458 3.085642 14.13224036 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 54.3 2.81e-5   NR MFC1552251.1 2053570 g81728 i0 37.3 0.38646288209607 59 36 38.6 1 438 262 284 341 MFC1552251.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Latescibacterota bacterium] diamond 177 54.3 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
30791248 30791248 PRJEB11748_P_NODE_388694_length_173_cov_5.562500_g386511_i0 PRJEB11748 388694 173 5.5625 9.623125 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 52.4 2.79e-6   NR MSR84724.1 2053570 g386511 i0 65.1 0.745664739884393 43 7 60.7 1 116 12 38 80 MSR84724.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Latescibacterota bacterium] diamond 129 52.4 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota 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);;