contig_metadata
9 rows where bioproject = "PRJEB27957" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2573348 | 2573348 | PRJEB27957_P_NODE_80703_length_191_cov_1.098592_g80593_i0 | PRJEB27957 | 80703 | 191 | 1.098592 | 2.09831072 | Nitrosophilus labii | 2706014 | Bacteria | Bacteria | 54.7 | 0.005 | NTclustered | gi|1897228471|dbj|AP022826.1| | 2706014 | g80593 | i0 | 100 | 0.151832460732984 | 29 | 0 | 15 | 0 | 110 | 138 | 1397439 | 1397467 | Nitrosophilus labii HRV44 DNA, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Nautiliales | Nitratiruptoraceae | Nitrosophilus | Nitrosophilus labii | ||
| 4814654 | 4814654 | PRJEB27957_P_NODE_2924_length_644_cov_1.968067_g2837_i0 | PRJEB27957 | 2924 | 644 | 1.968067 | 12.67435148 | Campylobacter | 194 | Bacteria | Bacteria | 54.7 | 0.018 | NTclustered | gi|2151054173|gb|CP086658.1| | 195 | g2837 | i0 | 100 | 2.79192546583851 | 29 | 0 | 5 | 0 | 299 | 327 | 38408 | 38380 | Campylobacter coli strain P4581 plasmid pCC001, complete sequence | blastn | 1798 | 54.7 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter coli | ||
| 6401560 | 6401560 | PRJEB27957_P_NODE_88906_length_182_cov_1.954887_g88796_i0 | PRJEB27957 | 88906 | 182 | 1.954887 | 3.55789434 | Campylobacter canadensis | 449520 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|1845963639|gb|CP035946.1| | 449520 | g88796 | i0 | 100 | 0.153846153846154 | 28 | 0 | 15 | 0 | 44 | 71 | 549840 | 549813 | Campylobacter canadensis strain LMG 24001 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter canadensis | ||
| 7675656 | 7675656 | PRJEB27957_P_NODE_125287_length_162_cov_0.920354_g125177_i0 | PRJEB27957 | 125287 | 162 | 0.920354 | 1.49097348 | Aliarcobacter cryaerophilus | 28198 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2581873871|gb|CP134842.1| | 2933791 | g125177 | i0 | 100 | 0.537037037037037 | 29 | 0 | 18 | 0 | 122 | 150 | 1750831 | 1750859 | Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 65 chromosome, complete genome | blastn | 87 | 54.7 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter cryaerophilus | ||
| 8950396 | 8950396 | PRJEB27957_P_NODE_100648_length_171_cov_1.278689_g100538_i0 | PRJEB27957 | 100648 | 171 | 1.278689 | 2.18655819 | Arcobacteraceae bacterium | 2808971 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|2621701254|emb|OY759974.1| | 2808971 | g100538 | i0 | 100 | 0.327485380116959 | 28 | 0 | 16 | 0 | 52 | 79 | 112319 | 112346 | MAG: Arcobacteraceae bacterium isolate 2f960911-6b7a-430b-8fcb-36b605e4e712 genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Arcobacteraceae bacterium | |||
| 8950468 | 8950468 | PRJEB27957_P_NODE_81568_length_190_cov_1.106383_g81458_i0 | PRJEB27957 | 81568 | 190 | 1.106383 | 2.1021277 | Aliarcobacter cryaerophilus | 28198 | Bacteria | Bacteria | 63.9 | 7.54e-6 | NTclustered | gi|1491731269|gb|CP032825.1| | 1032071 | g81458 | i0 | 97.297 | 0.489473684210526 | 37 | 1 | 19 | 0 | 151 | 187 | 619644 | 619680 | Aliarcobacter cryaerophilus D2610 chromosome, complete genome | blastn | 93 | 63.9 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter cryaerophilus | ||
| 14051563 | 14051563 | PRJEB27957_P_NODE_72492_length_200_cov_1.324503_g72382_i0 | PRJEB27957 | 72492 | 200 | 1.324503 | 2.649006 | Aliarcobacter butzleri | 28197 | Bacteria | Bacteria | 52.8 | 0.017 | NTclustered | gi|526271239|gb|CP006615.1| | 1036172 | g72382 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 128 | 155 | 114763 | 114736 | Arcobacter butzleri 7h1h, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Aliarcobacter | Aliarcobacter butzleri | ||
| 25212966 | 25212966 | PRJEB27957_P_NODE_96660_length_175_cov_1.190476_g96550_i0 | PRJEB27957 | 96660 | 175 | 1.190476 | 2.083333 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52.8 | 0.015 | NTclustered | gi|1850313845|gb|CP054052.1| | 1904463 | g96550 | i0 | 100 | 0.32 | 28 | 0 | 16 | 0 | 119 | 146 | 1938947 | 1938920 | Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Arcobacteraceae | Poseidonibacter | Poseidonibacter lekithochrous | ||
| 28770054 | 28770054 | PRJEB27957_P_NODE_12767_length_387_cov_1.843195_g12657_i0 | PRJEB27957 | 12767 | 387 | 1.843195 | 7.13316465 | Hydrogenimonas thermophila | 223786 | Bacteria | Bacteria | 42.7 | 0.0479 | NR | WP_092913072.1 | 223786 | g12657 | i0 | 35.6 | 0.457364341085271 | 59 | 29 | 38.8 | 2 | 53 | 202 | 37 | 95 | WP_092913072.1 hypothetical protein [Hydrogenimonas thermophila] | diamond | 177 | 42.7 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Hydrogenimonadaceae | Hydrogenimonas | Hydrogenimonas thermophila |
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);;