RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA407886" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 19 ✖

bioproject 1

  • PRJNA407886 · 19 ✖
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
416956 416956 PRJNA407886_P_NODE_21961_length_529_cov_3.962719_g20273_i0 PRJNA407886 21961 529 3.962719 20.96278351 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 285 3.95e-96   NR MBX9724270.1 2364082 g20273 i0 92.6 0.844990548204159 149 11 84.5 0 527 81 22 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 447 285 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
418014 418014 PRJNA407886_P_NODE_73921_length_247_cov_2.114943_g72227_i0 PRJNA407886 73921 247 2.114943 5.22390921 Halothece sp. PCC 7418 65093 Bacteria Bacteria 56.5 0.002   NTclustered gi|428688965|gb|CP003945.1| 65093 g72227 i0 92.308 1.07287449392713 39 3 16 0 140 178 4008612 4008650 Halothece sp. PCC 7418 chromosome, complete genome blastn 265 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Halothecacae Halothece Halothece sp. PCC 7418
6185684 6185684 PRJNA407886_P_NODE_78045_length_244_cov_0.900585_g76351_i0 PRJNA407886 78045 244 0.900585 2.1974274 Xenococcaceae cyanobacterium MO_167.B27 3036636 Bacteria Bacteria 85.9 2.51e-17   NR MDJ0746531.1 3036636 g76351 i0 67.8 4.38934426229508 59 19 72.5 0 186 10 757 815 MDJ0746531.1 aminomethyl-transferring glycine dehydrogenase [Xenococcaceae cyanobacterium MO_167.B27] diamond 1071 85.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Xenococcaceae   Xenococcaceae cyanobacterium MO_167.B27
6795748 6795748 PRJNA407886_P_NODE_69786_length_251_cov_0.865169_g68092_i0 PRJNA407886 69786 251 0.865169 2.17157419 Nostoc flagelliforme 1306274 Bacteria Bacteria 392 1.18e-104   NTclustered gi|1297075411|gb|CP024785.1| 2038116 g68092 i0 95.51 13.8605577689243 245 11 98 0 1 245 2819684 2819928 Nostoc flagelliforme CCNUN1 chromosome, complete genome blastn 3479 392 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc flagelliforme
8070534 8070534 PRJNA407886_P_NODE_34267_length_382_cov_2.051780_g32573_i0 PRJNA407886 34267 382 2.05178 7.8377996 root 1 Root_unresolved Root_unresolved 103 3.79e-25   NR WP_011243919.1 32046 g32573 i0 63 3.43979057591623 73 27 57.3 0 381 163 79 151 WP_011243919.1 nucleoside-diphosphate kinase [Synechococcus elongatus] diamond 1314 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus elongatus
8734737 8734737 PRJNA407886_P_NODE_20447_length_560_cov_3.392197_g18762_i0 PRJNA407886 20447 560 3.392197 18.9963032 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 305 1.47e-103   NR MBX9724270.1 2364082 g18762 i0 88.6 0.894642857142857 167 19 89.5 0 536 36 4 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 501 305 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
10621874 10621874 PRJNA407886_P_NODE_69329_length_251_cov_2.140449_g67635_i0 PRJNA407886 69329 251 2.140449 5.37252699 Nostoc sp. MS1 2764711 Bacteria Bacteria 58.4 4.89e-4   NTclustered gi|2093825993|dbj|AP023441.1| 2764711 g67635 i0 100 0.123505976095618 31 0 12 0 129 159 4614885 4614855 Nostoc sp. MS1 DNA, complete genome blastn 31 58.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. MS1
11896937 11896937 PRJNA407886_P_NODE_74510_length_247_cov_0.885057_g72816_i0 PRJNA407886 74510 247 0.885057 2.18609079 Nostoc sp. NIES-4103 2005458 Bacteria Bacteria 451 1.88e-122   NTclustered gi|1210228378|dbj|AP018288.1| 2005458 g72816 i0 99.595 3.79352226720648 247 1 100 0 1 247 4944189 4943943 Nostoc sp. NIES-4103 DNA, nearly complete genome blastn 937 451 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. NIES-4103
13835558 13835558 PRJNA407886_P_NODE_33791_length_386_cov_0.984026_g32097_i0 PRJNA407886 33791 386 0.984026 3.79834036 Microcystis 1125 Bacteria Bacteria 60.2 2.2e-4   NTclustered gi|2164481301|gb|CP089094.1| 267865 g32097 i0 97.222 73.7512953367876 36 0 10 1 85 119 4650599 4650634 Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome blastn 28468 60.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa
14446473 14446473 PRJNA407886_P_NODE_49492_length_306_cov_1.369099_g47798_i0 PRJNA407886 49492 306 1.369099 4.18944294 Stanieria cyanosphaera 102116 Bacteria Bacteria 283 9.3e-72   NTclustered gi|17976754|emb|AJ252121.1| 111780 g47798 i0 83.553 52.8235294117647 304 48 99 2 1 303 432 734 Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating) blastn 16164 283 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
27833508 27833508 PRJNA407886_P_NODE_32244_length_398_cov_1.673846_g30550_i0 PRJNA407886 32244 398 1.673846 6.66190708 Crocosphaera sp. 2729996 Bacteria Bacteria 43.9 0.044   NR MDJ0660882.1 2729996 g30550 i0 30.2 0.874371859296482 116 65 75.4 4 81 380 52 167 MDJ0660882.1 Uma2 family endonuclease [Crocosphaera sp.] diamond 348 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera sp.
28086080 28086080 PRJNA407886_P_NODE_21865_length_531_cov_2.951965_g20178_i0 PRJNA407886 21865 531 2.951965 15.67493415 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 44.7 0.0185   NR MBX9694168.1 2847862 g20178 i0 41.7 0.271186440677966 48 27 26.6 1 458 318 38 85 MBX9694168.1 hypothetical protein [Cyanobacteriota bacterium] diamond 144 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29096694 29096694 PRJNA407886_P_NODE_64428_length_263_cov_1.310526_g62734_i0 PRJNA407886 64428 263 1.310526 3.44668338 Cyanobacteria bacterium J06635_10 3023201 Bacteria Bacteria 45.1 0.00596   NR MEO1373427.1 3023201 g62734 i0 38.3 0.923954372623574 81 40 91.3 5 22 261 86 157 MEO1373427.1 CAP domain-containing protein [Cyanobacteria bacterium J06635_10] diamond 243 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06635_10
29871037 29871037 PRJNA407886_P_NODE_35771_length_372_cov_1.274247_g34077_i0 PRJNA407886 35771 372 1.274247 4.74019884 Bacteria 2 Bacteria Bacteria 80.5 7.87e-15   NR WP_334985009.1 1180 g34077 i0 70 5.25806451612903 50 15 40.3 0 370 221 378 427 WP_334985009.1 hypothetical protein [Nostoc sp.] diamond 1956 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
29886129 29886129 PRJNA407886_P_NODE_58531_length_278_cov_1.795122_g56837_i0 PRJNA407886 58531 278 1.795122 4.99043916 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 49.3 1.86e-4   NR MBC7473383.1 2762020 g56837 i0 38.3 0.87410071942446 81 45 83.1 3 277 47 99 178 MBC7473383.1 glutathione S-transferase family protein [Candidatus Sericytochromatia bacterium] diamond 243 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
29917678 29917678 PRJNA407886_P_NODE_53691_length_292_cov_1.406393_g51997_i0 PRJNA407886 53691 292 1.406393 4.10666756 Limnospira platensis 118562 Bacteria Bacteria 160 8.88e-49   NR MDV7399621.1 3080829 g51997 i0 87.1 0.873287671232877 85 11 87.3 0 2 256 18 102 MDV7399621.1 hypothetical protein [Arthrospira platensis SPKY1] diamond 255 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
30250380 30250380 PRJNA407886_P_NODE_42332_length_335_cov_1.175573_g40638_i0 PRJNA407886 42332 335 1.175573 3.93816955 Bacteria 2 Bacteria Bacteria 46.6 0.00489   NR WP_073074377.1 268141 g40638 i0 50 3.43880597014925 72 30 62.7 3 287 78 746 813 WP_073074377.1 SdrD B-like domain-containing protein [Phormidesmis priestleyi] diamond 1152 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi
31466174 31466174 PRJNA407886_P_NODE_61236_length_271_cov_1.424242_g59542_i0 PRJNA407886 61236 271 1.424242 3.8596958200000002 Synechococcus sp. TMED187 1986595 Bacteria Bacteria 86.3 1.65e-17   NR OUW48451.1 1986595 g59542 i0 54.3 0.896678966789668 81 37 89.7 0 261 19 287 367 OUW48451.1 MAG: hypothetical protein CBD47_02910 [Synechococcus sp. TMED187] diamond 243 86.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. TMED187
32573514 32573514 PRJNA407886_P_NODE_66259_length_258_cov_3.675676_g64565_i0 PRJNA407886 66259 258 3.675676 9.48324408 Stenomitos rutilans 1886682 Bacteria Bacteria 44.7 0.00962   NR MBW4471337.1 1382958 g64565 i0 36.7 0.569767441860465 49 31 57 0 227 81 1890 1938 MBW4471337.1 PAS domain S-box protein [Stenomitos rutilans HA7619-LM2] diamond 147 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos rutilans

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