RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA564810 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
5657991 5657991 PRJNA564810_S_NODE_5685_length_242_cov_1.536723_g5663_i0 PRJNA564810 5685 242 1.536723 3.71886966 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 156 1.99e-44   NR WP_106367299.1 2107693 g5663 i0 97.5 19.8347107438017 80 2 99.2 0 242 3 172 251 WP_106367299.1 recombinase RecA [Chlorogloea sp. CCALA 695] diamond 4800 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
8207119 8207119 PRJNA564810_S_NODE_3307_length_290_cov_1.813333_g3285_i0 PRJNA564810 3307 290 1.813333 5.2586657 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 182 1.58e-53   NR WP_009634238.1 927677 g3285 i0 97.9 0.993103448275862 96 2 99.3 0 1 288 84 179 WP_009634238.1 preprotein translocase subunit SecY [Synechocystis sp. PCC 7509] diamond 288 182 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
26636056 26636056 PRJNA564810_S_NODE_4061_length_272_cov_0.985507_g4039_i0 PRJNA564810 4061 272 0.985507 2.68057904 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 105 1.32e-25   NR WP_106367335.1 2107693 g4039 i0 77.9 0.75 68 15 75 0 272 69 200 267 WP_106367335.1 pyridine nucleotide transhydrogenase [Chlorogloea sp. CCALA 695] diamond 204 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
28216065 28216065 PRJNA564810_S_NODE_6326_length_232_cov_2.035928_g6304_i0 PRJNA564810 6326 232 2.035928 4.72335296 Nostocales cyanobacterium HT-58-2 1940762 Bacteria Bacteria 91.7 7.75e-20   NR ARV61053.1 1940762 g6304 i0 56.3 4.17672413793103 64 28 82.8 0 17 208 291 354 ARV61053.1 hypothetical protein BZZ01_22695 [Nostocales cyanobacterium HT-58-2] diamond 969 91.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales     Nostocales cyanobacterium HT-58-2
28469086 28469086 PRJNA564810_S_NODE_5206_length_250_cov_1.102703_g5184_i0 PRJNA564810 5206 250 1.102703 2.7567575 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 156 5.439999999999999e-43   NR WP_106369171.1 2107693 g5184 i0 88 0.996 83 10 99.6 0 249 1 21 103 WP_106369171.1 GspE/PulE family protein [Chlorogloea sp. CCALA 695] diamond 249 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
28626990 28626990 PRJNA564810_S_NODE_5687_length_242_cov_1.531073_g5665_i0 PRJNA564810 5687 242 1.531073 3.70519666 Chroococcus sp. CMT-3BRIN-NPC107 2499659 Bacteria Bacteria 55.8 5.62e-7   NR MBW4663526.1 2499659 g5665 i0 50.9 0.681818181818182 55 26 66.9 1 5 166 10 64 MBW4663526.1 hypothetical protein [Chroococcus sp. CMT-3BRIN-NPC107] diamond 165 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chroococcus Chroococcus sp. CMT-3BRIN-NPC107
31785892 31785892 PRJNA564810_S_NODE_5037_length_253_cov_1.808511_g5015_i0 PRJNA564810 5037 253 1.808511 4.57553283 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 150 1.8799999999999994e-42   NR WP_106370624.1 2107693 g5015 i0 89.3 0.99604743083004 84 9 99.6 0 1 252 211 294 WP_106370624.1 SDR family oxidoreductase [Chlorogloea sp. CCALA 695] diamond 252 150 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695

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