contig_metadata
18 rows where analysis = "diamond" and tax_phylum = "candidate division FCPU426"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1233423 | 1233423 | PRJNA849822_P_NODE_13861_length_392_cov_2.094044_g13687_i0 | PRJNA849822 | 13861 | 392 | 2.094044 | 8.20865248 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 85.1 | 1.01e-18 | NR | MBN1594640.1 | 2052330 | g13687 | i0 | 45.5 | 1.3469387755102 | 88 | 45 | 67.3 | 1 | 101 | 364 | 4 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 528 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 7650235 | 7650235 | PRJNA986481_P_NODE_6166_length_646_cov_1.839196_g5694_i0 | PRJNA986481 | 6166 | 646 | 1.839196 | 11.88120616 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 79.3 | 1.98e-15 | NR | MBN1594640.1 | 2052330 | g5694 | i0 | 45.1 | 0.761609907120743 | 82 | 42 | 38.1 | 1 | 643 | 398 | 10 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 492 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 18127110 | 18127110 | PRJNA1120203_P_NODE_81775_length_250_cov_0.870056_g80759_i0 | PRJNA1120203 | 81775 | 250 | 0.870056 | 2.17514 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 114 | 5.42e-28 | NR | MES2200685.1 | 2052330 | g80759 | i0 | 67.9 | 0.972 | 81 | 26 | 97.2 | 0 | 245 | 3 | 71 | 151 | MES2200685.1 folylpolyglutamate synthase/dihydrofolate synthase family protein [candidate division FCPU426 bacterium] | diamond | 243 | 114 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 22396438 | 22396438 | PRJNA734348_P_NODE_83738_length_257_cov_2.250000_g83040_i0 | PRJNA734348 | 83738 | 257 | 2.25 | 5.7825 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 133 | 4.97e-35 | NR | MEW6516007.1 | 2052330 | g83040 | i0 | 71.1 | 2.90661478599222 | 83 | 24 | 96.9 | 0 | 250 | 2 | 310 | 392 | MEW6516007.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [candidate division FCPU426 bacterium] | diamond | 747 | 133 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27021618 | 27021618 | PRJNA767802_P_NODE_4522_length_397_cov_6.307471_g4449_i0 | PRJNA767802 | 4522 | 397 | 6.307471 | 25.04065987 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 73.9 | 4.19e-14 | NR | MES2201120.1 | 2052330 | g4449 | i0 | 44.3 | 0.596977329974811 | 79 | 43 | 58.9 | 1 | 257 | 24 | 1 | 79 | MES2201120.1 hypothetical protein [candidate division FCPU426 bacterium] | diamond | 237 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27159307 | 27159307 | PRJEB17675_P_NODE_24162_length_155_cov_1.000000_g23858_i0 | PRJEB17675 | 24162 | 155 | 1 | 1.55 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 69.7 | 3.36e-12 | NR | MEW6515625.1 | 2052330 | g23858 | i0 | 70.6 | 8.88387096774194 | 51 | 15 | 98.7 | 0 | 2 | 154 | 249 | 299 | MEW6515625.1 ammonium transporter [candidate division FCPU426 bacterium] | diamond | 1377 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27406514 | 27406514 | PRJNA1002570_P_NODE_40743_length_245_cov_1.366279_g40548_i0 | PRJNA1002570 | 40743 | 245 | 1.366279 | 3.34738355 | Bacillati | 1783272 | Bacteria | Bacteria | 87.4 | 1.43e-18 | NR | MEW6515962.1 | 2052330 | g40548 | i0 | 53.1 | 4.95918367346939 | 81 | 38 | 99.2 | 0 | 2 | 244 | 33 | 113 | MEW6515962.1 ABC transporter permease [candidate division FCPU426 bacterium] | diamond | 1215 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27623835 | 27623835 | PRJNA849822_P_NODE_3684_length_841_cov_3.118490_g3525_i0 | PRJNA849822 | 3684 | 841 | 3.11849 | 26.2265009 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 84.7 | 6.44e-17 | NR | MBN1594640.1 | 2052330 | g3525 | i0 | 45.5 | 0.62782401902497 | 88 | 45 | 31.4 | 1 | 88 | 351 | 4 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 528 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27690990 | 27690990 | PRJNA1035005_P_NODE_4724_length_490_cov_3.052758_g4324_i0 | PRJNA1035005 | 4724 | 490 | 3.052758 | 14.9585142 | Bacteria | 2 | Bacteria | Bacteria | 124 | 3.26e-32 | NR | MBN1595395.1 | 2052330 | g4324 | i0 | 48.9 | 6.43469387755102 | 133 | 67 | 80.8 | 1 | 94 | 489 | 5 | 137 | MBN1595395.1 adenylate kinase [candidate division FCPU426 bacterium] | diamond | 3153 | 125 | 0.992 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27935150 | 27935150 | PRJNA688655_P_NODE_12705_length_245_cov_0.895349_g12640_i0 | PRJNA688655 | 12705 | 245 | 0.895349 | 2.19360505 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 61.2 | 1.17e-8 | NR | MES2201089.1 | 2052330 | g12640 | i0 | 39 | 0.942857142857143 | 77 | 47 | 94.3 | 0 | 5 | 235 | 670 | 746 | MES2201089.1 tetratricopeptide repeat protein [candidate division FCPU426 bacterium] | diamond | 231 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 28476415 | 28476415 | PRJNA874604_P_NODE_6106_length_663_cov_1.583051_g5777_i0 | PRJNA874604 | 6106 | 663 | 1.583051 | 10.49562813 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 85.1 | 1.33e-17 | NR | MBN1594640.1 | 2052330 | g5777 | i0 | 45.5 | 2.96380090497738 | 88 | 45 | 39.8 | 1 | 476 | 213 | 4 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 1965 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 29264314 | 29264314 | PRJNA799765_P_NODE_9209_length_164_cov_0.904348_g9099_i0 | PRJNA799765 | 9209 | 164 | 0.904348 | 1.48313072 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 49.3 | 6.27e-5 | NR | MBN1596038.1 | 2052330 | g9099 | i0 | 52.5 | 0.731707317073171 | 40 | 19 | 73.2 | 0 | 3 | 122 | 414 | 453 | MBN1596038.1 hypothetical protein [candidate division FCPU426 bacterium] | diamond | 120 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 29802464 | 29802464 | PRJNA876641_P_NODE_14671_length_256_cov_1.409836_g14597_i0 | PRJNA876641 | 14671 | 256 | 1.409836 | 3.60918016 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 70.5 | 1.17e-13 | NR | MBN1594640.1 | 2052330 | g14597 | i0 | 44.4 | 1.6875 | 72 | 37 | 84.4 | 1 | 2 | 217 | 20 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 432 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 30339949 | 30339949 | PRJNA857143_S_NODE_120692_length_292_cov_0.990868_g119599_i0 | PRJNA857143 | 120692 | 292 | 0.990868 | 2.89333456 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 65.5 | 1.68e-11 | NR | MBN1594640.1 | 2052330 | g119599 | i0 | 46.9 | 0.657534246575342 | 64 | 34 | 65.8 | 0 | 61 | 252 | 4 | 67 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 192 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 30689077 | 30689077 | PRJNA951810_P_NODE_27073_length_386_cov_7.654952_g26731_i0 | PRJNA951810 | 27073 | 386 | 7.654952 | 29.54811472 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 94 | 3.08e-21 | NR | MES2202614.1 | 2052330 | g26731 | i0 | 67.3 | 0.427461139896373 | 55 | 18 | 42.7 | 0 | 382 | 218 | 117 | 171 | MES2202614.1 cytochrome c [candidate division FCPU426 bacterium] | diamond | 165 | 94 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 30697913 | 30697913 | PRJNA1008624_P_NODE_35034_length_163_cov_0.912281_g34846_i0 | PRJNA1008624 | 35034 | 163 | 0.912281 | 1.48701803 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 46.2 | 6.96e-4 | NR | MES2201243.1 | 2052330 | g34846 | i0 | 47.6 | 0.773006134969325 | 42 | 22 | 77.3 | 0 | 127 | 2 | 139 | 180 | MES2201243.1 hypothetical protein [candidate division FCPU426 bacterium] | diamond | 126 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 32908420 | 32908420 | PRJEB14175_P_NODE_131537_length_301_cov_14.662500_g129270_i0 | PRJEB14175 | 131537 | 301 | 14.6625 | 44.134125 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 78.6 | 1.59e-14 | NR | MES2202144.1 | 2052330 | g129270 | i0 | 50.7 | 0.747508305647841 | 75 | 36 | 73.8 | 1 | 36 | 257 | 301 | 375 | MES2202144.1 hypothetical protein [candidate division FCPU426 bacterium] | diamond | 225 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 33058592 | 33058592 | PRJNA816047d_S_NODE_45285_length_325_cov_1.238971_g43450_i0 | PRJNA816047 | 45285 | 325 | 1.238971 | 4.02665575 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 66.2 | 5.28e-10 | NR | MEW6517312.1 | 2052330 | g43450 | i0 | 43.5 | 0.784615384615385 | 85 | 48 | 78.5 | 0 | 263 | 9 | 164 | 248 | MEW6517312.1 FliI/YscN family ATPase [candidate division FCPU426 bacterium] | diamond | 255 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 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);;