contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8087272 | 8087272 | PRJNA438111_P_NODE_29907_length_210_cov_4.414365_g29282_i0 | PRJNA438111 | 29907 | 210 | 4.414365 | 9.2701665 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 55.8 | 5.71e-7 | NR | MBB1557050.1 | 2044938 | g29282 | i0 | 96.9 | 0.457142857142857 | 32 | 1 | 45.7 | 0 | 2 | 97 | 823 | 854 | MBB1557050.1 DNA gyrase subunit A [candidate division SR1 bacterium] | diamond | 96 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 27928810 | 27928810 | PRJNA438111_P_NODE_52525_length_179_cov_1.893333_g51900_i0 | PRJNA438111 | 52525 | 179 | 1.893333 | 3.38906607 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 65.1 | 1.91e-10 | NR | MBB1557000.1 | 2044938 | g51900 | i0 | 96.6 | 0.486033519553073 | 29 | 1 | 48.6 | 0 | 2 | 88 | 288 | 316 | MBB1557000.1 hypothetical protein [candidate division SR1 bacterium] | diamond | 87 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 28244330 | 28244330 | PRJNA438111_P_NODE_43066_length_190_cov_1.962733_g42441_i0 | PRJNA438111 | 43066 | 190 | 1.962733 | 3.7291927 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 83.2 | 3.65e-17 | NR | MBF0931826.1 | 2044938 | g42441 | i0 | 97.6 | 0.647368421052632 | 41 | 1 | 64.7 | 0 | 6 | 128 | 1 | 41 | MBF0931826.1 hypothetical protein [candidate division SR1 bacterium] | diamond | 123 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 29444093 | 29444093 | PRJNA438111_P_NODE_49690_length_182_cov_2.215686_g49065_i0 | PRJNA438111 | 49690 | 182 | 2.215686 | 4.03254852 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 123 | 2.6399999999999997e-32 | NR | MBB1578652.1 | 2044938 | g49065 | i0 | 95 | 2.96703296703297 | 60 | 3 | 98.9 | 0 | 3 | 182 | 93 | 152 | MBB1578652.1 thymidylate synthase [candidate division SR1 bacterium] | diamond | 540 | 123 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 30012918 | 30012918 | PRJNA438111_P_NODE_66971_length_166_cov_4.649635_g66346_i0 | PRJNA438111 | 66971 | 166 | 4.649635 | 7.7183941 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 102 | 1.78e-25 | NR | MBB1557121.1 | 2044938 | g66346 | i0 | 100 | 0.975903614457831 | 54 | 0 | 97.6 | 0 | 164 | 3 | 94 | 147 | MBB1557121.1 30S ribosomal protein S3 [candidate division SR1 bacterium] | diamond | 162 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 30360762 | 30360762 | PRJNA438111_P_NODE_29592_length_210_cov_4.546961_g28967_i0 | PRJNA438111 | 29592 | 210 | 4.546961 | 9.5486181 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 52.4 | 9.94e-6 | NR | MBB1543409.1 | 2044938 | g28967 | i0 | 37.7 | 1.51428571428571 | 106 | 29 | 98.6 | 1 | 210 | 4 | 594 | 699 | MBB1543409.1 hypothetical protein [candidate division SR1 bacterium] | diamond | 318 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 30992339 | 30992339 | PRJNA438111_P_NODE_73494_length_162_cov_3.000000_g72869_i0 | PRJNA438111 | 73494 | 162 | 3 | 4.86 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 101 | 8.939999999999997e-24 | NR | MBB1578729.1 | 2044938 | g72869 | i0 | 98.1 | 1.96296296296296 | 53 | 1 | 98.1 | 0 | 3 | 161 | 178 | 230 | MBB1578729.1 HAMP domain-containing histidine kinase [candidate division SR1 bacterium] | diamond | 318 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 31877479 | 31877479 | PRJNA438111_P_NODE_78977_length_158_cov_5.465116_g78352_i0 | PRJNA438111 | 78977 | 158 | 5.465116 | 8.63488328 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 104 | 2.9100000000000004e-26 | NR | MBB1557121.1 | 2044938 | g78352 | i0 | 100 | 1.9746835443038 | 52 | 0 | 98.7 | 0 | 157 | 2 | 146 | 197 | MBB1557121.1 30S ribosomal protein S3 [candidate division SR1 bacterium] | diamond | 312 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 32257640 | 32257640 | PRJNA438111_P_NODE_27778_length_210_cov_6.646409_g27153_i0 | PRJNA438111 | 27778 | 210 | 6.646409 | 13.9574589 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 61.2 | 7.16e-9 | NR | MBB1557479.1 | 2044938 | g27153 | i0 | 87.9 | 0.471428571428571 | 33 | 4 | 47.1 | 0 | 100 | 2 | 461 | 493 | MBB1557479.1 penicillin-binding protein 2 [candidate division SR1 bacterium] | diamond | 99 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 32352498 | 32352498 | PRJNA438111_P_NODE_65419_length_167_cov_5.000000_g64794_i0 | PRJNA438111 | 65419 | 167 | 5 | 8.35 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 94.4 | 8.790000000000001e-21 | NR | MBB1556924.1 | 2044938 | g64794 | i0 | 97.9 | 0.844311377245509 | 47 | 1 | 84.4 | 0 | 165 | 25 | 448 | 494 | MBB1556924.1 type I restriction endonuclease subunit R [candidate division SR1 bacterium] | diamond | 141 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 32731182 | 32731182 | PRJNA438111_P_NODE_29760_length_210_cov_4.475138_g29135_i0 | PRJNA438111 | 29760 | 210 | 4.475138 | 9.3977898 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 92 | 2.77e-20 | NR | MBB1578744.1 | 2044938 | g29135 | i0 | 86.2 | 0.828571428571429 | 58 | 6 | 80 | 1 | 43 | 210 | 185 | 242 | MBB1578744.1 glycosyltransferase [candidate division SR1 bacterium] | diamond | 174 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 32857016 | 32857016 | PRJNA438111_P_NODE_33340_length_209_cov_3.600000_g32715_i0 | PRJNA438111 | 33340 | 209 | 3.6 | 7.524 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 65.5 | 1.3e-10 | NR | MBF0932153.1 | 2044938 | g32715 | i0 | 73.3 | 1.56459330143541 | 45 | 12 | 64.6 | 0 | 73 | 207 | 40 | 84 | MBF0932153.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase GatCAB subunit A [candidate division SR1 bacterium] | diamond | 327 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 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);;