RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
26617028 26617028 PRJNA315314_S_NODE_16921_length_200_cov_2.152047_g16600_i0 PRJNA315314 16921 200 2.152047 4.304094 Cyanophyceae 3028117 Bacteria Bacteria 115 4.89e-28   NR WP_224408936.1 331517 g16600 i0 80.3 27.72 66 13 99 0 198 1 165 230 WP_224408936.1 transketolase [Oscillatoria salina] diamond 5544 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria salina
26884671 26884671 PRJNA315314_S_NODE_22101_length_177_cov_1.243243_g21780_i0 PRJNA315314 22101 177 1.243243 2.20054011 Leptolyngbyaceae cyanobacterium bins.302 2971802 Bacteria Bacteria 44.7 0.00317   NR MDX2240709.1 2971802 g21780 i0 58.6 0.491525423728814 29 12 49.2 0 2 88 484 512 MDX2240709.1 DUF4157 domain-containing protein [Leptolyngbyaceae cyanobacterium bins.302] diamond 87 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium bins.302
26884685 26884685 PRJNA315314_S_NODE_5181_length_353_cov_2.240741_g4860_i0 PRJNA315314 5181 353 2.240741 7.90981573 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 44.3 0.0297   NR MCC5613425.1 2780403 g4860 i0 48.7 0.331444759206799 39 19 33.1 1 353 237 197 234 MCC5613425.1 mechanosensitive ion channel family protein [Nostoc sp. CHAB 5834] diamond 117 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
27186481 27186481 PRJNA315314_S_NODE_1462_length_634_cov_17.130579_g824_i1 PRJNA315314 1462 634 17.130579 108.60787086 Bacteria 2 Bacteria Bacteria 47 0.029   NR WP_214559332.1 1160 g824 i1 50 0.809148264984227 40 19 18.5 1 630 514 306 345 WP_214559332.1 hypothetical protein [Planktothrix agardhii] diamond 513 47.4 0.991561181434599 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
27232350 27232350 PRJNA315314_S_NODE_26983_length_162_cov_2.037594_g26662_i0 PRJNA315314 26983 162 2.037594 3.30090228 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 85.5 1.09e-17   NR MCC5610964.1 2780403 g26662 i0 75.9 2 54 13 100 0 162 1 701 754 MCC5610964.1 hypothetical protein [Nostoc sp. CHAB 5834] diamond 324 85.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
28179538 28179538 PRJNA315314_S_NODE_24106_length_170_cov_2.907801_g23785_i0 PRJNA315314 24106 170 2.907801 4.9432617 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 47.8 2.32e-5   NR MCC5611592.1 2780403 g23785 i0 48.3 1.02352941176471 58 26 98.8 2 168 1 8 63 MCC5611592.1 hypothetical protein [Nostoc sp. CHAB 5834] diamond 174 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
29158759 29158759 PRJNA315314_S_NODE_6829_length_310_cov_1.800712_g6508_i0 PRJNA315314 6829 310 1.800712 5.5822072 Dolichospermum circinale 109265 Bacteria Bacteria 49.3 1.01e-4   NR MDB9487518.1 3021739 g6508 i0 50 0.638709677419355 66 25 63.9 3 249 52 10 67 MDB9487518.1 hypothetical protein [Dolichospermum circinale CS-537/01] diamond 198 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum circinale
29316444 29316444 PRJNA315314_S_NODE_6929_length_307_cov_4.014388_g6608_i0 PRJNA315314 6929 307 4.014388 12.32417116 Phormidesmis priestleyi Ana 1666911 Bacteria Bacteria 48.5 6.33e-4   NR KPQ34866.1 1666911 g6608 i0 60 0.723127035830619 40 16 39.1 0 307 188 68 107 KPQ34866.1 MAG: TPR repeat/Tetratricopeptide repeat [Phormidesmis priestleyi Ana] diamond 222 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi
29459908 29459908 PRJNA315314_S_NODE_13070_length_225_cov_4.367347_g12749_i0 PRJNA315314 13070 225 4.367347 9.82653075 root 1 Root_unresolved Root_unresolved 106 2.86e-27   NR WP_212664291.1 155977 g12749 i0 69.8 8.4 63 19 84 0 224 36 87 149 WP_212664291.1 MULTISPECIES: nucleoside-diphosphate kinase [Acaryochloris] diamond 1890 107 0.990654205607477 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Acaryochloridaceae Acaryochloris  
29789878 29789878 PRJNA315314_S_NODE_17851_length_195_cov_2.265060_g17530_i0 PRJNA315314 17851 195 2.26506 4.416867 Microcoleus sp. SIO2G3 2607795 Bacteria Bacteria 110 1.7500000000000002e-26   NR NEQ25398.1 2607795 g17530 i0 79.7 2.95384615384615 64 13 98.5 0 193 2 527 590 NEQ25398.1 S9 family peptidase [Microcoleus sp. SIO2G3] diamond 576 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. SIO2G3
29884980 29884980 PRJNA315314_S_NODE_6171_length_325_cov_5.543919_g5850_i0 PRJNA315314 6171 325 5.543919 18.01773675 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 55.8 8.29e-7   NR MCC5612148.1 2780403 g5850 i0 35.7 0.775384615384615 84 52 75.7 1 68 313 99 182 MCC5612148.1 GNAT family N-acetyltransferase [Nostoc sp. CHAB 5834] diamond 252 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
30168901 30168901 PRJNA315314_S_NODE_10132_length_254_cov_7.568889_g9811_i0 PRJNA315314 10132 254 7.568889 19.22497806 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 68.9 5.25e-12   NR MCC5612596.1 2780403 g9811 i0 54.1 0.874015748031496 74 19 87.4 3 2 223 146 204 MCC5612596.1 hypothetical protein [Nostoc sp. CHAB 5834] diamond 222 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
30359218 30359218 PRJNA315314_S_NODE_31452_length_152_cov_2.056911_g31131_i0 PRJNA315314 31452 152 2.056911 3.12650472 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 103 1.05e-24   NR HEY9759762.1 3088181 g31131 i0 100 0.986842105263158 50 0 98.7 0 150 1 106 155 HEY9759762.1 sulfotransferase [Oculatellaceae cyanobacterium] diamond 150 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30896000 30896000 PRJNA315314_S_NODE_7574_length_293_cov_2.753788_g7253_i0 PRJNA315314 7574 293 2.753788 8.06859884 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 60.5 3.85e-8   NR MCC5612240.1 2780403 g7253 i0 36.7 1.73037542662116 98 56 98.3 2 292 5 108 201 MCC5612240.1 VWA domain-containing protein [Nostoc sp. CHAB 5834] diamond 507 60.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
31211304 31211304 PRJNA315314_S_NODE_16655_length_201_cov_3.697674_g16334_i0 PRJNA315314 16655 201 3.697674 7.43232474 Moorena sp. SIO1F2 2607819 Bacteria Bacteria 49.3 1.04e-4   NR WP_293047677.1 2607819 g16334 i0 44.1 1.01492537313433 68 36 98.5 1 3 200 196 263 WP_293047677.1 Ig-like domain-containing protein [Moorena sp. SIO1F2] diamond 204 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena sp. SIO1F2
31622913 31622913 PRJNA315314_S_NODE_20756_length_182_cov_1.692810_g20435_i0 PRJNA315314 20756 182 1.69281 3.0809142 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 48.9 8.5e-5   NR MCC5612648.1 2780403 g20435 i0 46.4 0.923076923076923 56 30 92.3 0 180 13 149 204 MCC5612648.1 hypothetical protein [Nostoc sp. CHAB 5834] diamond 168 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
31907620 31907620 PRJNA315314_S_NODE_11777_length_237_cov_2.490385_g11456_i0 PRJNA315314 11777 237 2.490385 5.90221245 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 58.5 8.9e-8   NR MCC5609601.1 2780403 g11456 i0 44.3 0.772151898734177 61 34 77.2 0 2 184 30 90 MCC5609601.1 TraB/VirB10 family protein [Nostoc sp. CHAB 5834] diamond 183 58.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
31907622 31907622 PRJNA315314_S_NODE_13237_length_224_cov_2.769231_g12916_i0 PRJNA315314 13237 224 2.769231 6.20307744 Fischerella sp. 1191 Bacteria Bacteria 56.6 3.66e-7   NR MCX7595652.1 1191 g12916 i0 63.6 0.589285714285714 44 16 58.9 0 92 223 3 46 MCX7595652.1 DUF2828 domain-containing protein [Fischerella sp.] diamond 132 56.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella sp.
32224147 32224147 PRJNA315314_S_NODE_16698_length_201_cov_2.610465_g16377_i0 PRJNA315314 16698 201 2.610465 5.24703465 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 57.4 1.48e-7   NR MCC5611830.1 2780403 g16377 i0 45 0.895522388059702 60 33 89.6 0 183 4 470 529 MCC5611830.1 single-stranded-DNA-specific exonuclease RecJ [Nostoc sp. CHAB 5834] diamond 180 57.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
32382314 32382314 PRJNA315314_S_NODE_5199_length_352_cov_4.058824_g4878_i0 PRJNA315314 5199 352 4.058824 14.28706048 Nostoc sp. CHAB 5834 2780403 Bacteria Bacteria 141 1.27e-37   NR MCC5611851.1 2780403 g4878 i0 73.9 0.75 88 23 75 0 351 88 313 400 MCC5611851.1 nicotinate phosphoribosyltransferase [Nostoc sp. CHAB 5834] diamond 264 141 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5834
32824008 32824008 PRJNA315314_S_NODE_17700_length_196_cov_1.688623_g17379_i0 PRJNA315314 17700 196 1.688623 3.30970108 Limnospira 2596745 Bacteria Bacteria 83.6 8.32e-17   NR WP_008056789.1 2596745 g17379 i0 72.2 11.7857142857143 54 15 82.7 0 193 32 765 818 WP_008056789.1 MULTISPECIES: phosphoenolpyruvate synthase [Limnospira] diamond 2310 83.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira  

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