contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22828632 | 22828632 | PRJNA630162_P_NODE_140758_length_167_cov_0.881356_g139235_i0 | PRJNA630162 | 140758 | 167 | 0.881356 | 1.47186452 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 110 | 2.18e-26 | NR | HMO49946.1 | 2212473 | g139235 | i0 | 96.2 | 44.7305389221557 | 53 | 2 | 95.2 | 0 | 161 | 3 | 311 | 363 | HMO49946.1 urease subunit alpha [Kiritimatiellia bacterium] | diamond | 7470 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 24103092 | 24103092 | PRJNA630162_P_NODE_140659_length_167_cov_0.881356_g139136_i0 | PRJNA630162 | 140659 | 167 | 0.881356 | 1.47186452 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 104 | 9.17e-27 | NR | MFO1489698.1 | 2212473 | g139136 | i0 | 94.4 | 0.970059880239521 | 54 | 3 | 97 | 0 | 162 | 1 | 67 | 120 | MFO1489698.1 30S ribosomal protein S7 [Kiritimatiellia bacterium] | diamond | 162 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26859539 | 26859539 | PRJNA630162_P_NODE_142641_length_166_cov_1.512821_g141118_i0 | PRJNA630162 | 142641 | 166 | 1.512821 | 2.51128286 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 65.1 | 3.34e-11 | NR | MBP7828349.1 | 2212473 | g141118 | i0 | 73.9 | 1.66265060240964 | 46 | 11 | 81.3 | 1 | 139 | 5 | 1 | 46 | MBP7828349.1 outer membrane beta-barrel protein [Kiritimatiellia bacterium] | diamond | 276 | 65.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27143532 | 27143532 | PRJNA630162_P_NODE_23862_length_375_cov_4.254601_g22343_i0 | PRJNA630162 | 23862 | 375 | 4.254601 | 15.95475375 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 56.6 | 2.48e-6 | NR | MFO1521312.1 | 2212473 | g22343 | i0 | 47.7 | 0.52 | 65 | 29 | 52 | 3 | 181 | 375 | 1488 | 1547 | MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 195 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27491683 | 27491683 | PRJNA630162_P_NODE_77123_length_205_cov_1.301282_g75600_i0 | PRJNA630162 | 77123 | 205 | 1.301282 | 2.6676281 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 54.7 | 1.37e-6 | NR | MFO1521312.1 | 2212473 | g75600 | i0 | 46.6 | 0.848780487804878 | 58 | 27 | 84.9 | 2 | 194 | 21 | 1502 | 1555 | MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 174 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27617995 | 27617995 | PRJNA630162_P_NODE_63904_length_221_cov_1.901163_g62381_i0 | PRJNA630162 | 63904 | 221 | 1.901163 | 4.20157023 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 54.7 | 1.74e-6 | NR | MDD2239633.1 | 2212473 | g62381 | i0 | 40.6 | 0.936651583710407 | 69 | 41 | 93.7 | 0 | 211 | 5 | 599 | 667 | MDD2239633.1 lamin tail domain-containing protein [Kiritimatiellia bacterium] | diamond | 207 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27649452 | 27649452 | PRJNA630162_P_NODE_148044_length_165_cov_0.896552_g146521_i0 | PRJNA630162 | 148044 | 165 | 0.896552 | 1.4793108 | Kiritimatiellaceae bacterium | 2026752 | Bacteria | Bacteria | 62 | 2.01e-9 | NR | NOU35723.1 | 2026752 | g146521 | i0 | 53.7 | 4.76363636363636 | 54 | 25 | 98.2 | 0 | 3 | 164 | 106 | 159 | NOU35723.1 UbiA family prenyltransferase [Kiritimatiellaceae bacterium] | diamond | 786 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellaceae | Kiritimatiellaceae bacterium | ||
| 28217490 | 28217490 | PRJNA630162_P_NODE_51766_length_245_cov_1.607143_g50243_i0 | PRJNA630162 | 51766 | 245 | 1.607143 | 3.93750035 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 95.1 | 1.42e-20 | NR | MFT5239676.1 | 2212473 | g50243 | i0 | 62 | 0.869387755102041 | 71 | 19 | 86.9 | 2 | 237 | 25 | 257 | 319 | MFT5239676.1 M6 family metalloprotease-like protein [Kiritimatiellia bacterium] | diamond | 213 | 95.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28596717 | 28596717 | PRJNA630162_P_NODE_150387_length_164_cov_1.765217_g148864_i0 | PRJNA630162 | 150387 | 164 | 1.765217 | 2.89495588 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 89.7 | 3.32e-19 | NR | MBR3821797.1 | 2212473 | g148864 | i0 | 83 | 5.81707317073171 | 53 | 9 | 97 | 0 | 5 | 163 | 112 | 164 | MBR3821797.1 YifB family Mg chelatase-like AAA ATPase [Kiritimatiellia bacterium] | diamond | 954 | 89.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29259426 | 29259426 | PRJNA630162_P_NODE_151749_length_164_cov_0.904348_g150226_i0 | PRJNA630162 | 151749 | 164 | 0.904348 | 1.48313072 | Kiritimatiellota bacterium | 2599938 | Bacteria | Bacteria | 65.5 | 1.22e-10 | NR | NOY81891.1 | 2599938 | g150226 | i0 | 62.7 | 0.932926829268293 | 51 | 19 | 93.3 | 0 | 160 | 8 | 92 | 142 | NOY81891.1 hypothetical protein [Kiritimatiellota bacterium] | diamond | 153 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium | |||||
| 29303883 | 29303883 | PRJNA630162_P_NODE_5569_length_812_cov_27.937090_g2446_i1 | PRJNA630162 | 5569 | 812 | 27.93709 | 226.8491708 | PVC group | 1783257 | Bacteria | Bacteria | 118 | 6.19e-26 | NR | MFO1521312.1 | 2212473 | g2446 | i1 | 39.2 | 2.54556650246305 | 204 | 111 | 75 | 5 | 776 | 168 | 1408 | 1599 | MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 2067 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29575262 | 29575262 | PRJNA630162_P_NODE_730_length_1834_cov_14.797199_g492_i0 | PRJNA630162 | 730 | 1834 | 14.797199 | 271.38062966 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 87 | 1.74e-13 | NR | MFO1521312.1 | 2212473 | g492 | i0 | 35.9 | 0.323882224645583 | 198 | 105 | 31.6 | 8 | 1834 | 1256 | 1424 | 1604 | MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 594 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31312995 | 31312995 | PRJNA630162_P_NODE_145995_length_165_cov_2.129310_g144472_i0 | PRJNA630162 | 145995 | 165 | 2.12931 | 3.5133615 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 76.6 | 1e-16 | NR | MBR4616010.1 | 2212473 | g144472 | i0 | 81 | 0.763636363636364 | 42 | 8 | 76.4 | 0 | 1 | 126 | 3 | 44 | MBR4616010.1 DNA cytosine methyltransferase [Kiritimatiellia bacterium] | diamond | 126 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32262378 | 32262378 | PRJNA630162_P_NODE_1558_length_1398_cov_16.417346_g492_i1 | PRJNA630162 | 1558 | 1398 | 16.417346 | 229.51449708 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 87 | 7.23e-14 | NR | MFO1521312.1 | 2212473 | g492 | i1 | 35.9 | 0.424892703862661 | 198 | 105 | 41.4 | 8 | 1 | 579 | 1424 | 1604 | MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 594 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;