RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA924320 · 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
22576236 22576236 PRJNA924320_S_NODE_28118_length_204_cov_0.987097_g27976_i0 PRJNA924320 28118 204 0.987097 2.01367788 Synechocystis sp. 1143 Bacteria Bacteria 88.6 3.87e-21   NR MEB3228129.1 1143 g27976 i0 78.8 1.52941176470588 52 11 76.5 0 2 157 36 87 MEB3228129.1 peptidylprolyl isomerase [Synechocystis sp.] diamond 312 88.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp.
26968579 26968579 PRJNA924320_S_NODE_54982_length_162_cov_0.902655_g54840_i0 PRJNA924320 54982 162 0.902655 1.4623011 Bacillati 1783272 Bacteria Bacteria 54.3 2.54e-7   NR WP_224413217.1 331517 g54840 i0 49.1 5.83333333333333 53 27 98.1 0 161 3 17 69 WP_224413217.1 NADAR family protein [Oscillatoria salina] diamond 945 54.7 0.992687385740402 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria salina
27435786 27435786 PRJNA924320_S_NODE_5343_length_410_cov_2.573407_g5201_i0 PRJNA924320 5343 410 2.573407 10.5509687 Thermoleptolyngbya sichuanensis 2885951 Bacteria Bacteria 45.8 0.0179   NR WP_277774598.1 2885951 g5201 i0 37.5 0.526829268292683 72 42 52.7 1 174 389 30 98 WP_277774598.1 alkaline phosphatase [Thermoleptolyngbya sichuanensis] diamond 216 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Thermoleptolyngbya Thermoleptolyngbya sichuanensis
28042724 28042724 PRJNA924320_S_NODE_40585_length_176_cov_1.393701_g40443_i0 PRJNA924320 40585 176 1.393701 2.45291376 Nostoc 1177 Bacteria Bacteria 52.8 4.42e-6   NR BBD60768.1 196308 g40443 i0 51.2 2.35227272727273 43 21 73.3 0 46 174 398 440 BBD60768.1 WD-40 repeat-containing protein [Nostoc sp. HK-01] diamond 414 53.1 0.994350282485876 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. HK-01
28130287 28130287 PRJNA924320_S_NODE_41245_length_175_cov_1.214286_g41103_i0 PRJNA924320 41245 175 1.214286 2.1250005 Stenomitos sp. 3088177 Bacteria Bacteria 53.1 3.19e-6   NR HEY9855868.1 3088177 g41103 i0 51.9 1.76571428571429 52 25 89.1 0 20 175 220 271 HEY9855868.1 AAA family ATPase [Stenomitos sp.] diamond 309 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos sp.
28446052 28446052 PRJNA924320_S_NODE_47646_length_166_cov_1.307692_g47504_i0 PRJNA924320 47646 166 1.307692 2.17076872 Leptolyngbya sp. FACHB-261 2692806 Bacteria Bacteria 42.4 0.0186   NR WP_190800882.1 2692806 g47504 i0 50 1.31927710843373 32 16 57.8 0 5 100 810 841 WP_190800882.1 DNA mismatch repair protein MutS [Leptolyngbya sp. FACHB-261] diamond 219 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-261
28579552 28579552 PRJNA924320_S_NODE_12247_length_283_cov_2.491453_g12105_i0 PRJNA924320 12247 283 2.491453 7.05081199 root 1 Root_unresolved Root_unresolved 159 4.1e-43   NR WP_288916497.1 154535 g12105 i0 96.4 1.74911660777385 83 3 88 0 7 255 607 689 WP_288916497.1 30S ribosomal protein S12 [uncultured Synechococcus sp.] diamond 495 159 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus uncultured Synechococcus sp.
28793053 28793053 PRJNA924320_S_NODE_20307_length_230_cov_1.751381_g20165_i0 PRJNA924320 20307 230 1.751381 4.0281763 Scytonematopsis contorta 1049027 Bacteria Bacteria 92.8 9.48e-21   NR MBW4505315.1 1049028 g20165 i0 68.2 5.15217391304348 66 21 86.1 0 228 31 4 69 MBW4505315.1 phytoene/squalene synthase family protein [Scytonematopsis contorta HA4267-MV1] diamond 1185 92.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonematopsis Scytonematopsis contorta
29109127 29109127 PRJNA924320_S_NODE_41288_length_175_cov_1.214286_g41146_i0 PRJNA924320 41288 175 1.214286 2.1250005 Cylindrospermum sp. NIES-4 2910429 Bacteria Bacteria 58.2 3.58e-8   NR BAZ32339.1 2005457 g41146 i0 55.1 0.84 49 22 84 0 154 8 7 55 BAZ32339.1 hypothetical protein NIES4074_48410 [Cylindrospermum sp. NIES-4074] diamond 147 58.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Cylindrospermum Cylindrospermum sp. NIES-4074
29620923 29620923 PRJNA924320_S_NODE_52050_length_164_cov_0.886957_g51908_i0 PRJNA924320 52050 164 0.886957 1.45460948 Cyanophyceae 3028117 Bacteria Bacteria 42.4 0.0176   NR WP_414542899.1 1056123 g51908 i0 41.9 1.5 43 25 78.7 0 8 136 89 131 WP_414542899.1 protein kinase domain-containing protein [Nostoc sp. CCY0012] diamond 246 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CCY0012
29961502 29961502 PRJNA924320_S_NODE_31791_length_194_cov_1.758621_g31649_i0 PRJNA924320 31791 194 1.758621 3.41172474 Cyanobacteria bacterium M_surface_10_m2_179 2775528 Bacteria Bacteria 41.2 0.049   NR MBM5806433.1 2775528 g31649 i0 51.1 0.695876288659794 45 20 66.5 1 58 186 36 80 MBM5806433.1 hypothetical protein [Cyanobacteria bacterium M_surface_10_m2_179] diamond 135 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium M_surface_10_m2_179
30309543 30309543 PRJNA924320_S_NODE_14872_length_261_cov_1.533019_g14730_i0 PRJNA924320 14872 261 1.533019 4.00117959 Calothrix sp. HK- 1187 Bacteria Bacteria 80.9 1.49e-15   NR OKH54609.1 1137096 g14730 i0 49.4 2.88505747126437 85 32 92 2 21 260 134 212 OKH54609.1 hypothetical protein NIES2101_07325 [Calothrix sp. HK-06] diamond 753 80.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. HK-06
30309560 30309560 PRJNA924320_S_NODE_28352_length_203_cov_1.383117_g28210_i0 PRJNA924320 28352 203 1.383117 2.80772751 Cyanobacteria bacterium GSL.Bin1 2773161 Bacteria Bacteria 60.5 1.21e-8   NR NBD15361.1 2773161 g28210 i0 45.3 2.77832512315271 64 35 94.6 0 192 1 35 98 NBD15361.1 folate/biopterin family MFS transporter [Cyanobacteria bacterium GSL.Bin1] diamond 564 60.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium GSL.Bin1
30719753 30719753 PRJNA924320_S_NODE_54754_length_162_cov_1.353982_g54612_i0 PRJNA924320 54754 162 1.353982 2.19345084 Kamptonema 1501433 Bacteria Bacteria 81.6 4.23e-17   NR WP_007354419.1 1501433 g54612 i0 70.4 2 54 15 100 1 162 1 169 221 WP_007354419.1 MULTISPECIES: glycosyl hydrolase 108 family protein [Kamptonema] diamond 324 81.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Kamptonema  
30814576 30814576 PRJNA924320_S_NODE_6074_length_386_cov_2.501484_g5932_i0 PRJNA924320 6074 386 2.501484 9.65572824 Dolichospermum sp. 2720786 Bacteria Bacteria 101 2.0299999999999998e-23   NR MFN7661193.1 2720786 g5932 i0 87.3 0.427461139896373 55 7 42.7 0 2 166 67 121 MFN7661193.1 hypothetical protein [Dolichospermum sp.] diamond 165 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
31067557 31067557 PRJNA924320_S_NODE_52335_length_164_cov_0.886957_g52193_i0 PRJNA924320 52335 164 0.886957 1.45460948 Leptolyngbyaceae cyanobacterium M33_DOE_097 2747805 Bacteria Bacteria 44.3 0.00371   NR HIK18349.1 2747805 g52193 i0 46.3 1.95731707317073 54 29 98.8 0 162 1 1525 1578 HIK18349.1 tandem-95 repeat protein [Leptolyngbyaceae cyanobacterium M33_DOE_097] diamond 321 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium M33_DOE_097
31517408 31517408 PRJNA924320_S_NODE_26556_length_208_cov_1.679245_g26414_i0 PRJNA924320 26556 208 1.679245 3.4928296 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 60.5 1.34e-8   NR WP_082650699.1 996925 g26414 i0 52.7 3.44711538461538 55 25 79.3 1 187 23 207 260 WP_082650699.1 expansin EXLX1 family cellulose-binding protein [Mastigocoleus testarum] diamond 717 60.8 0.995065789473684 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Mastigocoleus Mastigocoleus testarum
32079379 32079379 PRJNA924320_S_NODE_17838_length_242_cov_2.357513_g17696_i0 PRJNA924320 17838 242 2.357513 5.70518146 Sphaerospermopsis 752201 Bacteria Bacteria 57 2.04e-7   NR WP_096566227.1 752201 g17696 i0 48.5 1.68595041322314 68 32 84.3 1 212 9 138 202 WP_096566227.1 MULTISPECIES: CAP domain-containing protein [Sphaerospermopsis] diamond 408 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Sphaerospermopsis  
32237941 32237941 PRJNA924320_S_NODE_13818_length_269_cov_1.618182_g13676_i0 PRJNA924320 13818 269 1.618182 4.35290958 Dolichospermum sp. 2720786 Bacteria Bacteria 122 4.09e-32   NR MFN7661193.1 2720786 g13676 i0 83.1 0.79182156133829 71 12 79.2 0 215 3 1 71 MFN7661193.1 hypothetical protein [Dolichospermum sp.] diamond 213 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
32592939 32592939 PRJNA924320_S_NODE_22959_length_220_cov_1.192982_g22817_i0 PRJNA924320 22959 220 1.192982 2.6245604 Nostocales 1161 Bacteria Bacteria 53.5 3.02e-6   NR MBW4456104.1 287863 g22817 i0 44.4 13.3090909090909 54 30 73.6 0 212 51 8 61 MBW4456104.1 WD40 repeat domain-containing protein [Nostoc indistinguendum CM1-VF10] diamond 2928 53.9 0.992578849721707 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc indistinguendum
32711463 32711463 PRJNA924320_S_NODE_18840_length_237_cov_1.627660_g18698_i0 PRJNA924320 18840 237 1.62766 3.8575542 Merismopedia glauca 292586 Bacteria Bacteria 48.5 2.76e-4   NR WP_106291238.1 292586 g18698 i0 44.3 5.25316455696202 61 33 75.9 1 50 229 80 140 WP_106291238.1 SDR family NAD(P)-dependent oxidoreductase [Merismopedia glauca] diamond 1245 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Merismopedia Merismopedia glauca

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