contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9854562 | 9854562 | PRJNA946307_P_NODE_161008_length_162_cov_1.707965_g160134_i0 | PRJNA946307 | 161008 | 162 | 1.707965 | 2.7669033 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 82.4 | 6.59e-17 | NR | HEX8550445.1 | 2800791 | g160134 | i0 | 75.5 | 0.907407407407407 | 49 | 12 | 90.7 | 0 | 147 | 1 | 212 | 260 | HEX8550445.1 GNAT family N-acetyltransferase [Abditibacteriaceae bacterium] | diamond | 147 | 82.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 26613685 | 26613685 | PRJNA946307_P_NODE_150321_length_165_cov_0.879310_g149447_i0 | PRJNA946307 | 150321 | 165 | 0.87931 | 1.4508615 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 41.6 | 0.0347 | NR | HEX8550686.1 | 2800791 | g149447 | i0 | 45.7 | 0.836363636363636 | 46 | 25 | 83.6 | 0 | 19 | 156 | 176 | 221 | HEX8550686.1 O-antigen ligase family protein [Abditibacteriaceae bacterium] | diamond | 138 | 41.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27057061 | 27057061 | PRJNA946307_P_NODE_113962_length_178_cov_1.496124_g113088_i0 | PRJNA946307 | 113962 | 178 | 1.496124 | 2.66310072 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 72 | 7.45e-13 | NR | MDF2441487.1 | 2783868 | g113088 | i0 | 60.7 | 0.943820224719101 | 56 | 22 | 94.4 | 0 | 178 | 11 | 269 | 324 | MDF2441487.1 polysaccharide biosynthesis transport protein [Abditibacteriota bacterium] | diamond | 168 | 72 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27063704 | 27063704 | PRJNA946307_P_NODE_51942_length_210_cov_3.254658_g51068_i0 | PRJNA946307 | 51942 | 210 | 3.254658 | 6.8347818 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 60.1 | 1.81e-8 | NR | HVF09524.1 | 2800791 | g51068 | i0 | 84.8 | 2.27142857142857 | 33 | 5 | 47.1 | 0 | 111 | 209 | 323 | 355 | HVF09524.1 DUF1800 domain-containing protein [Abditibacteriaceae bacterium] | diamond | 477 | 60.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27214845 | 27214845 | PRJNA946307_P_NODE_145842_length_166_cov_0.871795_g144968_i0 | PRJNA946307 | 145842 | 166 | 0.871795 | 1.4471797 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 101 | 3.1e-23 | NR | HVF10891.1 | 2800791 | g144968 | i0 | 89.8 | 0.885542168674699 | 49 | 5 | 88.6 | 0 | 12 | 158 | 976 | 1024 | HVF10891.1 PDZ domain-containing protein [Abditibacteriaceae bacterium] | diamond | 147 | 101 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27436481 | 27436481 | PRJNA946307_P_NODE_144143_length_166_cov_1.658120_g143269_i0 | PRJNA946307 | 144143 | 166 | 1.65812 | 2.7524792 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 42.4 | 0.0185 | NR | HEX8237450.1 | 2800791 | g143269 | i0 | 57.7 | 0.939759036144578 | 52 | 18 | 94 | 2 | 165 | 10 | 569 | 616 | HEX8237450.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium] | diamond | 156 | 42.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27594259 | 27594259 | PRJNA946307_P_NODE_162204_length_162_cov_0.902655_g161330_i0 | PRJNA946307 | 162204 | 162 | 0.902655 | 1.4623011 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 86.7 | 2.08e-18 | NR | HEX8235257.1 | 2800791 | g161330 | i0 | 77.1 | 0.888888888888889 | 48 | 11 | 88.9 | 0 | 146 | 3 | 152 | 199 | HEX8235257.1 LacI family DNA-binding transcriptional regulator [Abditibacteriaceae bacterium] | diamond | 144 | 86.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 28036340 | 28036340 | PRJNA946307_P_NODE_78265_length_195_cov_3.760274_g77391_i0 | PRJNA946307 | 78265 | 195 | 3.760274 | 7.3325343 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 53.5 | 9.92e-7 | NR | HEX8463749.1 | 2109264 | g77391 | i0 | 48.8 | 0.661538461538462 | 43 | 22 | 66.2 | 0 | 158 | 30 | 106 | 148 | HEX8463749.1 hypothetical protein [Abditibacterium sp.] | diamond | 129 | 53.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28604580 | 28604580 | PRJNA946307_P_NODE_76307_length_196_cov_5.190476_g75433_i0 | PRJNA946307 | 76307 | 196 | 5.190476 | 10.17333296 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 51.2 | 1.5e-5 | NR | MDF2439746.1 | 2783868 | g75433 | i0 | 70 | 1.28571428571429 | 30 | 9 | 45.9 | 0 | 102 | 191 | 1 | 30 | MDF2439746.1 phosphoribosylaminoimidazole-succinocarboxamide synthase [Abditibacteriota bacterium] | diamond | 252 | 51.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 29393928 | 29393928 | PRJNA946307_P_NODE_154829_length_164_cov_0.886957_g153955_i0 | PRJNA946307 | 154829 | 164 | 0.886957 | 1.45460948 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 68.2 | 1.27e-11 | NR | HEY0075727.1 | 2800791 | g153955 | i0 | 69.4 | 0.896341463414634 | 49 | 15 | 89.6 | 0 | 162 | 16 | 170 | 218 | HEY0075727.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Abditibacteriaceae bacterium] | diamond | 147 | 68.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29488404 | 29488404 | PRJNA946307_P_NODE_22830_length_268_cov_3.671233_g21956_i0 | PRJNA946307 | 22830 | 268 | 3.671233 | 9.83890444 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 140 | 2.22e-36 | NR | HEX8550833.1 | 2800791 | g21956 | i0 | 76.1 | 0.985074626865672 | 88 | 19 | 98.5 | 1 | 266 | 3 | 107 | 192 | HEX8550833.1 TAT-variant-translocated molybdopterin oxidoreductase [Abditibacteriaceae bacterium] | diamond | 264 | 140 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29520063 | 29520063 | PRJNA946307_P_NODE_150310_length_165_cov_0.879310_g149436_i0 | PRJNA946307 | 150310 | 165 | 0.87931 | 1.4508615 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 54.7 | 7.69e-7 | NR | HEY0075478.1 | 2800791 | g149436 | i0 | 65.8 | 0.690909090909091 | 38 | 13 | 69.1 | 0 | 5 | 118 | 385 | 422 | HEY0075478.1 ABC transporter permease subunit [Abditibacteriaceae bacterium] | diamond | 114 | 54.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 30783760 | 30783760 | PRJNA946307_P_NODE_70614_length_199_cov_3.106667_g69740_i0 | PRJNA946307 | 70614 | 199 | 3.106667 | 6.18226733 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 65.1 | 9.73e-11 | NR | HEX8551324.1 | 2800791 | g69740 | i0 | 76.5 | 0.512562814070352 | 34 | 8 | 51.3 | 0 | 199 | 98 | 72 | 105 | HEX8551324.1 DUF3431 domain-containing protein [Abditibacteriaceae bacterium] | diamond | 102 | 65.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 30815257 | 30815257 | PRJNA946307_P_NODE_134454_length_169_cov_1.608333_g133580_i0 | PRJNA946307 | 134454 | 169 | 1.608333 | 2.71808277 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 66.6 | 3.52e-12 | NR | HEX8234565.1 | 2800791 | g133580 | i0 | 77.5 | 0.710059171597633 | 40 | 8 | 69.2 | 1 | 10 | 126 | 63 | 102 | HEX8234565.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 120 | 66.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31542522 | 31542522 | PRJNA946307_P_NODE_74716_length_197_cov_6.202703_g73842_i0 | PRJNA946307 | 74716 | 197 | 6.202703 | 12.21932491 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 55.5 | 8.45e-8 | NR | MDF2439457.1 | 2783868 | g73842 | i0 | 80 | 0.456852791878173 | 30 | 6 | 45.7 | 0 | 105 | 16 | 75 | 104 | MDF2439457.1 GntR family transcriptional regulator [Abditibacteriota bacterium] | diamond | 90 | 55.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 31574141 | 31574141 | PRJNA946307_P_NODE_135196_length_169_cov_0.866667_g134322_i0 | PRJNA946307 | 135196 | 169 | 0.866667 | 1.46466723 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 69.7 | 4.27e-12 | NR | HEX8465379.1 | 2109264 | g134322 | i0 | 61.2 | 0.869822485207101 | 49 | 19 | 87 | 0 | 162 | 16 | 462 | 510 | HEX8465379.1 hypothetical protein [Abditibacterium sp.] | diamond | 147 | 69.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 31858547 | 31858547 | PRJNA946307_P_NODE_124857_length_173_cov_1.572581_g123983_i0 | PRJNA946307 | 124857 | 173 | 1.572581 | 2.72056513 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 51.2 | 1.04e-5 | NR | WP_157947611.1 | 1960156 | g123983 | i0 | 64.1 | 0.676300578034682 | 39 | 9 | 67.6 | 1 | 41 | 157 | 173 | 206 | WP_157947611.1 DUF1559 domain-containing protein [Abditibacterium utsteinense] | diamond | 117 | 51.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 32333623 | 32333623 | PRJNA946307_P_NODE_26339_length_251_cov_3.678218_g25465_i0 | PRJNA946307 | 26339 | 251 | 3.678218 | 9.23232718 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 75.9 | 4.08e-15 | NR | BCM93933.1 | 2783868 | g25465 | i0 | 77.8 | 0.537848605577689 | 45 | 10 | 53.8 | 0 | 15 | 149 | 111 | 155 | BCM93933.1 hypothetical protein IAD21_05828 [Abditibacteriota bacterium] | diamond | 135 | 75.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 32617846 | 32617846 | PRJNA946307_P_NODE_78860_length_195_cov_2.212329_g77986_i0 | PRJNA946307 | 78860 | 195 | 2.212329 | 4.31404155 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 94.4 | 1.28e-20 | NR | MDF2440115.1 | 2783868 | g77986 | i0 | 93.8 | 0.738461538461539 | 48 | 3 | 73.8 | 0 | 193 | 50 | 422 | 469 | MDF2440115.1 ATP-binding cassette, subfamily putative efflux pump [Abditibacteriota bacterium] | diamond | 144 | 94.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 32712268 | 32712268 | PRJNA946307_P_NODE_60560_length_206_cov_2.802548_g59686_i0 | PRJNA946307 | 60560 | 206 | 2.802548 | 5.77324888 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 46.2 | 0.00124 | NR | MDF2439402.1 | 2783868 | g59686 | i0 | 100 | 0.320388349514563 | 22 | 0 | 32 | 0 | 2 | 67 | 239 | 260 | MDF2439402.1 phospholipid/cholesterol/gamma-HCH transport system permease protein [Abditibacteriota bacterium] | diamond | 66 | 46.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota 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);;