RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1008049 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
12480117 12480117 PRJNA1008049_S_NODE_3330_length_165_cov_5.595588_g3312_i0 PRJNA1008049 3330 165 5.595588 9.2327202 Flavobacterium sp. 27 239 Bacteria Bacteria 108 2.9e-28   NR WP_134146805.1 2512114 g3312 i0 100 0.981818181818182 54 0 98.2 0 163 2 36 89 WP_134146805.1 hypothetical protein [Flavobacterium sp. 270] diamond 162 108 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
26686189 26686189 PRJNA1008049_S_NODE_2981_length_169_cov_2.900000_g2963_i0 PRJNA1008049 2981 169 2.9 4.901 Xanthocytophaga agilis 3048010 Bacteria Bacteria 95.9 2.64e-21   NR WP_314513102.1 3048010 g2963 i0 75 0.994082840236686 56 14 99.4 0 1 168 180 235 WP_314513102.1 TonB-dependent receptor [Xanthocytophaga agilis] diamond 168 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Rhodocytophagaceae Xanthocytophaga Xanthocytophaga agilis
26844857 26844857 PRJNA1008049_S_NODE_721_length_226_cov_5.060914_g703_i0 PRJNA1008049 721 226 5.060914 11.43766564 Ferruginibacter sp. 1940288 Bacteria Bacteria 107 2.97e-28   NR HSN60774.1 1940288 g703 i0 65.3 0.995575221238938 75 26 99.6 0 226 2 29 103 HSN60774.1 hypothetical protein [Ferruginibacter sp.] diamond 225 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Ferruginibacter Ferruginibacter sp.
27121520 27121520 PRJNA1008049_S_NODE_2082_length_180_cov_2.721854_g2064_i0 PRJNA1008049 2082 180 2.721854 4.8993372 Chitinophagaceae 563835 Bacteria Bacteria 104 9.44e-28   NR MEI8280745.1 1898104 g2064 i0 87.7 7.6 57 7 95 0 9 179 1 57 MEI8280745.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase [Bacteroidota bacterium] diamond 1368 105 0.990476190476191 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28543173 28543173 PRJNA1008049_S_NODE_5147_length_150_cov_12.438017_g5129_i0 PRJNA1008049 5147 150 12.438017 18.6570255 Bacteroidota 976 Bacteria Bacteria 60.8 2.9e-9   NR HTE12334.1 1869212 g5129 i0 58.1 5.54 43 18 86 0 130 2 4 46 HTE12334.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Chitinophagaceae bacterium] diamond 831 60.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29024415 29024415 PRJNA1008049_S_NODE_1468_length_192_cov_17.239264_g1450_i0 PRJNA1008049 1468 192 17.239264 33.09938688 Flavobacterium sp. 27 239 Bacteria Bacteria 54.7 2.91e-8   NR WP_134148188.1 2512114 g1450 i0 100 0.828125 27 0 42.2 0 190 110 19 45 WP_134148188.1 rSAM-modified peptide [Flavobacterium sp. 270] diamond 159 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
29781768 29781768 PRJNA1008049_S_NODE_2111_length_179_cov_6.220000_g2093_i0 PRJNA1008049 2111 179 6.22 11.1338 Lutibacter sp. 1925666 Bacteria Bacteria 70.9 4.97e-13   NR MFA5300317.1 1925666 g2093 i0 55.7 3.03351955307263 61 25 98.9 1 179 3 132 192 MFA5300317.1 hypothetical protein [Lutibacter sp.] diamond 543 70.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Lutibacter Lutibacter sp.
29781769 29781769 PRJNA1008049_S_NODE_3211_length_166_cov_6.167883_g3193_i0 PRJNA1008049 3211 166 6.167883 10.23868578 Flavobacterium sp. 27 239 Bacteria Bacteria 112 1.01e-29   NR WP_134145436.1 2512114 g3193 i0 98.2 0.993975903614458 55 1 99.4 0 1 165 119 173 WP_134145436.1 Crp/Fnr family transcriptional regulator [Flavobacterium sp. 270] diamond 165 112 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
30382473 30382473 PRJNA1008049_S_NODE_3693_length_161_cov_7.810606_g3675_i0 PRJNA1008049 3693 161 7.810606 12.57507566 Flavobacterium sp. 27 239 Bacteria Bacteria 103 4.15e-27   NR TDW46491.1 2512114 g3675 i0 100 1.97515527950311 53 0 98.8 0 161 3 15 67 TDW46491.1 four helix bundle protein [Flavobacterium sp. 270] diamond 318 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270

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