RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA606583" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA606583 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
26731537 26731537 PRJNA606583_P_NODE_31701_length_186_cov_1.046980_g31272_i0 PRJNA606583 31701 186 1.04698 1.9473828 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 93.2 2.03e-20   NR MBX9692574.1 2847862 g31272 i0 72.6 1 62 17 100 0 186 1 295 356 MBX9692574.1 transposase [Cyanobacteriota bacterium] diamond 186 93.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27535682 27535682 PRJNA606583_P_NODE_26283_length_215_cov_1.533708_g25854_i0 PRJNA606583 26283 215 1.533708 3.2974722 Bacillati 1783272 Bacteria Bacteria 130 6.25e-36   NR MBA3991952.1 2067977 g25854 i0 80.3 1.98139534883721 71 14 99.1 0 213 1 34 104 MBA3991952.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42] diamond 426 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium DS2.3.42
27901145 27901145 PRJNA606583_P_NODE_33685_length_177_cov_1.392857_g33256_i0 PRJNA606583 33685 177 1.392857 2.46535689 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 119 2.06e-29   NR HEY9684282.1 3088181 g33256 i0 94.8 0.983050847457627 58 3 98.3 0 3 176 439 496 HEY9684282.1 type IV secretory system conjugative DNA transfer family protein [Oculatellaceae cyanobacterium] diamond 174 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
28374898 28374898 PRJNA606583_P_NODE_28126_length_204_cov_0.904192_g27697_i0 PRJNA606583 28126 204 0.904192 1.84455168 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 62.4 2.2e-9   NR HEY9680853.1 3088181 g27697 i0 42.4 0.970588235294118 66 37 95.6 1 199 5 253 318 HEY9680853.1 toprim domain-containing protein [Oculatellaceae cyanobacterium] diamond 198 62.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
28974968 28974968 PRJNA606583_P_NODE_39248_length_159_cov_1.278689_g38819_i0 PRJNA606583 39248 159 1.278689 2.03311551 Cyanobacteria bacterium DS2.3.42 2067977 Bacteria Bacteria 75.1 4.43e-14   NR MBA3992282.1 2067977 g38819 i0 65.4 0.981132075471698 52 17 98.1 1 157 2 206 256 MBA3992282.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42] diamond 156 75.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium DS2.3.42
29303729 29303729 PRJNA606583_P_NODE_40489_length_156_cov_0.983193_g40060_i0 PRJNA606583 40489 156 0.983193 1.53378108 Trichormus 264688 Bacteria Bacteria 103 7.23e-25   NR MBU6450306.1 2800110 g40060 i0 96.1 6.86538461538461 51 2 98.1 0 3 155 39 89 MBU6450306.1 response regulator [Cyanobacteria bacterium REEB67] diamond 1071 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
29827254 29827254 PRJNA606583_P_NODE_42171_length_152_cov_1.017391_g41742_i0 PRJNA606583 42171 152 1.017391 1.54643432 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 56.6 1.35e-7   NR MBA4076233.1 2067979 g41742 i0 58 0.986842105263158 50 19 98.7 2 3 152 9 56 MBA4076233.1 single-stranded-DNA-specific exonuclease RecJ [Cyanobacteria bacterium PR.023] diamond 150 56.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
30428076 30428076 PRJNA606583_P_NODE_31073_length_188_cov_2.410596_g30644_i0 PRJNA606583 31073 188 2.410596 4.53192048 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 46.2 1.55e-4   NR HEY9682146.1 3088181 g30644 i0 74.1 0.430851063829787 27 6 41.5 1 1 78 60 86 HEY9682146.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 81 46.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30775339 30775339 PRJNA606583_P_NODE_23814_length_233_cov_1.540816_g23385_i0 PRJNA606583 23814 233 1.540816 3.59010128 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 147 3.389999999999999e-42   NR HEY9757686.1 3088181 g23385 i0 92.1 0.978540772532189 76 6 97.9 0 229 2 143 218 HEY9757686.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 228 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32071582 32071582 PRJNA606583_P_NODE_32498_length_182_cov_1.613793_g32069_i0 PRJNA606583 32498 182 1.613793 2.93710326 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 100 3.9599999999999997e-23   NR MBX9692574.1 2847862 g32069 i0 81.7 0.989010989010989 60 11 98.9 0 182 3 234 293 MBX9692574.1 transposase [Cyanobacteriota bacterium] diamond 180 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32622359 32622359 PRJNA606583_P_NODE_40600_length_155_cov_2.313559_g40171_i0 PRJNA606583 40600 155 2.313559 3.58601645 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 50.4 2.11e-5   NR OLE96369.1 1805100 g40171 i0 53.8 5.32258064516129 39 18 75.5 0 1 117 223 261 OLE96369.1 MAG: hypothetical protein AUG75_21370 [Cyanobacteria bacterium 13_1_20CM_4_61_6] diamond 825 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium 13_1_20CM_4_61_6
32672159 32672159 PRJNA606583_P_NODE_39840_length_157_cov_1.950000_g39411_i0 PRJNA606583 39840 157 1.95 3.0615 Cyanobacteria bacterium SZAS LIN-2 2807731 Bacteria Bacteria 45.8 9.14e-4   NR MBS1994710.1 2807731 g39411 i0 79.2 0.955414012738854 24 5 45.9 0 155 84 463 486 MBS1994710.1 CHASE3 domain-containing protein [Cyanobacteria bacterium SZAS LIN-2] diamond 150 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-2

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