RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJDB4941" and tax_phylum = "Candidatus Parcubacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Parcubacteria · 4 ✖

tax_clade 1

bioproject 1

  • PRJDB4941 · 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
28358848 28358848 PRJDB4941_P_NODE_20006_length_229_cov_1.622222_g19238_i0 PRJDB4941 20006 229 1.622222 3.71488838 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 107 3.01e-26   NR MEN9920375.1 2762014 g19238 i0 74.6 1.86026200873362 71 18 93 0 228 16 70 140 MEN9920375.1 UDP-glucose 6-dehydrogenase [Candidatus Parcubacteria bacterium] diamond 426 107 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
32087267 32087267 PRJDB4941_P_NODE_37678_length_165_cov_0.965517_g36910_i0 PRJDB4941 37678 165 0.965517 1.59310305 Parcubacteria bacterium C7867- 2762014 Bacteria Bacteria 59.3 1.88e-8   NR KND47344.1 1659198 g36910 i0 54.3 1.67272727272727 46 21 83.6 0 165 28 84 129 KND47344.1 MAG: putative endopeptidase [Parcubacteria bacterium C7867-004] diamond 276 59.3 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium C7867-004
32309063 32309063 PRJDB4941_P_NODE_36939_length_166_cov_0.888889_g36171_i0 PRJDB4941 36939 166 0.888889 1.47555574 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 48.1 1.59e-4   NR MEY2671656.1 2762014 g36171 i0 40.4 0.939759036144578 52 31 94 0 6 161 485 536 MEY2671656.1 hypothetical protein [Candidatus Parcubacteria bacterium] diamond 156 48.1 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
32498803 32498803 PRJDB4941_P_NODE_37899_length_165_cov_0.896552_g37131_i0 PRJDB4941 37899 165 0.896552 1.4793108 Parcubacteria bacterium C7867- 2762014 Bacteria Bacteria 49.7 4.55e-5   NR KND49189.1 1659202 g37131 i0 44.4 0.981818181818182 54 30 98.2 0 164 3 61 114 KND49189.1 MAG: Mucin-2 precursor [Parcubacteria bacterium C7867-008] diamond 162 49.7 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium C7867-008

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