RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1061474" 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 · 17 ✖

bioproject 1

  • PRJNA1061474 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26837485 26837485 PRJNA1061474_P_NODE_54981_length_243_cov_0.905882_g54735_i0 PRJNA1061474 54981 243 0.905882 2.20129326 Bacillati 1783272 Bacteria Bacteria 119 5.77e-29   NR WP_242030094.1 1125 g54735 i0 67.1 5.85185185185185 79 26 97.5 0 241 5 873 951 WP_242030094.1 MULTISPECIES: hypothetical protein [Microcystis] diamond 1422 120 0.991666666666667 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis  
26900765 26900765 PRJNA1061474_P_NODE_47341_length_250_cov_0.870056_g47095_i0 PRJNA1061474 47341 250 0.870056 2.17514 Cyanophyceae 3028117 Bacteria Bacteria 77.4 4.1e-15   NR MBV9387869.1 2801879 g47095 i0 73.5 6.708 83 21 98.4 1 248 3 74 156 MBV9387869.1 general stress protein [Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30] diamond 1677 77.8 0.994858611825193 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae   Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30
27256700 27256700 PRJNA1061474_P_NODE_55483_length_243_cov_0.905882_g55237_i0 PRJNA1061474 55483 243 0.905882 2.20129326 Coleofasciculus sp. FACHB-712 2692789 Bacteria Bacteria 128 4.27e-33   NR WP_190425696.1 2692789 g55237 i0 76.5 1 81 19 100 0 243 1 157 237 WP_190425696.1 GNAT family N-acetyltransferase [Coleofasciculus sp. FACHB-712] diamond 243 128 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. FACHB-712
27415016 27415016 PRJNA1061474_P_NODE_55363_length_243_cov_0.905882_g55117_i0 PRJNA1061474 55363 243 0.905882 2.20129326 Candidatus Margulisiibacteriota bacterium 2053573 Bacteria Bacteria 150 7.38e-43   NR HVO26245.1 2053573 g55117 i0 90.1 1 81 8 100 0 243 1 86 166 HVO26245.1 universal stress protein [Candidatus Margulisiibacteriota bacterium] diamond 243 150 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Margulisiibacteriota         Candidatus Margulisiibacteriota bacterium
28393482 28393482 PRJNA1061474_P_NODE_4026_length_1092_cov_2.228656_g3878_i0 PRJNA1061474 4026 1092 2.228656 24.33692352 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 467 1.9599999999999996e-162   NR MBX9694561.1 2847862 g3878 i0 74.4 2.65384615384615 308 74 83.2 2 10 918 15 322 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 2898 467 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28993725 28993725 PRJNA1061474_P_NODE_50008_length_247_cov_0.885057_g49762_i0 PRJNA1061474 50008 247 0.885057 2.18609079 Vampirovibrio sp. 2717857 Bacteria Bacteria 97.4 2.62e-22   NR MCE3235059.1 2717857 g49762 i0 68.3 0.995951417004049 82 25 99.6 1 247 2 117 197 MCE3235059.1 fliC [Vampirovibrio sp.] diamond 246 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria Vampirovibriophyceae Vampirovibrionales   Vampirovibrio Vampirovibrio sp.
29206429 29206429 PRJNA1061474_P_NODE_45409_length_251_cov_0.865169_g45163_i0 PRJNA1061474 45409 251 0.865169 2.17157419 Microcoleus 44471 Bacteria Bacteria 87 1.4e-18   NR TAF58326.1 1151 g45163 i0 83.3 2.58167330677291 54 9 64.5 0 249 88 167 220 TAF58326.1 MAG: class II fructose-bisphosphate aldolase, partial [Oscillatoriales cyanobacterium] diamond 648 87.4 0.995423340961098 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales     Oscillatoriales cyanobacterium
29940889 29940889 PRJNA1061474_P_NODE_57431_length_241_cov_0.916667_g57185_i0 PRJNA1061474 57431 241 0.916667 2.20916747 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 100 2.39e-22   NR HEY9850074.1 3088178 g57185 i0 50.6 5.90041493775934 79 39 98.3 0 1 237 307 385 HEY9850074.1 PAS domain S-box protein [Leptolyngbyaceae cyanobacterium] diamond 1422 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
30730573 30730573 PRJNA1061474_P_NODE_57774_length_241_cov_0.916667_g57528_i0 PRJNA1061474 57774 241 0.916667 2.20916747 Cyanobacteria bacterium UBA8553 2055771 Bacteria Bacteria 137 1.82e-37   NR HAA31107.1 2055771 g57528 i0 84.8 0.983402489626556 79 12 98.3 0 1 237 230 308 HAA31107.1 hypothetical protein [Cyanobacteria bacterium UBA8553] diamond 237 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA8553
30951948 30951948 PRJNA1061474_P_NODE_48534_length_249_cov_0.875000_g48288_i0 PRJNA1061474 48534 249 0.875 2.17875 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 117 2.17e-28   NR MFA6210452.1 2364082 g48288 i0 65.4 0.975903614457831 81 28 97.6 0 248 6 28 108 MFA6210452.1 efflux RND transporter permease subunit [Candidatus Obscuribacterales bacterium] diamond 243 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31078301 31078301 PRJNA1061474_P_NODE_53115_length_245_cov_0.895349_g52869_i0 PRJNA1061474 53115 245 0.895349 2.19360505 Nodosilinea sp. LEGE 2497642 Bacteria Bacteria 139 2.28e-36   NR WP_194024197.1 2777970 g52869 i0 88.9 0.991836734693878 81 9 99.2 0 3 245 392 472 WP_194024197.1 sensor histidine kinase [Nodosilinea sp. LEGE 07298] diamond 243 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Nodosilinea Nodosilinea sp. LEGE 07298
31354493 31354493 PRJNA1061474_P_NODE_51296_length_246_cov_0.890173_g51050_i0 PRJNA1061474 51296 246 0.890173 2.18982558 Cyanophyceae 3028117 Bacteria Bacteria 77.4 9.51e-15   NR WP_236141268.1 2055159 g51050 i0 55.2 8.15853658536585 67 30 81.7 0 211 11 122 188 WP_236141268.1 DUF4397 domain-containing protein [Nostoc sp. CMAA1605] diamond 2007 77.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CMAA1605
31963559 31963559 PRJNA1061474_P_NODE_49098_length_248_cov_0.880000_g48852_i0 PRJNA1061474 49098 248 0.88 2.1824 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 43.5 0.0212   NR MFN8551917.1 2364082 g48852 i0 41.2 0.616935483870968 51 30 61.7 0 215 63 251 301 MFN8551917.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 153 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32058536 32058536 PRJNA1061474_P_NODE_56538_length_242_cov_0.911243_g56292_i0 PRJNA1061474 56538 242 0.911243 2.20520806 Stenomitos rutilans 1886682 Bacteria Bacteria 132 2.83e-36   NR MBW4470712.1 1382958 g56292 i0 93.8 3.96694214876033 80 5 99.2 0 3 242 10 89 MBW4470712.1 TerC family protein [Stenomitos rutilans HA7619-LM2] diamond 960 132 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos rutilans
32501824 32501824 PRJNA1061474_P_NODE_55119_length_243_cov_0.905882_g54873_i0 PRJNA1061474 55119 243 0.905882 2.20129326 Waterburya sp. 3069706 Bacteria Bacteria 149 1.9199999999999998e-42   NR HEY9675136.1 3069706 g54873 i0 83.8 1.97530864197531 80 13 98.8 0 2 241 41 120 HEY9675136.1 alpha/beta hydrolase [Waterburya sp.] diamond 480 149 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Waterburya Waterburya sp.
32659025 32659025 PRJNA1061474_P_NODE_20360_length_434_cov_1.099723_g20114_i0 PRJNA1061474 20360 434 1.099723 4.77279782 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 90.5 2.71e-19   NR MBX9690859.1 2847862 g20114 i0 39.3 0.808755760368664 117 66 80.2 2 415 68 13 125 MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium] diamond 351 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32871505 32871505 PRJNA1061474_P_NODE_41400_length_272_cov_1.185930_g41154_i0 PRJNA1061474 41400 272 1.18593 3.2257296 Cyanophyceae 3028117 Bacteria Bacteria 62.8 4.71e-9   NR GJD19581.1 448371 g41154 i0 66.7 1.95220588235294 42 14 46.3 0 147 272 669 710 GJD19581.1 signal transduction protein with Nacht domain, putative [Rivularia sp. IAM M-261] diamond 531 62.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia Rivularia sp. IAM M-261

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