contig_metadata
15 rows where bioproject = "PRJNA352850", tax_kingdom = "Pseudomonadati" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1670393 | 1670393 | PRJNA352850_P_NODE_44122_length_372_cov_3.024768_g41289_i0 | PRJNA352850 | 44122 | 372 | 3.024768 | 11.25213696 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 307 | 6.84e-79 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g41289 | i0 | 87.179 | 516.790322580645 | 273 | 32 | 73 | 2 | 1 | 272 | 2850965 | 2850695 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 192246 | 307 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 8048281 | 8048281 | PRJNA352850_P_NODE_21527_length_616_cov_6.199295_g18743_i0 | PRJNA352850 | 21527 | 616 | 6.199295 | 38.1876572 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 713 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g18743 | i0 | 89.138 | 278.965909090909 | 580 | 53 | 94 | 10 | 40 | 616 | 2851016 | 2851588 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 171843 | 713 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 10599682 | 10599682 | PRJNA352850_P_NODE_50769_length_337_cov_3.847222_g47936_i0 | PRJNA352850 | 50769 | 337 | 3.847222 | 12.96513814 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 177 | 1.7599999999999998e-52 | NR | MBV9866343.1 | 2800791 | g47936 | i0 | 75 | 1.98516320474777 | 112 | 28 | 99.7 | 0 | 337 | 2 | 30 | 141 | MBV9866343.1 xanthine dehydrogenase family protein subunit M [Abditibacteriaceae bacterium] | diamond | 669 | 177 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 18246370 | 18246370 | PRJNA352850_P_NODE_12815_length_901_cov_6.191315_g10319_i0 | PRJNA352850 | 12815 | 901 | 6.191315 | 55.78374815 | Bacteria | 2 | Bacteria | Bacteria | 266 | 8.670000000000001e-85 | NR | MDF2440612.1 | 2783868 | g10319 | i0 | 95.5 | 1.77136514983352 | 133 | 6 | 44.3 | 0 | 503 | 901 | 1 | 133 | MDF2440612.1 2-oxoglutarate/2-oxoacid ferredoxin oxidoreductase subunit beta [Abditibacteriota bacterium] | diamond | 1596 | 268 | 0.992537313432836 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 18246378 | 18246378 | PRJNA352850_P_NODE_12995_length_891_cov_6.045131_g10485_i0 | PRJNA352850 | 12995 | 891 | 6.045131 | 53.86211721 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 205 | 4.58e-60 | NR | MDF2441258.1 | 2783868 | g10485 | i0 | 69.4 | 0.451178451178451 | 134 | 41 | 45.1 | 0 | 489 | 890 | 1 | 134 | MDF2441258.1 twitching motility protein PilT [Abditibacteriota bacterium] | diamond | 402 | 205 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 23347309 | 23347309 | PRJNA352850_P_NODE_33779_length_449_cov_4.587500_g30949_i0 | PRJNA352850 | 33779 | 449 | 4.5875 | 20.597875 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 510 | 5.97e-140 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g30949 | i0 | 87.668 | 173.654788418708 | 446 | 45 | 98 | 8 | 9 | 448 | 2852025 | 2851584 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 77971 | 510 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27517200 | 27517200 | PRJNA352850_P_NODE_66203_length_279_cov_2.017391_g63370_i0 | PRJNA352850 | 66203 | 279 | 2.017391 | 5.62852089 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 130 | 1.17e-35 | NR | MDF2439576.1 | 2783868 | g63370 | i0 | 79.3 | 0.881720430107527 | 82 | 17 | 88.2 | 0 | 14 | 259 | 13 | 94 | MDF2439576.1 hypothetical protein [Abditibacteriota bacterium] | diamond | 246 | 130 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 28053832 | 28053832 | PRJNA352850_P_NODE_22225_length_602_cov_3.564195_g19435_i0 | PRJNA352850 | 22225 | 602 | 3.564195 | 21.4564539 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 350 | 2.53e-120 | NR | MDF2439721.1 | 2783868 | g19435 | i0 | 94.1 | 0.93687707641196 | 188 | 11 | 93.7 | 0 | 564 | 1 | 1 | 188 | MDF2439721.1 hypothetical protein [Abditibacteriota bacterium] | diamond | 564 | 350 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 28369609 | 28369609 | PRJNA352850_P_NODE_60666_length_297_cov_2.512097_g57833_i0 | PRJNA352850 | 60666 | 297 | 2.512097 | 7.46092809 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 73.2 | 4.26e-13 | NR | MDF2439840.1 | 2783868 | g57833 | i0 | 58.9 | 0.737373737373737 | 73 | 26 | 71.7 | 3 | 83 | 295 | 175 | 245 | MDF2439840.1 hypothetical protein [Abditibacteriota bacterium] | diamond | 219 | 73.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 28401273 | 28401273 | PRJNA352850_P_NODE_79986_length_249_cov_2.830000_g77153_i0 | PRJNA352850 | 79986 | 249 | 2.83 | 7.0467 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 103 | 2.99e-24 | NR | HEX8834404.1 | 2800791 | g77153 | i0 | 66.7 | 2.57831325301205 | 72 | 24 | 86.7 | 0 | 2 | 217 | 252 | 323 | HEX8834404.1 diguanylate cyclase [Abditibacteriaceae bacterium] | diamond | 642 | 103 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 28811390 | 28811390 | PRJNA352850_P_NODE_12648_length_910_cov_8.211382_g10163_i0 | PRJNA352850 | 12648 | 910 | 8.211382 | 74.7235762 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 328 | 6.94e-104 | NR | MBV9868269.1 | 2800791 | g10163 | i0 | 55.7 | 1.01208791208791 | 307 | 125 | 99.6 | 4 | 3 | 908 | 393 | 693 | MBV9868269.1 methionine--tRNA ligase [Abditibacteriaceae bacterium] | diamond | 921 | 328 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29096006 | 29096006 | PRJNA352850_P_NODE_46628_length_358_cov_4.932039_g43795_i0 | PRJNA352850 | 46628 | 358 | 4.932039 | 17.65669962 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 202 | 3.6699999999999997e-60 | NR | MDF2440154.1 | 2783868 | g43795 | i0 | 88.4 | 0.93854748603352 | 112 | 13 | 93.9 | 0 | 358 | 23 | 231 | 342 | MDF2440154.1 cellobiose epimerase [Abditibacteriota bacterium] | diamond | 336 | 202 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 29411548 | 29411548 | PRJNA352850_P_NODE_79969_length_249_cov_3.900000_g77136_i0 | PRJNA352850 | 79969 | 249 | 3.9 | 9.711 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 114 | 2.47e-27 | NR | MBV9864490.1 | 2800791 | g77136 | i0 | 71.3 | 1.04819277108434 | 87 | 15 | 98.8 | 3 | 248 | 3 | 553 | 634 | MBV9864490.1 S-layer homology domain-containing protein [Abditibacteriaceae bacterium] | diamond | 261 | 114 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31148628 | 31148628 | PRJNA352850_P_NODE_13295_length_876_cov_5.068924_g10767_i0 | PRJNA352850 | 13295 | 876 | 5.068924 | 44.40377424 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 333 | 6.629999999999999e-110 | NR | MDF2441225.1 | 2783868 | g10767 | i0 | 94.3 | 0.599315068493151 | 175 | 10 | 59.9 | 0 | 2 | 526 | 209 | 383 | MDF2441225.1 dehydrogenase [Abditibacteriota bacterium] | diamond | 525 | 333 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 32414501 | 32414501 | PRJNA352850_P_NODE_11779_length_959_cov_4.783516_g9354_i0 | PRJNA352850 | 11779 | 959 | 4.783516 | 45.87391844 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 273 | 4.33e-80 | NR | MDF2441722.1 | 2783868 | g9354 | i0 | 59.9 | 1.0385818561001 | 332 | 96 | 94.5 | 10 | 3 | 908 | 418 | 742 | MDF2441722.1 pilus assembly protein CpaC [Abditibacteriota bacterium] | diamond | 996 | 273 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota 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);;