contig_metadata
24 rows where bioproject = "PRJNA688655" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7045870 | 7045870 | PRJNA688655_P_NODE_7966_length_251_cov_0.865169_g7901_i0 | PRJNA688655 | 7966 | 251 | 0.865169 | 2.17157419 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 159 | 1.7599999999999999e-47 | NR | MDD4016338.1 | 2212473 | g7901 | i0 | 89.2 | 2.97609561752988 | 83 | 9 | 99.2 | 0 | 250 | 2 | 100 | 182 | MDD4016338.1 pantetheine-phosphate adenylyltransferase [Kiritimatiellia bacterium] | diamond | 747 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 25403378 | 25403378 | PRJNA688655_P_NODE_10220_length_248_cov_0.880000_g10155_i0 | PRJNA688655 | 10220 | 248 | 0.88 | 2.1824 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 172 | 5.54e-53 | NR | HQN80136.1 | 2212473 | g10155 | i0 | 98.8 | 1.98387096774194 | 82 | 1 | 99.2 | 0 | 3 | 248 | 42 | 123 | HQN80136.1 radical SAM protein [Kiritimatiellia bacterium] | diamond | 492 | 172 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26639068 | 26639068 | PRJNA688655_P_NODE_9621_length_249_cov_0.875000_g9556_i0 | PRJNA688655 | 9621 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 105 | 1.3e-27 | NR | MFA6633257.1 | 2212473 | g9556 | i0 | 82.3 | 0.746987951807229 | 62 | 11 | 74.7 | 0 | 1 | 186 | 8 | 69 | MFA6633257.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 186 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26765769 | 26765769 | PRJNA688655_P_NODE_10401_length_248_cov_0.880000_g10336_i0 | PRJNA688655 | 10401 | 248 | 0.88 | 2.1824 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 94 | 2.52e-20 | NR | MBO7166759.1 | 2212473 | g10336 | i0 | 60.5 | 0.979838709677419 | 81 | 32 | 98 | 0 | 2 | 244 | 127 | 207 | MBO7166759.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 243 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27176899 | 27176899 | PRJNA688655_P_NODE_9342_length_249_cov_0.875000_g9277_i0 | PRJNA688655 | 9342 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 99 | 5.700000000000001e-22 | NR | MBN1673866.1 | 2212473 | g9277 | i0 | 57.9 | 0.91566265060241 | 76 | 32 | 91.6 | 0 | 13 | 240 | 98 | 173 | MBN1673866.1 glycosyltransferase family 39 protein [Kiritimatiellia bacterium] | diamond | 228 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27555957 | 27555957 | PRJNA688655_P_NODE_10724_length_248_cov_0.880000_g10659_i0 | PRJNA688655 | 10724 | 248 | 0.88 | 2.1824 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 81.3 | 5.94e-17 | NR | MBO7222740.1 | 2212473 | g10659 | i0 | 80.4 | 1.66935483870968 | 46 | 9 | 55.6 | 0 | 109 | 246 | 1 | 46 | MBO7222740.1 flavin reductase family protein [Kiritimatiellia bacterium] | diamond | 414 | 81.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27587861 | 27587861 | PRJNA688655_P_NODE_14464_length_243_cov_0.905882_g14399_i0 | PRJNA688655 | 14464 | 243 | 0.905882 | 2.20129326 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 70.1 | 8.18e-12 | NR | MBP7009753.1 | 2212473 | g14399 | i0 | 100 | 0.407407407407407 | 33 | 0 | 40.7 | 0 | 241 | 143 | 228 | 260 | MBP7009753.1 threonine synthase [Kiritimatiellia bacterium] | diamond | 99 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27745863 | 27745863 | PRJNA688655_P_NODE_11044_length_247_cov_0.885057_g10979_i0 | PRJNA688655 | 11044 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 127 | 5.759999999999999e-34 | NR | MBN1270386.1 | 2212473 | g10979 | i0 | 68.3 | 0.995951417004049 | 82 | 26 | 99.6 | 0 | 247 | 2 | 117 | 198 | MBN1270386.1 NAD(P)-dependent oxidoreductase [Kiritimatiellia bacterium] | diamond | 246 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28219000 | 28219000 | PRJNA688655_P_NODE_11366_length_247_cov_0.885057_g11301_i0 | PRJNA688655 | 11366 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 114 | 2.5800000000000004e-27 | NR | MDD4872606.1 | 2212473 | g11301 | i0 | 70 | 1.94331983805668 | 80 | 24 | 97.2 | 0 | 240 | 1 | 379 | 458 | MDD4872606.1 serine/threonine-protein kinase [Kiritimatiellia bacterium] | diamond | 480 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28250684 | 28250684 | PRJNA688655_P_NODE_3566_length_328_cov_1.207843_g3501_i0 | PRJNA688655 | 3566 | 328 | 1.207843 | 3.96172504 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 217 | 1.4199999999999999e-69 | NR | MBP7008613.1 | 2212473 | g3501 | i0 | 100 | 0.996951219512195 | 109 | 0 | 99.7 | 0 | 328 | 2 | 1 | 109 | MBP7008613.1 PTS sugar transporter subunit IIA [Kiritimatiellia bacterium] | diamond | 327 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28850528 | 28850528 | PRJNA688655_P_NODE_9308_length_249_cov_0.875000_g9243_i0 | PRJNA688655 | 9308 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 110 | 5.91e-26 | NR | MBN1671716.1 | 2212473 | g9243 | i0 | 59.8 | 0.987951807228916 | 82 | 33 | 98.8 | 0 | 3 | 248 | 650 | 731 | MBN1671716.1 VCBS repeat-containing protein [Kiritimatiellia bacterium] | diamond | 246 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28882207 | 28882207 | PRJNA688655_P_NODE_13508_length_244_cov_0.900585_g13443_i0 | PRJNA688655 | 13508 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 58.9 | 6.95e-8 | NR | MDD4872884.1 | 2212473 | g13443 | i0 | 45.7 | 0.995901639344262 | 81 | 44 | 99.6 | 0 | 244 | 2 | 163 | 243 | MDD4872884.1 acyltransferase family protein [Kiritimatiellia bacterium] | diamond | 243 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29040391 | 29040391 | PRJNA688655_P_NODE_15888_length_242_cov_0.911243_g15823_i0 | PRJNA688655 | 15888 | 242 | 0.911243 | 2.20520806 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 130 | 2.75e-35 | NR | MBO5904889.1 | 2212473 | g15823 | i0 | 100 | 0.818181818181818 | 66 | 0 | 81.8 | 0 | 199 | 2 | 1 | 66 | MBO5904889.1 DMT family transporter [Kiritimatiellia bacterium] | diamond | 198 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29229850 | 29229850 | PRJNA688655_P_NODE_8209_length_251_cov_0.865169_g8144_i0 | PRJNA688655 | 8209 | 251 | 0.865169 | 2.17157419 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 142 | 7.09e-38 | NR | MDD4025129.1 | 2212473 | g8144 | i0 | 89.2 | 0.99203187250996006 | 83 | 9 | 99.2 | 0 | 251 | 3 | 128 | 210 | MDD4025129.1 SurA N-terminal domain-containing protein [Kiritimatiellia bacterium] | diamond | 249 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29513595 | 29513595 | PRJNA688655_P_NODE_13870_length_244_cov_0.900585_g13805_i0 | PRJNA688655 | 13870 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 116 | 1.18e-29 | NR | HPT16533.1 | 2212473 | g13805 | i0 | 77 | 1.79508196721311 | 74 | 17 | 91 | 0 | 243 | 22 | 204 | 277 | HPT16533.1 glycosyltransferase [Kiritimatiellia bacterium] | diamond | 438 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29608118 | 29608118 | PRJNA688655_P_NODE_15250_length_242_cov_0.911243_g15185_i0 | PRJNA688655 | 15250 | 242 | 0.911243 | 2.20520806 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 133 | 5.88e-34 | NR | HPF99568.1 | 2212473 | g15185 | i0 | 78.2 | 0.966942148760331 | 78 | 17 | 96.7 | 0 | 8 | 241 | 1161 | 1238 | HPF99568.1 carbohydrate-binding protein [Kiritimatiellia bacterium] | diamond | 234 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29861114 | 29861114 | PRJNA688655_P_NODE_9271_length_249_cov_0.875000_g9206_i0 | PRJNA688655 | 9271 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 56.6 | 4.39e-7 | NR | MBO5904855.1 | 2212473 | g9206 | i0 | 78.8 | 0.397590361445783 | 33 | 7 | 39.8 | 0 | 2 | 100 | 256 | 288 | MBO5904855.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 99 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30050505 | 30050505 | PRJNA688655_P_NODE_11531_length_247_cov_0.885057_g11466_i0 | PRJNA688655 | 11531 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 110 | 4.06e-26 | NR | HEY8240938.1 | 2212473 | g11466 | i0 | 58.8 | 0.97165991902834 | 80 | 33 | 97.2 | 0 | 245 | 6 | 429 | 508 | HEY8240938.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 240 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30272124 | 30272124 | PRJNA688655_P_NODE_9852_length_249_cov_0.875000_g9787_i0 | PRJNA688655 | 9852 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 152 | 1.3199999999999999e-40 | NR | HNX33485.1 | 2212473 | g9787 | i0 | 85.4 | 0.987951807228916 | 82 | 12 | 98.8 | 0 | 248 | 3 | 28 | 109 | HNX33485.1 glycoside hydrolase family 127 protein [Kiritimatiellia bacterium] | diamond | 246 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30619302 | 30619302 | PRJNA688655_P_NODE_8053_length_251_cov_0.865169_g7988_i0 | PRJNA688655 | 8053 | 251 | 0.865169 | 2.17157419 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 146 | 1.0499999999999998e-41 | NR | MCG2659740.1 | 2212473 | g7988 | i0 | 84.3 | 0.99203187250996006 | 83 | 13 | 99.2 | 0 | 3 | 251 | 127 | 209 | MCG2659740.1 aminopeptidase P family protein [Kiritimatiellia bacterium] | diamond | 249 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31187759 | 31187759 | PRJNA688655_P_NODE_11355_length_247_cov_0.885057_g11290_i0 | PRJNA688655 | 11355 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 112 | 8.13e-29 | NR | MFU8781023.1 | 2212473 | g11290 | i0 | 64.6 | 0.995951417004049 | 82 | 29 | 99.6 | 0 | 247 | 2 | 29 | 110 | MFU8781023.1 YceH family protein [Kiritimatiellia bacterium] | diamond | 246 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31441033 | 31441033 | PRJNA688655_P_NODE_12796_length_245_cov_0.895349_g12731_i0 | PRJNA688655 | 12796 | 245 | 0.895349 | 2.19360505 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 161 | 1.5199999999999998e-47 | NR | HOR74427.1 | 2212473 | g12731 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 1 | 243 | 37 | 117 | HOR74427.1 transposase [Kiritimatiellia bacterium] | diamond | 243 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31441036 | 31441036 | PRJNA688655_P_NODE_13616_length_244_cov_0.900585_g13551_i0 | PRJNA688655 | 13616 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 162 | 5.34e-50 | NR | MBP7009968.1 | 2212473 | g13551 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 243 | 1 | 13 | 93 | MBP7009968.1 30S ribosomal protein S6 [Kiritimatiellia bacterium] | diamond | 243 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32768788 | 32768788 | PRJNA688655_P_NODE_8620_length_250_cov_0.870056_g8555_i0 | PRJNA688655 | 8620 | 250 | 0.870056 | 2.17514 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 92.4 | 1.31e-19 | NR | MDD4018143.1 | 2212473 | g8555 | i0 | 52.4 | 0.984 | 82 | 39 | 98.4 | 0 | 248 | 3 | 499 | 580 | MDD4018143.1 DUF4838 domain-containing protein [Kiritimatiellia bacterium] | diamond | 246 | 92.4 | 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);;