RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA721440 · 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
10914176 10914176 PRJNA721440_S_NODE_2069_length_383_cov_45.727545_g1943_i0 PRJNA721440 2069 383 45.727545 175.13649735 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 240 3.8200000000000006e-79   NR MBX9724270.1 2364082 g1943 i0 91.3 0.994778067885117 127 11 99.5 0 1 381 21 147 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 381 240 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
10914188 10914188 PRJNA721440_S_NODE_4049_length_289_cov_3.400000_g3923_i0 PRJNA721440 4049 289 3.4 9.826 Stanieria cyanosphaera PCC 7437 111780 Bacteria Bacteria 166 2.09e-48   NR CAC81002.1 111780 g3923 i0 78.9 0.986159169550173 95 20 98.6 0 3 287 44 138 CAC81002.1 NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating), partial [Stanieria cyanosphaera PCC 7437] diamond 285 166 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
26682550 26682550 PRJNA721440_S_NODE_3501_length_306_cov_1.319066_g3375_i0 PRJNA721440 3501 306 1.319066 4.03634196 Cyanophyceae 3028117 Bacteria Bacteria 65.5 8.2e-10   NR MCL1491895.1 2938918 g3375 i0 41.3 7.40196078431373 92 40 90.2 1 284 9 883 960 MCL1491895.1 PAS domain S-box protein [Pseudanabaena sp. Salubria-1] diamond 2265 65.9 0.993930197268589 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. Salubria-1
26798831 26798831 PRJNA721440_S_NODE_5101_length_264_cov_2.483721_g4975_i0 PRJNA721440 5101 264 2.483721 6.55702344 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 150 5.17e-41   NR MBX9694651.1 2847862 g4975 i0 85.9 0.965909090909091 85 12 96.6 0 6 260 179 263 MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium] diamond 255 150 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27094091 27094091 PRJNA721440_S_NODE_15762_length_173_cov_2.290323_g15636_i0 PRJNA721440 15762 173 2.290323 3.96225879 root 1 Root_unresolved Root_unresolved 96.3 2.01e-21   NR MFN9176613.1 1143 g15636 i0 75.4 24.6763005780347 57 14 98.8 0 172 2 215 271 MFN9176613.1 glutamate synthase central domain-containing protein [Synechocystis sp.] diamond 4269 97.1 0.991761071060762 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp.
27283788 27283788 PRJNA721440_S_NODE_5623_length_254_cov_1.653659_g5497_i0 PRJNA721440 5623 254 1.653659 4.20029386 Cyanophyceae 3028117 Bacteria Bacteria 162 3.8700000000000003e-44   NR WP_088890090.1 1962290 g5497 i0 92.9 6.94488188976378 84 6 99.2 0 3 254 988 1071 WP_088890090.1 magnesium chelatase subunit H [Leptolyngbya ohadii] diamond 1764 162 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya ohadii
27463002 27463002 PRJNA721440_S_NODE_16643_length_170_cov_1.115702_g16517_i0 PRJNA721440 16643 170 1.115702 1.8966934 Nostoc sp. LEGE 1245 1180 Bacteria Bacteria 51.6 1.03e-5   NR WP_193950846.1 1828643 g16517 i0 45.6 2.98235294117647 57 26 98.8 2 170 3 182 234 WP_193950846.1 beta strand repeat-containing protein [Nostoc sp. LEGE 12450] diamond 507 51.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. LEGE 12450
27526004 27526004 PRJNA721440_S_NODE_17383_length_168_cov_0.873950_g17257_i0 PRJNA721440 17383 168 0.87395 1.468236 Candidatus Gastranaerophilales bacterium HUM_13 1916221 Bacteria Bacteria 45.4 0.00138   NR DAB05885.1 1916221 g17257 i0 64.7 0.607142857142857 34 12 60.7 0 166 65 219 252 DAB05885.1 MAG TPA: recombinase RecA [Candidatus Gastranaerophilales bacterium HUM_13] diamond 102 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium HUM_13
27715868 27715868 PRJNA721440_S_NODE_5664_length_253_cov_3.818627_g5538_i0 PRJNA721440 5664 253 3.818627 9.66112631 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 110 2.88e-27   NR MBX9693408.1 2847862 g5538 i0 87.3 0.74703557312253 63 8 74.7 0 190 2 141 203 MBX9693408.1 hypothetical protein [Cyanobacteriota bacterium] diamond 189 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28978570 28978570 PRJNA721440_S_NODE_17128_length_168_cov_4.563025_g17002_i0 PRJNA721440 17128 168 4.563025 7.665882 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 47 4.34e-4   NR MBX9694561.1 2847862 g17002 i0 64.1 0.696428571428571 39 10 62.5 1 114 10 15 53 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 117 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30209798 30209798 PRJNA721440_S_NODE_10092_length_204_cov_1.832258_g9966_i0 PRJNA721440 10092 204 1.832258 3.73780632 Trichodesmium erythraeum 1206 Bacteria Bacteria 48.1 2.78e-4   NR WP_011613745.1 1206 g9966 i0 35.6 0.867647058823529 59 37 85.3 1 193 20 347 405 WP_011613745.1 beta-galactosidase [Trichodesmium erythraeum] diamond 177 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Trichodesmium Trichodesmium erythraeum
30757669 30757669 PRJNA721440_S_NODE_13554_length_183_cov_1.507463_g13428_i0 PRJNA721440 13554 183 1.507463 2.75865729 root 1 Root_unresolved Root_unresolved 91.3 1.32e-19   NR WP_015191366.1 102116 g13428 i0 65 41.2950819672131 60 21 98.4 0 2 181 391 450 WP_015191366.1 isoleucine--tRNA ligase [Stanieria cyanosphaera] diamond 7557 92 0.992391304347826 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
31189136 31189136 PRJNA721440_S_NODE_175_length_1018_cov_18.079463_g132_i0 PRJNA721440 175 1018 18.079463 184.04893334 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 439 1.3499999999999994e-151   NR MBX9694561.1 2847862 g132 i0 76.1 2.59332023575638 276 65 81 1 2 826 47 322 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 2640 439 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31231398 31231398 PRJNA721440_S_NODE_4735_length_272_cov_1.784753_g4609_i0 PRJNA721440 4735 272 1.784753 4.85452816 root 1 Root_unresolved Root_unresolved 48.9 3.73e-4   NR MDV3002255.1 1521635 g4609 i0 41.5 3.65073529411765 82 38 90.4 2 27 272 1097 1168 MDV3002255.1 Tyrocidine synthase 3 [Chroococcopsis gigantea SAG 12.99] diamond 993 49.3 0.991886409736308 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Chroococcopsis Chroococcopsis gigantea
31821931 31821931 PRJNA721440_S_NODE_9977_length_205_cov_1.397436_g9851_i0 PRJNA721440 9977 205 1.397436 2.8647438 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 95.5 2.83e-23   NR MBX9722668.1 2364082 g9851 i0 76.3 0.863414634146341 59 14 86.3 0 1 177 79 137 MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 177 95.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32328677 32328677 PRJNA721440_S_NODE_619_length_647_cov_2.372910_g512_i0 PRJNA721440 619 647 2.37291 15.3527277 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 192 2.13e-59   NR MBX9692690.1 2847862 g512 i0 76.1 0.542503863987635 117 28 54.3 0 155 505 1 117 MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium] diamond 351 192 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32644065 32644065 PRJNA721440_S_NODE_9400_length_209_cov_2.200000_g9274_i0 PRJNA721440 9400 209 2.2 4.598 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 125 7.97e-32   NR MBX9694651.1 2847862 g9274 i0 88.2 0.976076555023923 68 8 97.6 0 205 2 115 182 MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium] diamond 204 125 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);;