RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA358049", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Campylobacterota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358049 · 13 ✖

analysis 1

tax_clade 0

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
398471 398471 PRJNA358049_S_NODE_11381_length_193_cov_2.166667_g11333_i0 PRJNA358049 11381 193 2.166667 4.18166731 Campylobacter showae 204 Bacteria Bacteria 307 3.2200000000000003e-79   NTclustered gi|1483583565|emb|LT631545.1| 204 g11333 i0 95.337 12 193 9 100 0 1 193 1356178 1356370 Campylobacter showae strain B32_SW genome assembly, chromosome: I blastn 2316 307 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
1073176 1073176 PRJNA358049_S_NODE_8261_length_219_cov_1.647059_g8213_i0 PRJNA358049 8261 219 1.647059 3.60705921 Campylobacter 194 Bacteria Bacteria 399 6.009999999999999e-107   NTclustered gi|1207769201|gb|MF351714.1| 199 g8213 i0 99.543 232.301369863014 219 1 100 0 1 219 1079 1297 Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence blastn 50874 399 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
1673481 1673481 PRJNA358049_S_NODE_6482_length_243_cov_1.329897_g6434_i0 PRJNA358049 6482 243 1.329897 3.23164971 Campylobacter concisus 199 Bacteria Bacteria 416 6.739999999999998e-112   NTclustered gi|1376251231|gb|CP021642.1| 199 g6434 i0 97.531 8.9917695473251 243 6 100 0 1 243 865491 865733 Campylobacter concisus strain P2CDO4 chromosome, complete genome blastn 2185 416 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
6176146 6176146 PRJNA358049_S_NODE_3245_length_331_cov_1.187943_g3197_i0 PRJNA358049 3245 331 1.187943 3.93209133 Campylobacter 194 Bacteria Bacteria 612 1.14e-170   NTclustered gi|1935888393|gb|CP049239.1| 199 g3197 i0 100 69.8942598187311 331 0 100 0 1 331 1703957 1703627 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 23135 612 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
9326593 9326593 PRJNA358049_S_NODE_13368_length_182_cov_1.819549_g13320_i0 PRJNA358049 13368 182 1.819549 3.31157918 Campylobacter concisus 199 Bacteria Bacteria 331 1.7800000000000002e-86   NTclustered gi|1207769203|gb|MF351716.1| 199 g13320 i0 99.451 246.543956043956 182 1 100 0 1 182 464 283 Campylobacter concisus strain H9O-S1 23S ribosomal RNA gene, partial sequence blastn 44871 331 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
13152537 13152537 PRJNA358049_S_NODE_8271_length_219_cov_1.464706_g8223_i0 PRJNA358049 8271 219 1.464706 3.20770614 Campylobacter concisus 199 Bacteria Bacteria 399 6.009999999999999e-107   NTclustered gi|1938715890|gb|CP049263.1| 199 g8223 i0 99.543 27.8264840182648 219 1 100 0 1 219 455929 455711 Campylobacter concisus strain H16O-S1 chromosome, complete genome blastn 6094 399 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
17650721 17650721 PRJNA358049_S_NODE_11614_length_192_cov_1.818182_g11566_i0 PRJNA358049 11614 192 1.818182 3.49090944 Campylobacter 194 Bacteria Bacteria 355 1.13e-93   NTclustered gi|1207769205|gb|MF351718.1| 199 g11566 i0 100 249 192 0 100 0 1 192 907 1098 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 47808 355 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
17650758 17650758 PRJNA358049_S_NODE_2714_length_360_cov_8.241158_g2666_i0 PRJNA358049 2714 360 8.241158 29.6681688 Campylobacter 194 Bacteria Bacteria 623 5.759999999999999e-174   NTclustered gi|1207769205|gb|MF351718.1| 199 g2666 i0 100 231.697222222222 337 0 94 0 24 360 1 337 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 83411 623 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
18250270 18250270 PRJNA358049_S_NODE_18175_length_163_cov_0.912281_g18127_i0 PRJNA358049 18175 163 0.912281 1.48701803 Campylobacter concisus 199 Bacteria Bacteria 302 1.22e-77   NTclustered gi|1938715890|gb|CP049263.1| 199 g18127 i0 100 12.840490797546 163 0 100 0 1 163 1594080 1594242 Campylobacter concisus strain H16O-S1 chromosome, complete genome blastn 2093 302 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
22749965 22749965 PRJNA358049_S_NODE_3058_length_340_cov_2.068729_g3010_i0 PRJNA358049 3058 340 2.068729 7.0336786 Campylobacter 194 Bacteria Bacteria 597 3.289999999999999e-166   NTclustered gi|1483583529|emb|LT631453.1| 204 g3010 i0 99.693 101.361764705882 326 1 96 0 15 340 393452 393127 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 34463 603 0.990049751243781 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
24024857 24024857 PRJNA358049_S_NODE_13159_length_183_cov_1.828358_g13111_i0 PRJNA358049 13159 183 1.828358 3.34589514 Campylobacter 194 Bacteria Bacteria 333 4.97e-87   NTclustered gi|1207769205|gb|MF351718.1| 199 g13111 i0 99.454 234.562841530055 183 1 100 0 1 183 717 899 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 42925 333 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
24624744 24624744 PRJNA358049_S_NODE_14660_length_175_cov_1.523810_g14612_i0 PRJNA358049 14660 175 1.52381 2.6666675 Campylobacter concisus 199 Bacteria Bacteria 285 1.3399999999999998e-72   NTclustered gi|1935893765|gb|CP049234.1| 199 g14612 i0 96 31.2285714285714 175 7 100 0 1 175 480739 480565 Campylobacter concisus strain P15UCO-S2 chromosome, complete genome blastn 5465 285 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
25299346 25299346 PRJNA358049_S_NODE_8460_length_217_cov_1.482143_g8412_i0 PRJNA358049 8460 217 1.482143 3.21625031 Campylobacter 194 Bacteria Bacteria 396 7.689999999999997e-106   NTclustered gi|1938726479|gb|CP049270.1| 199 g8412 i0 99.539 230.013824884793 217 1 100 0 1 217 1054277 1054493 Campylobacter concisus strain P26UCO-S2 chromosome, complete genome blastn 49913 396 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus

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