RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1262902" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1262902 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27295156 27295156 PRJNA1262902_P_NODE_9503_length_247_cov_0.885057_g9461_i0 PRJNA1262902 9503 247 0.885057 2.18609079 Aliterella atlantica 1827278 Bacteria Bacteria 127 4.34e-32   NR WP_072044968.1 1827278 g9461 i0 77.8 0.983805668016194 81 18 98.4 0 3 245 35 115 WP_072044968.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Aliterella atlantica] diamond 243 127 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28052943 28052943 PRJNA1262902_P_NODE_11905_length_242_cov_0.911243_g11863_i0 PRJNA1262902 11905 242 0.911243 2.20520806 Nostoc mirabile 2907820 Bacteria Bacteria 117 2.68e-28   NR WP_229499096.1 2907820 g11863 i0 81.3 0.991735537190083 80 15 99.2 0 3 242 482 561 WP_229499096.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Nostoc mirabile] diamond 240 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc mirabile
28589945 28589945 PRJNA1262902_P_NODE_8727_length_248_cov_0.880000_g8685_i0 PRJNA1262902 8727 248 0.88 2.1824 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 152 4.99e-45   NR WP_009629898.1 927677 g8685 i0 97.6 0.991935483870968 82 2 99.2 0 2 247 57 138 WP_009629898.1 recombinase family protein [Synechocystis sp. PCC 7509] diamond 246 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
29554635 29554635 PRJNA1262902_P_NODE_7890_length_250_cov_0.870056_g7848_i0 PRJNA1262902 7890 250 0.870056 2.17514 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 60.8 1.16e-8   NR WP_286003993.1 1471433 g7848 i0 59.3 1.284 54 22 64.8 0 249 88 218 271 WP_286003993.1 hypothetical protein [Geitlerinema calcuttense] diamond 321 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Geitlerinematales Geitlerinemataceae Geitlerinema Geitlerinema calcuttense
30136707 30136707 PRJNA1262902_P_NODE_6732_length_257_cov_1.592391_g6690_i0 PRJNA1262902 6732 257 1.592391 4.09244487 Pseudanabaenaceae cyanobacterium LEGE 13415 2777976 Bacteria Bacteria 89 5.64e-19   NR MBE9012643.1 2777976 g6690 i0 83.1 1.51750972762646 59 10 68.9 0 10 186 2 60 MBE9012643.1 AAA family ATPase [Pseudanabaenaceae cyanobacterium LEGE 13415] diamond 390 89 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium LEGE 13415
31053637 31053637 PRJNA1262902_P_NODE_10355_length_245_cov_0.895349_g10313_i0 PRJNA1262902 10355 245 0.895349 2.19360505 Synechococcaceae cyanobacterium SM1_2_3 2720456 Bacteria Bacteria 148 3.4599999999999987e-41   NR NJM12592.1 2720456 g10313 i0 86.4 0.991836734693878 81 11 99.2 0 1 243 170 250 NJM12592.1 N4-gp56 family major capsid protein [Synechococcaceae cyanobacterium SM1_2_3] diamond 243 148 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium SM1_2_3

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