RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA274362", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_clade 1

  • Bacteria candidate phyla · 5 ✖

bioproject 1

  • PRJNA274362 · 5 ✖

analysis 1

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
370711 370711 PRJNA274362_S_NODE_31101_length_171_cov_1.229508_g30981_i0 PRJNA274362 31101 171 1.229508 2.10245868 Patescibacteria group bacterium 2052139 Bacteria Bacteria 88.6 7.58e-19   NR MFA6963143.1 2052139 g30981 i0 66.1 1.94736842105263 56 19 98.2 0 170 3 275 330 MFA6963143.1 adenosylhomocysteinase [Patescibacteria group bacterium] diamond 333 88.6 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
11849168 11849168 PRJNA274362_S_NODE_2250_length_540_cov_1.767821_g2135_i0 PRJNA274362 2250 540 1.767821 9.5462334 Minisyncoccota bacterium 2053589 Bacteria Bacteria 162 3.75e-48   NR MDR3570671.1 2053589 g2135 i0 78.5 0.594444444444444 107 22 58.9 1 435 118 1 107 MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 321 162 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
28842381 28842381 PRJNA274362_S_NODE_14868_length_233_cov_1.103261_g14748_i0 PRJNA274362 14868 233 1.103261 2.57059813 Minisyncoccota bacterium 2053589 Bacteria Bacteria 68.2 1.24e-12   NR MDR3570671.1 2053589 g14748 i0 52.4 1.05579399141631 82 32 96.6 2 5 229 22 103 MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 246 68.2 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
30674263 30674263 PRJNA274362_S_NODE_19533_length_208_cov_1.308176_g19413_i0 PRJNA274362 19533 208 1.308176 2.72100608 Patescibacteria group bacterium 2052139 Bacteria Bacteria 48.1 1.64e-4   NR MEK7650155.1 2052139 g19413 i0 60.6 0.475961538461538 33 13 47.6 0 205 107 6 38 MEK7650155.1 50S ribosomal protein L6 [Patescibacteria group bacterium] diamond 99 48.1 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
31179568 31179568 PRJNA274362_S_NODE_30395_length_173_cov_0.693548_g30275_i0 PRJNA274362 30395 173 0.693548 1.19983804 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 43.9 0.00565   NR HXI03587.1 2973664 g30275 i0 44.4 0.780346820809249 45 25 78 0 8 142 300 344 HXI03587.1 ABC transporter permease [Candidatus Saccharimonadales bacterium] diamond 135 43.9 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales 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);;