RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1214993" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 7 ✖

bioproject 1

  • PRJNA1214993 · 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
14359353 14359353 PRJNA1214993_P_NODE_24252_length_245_cov_0.906977_g24066_i0 PRJNA1214993 24252 245 0.906977 2.22209365 Cyanophyceae 3028117 Bacteria Bacteria 134 4.42e-38   NR WP_009756874.1 372787 g24066 i0 77.8 13.8367346938776 81 18 99.2 0 245 3 53 133 WP_009756874.1 nucleoside-diphosphate kinase [Fischerella thermalis] diamond 3390 135 0.992592592592593 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella thermalis
27673062 27673062 PRJNA1214993_P_NODE_20224_length_252_cov_0.871508_g20038_i0 PRJNA1214993 20224 252 0.871508 2.19620016 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 43.5 0.0219   NR HEY9685893.1 3081323 g20038 i0 34.9 0.75 63 32 75 2 231 43 163 216 HEY9685893.1 site-2 protease family protein [Coleofasciculaceae cyanobacterium] diamond 189 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
27767851 27767851 PRJNA1214993_P_NODE_24744_length_244_cov_0.912281_g24558_i0 PRJNA1214993 24744 244 0.912281 2.22596564 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 117 1.05e-29   NR WP_250123614.1 155894 g24558 i0 78.2 0.959016393442623 78 16 95.9 1 4 237 44 120 WP_250123614.1 Ycf66 family protein [Chroococcidiopsis sp. CCMEE 29] diamond 234 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
28177821 28177821 PRJNA1214993_P_NODE_11346_length_327_cov_1.228346_g11160_i0 PRJNA1214993 11346 327 1.228346 4.01669142 Synechococcaceae cyanobacterium SM2_3_1 2720469 Bacteria Bacteria 49.3 2.48e-4   NR NJK64491.1 2720469 g11160 i0 29 0.917431192660551 100 66 87.2 3 16 300 86 185 NJK64491.1 hypothetical protein [Synechococcaceae cyanobacterium SM2_3_1] diamond 300 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium SM2_3_1
28177842 28177842 PRJNA1214993_P_NODE_23166_length_247_cov_0.885057_g22980_i0 PRJNA1214993 23166 247 0.885057 2.18609079 Cyanobacteria bacterium P01_G01_bin.54 3023307 Bacteria Bacteria 49.3 1.4e-4   NR MEM8642542.1 3023307 g22980 i0 33.3 1.90688259109312 78 48 92.3 3 9 236 61 136 MEM8642542.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Cyanobacteria bacterium P01_G01_bin.54] diamond 471 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_G01_bin.54
32190838 32190838 PRJNA1214993_P_NODE_24698_length_244_cov_0.912281_g24512_i0 PRJNA1214993 24698 244 0.912281 2.22596564 Leptolyngbya sp. SIO3F4 2607780 Bacteria Bacteria 41.6 0.0497   NR NEQ51820.1 2607780 g24512 i0 45.7 0.430327868852459 35 19 43 0 2 106 15 49 NEQ51820.1 DUF4281 domain-containing protein [Leptolyngbya sp. SIO3F4] diamond 105 41.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. SIO3F4
32431154 32431154 PRJNA1214993_P_NODE_2639_length_647_cov_1.900697_g2462_i0 PRJNA1214993 2639 647 1.900697 12.29750959 root 1 Root_unresolved Root_unresolved 55.8 3.64e-5   NR WP_199328726.1 109615 g2462 i0 45.3 2.1468315301391 53 29 24.6 0 84 242 294 346 WP_199328726.1 C1 family peptidase [Microcystis flos-aquae] diamond 1389 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis flos-aquae

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