RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA603943" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA603943 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28090594 28090594 PRJNA603943_P_NODE_5705_length_638_cov_1.564602_g5520_i0 PRJNA603943 5705 638 1.564602 9.98216076 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 306 1.3099999999999995e-101   NR MBX9694561.1 2847862 g5520 i0 73.4 0.973354231974922 207 50 95 2 614 9 15 221 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 621 306 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30869820 30869820 PRJNA603943_P_NODE_52654_length_251_cov_0.865169_g52462_i0 PRJNA603943 52654 251 0.865169 2.17157419 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 152 8.88e-46   NR MBX9692690.1 2847862 g52462 i0 88.3 0.920318725099602 77 9 92 0 250 20 41 117 MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium] diamond 231 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31831429 31831429 PRJNA603943_P_NODE_22797_length_365_cov_1.044521_g22605_i0 PRJNA603943 22797 365 1.044521 3.81250165 Synechococcus 1129 Bacteria Bacteria 80.5 7.82e-15   NR WP_414413135.1 2291959 g22605 i0 40.5 5.75342465753425 116 33 95.3 1 350 3 142 221 WP_414413135.1 peptide chain release factor 3, partial [Synechococcus sp. R8-2] diamond 2100 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. R8-2
31958113 31958113 PRJNA603943_P_NODE_3057_length_828_cov_3.219868_g2898_i0 PRJNA603943 3057 828 3.219868 26.66050704 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 124 2.68e-29   NR WP_015138290.1 28072 g2898 i0 37.3 2.36231884057971 217 123 77.9 6 756 112 90 295 WP_015138290.1 hypothetical protein [Nostoc sp. PCC 7524] diamond 1956 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. PCC 7524

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