contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27206607 | 27206607 | PRJNA615351_P_NODE_20462_length_1445_cov_9.958156_g14858_i0 | PRJNA615351 | 20462 | 1445 | 9.958156 | 143.8953542 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 78.6 | 1.81e-11 | NR | RKY54847.1 | 2026760 | g14858 | i0 | 30.4 | 0.34878892733564 | 168 | 104 | 34 | 4 | 1216 | 725 | 29 | 187 | RKY54847.1 MAG: tRNA nucleotidyltransferase [Fidelibacterota bacterium] | diamond | 504 | 78.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27522629 | 27522629 | PRJNA615351_P_NODE_10423_length_2004_cov_4.269680_g7469_i0 | PRJNA615351 | 10423 | 2004 | 4.26968 | 85.5643872 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 97.8 | 2.61e-19 | NR | PCJ12276.1 | 2026760 | g7469 | i0 | 69.4 | 0.107784431137725 | 72 | 22 | 10.8 | 0 | 1130 | 1345 | 118 | 189 | PCJ12276.1 MAG: hypothetical protein COA98_05575, partial [Fidelibacterota bacterium] | diamond | 216 | 97.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27933236 | 27933236 | PRJNA615351_P_NODE_20305_length_1452_cov_2.714185_g14747_i0 | PRJNA615351 | 20305 | 1452 | 2.714185 | 39.4099662 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 76.3 | 7.39e-11 | NR | MAP02912.1 | 2026760 | g14747 | i0 | 28.7 | 0.921487603305785 | 258 | 156 | 53.1 | 9 | 673 | 1443 | 103 | 333 | MAP02912.1 molecular chaperone DnaK [Fidelibacterota bacterium] | diamond | 1338 | 76.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28059411 | 28059411 | PRJNA615351_P_NODE_128105_length_230_cov_2.035897_g114005_i0 | PRJNA615351 | 128105 | 230 | 2.035897 | 4.6825631 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.9 | 0.00576 | NR | MAX10684.1 | 2026760 | g114005 | i0 | 40.4 | 0.743478260869565 | 57 | 31 | 74.3 | 2 | 224 | 54 | 20 | 73 | MAX10684.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 171 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28280440 | 28280440 | PRJNA615351_P_NODE_65366_length_543_cov_1.927165_g51713_i0 | PRJNA615351 | 65366 | 543 | 1.927165 | 10.46450595 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 56.2 | 1.49e-5 | NR | MBD23449.1 | 2026760 | g51713 | i0 | 44.3 | 0.386740331491713 | 70 | 36 | 37 | 2 | 227 | 27 | 9 | 78 | MBD23449.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 210 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29227991 | 29227991 | PRJNA615351_P_NODE_150089_length_190_cov_1.193548_g135989_i0 | PRJNA615351 | 150089 | 190 | 1.193548 | 2.2677412 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.1 | 0.0134 | NR | MFB0516796.1 | 2026760 | g135989 | i0 | 35.6 | 0.931578947368421 | 59 | 35 | 88.4 | 1 | 168 | 1 | 133 | 191 | MFB0516796.1 DNA-directed RNA polymerase subunit alpha [Fidelibacterota bacterium] | diamond | 177 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29228128 | 29228128 | PRJNA615351_P_NODE_76309_length_451_cov_2.281250_g62301_i0 | PRJNA615351 | 76309 | 451 | 2.28125 | 10.2884375 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 47.4 | 0.00489 | NR | MCH7818396.1 | 2026760 | g62301 | i0 | 36.4 | 3.27272727272727 | 66 | 42 | 43.9 | 0 | 1 | 198 | 72 | 137 | MCH7818396.1 Crp/Fnr family transcriptional regulator [Fidelibacterota bacterium] | diamond | 1476 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29417125 | 29417125 | PRJNA615351_P_NODE_37429_length_952_cov_14.006543_g27702_i0 | PRJNA615351 | 37429 | 952 | 14.006543 | 133.34228936 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 67 | 1.72e-9 | NR | MBI89257.1 | 2026760 | g27702 | i0 | 27.8 | 0.475840336134454 | 151 | 93 | 44.1 | 3 | 257 | 676 | 6 | 151 | MBI89257.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 453 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29682409 | 29682409 | PRJNA615351_P_NODE_27390_length_1208_cov_3.884058_g19946_i0 | PRJNA615351 | 27390 | 1208 | 3.884058 | 46.91942064 | root | 1 | Root_unresolved | Root_unresolved | 89.7 | 9.04e-17 | NR | MBT4662924.1 | 2026760 | g19946 | i0 | 32.1 | 1.87996688741722 | 193 | 120 | 47.4 | 3 | 1121 | 549 | 12 | 195 | MBT4662924.1 glutathione S-transferase [Fidelibacterota bacterium] | diamond | 2271 | 89.7 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29764381 | 29764381 | PRJNA615351_P_NODE_37431_length_952_cov_11.961832_g27702_i1 | PRJNA615351 | 37431 | 952 | 11.961832 | 113.87664064 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 66.6 | 2.36e-9 | NR | MBI89257.1 | 2026760 | g27702 | i1 | 27.2 | 0.475840336134454 | 151 | 94 | 44.1 | 3 | 257 | 676 | 6 | 151 | MBI89257.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 453 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29859302 | 29859302 | PRJNA615351_P_NODE_66191_length_535_cov_2.326000_g52496_i0 | PRJNA615351 | 66191 | 535 | 2.326 | 12.4441 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.1 | 0.0434 | NR | MBT5996771.1 | 2026760 | g52496 | i0 | 42.9 | 0.274766355140187 | 49 | 28 | 27.5 | 0 | 535 | 389 | 36 | 84 | MBT5996771.1 sulfurtransferase [Fidelibacterota bacterium] | diamond | 147 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30396797 | 30396797 | PRJNA615351_P_NODE_140253_length_206_cov_1.169591_g126153_i0 | PRJNA615351 | 140253 | 206 | 1.169591 | 2.40935746 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 76.6 | 2.57e-14 | NR | MAM98301.1 | 2026760 | g126153 | i0 | 65.6 | 3.77184466019417 | 64 | 17 | 93.2 | 2 | 2 | 193 | 222 | 280 | MAM98301.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 777 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30775762 | 30775762 | PRJNA615351_P_NODE_86614_length_384_cov_4.429799_g72540_i0 | PRJNA615351 | 86614 | 384 | 4.429799 | 17.01042816 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 131 | 4.13e-33 | NR | MFB0515731.1 | 2026760 | g72540 | i0 | 62.1 | 5.5625 | 95 | 35 | 74.2 | 1 | 98 | 382 | 361 | 454 | MFB0515731.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Fidelibacterota bacterium] | diamond | 2136 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30933598 | 30933598 | PRJNA615351_P_NODE_40334_length_894_cov_3.066356_g29953_i0 | PRJNA615351 | 40334 | 894 | 3.066356 | 27.41322264 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 67.4 | 1.4e-8 | NR | HCL00161.1 | 2026760 | g29953 | i0 | 30.2 | 1.87248322147651 | 179 | 92 | 58.1 | 7 | 540 | 22 | 226 | 377 | HCL00161.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 1674 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32325496 | 32325496 | PRJNA615351_P_NODE_69299_length_507_cov_1.669492_g55444_i0 | PRJNA615351 | 69299 | 507 | 1.669492 | 8.46432444 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 77 | 7.19e-13 | NR | MCH8327546.1 | 2026760 | g55444 | i0 | 42.1 | 0.828402366863905 | 140 | 72 | 81.7 | 4 | 506 | 93 | 599 | 731 | MCH8327546.1 tandem-95 repeat protein [Fidelibacterota bacterium] | diamond | 420 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;