contig_metadata
11 rows where bioproject = "PRJEB2368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22875 | 22875 | PRJEB2368_P_NODE_10601_length_287_cov_1.084000_g10283_i0 | PRJEB2368 | 10601 | 287 | 1.084 | 3.11108 | Arcobacter suis | 1278212 | Bacteria | Bacteria | 141 | 5.510000000000001e-29 | NTclustered | gi|1474790806|gb|CP032100.1| | 663365 | g10283 | i0 | 100 | 1.46689895470383 | 76 | 0 | 53 | 0 | 212 | 287 | 804360 | 804285 | Arcobacter suis CECT 7833 chromosome, complete genome | blastn | 421 | 141 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Arcobacter | Arcobacter suis | ||
| 2261698 | 2261698 | PRJEB2368_P_NODE_9782_length_287_cov_1.360000_g9464_i0 | PRJEB2368 | 9782 | 287 | 1.36 | 3.9032 | Aliarcobacter | 2321111 | Bacteria | Bacteria | 141 | 5.510000000000001e-29 | NTclustered | gi|1534011987|gb|CP034309.1| | 28200 | g9464 | i0 | 100 | 1.05923344947735 | 76 | 0 | 53 | 0 | 1 | 76 | 71965 | 71890 | Aliarcobacter skirrowii strain A2S6 chromosome, complete genome | blastn | 304 | 141 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter skirrowii | ||
| 5125288 | 5125288 | PRJEB2368_P_NODE_10545_length_287_cov_1.156000_g10227_i0 | PRJEB2368 | 10545 | 287 | 1.156 | 3.31772 | Campylobacter sp. RM5004 | 1660078 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2198378962|gb|CP059599.1| | 1660078 | g10227 | i0 | 96.774 | 0.10801393728223 | 31 | 1 | 11 | 0 | 247 | 277 | 1474530 | 1474500 | Campylobacter sp. RM5004 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter sp. RM5004 | ||
| 7364088 | 7364088 | PRJEB2368_P_NODE_9946_length_287_cov_1.328000_g9628_i0 | PRJEB2368 | 9946 | 287 | 1.328 | 3.81136 | Aliarcobacter | 2321111 | Bacteria | Bacteria | 141 | 5.510000000000001e-29 | NTclustered | gi|1898123824|gb|CP060693.1| | 28198 | g9628 | i0 | 100 | 14.2264808362369 | 76 | 0 | 53 | 0 | 1 | 76 | 897511 | 897586 | Aliarcobacter cryaerophilus strain 16CS1285-4 chromosome, complete genome | blastn | 4083 | 141 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter cryaerophilus | ||
| 9914434 | 9914434 | PRJEB2368_P_NODE_14608_length_162_cov_1.872000_g14289_i0 | PRJEB2368 | 14608 | 162 | 1.872 | 3.03264 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 300 | 4.36e-77 | NTclustered | gi|1226876681|gb|CP022559.1| | 197 | g14289 | i0 | 100 | 100 | 162 | 0 | 100 | 0 | 1 | 162 | 701280 | 701119 | Campylobacter jejuni strain 11168H/araE chromosome, complete genome | blastn | 16200 | 300 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter jejuni | ||
| 11500914 | 11500914 | PRJEB2368_P_NODE_11010_length_286_cov_1.425703_g10692_i0 | PRJEB2368 | 11010 | 286 | 1.425703 | 4.07751058 | Aliarcobacter cryaerophilus | 28198 | Bacteria | Bacteria | 132 | 3.3e-26 | NTclustered | gi|2317587505|gb|CP099556.1| | 28198 | g10692 | i0 | 98.649 | 7.26573426573427 | 74 | 1 | 26 | 0 | 212 | 285 | 1947456 | 1947383 | Aliarcobacter cryaerophilus strain ICDCAC48 chromosome, complete genome | blastn | 2078 | 132 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter cryaerophilus | ||
| 12465346 | 12465346 | PRJEB2368_P_NODE_10050_length_287_cov_1.312000_g9732_i0 | PRJEB2368 | 10050 | 287 | 1.312 | 3.76544 | Bacteria | 2 | Bacteria | Bacteria | 67.6 | 9.48e-7 | NTclustered | gi|1666442357|gb|CP040463.1| | 391592 | g9732 | i0 | 93.333 | 0.43205574912892 | 45 | 3 | 16 | 0 | 2 | 46 | 1071961 | 1071917 | Caminibacter mediatlanticus TB-2 chromosome, complete genome | blastn | 124 | 67.6 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Nautiliales | Nautiliaceae | Caminibacter | Caminibacter mediatlanticus | ||
| 16289086 | 16289086 | PRJEB2368_P_NODE_9313_length_287_cov_1.428000_g8995_i0 | PRJEB2368 | 9313 | 287 | 1.428 | 4.09836 | Aliarcobacter | 2321111 | Bacteria | Bacteria | 141 | 5.510000000000001e-29 | NTclustered | gi|1898125941|gb|CP060694.1| | 28198 | g8995 | i0 | 100 | 8.93728222996516 | 76 | 0 | 26 | 0 | 1 | 76 | 5258 | 5333 | Aliarcobacter cryaerophilus strain 16CS1292-4 chromosome, complete genome | blastn | 2565 | 141 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter cryaerophilus | ||
| 20112926 | 20112926 | PRJEB2368_P_NODE_9496_length_287_cov_1.400000_g9178_i0 | PRJEB2368 | 9496 | 287 | 1.4 | 4.018 | Aliarcobacter | 2321111 | Bacteria | Bacteria | 108 | 5.58e-19 | NTclustered | gi|1231709647|emb|LT906455.1| | 28197 | g9178 | i0 | 92.105 | 5.16376306620209 | 76 | 6 | 26 | 0 | 1 | 76 | 293460 | 293385 | Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 | blastn | 1482 | 108 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter butzleri | ||
| 24248756 | 24248756 | PRJEB2368_P_NODE_8920_length_287_cov_1.496000_g8602_i0 | PRJEB2368 | 8920 | 287 | 1.496 | 4.29352 | Arcobacter aquimarinus | 1315211 | Bacteria | Bacteria | 69.4 | 2.64e-7 | NTclustered | gi|1845961186|gb|CP030944.1| | 1315211 | g8602 | i0 | 82.895 | 0.797909407665505 | 76 | 13 | 26 | 0 | 212 | 287 | 2261899 | 2261974 | Arcobacter aquimarinus strain W63 chromosome, complete genome | blastn | 229 | 69.4 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Arcobacter | Arcobacter aquimarinus | ||
| 26716202 | 26716202 | PRJEB2368_P_NODE_4681_length_359_cov_2.006211_g4367_i0 | PRJEB2368 | 4681 | 359 | 2.006211 | 7.20229749 | Helicobacter pylori | 210 | Bacteria | Bacteria | 60.8 | 1.4e-9 | NR | GAA8732559.1 | 210 | g4367 | i0 | 93.1 | 0.242339832869081 | 29 | 2 | 24.2 | 0 | 272 | 358 | 1 | 29 | GAA8732559.1 hypothetical protein Kyoto147A_0770 [Helicobacter pylori] | diamond | 87 | 60.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter pylori |
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);;