contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA631796" and tax_phylum = "Campylobacterota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4431141 | 4431141 | PRJNA631796_P_NODE_9304_length_225_cov_1.560976_g9026_i0 | PRJNA631796 | 9304 | 225 | 1.560976 | 3.512196 | uncultured Arcobacter sp. | 165434 | Bacteria | Bacteria | 128 | 3.23e-25 | NTclustered | gi|682122801|gb|KJ739652.1| | 165434 | g9026 | i0 | 87.611 | 67.6577777777778 | 113 | 10 | 49 | 3 | 1 | 111 | 116 | 6 | Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence | blastn | 15223 | 128 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Arcobacter | uncultured Arcobacter sp. | ||
| 6255705 | 6255705 | PRJNA631796_P_NODE_6645_length_265_cov_2.063725_g6367_i0 | PRJNA631796 | 6645 | 265 | 2.063725 | 5.46887125 | Helicobacter | 209 | Bacteria | Bacteria | 490 | 4.3299999999999986e-134 | NTclustered | gi|50957175|gb|AY596260.1| | 213 | g6367 | i0 | 100 | 120.796226415094 | 265 | 0 | 100 | 0 | 1 | 265 | 1629 | 1365 | Helicobacter cinaedi strain CCUG 33804 23S ribosomal RNA gene, partial sequence | blastn | 32011 | 490 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter cinaedi | ||
| 15180424 | 15180424 | PRJNA631796_P_NODE_7952_length_240_cov_4.167598_g7674_i0 | PRJNA631796 | 7952 | 240 | 4.167598 | 10.0022352 | Campylobacter | 194 | Bacteria | Bacteria | 401 | 1.8599999999999994e-107 | NTclustered | gi|1207769205|gb|MF351718.1| | 199 | g7674 | i0 | 99.545 | 204.3125 | 220 | 1 | 92 | 0 | 21 | 240 | 1869 | 1650 | Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence | blastn | 49035 | 401 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter concisus | ||
| 15906196 | 15906196 | PRJNA631796_P_NODE_11713_length_206_cov_1.324138_g11435_i0 | PRJNA631796 | 11713 | 206 | 1.324138 | 2.72772428 | Campylobacter sp. CCS1377 | 3158229 | Bacteria | Bacteria | 167 | 6.159999999999999e-37 | NTclustered | gi|2738339955|gb|CP155620.1| | 3158229 | g11435 | i0 | 85.185 | 95.4563106796116 | 162 | 24 | 79 | 0 | 4 | 165 | 119648 | 119809 | Campylobacter sp. CCS1377 chromosome, complete genome | blastn | 19664 | 167 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter sp. CCS1377 | ||
| 15906235 | 15906235 | PRJNA631796_P_NODE_4473_length_327_cov_3.424812_g4195_i0 | PRJNA631796 | 4473 | 327 | 3.424812 | 11.19913524 | Helicobacter pylori | 210 | Bacteria | Bacteria | 71.3 | 8.49e-8 | NTclustered | gi|2222028449|gb|CP094103.1| | 210 | g4195 | i0 | 100 | 13.1162079510703 | 38 | 0 | 12 | 0 | 290 | 327 | 1292723 | 1292686 | Helicobacter pylori strain Hpfe077 chromosome, complete genome | blastn | 4289 | 71.3 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter pylori | ||
| 21005783 | 21005783 | PRJNA631796_P_NODE_14417_length_169_cov_4.351852_g14139_i0 | PRJNA631796 | 14417 | 169 | 4.351852 | 7.35462988 | Campylobacter gracilis | 824 | Bacteria | Bacteria | 307 | 2.73e-79 | NTclustered | gi|909717139|gb|CP012196.1| | 824 | g14139 | i0 | 99.408 | 254.639053254438 | 169 | 1 | 100 | 0 | 1 | 169 | 500657 | 500489 | Campylobacter gracilis strain ATCC 33236, complete genome | blastn | 43034 | 307 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter gracilis | ||
| 22829454 | 22829454 | PRJNA631796_P_NODE_13618_length_194_cov_4.255639_g13340_i0 | PRJNA631796 | 13618 | 194 | 4.255639 | 8.25593966 | Campylobacter | 194 | Bacteria | Bacteria | 353 | 4.1e-93 | NTclustered | gi|1207769205|gb|MF351718.1| | 199 | g13340 | i0 | 99.485 | 231.365979381443 | 194 | 1 | 100 | 0 | 1 | 194 | 704 | 897 | Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence | blastn | 44885 | 353 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter concisus | ||
| 22829461 | 22829461 | PRJNA631796_P_NODE_2938_length_410_cov_6.673352_g2661_i0 | PRJNA631796 | 2938 | 410 | 6.673352 | 27.3607432 | Campylobacter | 194 | Bacteria | Bacteria | 752 | 0 | NTclustered | gi|1935888393|gb|CP049239.1| | 199 | g2661 | i0 | 99.756 | 236.407317073171 | 410 | 1 | 100 | 0 | 1 | 410 | 1033143 | 1032734 | Campylobacter concisus strain P3UCO1 chromosome, complete genome | blastn | 96927 | 752 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter concisus |
Advanced export
JSON shape: default, array, newline-delimited
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);;