RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB6097" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB6097 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
125575 125575 PRJEB6097_S_NODE_281_length_463_cov_26976.037383_g227_i0 PRJEB6097 281 463 26976.037383 124899.05308329 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 142 1.1999999999999999e-39   NR WP_095160867.1 1509483 g227 i0 100 0.505399568034557 78 0 50.5 0 461 228 125 202 WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569] diamond 234 142 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
27602509 27602509 PRJEB6097_S_NODE_6284_length_164_cov_1.821705_g6230_i0 PRJEB6097 6284 164 1.821705 2.9875962 Bacteroidota 976 Bacteria Bacteria 96.7 6.45e-25   NR WP_095162445.1 976 g6230 i0 100 0.878048780487805 48 0 87.8 0 144 1 1 48 WP_095162445.1 MULTISPECIES: histone H1 [Bacteroidota] diamond 144 96.7 1 Bacteria FCB group Pseudomonadati Bacteroidota          
28044338 28044338 PRJEB6097_S_NODE_1245_length_343_cov_2.038961_g1191_i0 PRJEB6097 1245 343 2.038961 6.99363623 Flectobacillus longus 2984207 Bacteria Bacteria 180 3.79e-54   NR WP_283369909.1 2984207 g1191 i0 95.5 0.962099125364432 110 5 96.2 0 2 331 161 270 WP_283369909.1 30S ribosomal protein S2 [Flectobacillus longus] diamond 330 180 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus longus
28170655 28170655 PRJEB6097_S_NODE_6226_length_166_cov_1.610687_g6172_i0 PRJEB6097 6226 166 1.610687 2.67374042 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 99.4 1.19e-22   NR WP_095165358.1 1509483 g6172 i0 94.5 0.993975903614458 55 3 99.4 0 166 2 270 324 WP_095165358.1 tetratricopeptide repeat protein [Flectobacillus sp. BAB-3569] diamond 165 99.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
29805613 29805613 PRJEB6097_S_NODE_5931_length_177_cov_1.866197_g5877_i0 PRJEB6097 5931 177 1.866197 3.30316869 Bacteroidota 976 Bacteria Bacteria 57.8 7.87e-8   NR WP_166549688.1 2683263 g5877 i0 74.6 2 59 15 100 0 1 177 178 236 WP_166549688.1 translation initiation factor IF-2 [Cellulophaga sp. BC115SP] diamond 354 57.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
30823526 30823526 PRJEB6097_S_NODE_5954_length_176_cov_1.716312_g5900_i0 PRJEB6097 5954 176 1.716312 3.02070912 Flectobacillus longus 2984207 Bacteria Bacteria 116 3.42e-30   NR WP_283371007.1 2984207 g5900 i0 100 0.988636363636364 58 0 98.9 0 174 1 112 169 WP_283371007.1 type I methionyl aminopeptidase [Flectobacillus longus] diamond 174 116 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus longus
30981691 30981691 PRJEB6097_S_NODE_5834_length_182_cov_2.170068_g5780_i0 PRJEB6097 5834 182 2.170068 3.94952376 Bacteroidota 976 Bacteria Bacteria 44.3 0.00331   NR WP_095160744.1 976 g5780 i0 100 0.32967032967033 20 0 33 0 182 123 166 185 WP_095160744.1 MULTISPECIES: 50S ribosomal protein L5 [Bacteroidota] diamond 60 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota          
31771947 31771947 PRJEB6097_S_NODE_5537_length_201_cov_5.126506_g5483_i0 PRJEB6097 5537 201 5.126506 10.30427706 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 89.4 1.7e-20   NR WP_166549596.1 2683263 g5483 i0 97.7 0.656716417910448 44 1 65.7 0 201 70 128 171 WP_166549596.1 ExbD/TolR family protein [Cellulophaga sp. BC115SP] diamond 132 89.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
31835068 31835068 PRJEB6097_S_NODE_5577_length_198_cov_2.208589_g5523_i0 PRJEB6097 5577 198 2.208589 4.37300622 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 132 2.709999999999999e-38   NR WP_092018866.1 1079859 g5523 i0 100 0.984848484848485 65 0 98.5 0 2 196 26 90 WP_092018866.1 30S ribosomal protein S6 [Pseudarcicella hirudinis] diamond 195 132 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis
32088364 32088364 PRJEB6097_S_NODE_6458_length_159_cov_1.258065_g6404_i0 PRJEB6097 6458 159 1.258065 2.00032335 Flectobacillus longus 2984207 Bacteria Bacteria 77.8 6.61e-17   NR WP_283325609.1 2984207 g6404 i0 100 0.849056603773585 45 0 84.9 0 137 3 1 45 WP_283325609.1 hypothetical protein [Flectobacillus longus] diamond 135 77.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus longus
32215027 32215027 PRJEB6097_S_NODE_6138_length_169_cov_1.194030_g6084_i0 PRJEB6097 6138 169 1.19403 2.0179107 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 99 6.399999999999999e-24   NR SFP43801.1 1079859 g6084 i0 100 0.994082840236686 56 0 99.4 0 1 168 81 136 SFP43801.1 large subunit ribosomal protein L27 [Pseudarcicella hirudinis] diamond 168 99 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis

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