RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1082072", tax_kingdom = "Bacillati" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 7 ✖

tax_kingdom 1

  • Bacillati · 7 ✖

bioproject 1

  • PRJNA1082072 · 7 ✖

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
27257117 27257117 PRJNA1082072_P_NODE_2023_length_252_cov_1.720670_g2016_i0 PRJNA1082072 2023 252 1.72067 4.3360884 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 182 1.0799999999999998e-55   NR HEY9684779.1 3088181 g2016 i0 100 1 84 0 100 0 1 252 107 190 HEY9684779.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 252 182 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
28299151 28299151 PRJNA1082072_P_NODE_2646_length_245_cov_0.895349_g2639_i0 PRJNA1082072 2646 245 0.895349 2.19360505 Leptolyngbyaceae cyanobacterium SM2_3_12 2720470 Bacteria Bacteria 70.9 4.62e-12   NR NJL45226.1 2720470 g2639 i0 51.5 0.808163265306122 66 30 78.4 1 241 50 144 209 NJL45226.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Leptolyngbyaceae cyanobacterium SM2_3_12] diamond 198 70.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Leptolyngbyaceae cyanobacterium SM2_3_12
28417117 28417117 PRJNA1082072_P_NODE_1326_length_301_cov_1.688596_g1319_i0 PRJNA1082072 1326 301 1.688596 5.08267396 Bacteria 2 Bacteria Bacteria 94.4 4.15e-20   NR PSR14385.1 2107704 g1319 i0 46 2.99003322259136 100 53 99.7 1 300 1 172 270 PSR14385.1 hypothetical protein C8255_24205 [filamentous cyanobacterium CCP3] diamond 900 95.1 0.992639327024185 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         filamentous cyanobacterium CCP3
29088666 29088666 PRJNA1082072_P_NODE_2948_length_241_cov_0.916667_g2941_i0 PRJNA1082072 2948 241 0.916667 2.20916747 Drouetiella sp. 3088174 Bacteria Bacteria 152 9.15e-41   NR HEY9677341.1 3088174 g2941 i0 93.8 0.995850622406639 80 5 99.6 0 240 1 548 627 HEY9677341.1 glycine--tRNA ligase subunit beta [Drouetiella sp.] diamond 240 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Drouetiella Drouetiella sp.
30067424 30067424 PRJNA1082072_P_NODE_92_length_952_cov_1.616610_g88_i0 PRJNA1082072 92 952 1.61661 15.3901272 Phormidium sp. CCY1219 2886104 Bacteria Bacteria 244 1.26e-72   NR WP_324633554.1 2886104 g88 i0 45.5 3.71848739495798 299 130 94.2 4 18 914 311 576 WP_324633554.1 vanadium-dependent haloperoxidase [Phormidium sp. CCY1219] diamond 3540 244 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium sp. CCY1219
32090663 32090663 PRJNA1082072_P_NODE_1638_length_278_cov_1.502439_g1631_i0 PRJNA1082072 1638 278 1.502439 4.17678042 Cyanobacteria bacterium SZAS-4 2807733 Bacteria Bacteria 64.3 1.12e-9   NR MBS1955513.1 2807733 g1631 i0 66 0.507194244604317 47 16 50.7 0 136 276 24 70 MBS1955513.1 hypothetical protein [Cyanobacteria bacterium SZAS-4] diamond 141 64.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS-4
32375526 32375526 PRJNA1082072_P_NODE_1619_length_279_cov_1.495146_g1612_i0 PRJNA1082072 1619 279 1.495146 4.17145734 Desertifilum sp. 2497424 Bacteria Bacteria 63.5 2.72e-9   NR MCD8487938.1 2497424 g1612 i0 44.7 0.913978494623656 85 45 91.4 1 271 17 550 632 MCD8487938.1 DEAD/DEAH box helicase [Desertifilum sp.] diamond 255 63.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Desertifilales Desertifilaceae Desertifilum Desertifilum 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);;