contig_metadata
7 rows where bioproject = "PRJEB20058", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26058349 | 26058349 | PRJEB20058_P_NODE_131421_length_343_cov_6.226950_g128602_i0 | PRJEB20058 | 131421 | 343 | 6.22695 | 21.3584385 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 209 | 1.82e-49 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g128602 | i0 | 82.5 | 0.699708454810496 | 240 | 40 | 70 | 2 | 20 | 258 | 37857 | 38095 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 240 | 209 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 32922889 | 32922889 | PRJEB20058_P_NODE_27513_length_798_cov_1.978290_g25167_i0 | PRJEB20058 | 27513 | 798 | 1.97829 | 15.7867542 | Bacteria | 2 | Bacteria | Bacteria | 51.2 | 0.00313 | NR | RAL57825.1 | 1912928 | g25167 | i0 | 23.8 | 1.36842105263158 | 181 | 129 | 67.3 | 3 | 254 | 790 | 760 | 933 | RAL57825.1 hypothetical protein BLD25_00510 [Candidatus Gracilibacteria bacterium GN02-872] | diamond | 1092 | 51.6 | 0.992248062015504 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-872 | ||||||
| 32928455 | 32928455 | PRJEB20058_P_NODE_44897_length_627_cov_162.602473_g42211_i0 | PRJEB20058 | 44897 | 627 | 162.602473 | 1019.51750571 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 113 | 6.190000000000001e-27 | NR | ATU04884.1 | 1540872 | g42211 | i0 | 61.4 | 0.421052631578947 | 88 | 34 | 42.1 | 0 | 178 | 441 | 2 | 89 | ATU04884.1 hypothetical protein BKN14_00300 [Candidatus Gracilibacteria bacterium HOT-871] | diamond | 264 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 32962390 | 32962390 | PRJEB20058_P_NODE_184986_length_270_cov_6.086124_g182163_i0 | PRJEB20058 | 184986 | 270 | 6.086124 | 16.4325348 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 115 | 2.49e-30 | NR | MBX9808981.1 | 2044595 | g182163 | i0 | 64.4 | 0.966666666666667 | 87 | 30 | 95.6 | 1 | 2 | 259 | 5 | 91 | MBX9808981.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 261 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 33116339 | 33116339 | PRJEB20058_P_NODE_69647_length_499_cov_18.367580_g66876_i0 | PRJEB20058 | 69647 | 499 | 18.36758 | 91.6542242 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 60.8 | 2.66e-7 | NR | MBP7822810.1 | 2044595 | g66876 | i0 | 70 | 0.583166332665331 | 50 | 14 | 29.5 | 1 | 173 | 27 | 1024 | 1073 | MBP7822810.1 DNA polymerase III subunit alpha [Candidatus Altimarinota bacterium] | diamond | 291 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 33116489 | 33116489 | PRJEB20058_P_NODE_94631_length_421_cov_1.422222_g91830_i0 | PRJEB20058 | 94631 | 421 | 1.422222 | 5.98755462 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 180 | 2.87e-53 | NR | MBP7806662.1 | 2044595 | g91830 | i0 | 77.8 | 0.769596199524941 | 108 | 24 | 77 | 0 | 325 | 2 | 56 | 163 | MBP7806662.1 phosphodiester glycosidase family protein [Candidatus Altimarinota bacterium] | diamond | 324 | 180 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 33132834 | 33132834 | PRJEB20058_P_NODE_174391_length_282_cov_4.389140_g171568_i0 | PRJEB20058 | 174391 | 282 | 4.38914 | 12.3773748 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 95.5 | 3.67e-22 | NR | MFA6080654.1 | 2044595 | g171568 | i0 | 60.8 | 0.840425531914894 | 79 | 29 | 84 | 1 | 245 | 9 | 120 | 196 | MFA6080654.1 sigma-70 family RNA polymerase sigma factor [Candidatus Altimarinota bacterium] | diamond | 237 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;