RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA773625" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA773625 · 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
21151906 21151906 PRJNA773625_P_NODE_6797_length_172_cov_1.471545_g6782_i0 PRJNA773625 6797 172 1.471545 2.5310574 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 80.9 5.24e-16   NR WP_166550734.1 2683263 g6782 i0 100 0.680232558139535 39 0 68 0 147 31 954 992 WP_166550734.1 PAS domain S-box protein [Cellulophaga sp. BC115SP] diamond 117 80.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
29610883 29610883 PRJNA773625_P_NODE_8630_length_166_cov_1.213675_g8615_i0 PRJNA773625 8630 166 1.213675 2.0147005 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 117 1.51e-30   NR WP_370520429.1 2683263 g8615 i0 96.4 0.993975903614458 55 2 99.4 0 1 165 62 116 WP_370520429.1 helix-turn-helix domain-containing protein [Cellulophaga sp. BC115SP] diamond 165 117 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
30306589 30306589 PRJNA773625_P_NODE_8212_length_167_cov_0.881356_g8197_i0 PRJNA773625 8212 167 0.881356 1.47186452 Pontibacter virosus 1765052 Bacteria Bacteria 80.9 1.6e-17   NR WP_116541989.1 1765052 g8197 i0 73.1 0.934131736526946 52 14 93.4 0 156 1 1 52 WP_116541989.1 hypothetical protein [Pontibacter virosus] diamond 156 80.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Pontibacter Pontibacter virosus
30473752 30473752 PRJNA773625_P_NODE_8713_length_166_cov_0.888889_g8698_i0 PRJNA773625 8713 166 0.888889 1.47555574 Bacteroidota 976 Bacteria Bacteria 87.4 8.26e-19   NR WP_044171645.1 103 g8698 i0 95.7 1.66265060240964 46 2 83.1 0 3 140 184 229 WP_044171645.1 hypothetical protein [Flectobacillus major] diamond 276 87.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus major
31538871 31538871 PRJNA773625_P_NODE_10776_length_162_cov_0.920354_g10761_i0 PRJNA773625 10776 162 0.920354 1.49097348 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 52.4 1.34e-6   NR WP_166551959.1 2683263 g10761 i0 96.2 0.481481481481481 26 1 48.1 0 96 19 1 26 WP_166551959.1 MarR family winged helix-turn-helix transcriptional regulator [Cellulophaga sp. BC115SP] diamond 78 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP

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