RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 7 ✖

bioproject 1

  • PRJNA255848 · 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
27073991 27073991 PRJNA255848_P_NODE_40622_length_164_cov_1.773913_g40304_i0 PRJNA255848 40622 164 1.773913 2.90921732 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 94.7 9.48e-22   NR MBA4076805.1 2067979 g40304 i0 92.2 3.84146341463415 51 4 93.3 0 11 163 31 81 MBA4076805.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 630 94.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27200240 27200240 PRJNA255848_P_NODE_47382_length_161_cov_0.910714_g47064_i0 PRJNA255848 47382 161 0.910714 1.46624954 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 50.4 8.79e-6   NR MBX9571837.1 2364082 g47064 i0 88.9 0.503105590062112 27 3 50.3 0 124 44 52 78 MBX9571837.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 81 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27471120 27471120 PRJNA255848_P_NODE_26843_length_192_cov_1.426573_g26525_i0 PRJNA255848 26843 192 1.426573 2.73902016 Bacillati 1783272 Bacteria Bacteria 99 2.96e-22   NR WP_223280385.1 2575443 g26525 i0 82.5 9.765625 63 11 98.4 0 2 190 586 648 WP_223280385.1 phosphoenolpyruvate synthase [Nostoc sp. PA-18-2419] diamond 1875 100 0.99 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. PA-18-2419
27863619 27863619 PRJNA255848_P_NODE_41485_length_164_cov_0.886957_g41167_i0 PRJNA255848 41485 164 0.886957 1.45460948 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 50.4 2.43e-5   NR MFA7336431.1 2364082 g41167 i0 44.2 0.951219512195122 52 28 93.3 1 1 153 852 903 MFA7336431.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 156 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31893398 31893398 PRJNA255848_P_NODE_33817_length_170_cov_1.289256_g33499_i0 PRJNA255848 33817 170 1.289256 2.1917352 Bacteria 2 Bacteria Bacteria 49.7 4.85e-6   NR WP_226592583.1 467598 g33499 i0 74.2 3.40588235294118 31 8 54.7 0 168 76 47 77 WP_226592583.1 peptidoglycan-binding domain-containing protein [Microseira wollei] diamond 579 50.1 0.992015968063872 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira wollei
32097128 32097128 PRJNA255848_P_NODE_29538_length_183_cov_1.156716_g29220_i0 PRJNA255848 29538 183 1.156716 2.11679028 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 75.1 6.45e-14   NR WP_146134162.1 2107693 g29220 i0 76.7 0.983606557377049 60 13 98.4 1 3 182 543 601 WP_146134162.1 DUF3854 domain-containing protein, partial [Chlorogloea sp. CCALA 695] diamond 180 75.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
32729227 32729227 PRJNA255848_P_NODE_44500_length_162_cov_1.805310_g44182_i0 PRJNA255848 44500 162 1.80531 2.9246022 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 39.7 0.0497   NR MFM8526346.1 2847862 g44182 i0 35.4 0.888888888888889 48 30 87 1 21 161 11 58 MFM8526346.1 4a-hydroxytetrahydrobiopterin dehydratase [Cyanobacteriota bacterium] diamond 144 39.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium

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