RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 8 ✖

bioproject 1

  • PRJNA642647 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
8811465 8811465 PRJNA642647_P_NODE_1267_length_311_cov_3.536496_g1217_i0 PRJNA642647 1267 311 3.536496 10.99850256 Pseudanabaena sp. 1153 Bacteria Bacteria 78.6 8.52e-15   NR MFN9051406.1 1153 g1217 i0 53.8 0.771704180064309 80 30 77.2 1 311 72 55 127 MFN9051406.1 hypothetical protein [Pseudanabaena sp.] diamond 240 78.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp.
26669467 26669467 PRJNA642647_P_NODE_5181_length_166_cov_2.658915_g5131_i0 PRJNA642647 5181 166 2.658915 4.4137989 Stenomitos sp. 3088177 Bacteria Bacteria 48.5 1.21e-4   NR HEY9826366.1 3088177 g5131 i0 87.5 0.433734939759036 24 3 43.4 0 91 162 249 272 HEY9826366.1 phage/plasmid primase, P4 family [Stenomitos sp.] diamond 72 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos sp.
27713473 27713473 PRJNA642647_P_NODE_1324_length_304_cov_1.411985_g1274_i0 PRJNA642647 1324 304 1.411985 4.2924344 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 74.7 8.77e-14   NR MFA6213521.1 2364082 g1274 i0 76.7 0.424342105263158 43 10 42.4 0 158 286 1 43 MFA6213521.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 129 74.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27997382 27997382 PRJNA642647_P_NODE_325_length_621_cov_2.565068_g279_i0 PRJNA642647 325 621 2.565068 15.92907228 Microcoleus sp. herbarium19 3055440 Bacteria Bacteria 80.1 2.46e-14   NR WP_333272793.1 3055440 g279 i0 55.1 0.661835748792271 69 30 32.9 1 204 1 108 176 WP_333272793.1 hypothetical protein [Microcoleus sp. herbarium19] diamond 411 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. herbarium19
29070952 29070952 PRJNA642647_P_NODE_4748_length_168_cov_1.083969_g4698_i0 PRJNA642647 4748 168 1.083969 1.82106792 Oculatella sp. LEGE 3100279 Bacteria Bacteria 54.3 1.24e-7   NR WP_193877608.1 1828648 g4698 i0 50 0.964285714285714 54 26 96.4 1 6 167 37 89 WP_193877608.1 hypothetical protein [Oculatella sp. LEGE 06141] diamond 162 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Oculatella Oculatella sp. LEGE 06141
29355038 29355038 PRJNA642647_P_NODE_5389_length_164_cov_0.897638_g5339_i0 PRJNA642647 5389 164 0.897638 1.47212632 Spirulinaceae cyanobacterium 3107590 Bacteria Bacteria 60.8 3.92e-9   NR MFP4006659.1 3107590 g5339 i0 75 0.658536585365854 36 9 65.9 0 108 1 6 41 MFP4006659.1 DNA adenine methylase [Spirulinaceae cyanobacterium] diamond 108 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae   Spirulinaceae cyanobacterium
29860066 29860066 PRJNA642647_P_NODE_1251_length_314_cov_1.454874_g1201_i0 PRJNA642647 1251 314 1.454874 4.56830436 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 80.1 6.3e-15   NR MEY3400504.1 2847862 g1201 i0 69.8 0.410828025477707 43 13 41.1 0 129 1 3 45 MEY3400504.1 hypothetical protein [Cyanobacteriota bacterium] diamond 129 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30460830 30460830 PRJNA642647_P_NODE_3333_length_193_cov_2.923077_g3283_i0 PRJNA642647 3333 193 2.923077 5.64153861 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 50.1 5.14e-6   NR MEO0014922.1 2847862 g3283 i0 46.8 0.730569948186529 47 25 73.1 0 43 183 9 55 MEO0014922.1 hypothetical protein [Cyanobacteriota bacterium] diamond 141 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota 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);;