contig_metadata
13 rows where analysis = "diamond" and tax_phylum = "candidate division CPR1"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 392975 | 392975 | PRJNA342843_S_NODE_2021_length_576_cov_3.142056_g1874_i0 | PRJNA342843 | 2021 | 576 | 3.142056 | 18.09824256 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 254 | 7.39e-81 | NR | OQB40762.1 | 1852826 | g1874 | i0 | 80.3 | 0.817708333333333 | 157 | 29 | 81.8 | 1 | 498 | 28 | 1 | 155 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 471 | 254 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 8022185 | 8022185 | PRJNA255848_P_NODE_8007_length_376_cov_1.232416_g7689_i0 | PRJNA255848 | 8007 | 376 | 1.232416 | 4.63388416 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 204 | 2.01e-62 | NR | OQB40762.1 | 1852826 | g7689 | i0 | 82.3 | 0.98936170212766 | 124 | 20 | 98.9 | 1 | 374 | 3 | 44 | 165 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 372 | 204 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 10212236 | 10212236 | PRJDB4470_P_NODE_32149_length_401_cov_1.465909_g31001_i0 | PRJDB4470 | 32149 | 401 | 1.465909 | 5.87829509 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 131 | 6.249999999999999e-34 | NR | OQB40762.1 | 1852826 | g31001 | i0 | 84 | 1.12219451371571 | 75 | 12 | 56.1 | 0 | 175 | 399 | 90 | 164 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 450 | 131 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 24592003 | 24592003 | PRJNA177642_P_NODE_9660_length_367_cov_1.627219_g8440_i0 | PRJNA177642 | 9660 | 367 | 1.627219 | 5.97189373 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 194 | 2.13e-58 | NR | OQB40762.1 | 1852826 | g8440 | i0 | 77 | 0.997275204359673 | 122 | 28 | 99.7 | 0 | 367 | 2 | 81 | 202 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 366 | 194 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 27483026 | 27483026 | PRJNA1180292_P_NODE_7863_length_253_cov_0.866667_g7731_i0 | PRJNA1180292 | 7863 | 253 | 0.866667 | 2.19266751 | candidate division CPR1 bacterium GW2 | 1618338 | Bacteria | Bacteria | 148 | 7.83e-40 | NR | KKS44567.1 | 1618341 | g7731 | i0 | 79.8 | 2.98814229249012 | 84 | 17 | 99.6 | 0 | 252 | 1 | 275 | 358 | KKS44567.1 MAG: Recombinase [candidate division CPR1 bacterium GW2011_GWA2_42_17] | diamond | 756 | 148 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium GW2011_GWA2_42_17 | ||||||
| 28006084 | 28006084 | PRJEB11748_P_NODE_72025_length_497_cov_4.116972_g69876_i0 | PRJEB11748 | 72025 | 497 | 4.116972 | 20.46135084 | Bacillati | 1783272 | Bacteria | Bacteria | 143 | 4.78e-36 | NR | KKW05514.1 | 1618342 | g69876 | i0 | 59.6 | 3.80885311871227 | 104 | 42 | 62.8 | 0 | 185 | 496 | 678 | 781 | KKW05514.1 MAG: Terminase [candidate division CPR1 bacterium GW2011_GWC1_49_13] | diamond | 1893 | 144 | 0.993055555555556 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium GW2011_GWC1_49_13 | ||||||
| 28200515 | 28200515 | PRJNA946307_P_NODE_78506_length_195_cov_3.212329_g77632_i0 | PRJNA946307 | 78506 | 195 | 3.212329 | 6.26404155 | Bacteria | 2 | Bacteria | Bacteria | 65.9 | 1.72e-11 | NR | KKS42417.1 | 1618341 | g77632 | i0 | 93.8 | 6.01538461538462 | 32 | 2 | 49.2 | 0 | 98 | 3 | 72 | 103 | KKS42417.1 MAG: Recombinase, partial [candidate division CPR1 bacterium GW2011_GWA2_42_17] | diamond | 1173 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium GW2011_GWA2_42_17 | ||||||
| 28743317 | 28743317 | PRJNA1120060_P_NODE_3215407_length_230_cov_7.490446_g3197300_i0 | PRJNA1120060 | 3215407 | 230 | 7.490446 | 17.2280258 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 71.2 | 3.01e-14 | NR | OQB42268.1 | 1852826 | g3197300 | i0 | 68.6 | 0.665217391304348 | 51 | 16 | 66.5 | 0 | 1 | 153 | 23 | 73 | OQB42268.1 MAG: Tetratricopeptide repeat protein [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 153 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 29858934 | 29858934 | PRJNA611476_P_NODE_102851_length_245_cov_0.895349_g102060_i0 | PRJNA611476 | 102851 | 245 | 0.895349 | 2.19360505 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 46.2 | 8.14e-4 | NR | OQB40784.1 | 1852826 | g102060 | i0 | 43.9 | 0.808163265306122 | 66 | 36 | 79.6 | 1 | 206 | 12 | 1 | 66 | OQB40784.1 MAG: hypothetical protein BWY04_01203 [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 198 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 30853668 | 30853668 | PRJNA966993_P_NODE_50754_length_304_cov_1.978355_g50302_i0 | PRJNA966993 | 50754 | 304 | 1.978355 | 6.0141992 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.3 | 3.49e-9 | NR | OQB41255.1 | 1852826 | g50302 | i0 | 45.5 | 2.14144736842105 | 55 | 30 | 54.3 | 0 | 165 | 1 | 2 | 56 | OQB41255.1 MAG: 50S ribosomal protein L1 [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 651 | 59.7 | 0.993299832495812 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 30864987 | 30864987 | PRJNA385064_P_NODE_3534_length_232_cov_1.109290_g3409_i0 | PRJNA385064 | 3534 | 232 | 1.10929 | 2.5735528 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 117 | 2.4799999999999996e-29 | NR | OQB40762.1 | 1852826 | g3409 | i0 | 78.1 | 1.95258620689655 | 73 | 14 | 94.4 | 1 | 3 | 221 | 31 | 101 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 453 | 117 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 31075488 | 31075488 | PRJEB10140_P_NODE_95175_length_385_cov_1.267857_g77881_i0 | PRJEB10140 | 95175 | 385 | 1.267857 | 4.88124945 | candidate division CPR1 bacterium ADurb.Bin16 | 1618338 | Bacteria | Bacteria | 135 | 2.3499999999999997e-35 | NR | OQB40762.1 | 1852826 | g77881 | i0 | 74 | 0.748051948051948 | 96 | 21 | 73.2 | 3 | 284 | 3 | 16 | 109 | OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] | diamond | 288 | 135 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium ADurb.Bin160 | ||||||
| 32253266 | 32253266 | PRJNA1148190_P_NODE_659698_length_247_cov_0.885057_g648525_i0 | PRJNA1148190 | 659698 | 247 | 0.885057 | 2.18609079 | candidate division CPR1 bacterium GW2 | 1618338 | Bacteria | Bacteria | 110 | 8.59e-29 | NR | KKW06167.1 | 1618342 | g648525 | i0 | 90.7 | 0.65587044534413 | 54 | 5 | 65.6 | 0 | 1 | 162 | 74 | 127 | KKW06167.1 MAG: Methionine sulfoxide reductase (Peptide-methionine (R)-S-oxide reductase) [candidate division CPR1 bacterium GW2011_GWC1_49_13] | diamond | 162 | 110 | 1 | Bacteria | Bacteria candidate phyla | candidate division CPR1 | candidate division CPR1 bacterium GW2011_GWC1_49_13 |
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);;