contig_metadata
12 rows where bioproject = "PRJEB11748" and tax_phylum = "Candidatus Latescibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14853 | 14853 | PRJEB11748_P_NODE_150101_length_335_cov_3.124088_g147920_i0 | PRJEB11748 | 150101 | 335 | 3.124088 | 10.4656948 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 172 | 2.32e-38 | NTclustered | gi|2891482400|emb|OZ220090.1| | 2053570 | g147920 | i0 | 77.632 | 42.289552238806 | 304 | 54 | 88 | 11 | 32 | 327 | 626093 | 625796 | MAG: Candidatus Latescibacterota bacterium isolate 4e2a754f-172e-45f6-b93c-83e01e84db49 genome assembly, chromosome: 2 | blastn | 14167 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 6395911 | 6395911 | PRJEB11748_P_NODE_303366_length_218_cov_1.605096_g301183_i0 | PRJEB11748 | 303366 | 218 | 1.605096 | 3.49910928 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 119 | 1.87e-22 | NTclustered | gi|2108033339|gb|CP070763.1| | 2053570 | g301183 | i0 | 82.143 | 0.642201834862385 | 140 | 23 | 64 | 2 | 1 | 139 | 2081835 | 2081697 | MAG: Candidatus Latescibacterota bacterium isolate bin260 chromosome | blastn | 140 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 12463620 | 12463620 | PRJEB11748_P_NODE_338730_length_203_cov_1.633803_g336547_i0 | PRJEB11748 | 338730 | 203 | 1.633803 | 3.31662009 | Bacteria | 2 | Bacteria | Bacteria | 121 | 4.78e-23 | NTclustered | gi|2518550840|emb|OX638317.1| | 199737 | g336547 | i0 | 91.86 | 47.2906403940887 | 86 | 7 | 42 | 0 | 89 | 174 | 5013940 | 5014025 | MAG: uncultured Latescibacteria bacterium isolate cbbe8a84-e08a-4d06-a76e-2eb930d8ff24 genome assembly, chromosome: 1 | blastn | 9600 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 20414419 | 20414419 | PRJEB11748_P_NODE_100397_length_417_cov_2.264045_g98227_i0 | PRJEB11748 | 100397 | 417 | 2.264045 | 9.44106765 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 115 | 5.040000000000001e-21 | NTclustered | gi|2874254090|emb|OY970173.1| | 2053570 | g98227 | i0 | 77.612 | 6.01438848920863 | 201 | 38 | 47 | 7 | 199 | 395 | 745670 | 745473 | MAG: Candidatus Latescibacteria bacterium isolate MFD02242.bin.1.32 genome assembly, chromosome: 1 | blastn | 2508 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 20414614 | 20414614 | PRJEB11748_P_NODE_108897_length_399_cov_6.387574_g106723_i0 | PRJEB11748 | 108897 | 399 | 6.387574 | 25.48642026 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 158 | 7.87e-34 | NTclustered | gi|2893358441|emb|OZ220733.1| | 2053570 | g106723 | i0 | 75.134 | 2.63659147869674 | 374 | 73 | 90 | 18 | 4 | 364 | 4163348 | 4162982 | MAG: Candidatus Latescibacterota bacterium isolate cc6a1995-d657-4e87-88a0-a2308bb9e8e7 genome assembly, chromosome: 1 | blastn | 1052 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 24244307 | 24244307 | PRJEB11748_P_NODE_340820_length_202_cov_2.482270_g338637_i0 | PRJEB11748 | 340820 | 202 | 2.48227 | 5.0141854 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 113 | 7.95e-21 | NTclustered | gi|2874254090|emb|OY970173.1| | 2053570 | g338637 | i0 | 82.576 | 1.85148514851485 | 132 | 20 | 64 | 2 | 11 | 139 | 674316 | 674447 | MAG: Candidatus Latescibacteria bacterium isolate MFD02242.bin.1.32 genome assembly, chromosome: 1 | blastn | 374 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 25209603 | 25209603 | PRJEB11748_P_NODE_206460_length_278_cov_5.377880_g204277_i0 | PRJEB11748 | 206460 | 278 | 5.37788 | 14.9505064 | FCB group | 1783270 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2531976020|emb|OY282352.1| | 199737 | g204277 | i0 | 96.875 | 7.02517985611511 | 32 | 1 | 12 | 0 | 197 | 228 | 3725702 | 3725733 | MAG: uncultured Latescibacteria bacterium genome assembly, chromosome: 1 | blastn | 1953 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 27285771 | 27285771 | PRJEB11748_P_NODE_351543_length_197_cov_2.992647_g349360_i0 | PRJEB11748 | 351543 | 197 | 2.992647 | 5.89551459 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 92 | 5.29e-20 | NR | MSR82164.1 | 2053570 | g349360 | i0 | 76.4 | 1.65989847715736 | 55 | 13 | 83.8 | 0 | 18 | 182 | 142 | 196 | MSR82164.1 FtsX-like permease family protein [Candidatus Latescibacterota bacterium] | diamond | 327 | 92 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 27948894 | 27948894 | PRJEB11748_P_NODE_245165_length_250_cov_1.851852_g242982_i0 | PRJEB11748 | 245165 | 250 | 1.851852 | 4.62963 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 71.6 | 9.37e-13 | NR | HCP99413.1 | 2053570 | g242982 | i0 | 48.6 | 1.716 | 72 | 35 | 85.2 | 2 | 234 | 22 | 11 | 81 | HCP99413.1 hypothetical protein [Candidatus Latescibacterota bacterium] | diamond | 429 | 71.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 28896093 | 28896093 | PRJEB11748_P_NODE_59128_length_553_cov_4.583333_g56998_i0 | PRJEB11748 | 59128 | 553 | 4.583333 | 25.34583149 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 220 | 2.7099999999999998e-67 | NR | MSR82125.1 | 2053570 | g56998 | i0 | 86.8 | 0.656419529837251 | 121 | 16 | 65.6 | 0 | 23 | 385 | 272 | 392 | MSR82125.1 aminopeptidase P family protein [Candidatus Latescibacterota bacterium] | diamond | 363 | 220 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 30475441 | 30475441 | PRJEB11748_P_NODE_83893_length_458_cov_3.085642_g81728_i0 | PRJEB11748 | 83893 | 458 | 3.085642 | 14.13224036 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 54.3 | 2.81e-5 | NR | MFC1552251.1 | 2053570 | g81728 | i0 | 37.3 | 0.38646288209607 | 59 | 36 | 38.6 | 1 | 438 | 262 | 284 | 341 | MFC1552251.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Latescibacterota bacterium] | diamond | 177 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 30791248 | 30791248 | PRJEB11748_P_NODE_388694_length_173_cov_5.562500_g386511_i0 | PRJEB11748 | 388694 | 173 | 5.5625 | 9.623125 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 52.4 | 2.79e-6 | NR | MSR84724.1 | 2053570 | g386511 | i0 | 65.1 | 0.745664739884393 | 43 | 7 | 60.7 | 1 | 116 | 12 | 38 | 80 | MSR84724.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Latescibacterota bacterium] | diamond | 129 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota 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);;