contig_metadata
13 rows where bioproject = "PRJNA944406" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1259305 | 1259305 | PRJNA944406_P_NODE_11981_length_363_cov_2.124138_g11022_i0 | PRJNA944406 | 11981 | 363 | 2.124138 | 7.71062094 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 542 | 1.6799999999999999e-149 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g11022 | i0 | 93.664 | 510.699724517906 | 363 | 21 | 100 | 2 | 1 | 363 | 1603038 | 1602678 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 185384 | 542 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 11463319 | 11463319 | PRJNA944406_P_NODE_59569_length_254_cov_1.701657_g58610_i0 | PRJNA944406 | 59569 | 254 | 1.701657 | 4.32220878 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 228 | 3.569999999999999e-55 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g58610 | i0 | 83.333 | 78.7834645669291 | 258 | 32 | 99 | 8 | 1 | 252 | 1603202 | 1603454 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 20011 | 228 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 18776723 | 18776723 | PRJNA944406_P_NODE_78095_length_248_cov_0.880000_g77136_i0 | PRJNA944406 | 78095 | 248 | 0.88 | 2.1824 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 172 | 1.6499999999999999e-38 | NTclustered | gi|1858604176|gb|CP054675.1| | 2053306 | g77136 | i0 | 88.276 | 3.19758064516129 | 145 | 16 | 58 | 1 | 6 | 149 | 872997 | 873141 | Ignavibacteria bacterium isolate Ch128a chromosome, complete genome | blastn | 793 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26803676 | 26803676 | PRJNA944406_P_NODE_21481_length_290_cov_1.419355_g20522_i0 | PRJNA944406 | 21481 | 290 | 1.419355 | 4.1161295 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 51.6 | 3.75e-5 | NR | MCU0373539.1 | 2053306 | g20522 | i0 | 37.2 | 0.806896551724138 | 78 | 43 | 80.7 | 2 | 26 | 259 | 162 | 233 | MCU0373539.1 30S ribosomal protein S2 [Ignavibacteria bacterium] | diamond | 234 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28225278 | 28225278 | PRJNA944406_P_NODE_53126_length_260_cov_1.647059_g52167_i0 | PRJNA944406 | 53126 | 260 | 1.647059 | 4.2823534 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 148 | 1.28e-39 | NR | MEO8664037.1 | 2053306 | g52167 | i0 | 86 | 0.992307692307692 | 86 | 12 | 99.2 | 0 | 1 | 258 | 315 | 400 | MEO8664037.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 258 | 148 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28572770 | 28572770 | PRJNA944406_P_NODE_111587_length_234_cov_2.850932_g110628_i0 | PRJNA944406 | 111587 | 234 | 2.850932 | 6.67118088 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 84.7 | 5.77e-18 | NR | MCJ7552770.1 | 2651163 | g110628 | i0 | 51.9 | 0.987179487179487 | 77 | 37 | 98.7 | 0 | 232 | 2 | 96 | 172 | MCJ7552770.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 231 | 84.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28699293 | 28699293 | PRJNA944406_P_NODE_35827_length_276_cov_1.901478_g34868_i0 | PRJNA944406 | 35827 | 276 | 1.901478 | 5.24807928 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 68.6 | 4.43e-11 | NR | HMQ69905.1 | 2053306 | g34868 | i0 | 41.1 | 0.978260869565217 | 90 | 53 | 97.8 | 0 | 275 | 6 | 154 | 243 | HMQ69905.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 270 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29614439 | 29614439 | PRJNA944406_P_NODE_43410_length_269_cov_1.571429_g42451_i0 | PRJNA944406 | 43410 | 269 | 1.571429 | 4.22714401 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 156 | 5.059999999999999e-46 | NR | MBK8553790.1 | 2053306 | g42451 | i0 | 81.3 | 1.01486988847584 | 91 | 15 | 99.3 | 1 | 1 | 267 | 20 | 110 | MBK8553790.1 prolyl oligopeptidase family serine peptidase [Ignavibacteria bacterium] | diamond | 273 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30025467 | 30025467 | PRJNA944406_P_NODE_105911_length_242_cov_0.881657_g104952_i0 | PRJNA944406 | 105911 | 242 | 0.881657 | 2.13360994 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 110 | 2.1e-27 | NR | MBK7447378.1 | 2053306 | g104952 | i0 | 57.5 | 0.991735537190083 | 80 | 34 | 99.2 | 0 | 2 | 241 | 49 | 128 | MBK7447378.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 240 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30253509 | 30253509 | PRJNA944406_P_NODE_27872_length_284_cov_1.350711_g26913_i0 | PRJNA944406 | 27872 | 284 | 1.350711 | 3.83601924 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 119 | 1.8099999999999997e-30 | NR | MFA5806261.1 | 2614255 | g26913 | i0 | 60.7 | 1.77464788732394 | 84 | 33 | 88.7 | 0 | 31 | 282 | 198 | 281 | MFA5806261.1 nuclear transport factor 2 family protein [Melioribacteraceae bacterium] | diamond | 504 | 120 | 0.991666666666667 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 30348586 | 30348586 | PRJNA944406_P_NODE_42552_length_270_cov_1.553299_g41593_i0 | PRJNA944406 | 42552 | 270 | 1.553299 | 4.1939073 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.1 | 0.00789 | NR | NLT50973.1 | 2053306 | g41593 | i0 | 47.6 | 3.87777777777778 | 42 | 21 | 45.6 | 1 | 1 | 123 | 425 | 466 | NLT50973.1 HD domain-containing protein [Ignavibacteria bacterium] | diamond | 1047 | 45.4 | 0.993392070484582 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30783619 | 30783619 | PRJNA944406_P_NODE_43174_length_269_cov_2.183673_g42215_i0 | PRJNA944406 | 43174 | 269 | 2.183673 | 5.87408037 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 136 | 7.139999999999999e-35 | NR | MBI3259271.1 | 2026749 | g42215 | i0 | 75 | 0.981412639405205 | 88 | 22 | 98.1 | 0 | 2 | 265 | 1662 | 1749 | MBI3259271.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 264 | 136 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31707174 | 31707174 | PRJNA944406_P_NODE_112217_length_231_cov_2.322785_g111258_i0 | PRJNA944406 | 112217 | 231 | 2.322785 | 5.36563335 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.5 | 1.51e-4 | NR | HEY6437391.1 | 2651163 | g111258 | i0 | 44.4 | 2.77922077922078 | 54 | 27 | 70.1 | 1 | 229 | 68 | 31 | 81 | HEY6437391.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 642 | 48.9 | 0.991820040899796 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium |
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);;