RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA861969 · 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
26960021 26960021 PRJNA861969_P_NODE_33562_length_248_cov_1.760000_g33331_i0 PRJNA861969 33562 248 1.76 4.3648 Gemmataceae bacterium 2052164 Bacteria Bacteria 151 1.69e-42   NR MFO0852601.1 2052164 g33331 i0 81.7 0.991935483870968 82 15 99.2 0 2 247 259 340 MFO0852601.1 sialidase family protein [Gemmataceae bacterium] diamond 246 151 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28160734 28160734 PRJNA861969_P_NODE_27525_length_264_cov_1.476440_g27294_i0 PRJNA861969 27525 264 1.47644 3.8978016 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.3 0.013   NR MBM4009064.1 2026780 g27294 i0 38.6 1 44 24 46.6 1 249 127 135 178 MBM4009064.1 DMT family transporter [Planctomycetota bacterium] diamond 264 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30908327 30908327 PRJNA861969_P_NODE_23114_length_284_cov_1.459716_g22883_i0 PRJNA861969 23114 284 1.459716 4.14559344 Candidatus Laterigemmans baculatus 2770505 Bacteria Bacteria 180 1.77e-52   NR WP_164101029.1 2770505 g22883 i0 96.8 1.98591549295775 94 3 99.3 0 284 3 214 307 WP_164101029.1 V-type ATP synthase subunit B [Candidatus Laterigemmans baculatus] diamond 564 180 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Candidatus Laterigemmans Candidatus Laterigemmans baculatus
30939945 30939945 PRJNA861969_P_NODE_37294_length_245_cov_0.895349_g37063_i0 PRJNA861969 37294 245 0.895349 2.19360505 Planctomycetota bacterium 2026780 Bacteria Bacteria 70.1 6.57e-13   NR MCI0332210.1 2026780 g37063 i0 47.8 0.820408163265306 67 35 82 0 1 201 84 150 MCI0332210.1 hypothetical protein [Planctomycetota bacterium] diamond 201 70.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32489742 32489742 PRJNA861969_P_NODE_37559_length_245_cov_0.895349_g37328_i0 PRJNA861969 37559 245 0.895349 2.19360505 Fimbriiglobus sp. 1914235 Bacteria Bacteria 92 7.42e-20   NR MCU0705219.1 1914235 g37328 i0 57.1 0.942857142857143 77 33 94.3 0 242 12 192 268 MCU0705219.1 ATP-grasp domain-containing protein [Fimbriiglobus sp.] diamond 231 92 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus sp.

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