contig_metadata
12 rows where bioproject = "PRJNA414036", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418751 | 418751 | PRJNA414036_P_NODE_38701_length_237_cov_1.811881_g36962_i0 | PRJNA414036 | 38701 | 237 | 1.811881 | 4.29415797 | Campylobacter sp. RM16704 | 1500960 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|744807575|gb|CP007769.1| | 1500960 | g36962 | i0 | 92.105 | 0.160337552742616 | 38 | 3 | 16 | 0 | 195 | 232 | 204249 | 204212 | Campylobacter sp. RM16704 chromosome, complete genome | blastn | 38 | 54.7 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter sp. RM16704 | ||
| 2969420 | 2969420 | PRJNA414036_P_NODE_26943_length_290_cov_10.250980_g25208_i0 | PRJNA414036 | 26943 | 290 | 10.25098 | 29.727842 | Candidatus Thiovulum stygium | 2951083 | Bacteria | Bacteria | 154 | 7.160000000000001e-33 | NTclustered | gi|2182967327|gb|CP091137.1| | 2951083 | g25208 | i0 | 81.868 | 132.068965517241 | 182 | 33 | 63 | 0 | 1 | 182 | 564567 | 564386 | MAG: Candidatus Thiovulum stygium isolate 07-Movile_MetG_Ill chromosome, complete genome | blastn | 38300 | 154 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Sulfurimonadaceae | Thiovulum | Candidatus Thiovulum stygium | ||
| 2969450 | 2969450 | PRJNA414036_P_NODE_34903_length_251_cov_6.875000_g33167_i0 | PRJNA414036 | 34903 | 251 | 6.875 | 17.25625 | Campylobacter jejuni | 197 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|1829615825|gb|CP048760.1| | 197 | g33167 | i0 | 96.875 | 0.127490039840637 | 32 | 0 | 13 | 1 | 98 | 129 | 777635 | 777605 | Campylobacter jejuni strain ZS005 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter jejuni | ||
| 2969588 | 2969588 | PRJNA414036_P_NODE_88103_length_151_cov_3.387931_g86364_i0 | PRJNA414036 | 88103 | 151 | 3.387931 | 5.11577581 | Helicobacter bizzozeronii | 56877 | Bacteria | Bacteria | 52.8 | 0.012 | NTclustered | gi|335332259|emb|FR871757.1| | 1002804 | g86364 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 72 | 99 | 519604 | 519631 | Helicobacter bizzozeronii CIII-1 main chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter bizzozeronii | ||
| 10010927 | 10010927 | PRJNA414036_P_NODE_1548_length_668_cov_10.505529_g1231_i0 | PRJNA414036 | 1548 | 668 | 10.505529 | 70.17693372 | Campylobacter | 194 | Bacteria | Bacteria | 241 | 1.32e-58 | NTclustered | gi|1883582428|gb|CP059437.1| | 196 | g1231 | i0 | 88.177 | 119.053892215569 | 203 | 23 | 42 | 1 | 261 | 462 | 135969 | 136171 | Campylobacter fetus strain CFViADRI545 chromosome, complete genome | blastn | 79528 | 241 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter fetus | ||
| 12561709 | 12561709 | PRJNA414036_P_NODE_7610_length_469_cov_14.278802_g6327_i0 | PRJNA414036 | 7610 | 469 | 14.278802 | 66.96758138 | Campylobacter | 194 | Bacteria | Bacteria | 252 | 4.1899999999999995e-62 | NTclustered | gi|1883582428|gb|CP059437.1| | 196 | g6327 | i0 | 83.895 | 192.865671641791 | 267 | 40 | 74 | 3 | 196 | 460 | 136171 | 135906 | Campylobacter fetus strain CFViADRI545 chromosome, complete genome | blastn | 90454 | 252 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter fetus | ||
| 13836312 | 13836312 | PRJNA414036_P_NODE_14031_length_390_cov_12.338028_g12375_i0 | PRJNA414036 | 14031 | 390 | 12.338028 | 48.1183092 | Campylobacter | 194 | Bacteria | Bacteria | 364 | 4.219999999999998e-96 | NTclustered | gi|1861376917|gb|CP053828.1| | 91353 | g12375 | i0 | 88.818 | 244.725641025641 | 313 | 13 | 95 | 3 | 75 | 386 | 361261 | 360970 | Campylobacter hyointestinalis subsp. lawsonii strain CHY5 chromosome, complete genome | blastn | 95443 | 364 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter hyointestinalis | ||
| 20209075 | 20209075 | PRJNA414036_P_NODE_31316_length_267_cov_9.064655_g29580_i0 | PRJNA414036 | 31316 | 267 | 9.064655 | 24.20262885 | Campylobacter | 194 | Bacteria | Bacteria | 189 | 1.78e-43 | NTclustered | gi|1883582428|gb|CP059437.1| | 196 | g29580 | i0 | 99.048 | 156.176029962547 | 105 | 1 | 39 | 0 | 10 | 114 | 136884 | 136780 | Campylobacter fetus strain CFViADRI545 chromosome, complete genome | blastn | 41699 | 189 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter fetus | ||
| 24034726 | 24034726 | PRJNA414036_P_NODE_71119_length_180_cov_8.013793_g69380_i0 | PRJNA414036 | 71119 | 180 | 8.013793 | 14.4248274 | Campylobacter | 194 | Bacteria | Bacteria | 172 | 1.1199999999999999e-38 | NTclustered | gi|1207769205|gb|MF351718.1| | 199 | g69380 | i0 | 100 | 134.188888888889 | 93 | 0 | 52 | 0 | 80 | 172 | 1694 | 1786 | Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence | blastn | 24154 | 172 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter concisus | ||
| 25309065 | 25309065 | PRJNA414036_P_NODE_36940_length_243_cov_3.620192_g35204_i0 | PRJNA414036 | 36940 | 243 | 3.620192 | 8.79706656 | Campylobacter | 194 | Bacteria | Bacteria | 145 | 3.51e-30 | NTclustered | gi|2323232558|gb|CP109813.1| | 195 | g35204 | i0 | 100 | 74.4691358024691 | 78 | 0 | 32 | 0 | 10 | 87 | 43247 | 43324 | Campylobacter coli strain CC20JX12 chromosome, complete genome | blastn | 18096 | 145 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Campylobacteraceae | Campylobacter | Campylobacter coli | ||
| 28243933 | 28243933 | PRJNA414036_P_NODE_42866_length_231_cov_4.066327_g41127_i0 | PRJNA414036 | 42866 | 231 | 4.066327 | 9.39321537 | Helicobacter pylori | 210 | Bacteria | Bacteria | 42.4 | 0.00385 | NR | GAA9259198.1 | 210 | g41127 | i0 | 79.2 | 0.311688311688312 | 24 | 5 | 31.2 | 0 | 158 | 229 | 14 | 37 | GAA9259198.1 hypothetical protein Kyoto199A_4160 [Helicobacter pylori] | diamond | 72 | 42.4 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter pylori | ||
| 32636036 | 32636036 | PRJNA414036_P_NODE_77840_length_166_cov_147.541985_g76101_i0 | PRJNA414036 | 77840 | 166 | 147.541985 | 244.9196951 | Helicobacter felis ATCC 49179 | 936155 | Bacteria | Bacteria | 83.6 | 9.07e-19 | NR | CBY83691.1 | 936155 | g76101 | i0 | 74.5 | 0.921686746987952 | 51 | 13 | 92.2 | 0 | 13 | 165 | 53 | 103 | CBY83691.1 putative uncharacterized protein [Helicobacter felis ATCC 49179] | diamond | 153 | 83.6 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter felis |
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);;