RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA572587 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
27237493 27237493 PRJNA572587_P_NODE_8703_length_408_cov_86.983287_g8377_i0 PRJNA572587 8703 408 86.983287 354.89181096 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 50.1 4.78e-5   NR MBA4078324.1 2067979 g8377 i0 50.8 0.463235294117647 63 30 46.3 1 51 239 13 74 MBA4078324.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 189 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27490357 27490357 PRJNA572587_P_NODE_1743_length_967_cov_63.428105_g1579_i0 PRJNA572587 1743 967 63.428105 613.34977535 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 595 5.96e-209   NR HEY9760692.1 3088181 g1579 i0 99.7 0.955532574974147 308 1 95.6 0 20 943 266 573 HEY9760692.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 924 595 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27521785 27521785 PRJNA572587_P_NODE_43523_length_166_cov_0.871795_g43195_i0 PRJNA572587 43523 166 0.871795 1.4471797 Gloeocapsa sp. BRSZ 3160964 Bacteria Bacteria 61.2 3.93e-9   NR WP_352532341.1 3160964 g43195 i0 53.7 0.975903614457831 54 20 97.6 1 1 162 221 269 WP_352532341.1 right-handed parallel beta-helix repeat-containing protein [Gloeocapsa sp. BRSZ] diamond 162 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. BRSZ
27693633 27693633 PRJNA572587_P_NODE_16704_length_280_cov_1.679654_g16376_i0 PRJNA572587 16704 280 1.679654 4.7030312 Bacillati 1783272 Bacteria Bacteria 87.8 8.11e-18   NR MBA4076933.1 2067979 g16376 i0 67.7 3.28928571428571 62 16 62.1 1 278 105 644 705 MBA4076933.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 921 88.6 0.99097065462754 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
28816132 28816132 PRJNA572587_P_NODE_25308_length_223_cov_2.632184_g24980_i0 PRJNA572587 25308 223 2.632184 5.86977032 Nostoc 1177 Bacteria Bacteria 43.1 0.00499   NR WP_190900315.1 1177 g24980 i0 34.5 0.739910313901345 55 33 71.3 2 193 35 28 81 WP_190900315.1 MULTISPECIES: hypothetical protein [Nostoc] diamond 165 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc  
28956534 28956534 PRJNA572587_P_NODE_29748_length_204_cov_1.774194_g29420_i0 PRJNA572587 29748 204 1.774194 3.61935576 Bacillati 1783272 Bacteria Bacteria 113 9.13e-29   NR MBA4074669.1 2067979 g29420 i0 80.6 1.97058823529412 67 13 98.5 0 202 2 35 101 MBA4074669.1 enoyl-CoA hydratase [Cyanobacteria bacterium PR.023] diamond 402 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
29258181 29258181 PRJNA572587_P_NODE_12069_length_337_cov_2.524306_g11741_i0 PRJNA572587 12069 337 2.524306 8.50691122 Calothrix sp. UHCC 1187 Bacteria Bacteria 192 6.139999999999998e-56   NR WP_323341403.1 3110245 g11741 i0 77.4 0.943620178041543 106 24 94.4 0 320 3 459 564 WP_323341403.1 SDR family NAD(P)-dependent oxidoreductase [Calothrix sp. UHCC 0171] diamond 318 192 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. UHCC 0171
29335215 29335215 PRJNA572587_P_NODE_37749_length_179_cov_0.830769_g37421_i0 PRJNA572587 37749 179 0.830769 1.48707651 Bacillati 1783272 Bacteria Bacteria 65.5 1.03e-10   NR MBA4074669.1 2067979 g37421 i0 83.8 1.87709497206704 37 6 62 0 36 146 256 292 MBA4074669.1 enoyl-CoA hydratase [Cyanobacteria bacterium PR.023] diamond 336 65.9 0.993930197268589 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
29366861 29366861 PRJNA572587_P_NODE_47009_length_161_cov_0.910714_g46681_i0 PRJNA572587 47009 161 0.910714 1.46624954 Leptolyngbya 47251 Bacteria Bacteria 95.5 3.1600000000000003e-21   NR WP_088890714.1 1962290 g46681 i0 88.7 6.91304347826087 53 6 98.8 0 161 3 9 61 WP_088890714.1 Tex family protein [Leptolyngbya ohadii] diamond 1113 95.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya ohadii
29493049 29493049 PRJNA572587_P_NODE_4390_length_611_cov_6.409253_g4087_i0 PRJNA572587 4390 611 6.409253 39.16053583 Bacillati 1783272 Bacteria Bacteria 67 7.71e-10   NR WP_106459555.1 1521625 g4087 i0 61.1 1.89034369885434 54 19 26 2 396 554 1 53 WP_106459555.1 3'-5' exoribonuclease domain-containing protein [Aphanothece hegewaldii] diamond 1155 67 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Aphanothece Aphanothece hegewaldii
30016423 30016423 PRJNA572587_P_NODE_35731_length_184_cov_8.925926_g35403_i0 PRJNA572587 35731 184 8.925926 16.42370384 Moorena producens 3L 489825 Bacteria Bacteria 60.8 1.31e-9   NR EGJ32297.1 489825 g35403 i0 89.2 0.603260869565217 37 4 60.3 0 73 183 44 80 EGJ32297.1 carbon dioxide concentrating mechanism/carboxysome shell protein [Moorena producens 3L] diamond 111 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena producens
30521809 30521809 PRJNA572587_P_NODE_1593_length_1004_cov_40.877487_g1441_i0 PRJNA572587 1593 1004 40.877487 410.40996948 Cyanobacteria bacterium REEB67 2800110 Bacteria Bacteria 262 1.8e-84   NR MBU6450327.1 2800110 g1441 i0 71.3 1.98705179282869 167 48 49.9 0 133 633 1 167 MBU6450327.1 hypothetical protein [Cyanobacteria bacterium REEB67] diamond 1995 262 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
31786074 31786074 PRJNA572587_P_NODE_1177_length_1132_cov_11.622345_g1071_i0 PRJNA572587 1177 1132 11.622345 131.5649454 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 90.5 3.73e-18   NR MEY2976746.1 2847862 g1071 i0 43.3 0.257067137809187 97 55 25.7 0 841 1131 2 98 MEY2976746.1 hypothetical protein [Cyanobacteriota bacterium] diamond 291 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32229428 32229428 PRJNA572587_P_NODE_5898_length_512_cov_3.259179_g5577_i0 PRJNA572587 5898 512 3.259179 16.68699648 Cyanobacteria bacterium SZAS LIN-2 2807731 Bacteria Bacteria 169 1.6199999999999998e-48   NR MBS1995535.1 2807731 g5577 i0 60.7 1.74609375 140 55 82 0 84 503 7 146 MBS1995535.1 patatin-like phospholipase family protein [Cyanobacteria bacterium SZAS LIN-2] diamond 894 169 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-2
32482489 32482489 PRJNA572587_P_NODE_30039_length_203_cov_1.467532_g29711_i0 PRJNA572587 30039 203 1.467532 2.97908996 Microcystis viridis Mv_BB_P_19951 44822 Bacteria Bacteria 134 1.29e-34   NR TRU80155.1 2486268 g29711 i0 100 0.960591133004926 65 0 96.1 0 1 195 514 578 TRU80155.1 MAG: T9SS type A sorting domain-containing protein, partial [Microcystis viridis Mv_BB_P_19951000_S69D] diamond 195 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis viridis

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