RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879067 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
7234151 7234151 PRJNA879067_P_NODE_73766_length_368_cov_2.349153_g70281_i0 PRJNA879067 73766 368 2.349153 8.64488304 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 215 1.47e-69   NR HEY9780609.1 3088178 g70281 i0 98.1 0.855978260869565 105 2 85.6 0 315 1 1 105 HEY9780609.1 MarR family transcriptional regulator [Leptolyngbyaceae cyanobacterium] diamond 315 215 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
12335424 12335424 PRJNA879067_P_NODE_89870_length_299_cov_1.362832_g86384_i0 PRJNA879067 89870 299 1.362832 4.07486768 Bacteria 2 Bacteria Bacteria 54.7 2.33e-7   NR MCA9801980.1 2775582 g86384 i0 40.6 1.25418060200669 64 38 64.2 0 107 298 1 64 MCA9801980.1 hypothetical protein [Cyanobacteria bacterium HKST-UBA02] diamond 375 55.1 0.992740471869329 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium HKST-UBA02
16156434 16156434 PRJNA879067_P_NODE_103493_length_251_cov_0.865169_g100007_i0 PRJNA879067 103493 251 0.865169 2.17157419 Microcoleus sp. SIO2G3 2607795 Bacteria Bacteria 146 1.95e-40   NR NEQ27776.1 2607795 g100007 i0 87.3 2.83266932270916 79 10 94.4 0 249 13 181 259 NEQ27776.1 alkene reductase [Microcoleus sp. SIO2G3] diamond 711 146 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. SIO2G3
17433904 17433904 PRJNA879067_P_NODE_65974_length_411_cov_1.926036_g62489_i0 PRJNA879067 65974 411 1.926036 7.91600796 Leptolyngbyaceae cyanobacterium CRU_2_3 2720406 Bacteria Bacteria 224 3.1500000000000007e-65   NR NJR64468.1 2720406 g62489 i0 85.9 1.97080291970803 135 19 98.5 0 1 405 838 972 NJR64468.1 response regulator [Leptolyngbyaceae cyanobacterium CRU_2_3] diamond 810 224 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium CRU_2_3
21255852 21255852 PRJNA879067_P_NODE_105897_length_247_cov_2.126437_g102411_i0 PRJNA879067 105897 247 2.126437 5.25229939 Pleurocapsa sp. SU_196_0 2720476 Bacteria Bacteria 90.1 4.19e-21   NR NJK46417.1 2720476 g102411 i0 63.4 0.862348178137652 71 26 86.2 0 35 247 16 86 NJK46417.1 rhodanese-like domain-containing protein [Pleurocapsa sp. SU_196_0] diamond 213 90.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. SU_196_0
26833850 26833850 PRJNA879067_P_NODE_75161_length_361_cov_2.138889_g71675_i0 PRJNA879067 75161 361 2.138889 7.72138929 Cyanobacteria bacterium REEB67 2800110 Bacteria Bacteria 101 1.5199999999999995e-23   NR MBU6455445.1 2800110 g71675 i0 61.4 0.731301939058172 88 34 73.1 0 327 64 172 259 MBU6455445.1 biotin/lipoyl-binding protein [Cyanobacteria bacterium REEB67] diamond 264 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
26865699 26865699 PRJNA879067_P_NODE_41821_length_602_cov_11.746692_g38367_i0 PRJNA879067 41821 602 11.746692 70.71508584 Cyanobacteria bacterium PR.3.49 2067978 Bacteria Bacteria 125 2.799999999999999e-29   NR MBA3857465.1 2067978 g38367 i0 38.1 0.981727574750831 197 121 97.7 1 601 14 945 1141 MBA3857465.1 hypothetical protein [Cyanobacteria bacterium PR.3.49] diamond 591 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.3.49
26905210 26905210 PRJNA879067_P_NODE_39841_length_625_cov_1.358696_g36396_i0 PRJNA879067 39841 625 1.358696 8.49185 Bacteria 2 Bacteria Bacteria 92.4 6.78e-18   NR WP_139297159.1 126344 g36396 i0 28.2 2.6352 206 140 95.5 4 2 598 87 291 WP_139297159.1 HEPN domain-containing protein [Phormidium tenue] diamond 1647 92.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium tenue
28065943 28065943 PRJNA879067_P_NODE_107125_length_246_cov_0.890173_g103639_i0 PRJNA879067 107125 246 0.890173 2.18982558 Allocoleopsis sp. 3088169 Bacteria Bacteria 147 1.0299999999999999e-40   NR HEY9600726.1 3088169 g103639 i0 91.4 0.98780487804878 81 7 98.8 0 3 245 148 228 HEY9600726.1 HNH endonuclease signature motif containing protein [Allocoleopsis sp.] diamond 243 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
28863253 28863253 PRJNA879067_P_NODE_67868_length_400_cov_1.642202_g64383_i0 PRJNA879067 67868 400 1.642202 6.568808 Leptolyngbya 47251 Bacteria Bacteria 98.6 6.1e-23   NR WP_316426702.1 1184 g64383 i0 40.7 2.7675 123 73 92.3 0 400 32 55 177 WP_316426702.1 HEPN domain-containing protein [Leptolyngbya boryana] diamond 1107 98.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya boryana
29084497 29084497 PRJNA879067_P_NODE_88268_length_305_cov_1.530172_g84782_i0 PRJNA879067 88268 305 1.530172 4.6670246 Bacillati 1783272 Bacteria Bacteria 75.9 1.64e-13   NR MBA4026685.1 2067984 g84782 i0 74.5 0.914754098360656 47 12 46.2 0 164 304 2 48 MBA4026685.1 hypothetical protein [Cyanobacteria bacterium DS3.002] diamond 279 76.3 0.99475753604194 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium DS3.002
29392203 29392203 PRJNA879067_P_NODE_92569_length_289_cov_1.300926_g89083_i0 PRJNA879067 92569 289 1.300926 3.75967614 Nostoc sp. ChiSLP02 3075379 Bacteria Bacteria 108 3.4999999999999997e-25   NR MDZ8189333.1 3075379 g89083 i0 61.5 2.98961937716263 96 36 99.7 1 2 289 300 394 MDZ8189333.1 ATP-binding protein [Nostoc sp. ChiSLP02] diamond 864 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. ChiSLP02
29486581 29486581 PRJNA879067_P_NODE_64570_length_419_cov_5.075145_g61085_i0 PRJNA879067 64570 419 5.075145 21.26485755 Cyanobacteria bacterium SZAS LIN-5 2807734 Bacteria Bacteria 271 8.099999999999997e-88   NR MBS2003098.1 2807734 g61085 i0 92.1 1.98329355608592 139 11 99.5 0 419 3 124 262 MBS2003098.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-5] diamond 831 271 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-5
29526511 29526511 PRJNA879067_P_NODE_17570_length_1103_cov_3.194175_g14795_i0 PRJNA879067 17570 1103 3.194175 35.23175025 Cyanophyceae 3028117 Bacteria Bacteria 65.5 2.07e-7   NR WP_199315623.1 1246630 g14795 i0 31 1.53943789664551 113 53 30.7 1 890 552 435 522 WP_199315623.1 poly(A) polymerase [Aerosakkonema funiforme] diamond 1698 65.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Aerosakkonema Aerosakkonema funiforme
29581214 29581214 PRJNA879067_P_NODE_21930_length_948_cov_4.514286_g18910_i0 PRJNA879067 21930 948 4.514286 42.79543128 Chroococcales cyanobacterium 3088180 Bacteria Bacteria 192 6.609999999999999e-55   NR HEY9725456.1 3088180 g18910 i0 40.8 1.9746835443038 314 167 96.8 6 23 940 27 329 HEY9725456.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Chroococcales cyanobacterium] diamond 1872 192 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales     Chroococcales cyanobacterium
29873800 29873800 PRJNA879067_P_NODE_34911_length_687_cov_17.102606_g31520_i0 PRJNA879067 34911 687 17.102606 117.49490322 Cyanophyceae 3028117 Bacteria Bacteria 172 3.34e-49   NR MBR8836653.1 221294 g31520 i0 48.3 1.50655021834061 178 87 77.7 2 534 1 1 173 MBR8836653.1 hypothetical protein [Stigonema ocellatum SAG 48.90 = DSM 106950] diamond 1035 173 0.994219653179191 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Stigonemataceae Stigonema Stigonema ocellatum
29929089 29929089 PRJNA879067_P_NODE_44051_length_579_cov_6.618577_g40590_i0 PRJNA879067 44051 579 6.618577 38.32156083 Cyanobacteria bacterium SZAS LIN-5 2807734 Bacteria Bacteria 108 7.61e-27   NR MBS2003549.1 2807734 g40590 i0 54.5 0.580310880829015 112 43 55.4 3 371 51 1 109 MBS2003549.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-5] diamond 336 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-5
31097770 31097770 PRJNA879067_P_NODE_111055_length_241_cov_0.916667_g107569_i0 PRJNA879067 111055 241 0.916667 2.20916747 Scytonematopsis contorta 1049027 Bacteria Bacteria 102 4.3599999999999997e-23   NR MBW4506237.1 1049028 g107569 i0 80 2.71369294605809 70 14 87.1 0 24 233 501 570 MBW4506237.1 mechanosensitive ion channel [Scytonematopsis contorta HA4267-MV1] diamond 654 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonematopsis Scytonematopsis contorta
31350953 31350953 PRJNA879067_P_NODE_87816_length_307_cov_1.153846_g84330_i0 PRJNA879067 87816 307 1.153846 3.54230722 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 154 3.929999999999999e-42   NR WP_106371242.1 2107693 g84330 i0 77.2 0.986970684039088 101 23 98.7 0 3 305 279 379 WP_106371242.1 glycosyltransferase family 39 protein [Chlorogloea sp. CCALA 695] diamond 303 154 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
31983396 31983396 PRJNA879067_P_NODE_36538_length_665_cov_3.633446_g33123_i0 PRJNA879067 36538 665 3.633446 24.1624159 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 144 1.26e-39   NR WP_227501458.1 927677 g33123 i0 83.8 0.360902255639098 80 13 36.1 0 663 424 79 158 WP_227501458.1 cupin domain-containing protein [Synechocystis sp. PCC 7509] diamond 240 144 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
32268417 32268417 PRJNA879067_P_NODE_112118_length_220_cov_4.190476_g108632_i0 PRJNA879067 112118 220 4.190476 9.2190472 Drouetiella sp. 3088174 Bacteria Bacteria 58.2 8.73e-8   NR HEY9734052.1 3088174 g108632 i0 100 0.368181818181818 27 0 36.8 0 140 220 1 27 HEY9734052.1 NAD-dependent epimerase/dehydratase family protein [Drouetiella sp.] diamond 81 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Drouetiella Drouetiella sp.
32268439 32268439 PRJNA879067_P_NODE_99918_length_263_cov_1.136842_g96432_i0 PRJNA879067 99918 263 1.136842 2.98989446 Nostoc sp. 1180 Bacteria Bacteria 105 5.68e-24   NR WP_335118582.1 1180 g96432 i0 56.2 19.1406844106464 89 35 97 1 260 6 965 1053 WP_335118582.1 amino acid adenylation domain-containing protein [Nostoc sp.] diamond 5034 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
32331908 32331908 PRJNA879067_P_NODE_36799_length_661_cov_20.253401_g33380_i0 PRJNA879067 36799 661 20.253401 133.87498061 Gloeocapsopsis dulcis 2859516 Bacteria Bacteria 152 1.51e-38   NR WP_105217920.1 2859516 g33380 i0 85.7 0.413010590015129 91 13 41.3 0 608 336 1 91 WP_105217920.1 type I restriction endonuclease subunit R [Gloeocapsopsis dulcis] diamond 273 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsopsis Gloeocapsopsis dulcis
32561311 32561311 PRJNA879067_P_NODE_93799_length_284_cov_2.535545_g90313_i0 PRJNA879067 93799 284 2.535545 7.2009478 Cyanophyceae 3028117 Bacteria Bacteria 109 2.45e-25   NR WP_250122977.1 155894 g90313 i0 67.4 1.88028169014085 89 25 89.8 1 271 17 141 229 WP_250122977.1 chemotaxis protein CheB [Chroococcidiopsis sp. CCMEE 29] diamond 534 110 0.990909090909091 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
32836374 32836374 PRJNA879067_P_NODE_80200_length_338_cov_1.743396_g76714_i0 PRJNA879067 80200 338 1.743396 5.89267848 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 163 2.32e-46   NR WP_009631165.1 927677 g76714 i0 94.2 1.5 86 5 76.3 0 25 282 1 86 WP_009631165.1 RNA-guided endonuclease InsQ/TnpB family protein [Synechocystis sp. PCC 7509] diamond 507 163 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509

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