RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA931595" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA931595 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
13663280 13663280 PRJNA931595_P_NODE_15671_length_240_cov_2.724551_g15562_i0 PRJNA931595 15671 240 2.724551 6.5389224 Flavisolibacter sp. 1954249 Bacteria Bacteria 143 1.25e-37   NR HWI91994.1 1954249 g15562 i0 87.2 1.95 78 10 97.5 0 2 235 266 343 HWI91994.1 leucine--tRNA ligase [Flavisolibacter sp.] diamond 468 143 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter sp.
21311730 21311730 PRJNA931595_P_NODE_15657_length_241_cov_0.880952_g15548_i0 PRJNA931595 15657 241 0.880952 2.12309432 Kaistella haifensis 421525 Bacteria Bacteria 142 7.36e-38   NR ROI03799.1 421525 g15548 i0 83.5 1.96680497925311 79 13 98.3 0 3 239 6 84 ROI03799.1 glycosyltransferase [Kaistella haifensis] diamond 474 142 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Kaistella Kaistella haifensis
25136030 25136030 PRJNA931595_P_NODE_8800_length_283_cov_1.214286_g8691_i0 PRJNA931595 8800 283 1.214286 3.43642938 Bacteroidales bacterium 2030927 Bacteria Bacteria 197 2.04e-56   NR MBS7358709.1 2030927 g8691 i0 100 0.996466431095406 94 0 99.6 0 283 2 32 125 MBS7358709.1 aminomethyl-transferring glycine dehydrogenase [Bacteroidales bacterium] diamond 282 197 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27056643 27056643 PRJNA931595_P_NODE_10782_length_265_cov_1.604167_g10673_i0 PRJNA931595 10782 265 1.604167 4.25104255 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 150 1.8799999999999994e-42   NR WP_092723107.1 1235997 g10673 i0 90.5 0.950943396226415 84 6 92.8 1 2 247 235 318 WP_092723107.1 aldose 1-epimerase [Hydrobacter penzbergensis] diamond 252 150 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
27846131 27846131 PRJNA931595_P_NODE_9724_length_275_cov_1.450495_g9615_i0 PRJNA931595 9724 275 1.450495 3.98886125 Chitinophaga sp. H8 3163343 Bacteria Bacteria 171 3.8e-53   NR WP_354664049.1 3163343 g9615 i0 86.8 1.98545454545455 91 12 99.3 0 2 274 20 110 WP_354664049.1 hypothetical protein [Chitinophaga defluvii] diamond 546 171 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga defluvii
28983162 28983162 PRJNA931595_P_NODE_10488_length_268_cov_1.528205_g10379_i0 PRJNA931595 10488 268 1.528205 4.0955894 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 154 1.15e-43   NR HRE37100.1 1869212 g10379 i0 89.9 0.996268656716418 89 9 99.6 0 2 268 231 319 HRE37100.1 DNA replication and repair protein RecF [Chitinophagaceae bacterium] diamond 267 154 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29330200 29330200 PRJNA931595_P_NODE_14929_length_243_cov_0.905882_g14820_i0 PRJNA931595 14929 243 0.905882 2.20129326 Flavisolibacter sp. 1954249 Bacteria Bacteria 149 6.51e-42   NR MBD0376655.1 1954249 g14820 i0 95.1 1 81 4 100 0 243 1 179 259 MBD0376655.1 IS110 family transposase [Flavisolibacter sp.] diamond 243 149 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Flavisolibacter Flavisolibacter sp.
32774659 32774659 PRJNA931595_P_NODE_15960_length_228_cov_2.032258_g15851_i0 PRJNA931595 15960 228 2.032258 4.63354824 Bacteroidota bacterium 1898104 Bacteria Bacteria 141 6.82e-38   NR MEY3115090.1 1898104 g15851 i0 98.7 1 76 1 100 0 228 1 72 147 MEY3115090.1 hypothetical protein [Bacteroidota bacterium] diamond 228 141 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium

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