RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA752572", tax_phylum = "Cyanobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Cyanobacteriota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA752572 · 20 ✖
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
8381889 8381889 PRJNA752572_P_NODE_221087_length_178_cov_1.944056_g220580_i0 PRJNA752572 221087 178 1.944056 3.46041968 Cylindrospermum stagnale 142864 Bacteria Bacteria 54.7 0.004   NTclustered gi|428256439|gb|CP003642.1| 56107 g220580 i0 100 0.162921348314607 29 0 16 0 2 30 2711803 2711831 Cylindrospermum stagnale PCC 7417, complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum stagnale
12681018 12681018 PRJNA752572_P_NODE_82030_length_300_cov_1.622642_g81523_i0 PRJNA752572 82030 300 1.622642 4.867926 Oscillatoriales 1150 Bacteria Bacteria 544 3.78e-150   NTclustered gi|1345606773|gb|MG968507.1| 1521532 g81523 i0 99.333 147.8 300 2 100 0 1 300 273 572 Oscillatoria amoena SAG 1459-7 23S ribosomal RNA gene, partial sequence blastn 44340 544 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria amoena
16031259 16031259 PRJNA752572_P_NODE_63633_length_342_cov_1.811075_g63126_i0 PRJNA752572 63633 342 1.811075 6.1938765 Nostoc sp. MS1 2764711 Bacteria Bacteria 60.2 1.93e-4   NTclustered gi|2093825993|dbj|AP023441.1| 2764711 g63126 i0 94.737 0.111111111111111 38 2 11 0 6 43 6113475 6113512 Nostoc sp. MS1 DNA, complete genome blastn 38 60.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. MS1
22405990 22405990 PRJNA752572_P_NODE_229898_length_174_cov_2.928058_g229391_i0 PRJNA752572 229898 174 2.928058 5.09482092 Nostoc piscinale 224012 Bacteria Bacteria 56.5 0.001   NTclustered gi|930349143|gb|CP012036.1| 224013 g229391 i0 86.275 0.293103448275862 51 7 29 0 111 161 202655 202705 Nostoc piscinale CENA21 chromosome blastn 51 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc piscinale
26704472 26704472 PRJNA752572_P_NODE_89881_length_286_cov_1.374502_g89374_i0 PRJNA752572 89881 286 1.374502 3.93107572 Calothrix sp. NIES-2 1187 Bacteria Bacteria 51.2 5.85e-5   NR WP_096593725.1 1954171 g89374 i0 25.3 0.954545454545455 91 66 95.5 2 278 6 63 151 WP_096593725.1 serine/threonine-protein kinase [Calothrix sp. NIES-2098] diamond 273 51.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-2098
26841463 26841463 PRJNA752572_P_NODE_229861_length_174_cov_3.014388_g229354_i0 PRJNA752572 229861 174 3.014388 5.24503512 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 55.8 3.63e-7   NR WP_106367121.1 2107693 g229354 i0 100 0.862068965517241 25 0 43.1 0 174 100 1822 1846 WP_106367121.1 type I polyketide synthase [Chlorogloea sp. CCALA 695] diamond 150 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
27094315 27094315 PRJNA752572_P_NODE_167442_length_206_cov_2.783626_g166935_i0 PRJNA752572 167442 206 2.783626 5.73426956 Bacteria 2 Bacteria Bacteria 94.4 1.54e-20   NR MEM1278527.1 3023315 g166935 i0 63.2 1.98058252427184 68 25 99 0 206 3 550 617 MEM1278527.1 glycoside hydrolase family 19 protein [Cyanobacteria bacterium P01_H01_bin.152] diamond 408 95.1 0.992639327024185 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_H01_bin.152
27536754 27536754 PRJNA752572_P_NODE_282243_length_156_cov_3.892562_g281736_i0 PRJNA752572 282243 156 3.892562 6.07239672 Nostoc 1177 Bacteria Bacteria 59.3 1.05e-8   NR WP_289798355.1 3056647 g281736 i0 55.3 1.80769230769231 47 20 90.4 1 145 5 60 105 WP_289798355.1 hypothetical protein [Nostoc sp. GT001] diamond 282 59.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. GT001
27779559 27779559 PRJNA752572_P_NODE_283684_length_155_cov_2.058333_g283177_i0 PRJNA752572 283684 155 2.058333 3.19041615 Cyanobacteria bacterium KgW148 2793240 Bacteria Bacteria 43.9 0.00437   NR MCA1904422.1 2793240 g283177 i0 41.7 6.32903225806452 48 26 89 1 2 139 86 133 MCA1904422.1 aminotransferase class V-fold PLP-dependent enzyme [Cyanobacteria bacterium KgW148] diamond 981 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium KgW148
28474112 28474112 PRJNA752572_P_NODE_140726_length_226_cov_1.256545_g140219_i0 PRJNA752572 140726 226 1.256545 2.8397917 Cyanobacteria bacterium HKST-UBA01 2775581 Bacteria Bacteria 51.6 2.11e-5   NR MCA9815097.1 2775581 g140219 i0 38.9 1.92477876106195 72 42 95.6 2 218 3 255 324 MCA9815097.1 amidohydrolase [Cyanobacteria bacterium HKST-UBA01] diamond 435 51.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium HKST-UBA01
28663581 28663581 PRJNA752572_P_NODE_67047_length_332_cov_4.245791_g66540_i0 PRJNA752572 67047 332 4.245791 14.09602612 Nostoc sp. UHCC 1180 Bacteria Bacteria 90.9 1.37e-18   NR QSJ14844.1 2814655 g66540 i0 47.9 1.73493975903614 96 44 86.7 2 5 292 843 932 QSJ14844.1 FAD-binding protein [Nostoc sp. UHCC 0702] diamond 576 90.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0702
28821069 28821069 PRJNA752572_P_NODE_708_length_1889_cov_3.459008_g645_i0 PRJNA752572 708 1889 3.459008 65.34066112 Nostoc sp. UHCC 1180 Bacteria Bacteria 377 1.2399999999999996e-115   NR QSJ14844.1 2814655 g645 i0 40.6 1.66754896770778 534 292 83.7 10 223 1803 416 931 QSJ14844.1 FAD-binding protein [Nostoc sp. UHCC 0702] diamond 3150 377 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0702
29294948 29294948 PRJNA752572_P_NODE_246269_length_170_cov_0.977778_g245762_i0 PRJNA752572 246269 170 0.977778 1.6622226 Nodosilinea sp. LVE12 2497642 Bacteria Bacteria 71.6 8.78e-13   NR XGB41735.1 2904796 g245762 i0 60 0.970588235294118 55 22 97.1 0 167 3 20 74 XGB41735.1 MAG: hypothetical protein LVS60_16045 [Nodosilinea sp. LVE1205-7] diamond 165 71.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Nodosilinea Nodosilinea sp. LVE1205-7
29863285 29863285 PRJNA752572_P_NODE_70131_length_325_cov_2.200000_g69624_i0 PRJNA752572 70131 325 2.2 7.15 Gloeocapsa sp. PCC 731 102232 Bacteria Bacteria 50.4 1.89e-4   NR WP_006529553.1 102232 g69624 i0 31.6 1.92 98 58 82.2 1 271 5 313 410 WP_006529553.1 cyclic nucleotide-binding domain-containing protein [Gloeocapsa sp. PCC 73106] diamond 624 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. PCC 73106
30115952 30115952 PRJNA752572_P_NODE_56032_length_365_cov_3.175758_g55525_i0 PRJNA752572 56032 365 3.175758 11.5915167 Nostoc sp. UHCC 1180 Bacteria Bacteria 52 8.59e-5   NR QSJ14844.1 2814655 g55525 i0 39.5 1.24931506849315 76 39 62.5 2 228 1 776 844 QSJ14844.1 FAD-binding protein [Nostoc sp. UHCC 0702] diamond 456 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0702
30526729 30526729 PRJNA752572_P_NODE_194073_length_191_cov_1.717949_g193566_i0 PRJNA752572 194073 191 1.717949 3.28128259 Limnospira platensis 118562 Bacteria Bacteria 83.2 1.02e-18   NR MDV7395947.1 3080829 g193566 i0 79.1 0.675392670157068 43 9 67.5 0 187 59 64 106 MDV7395947.1 citrate/2-methylcitrate synthase [Arthrospira platensis SPKY1] diamond 129 83.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
30937684 30937684 PRJNA752572_P_NODE_49394_length_389_cov_2.242938_g48889_i0 PRJNA752572 49394 389 2.242938 8.72502882 Dolichospermum sp. 2720786 Bacteria Bacteria 189 1.17e-57   NR MFN7661193.1 2720786 g48889 i0 86.5 0.802056555269923 104 14 80.2 0 389 78 18 121 MFN7661193.1 hypothetical protein [Dolichospermum sp.] diamond 312 189 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
31000842 31000842 PRJNA752572_P_NODE_236994_length_172_cov_1.737226_g236487_i0 PRJNA752572 236994 172 1.737226 2.98802872 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 55.8 1.12e-7   NR MFM1812702.1 2847862 g236487 i0 61 2.1453488372093 41 16 71.5 0 125 3 20 60 MFM1812702.1 cytosine/adenosine deaminase [Cyanobacteriota bacterium] diamond 369 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31674474 31674474 PRJNA752572_P_NODE_71717_length_321_cov_2.688811_g71210_i0 PRJNA752572 71717 321 2.688811 8.63108331 Nodosilinea 1120752 Bacteria Bacteria 44.3 0.025   NR WP_017301405.1 416001 g71210 i0 27.8 1.81308411214953 97 68 89.7 2 309 22 40 135 WP_017301405.1 AI-2E family transporter [Nodosilinea nodulosa] diamond 582 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Nodosilinea Nodosilinea nodulosa
31769453 31769453 PRJNA752572_P_NODE_25637_length_538_cov_2.139165_g25165_i0 PRJNA752572 25637 538 2.139165 11.5087077 Bacteria 2 Bacteria Bacteria 46.6 0.0285   NR WP_073074377.1 268141 g25165 i0 50 1.70631970260223 72 30 39 3 170 379 746 813 WP_073074377.1 SdrD B-like domain-containing protein [Phormidesmis priestleyi] diamond 918 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi

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