RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA781427" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA781427 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
9690157 9690157 PRJNA781427_P_NODE_82748_length_247_cov_0.885057_g81864_i0 PRJNA781427 82748 247 0.885057 2.18609079 Balneola sp. 2024824 Bacteria Bacteria 107 3.62e-25   NR MEQ8579979.1 2024824 g81864 i0 91.5 4.29959514170041 59 5 71.7 0 4 180 407 465 MEQ8579979.1 T9SS type A sorting domain-containing protein [Balneola sp.] diamond 1062 107 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
29052554 29052554 PRJNA781427_P_NODE_94068_length_242_cov_0.911243_g93184_i0 PRJNA781427 94068 242 0.911243 2.20520806 Balneola 455358 Bacteria Bacteria 155 1.0499999999999996e-43   NR WP_066217722.1 1849360 g93184 i0 91.3 1.98347107438017 80 7 99.2 0 1 240 295 374 WP_066217722.1 hypothetical protein [Balneola sp. EhC07] diamond 480 155 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp. EhC07
30653750 30653750 PRJNA781427_P_NODE_83033_length_247_cov_0.885057_g82149_i0 PRJNA781427 83033 247 0.885057 2.18609079 Balneola sp. 2024824 Bacteria Bacteria 145 1.3e-40   NR MBO6571158.1 2024824 g82149 i0 80.2 0.983805668016194 81 16 98.4 0 3 245 223 303 MBO6571158.1 hypothetical protein [Balneola sp.] diamond 243 145 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
31791764 31791764 PRJNA781427_P_NODE_91577_length_243_cov_0.905882_g90693_i0 PRJNA781427 91577 243 0.905882 2.20129326 Balneola sp. 2024824 Bacteria Bacteria 42.4 0.0492   NR MEP2445649.1 2024824 g90693 i0 61.8 0.419753086419753 34 13 42 0 107 6 6 39 MEP2445649.1 hypothetical protein [Balneola sp.] diamond 102 42.4 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
31918535 31918535 PRJNA781427_P_NODE_94877_length_242_cov_0.911243_g93993_i0 PRJNA781427 94877 242 0.911243 2.20520806 Balneola sp. 2024824 Bacteria Bacteria 124 2.55e-32   NR MEP1151688.1 2024824 g93993 i0 78.8 0.991735537190083 80 17 99.2 0 1 240 268 347 MEP1151688.1 FecR domain-containing protein [Balneola sp.] diamond 240 124 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.

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