contig_metadata
12 rows where bioproject = "PRJNA255848" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 368670 | 368670 | PRJNA255848_P_NODE_33901_length_170_cov_1.264463_g33583_i0 | PRJNA255848 | 33901 | 170 | 1.264463 | 2.1495871 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 265 | 1.68e-66 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g33583 | i0 | 94.706 | 213.158823529412 | 170 | 9 | 100 | 0 | 1 | 170 | 962288 | 962457 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 36237 | 265 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 1643547 | 1643547 | PRJNA255848_P_NODE_44682_length_162_cov_1.318584_g44364_i0 | PRJNA255848 | 44682 | 162 | 1.318584 | 2.13610608 | Candidatus Saccharibacteria bacterium RAAC3_TM7_1 | 1394711 | Bacteria | Bacteria | 220 | 3.49e-53 | NTclustered | gi|563353835|gb|CP006915.1| | 1394711 | g44364 | i0 | 91.824 | 360.469135802469 | 159 | 11 | 98 | 2 | 5 | 162 | 450319 | 450162 | Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome | blastn | 58396 | 220 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RAAC3_TM7_1 | ||||||
| 4195770 | 4195770 | PRJNA255848_P_NODE_21624_length_214_cov_1.539394_g21306_i0 | PRJNA255848 | 21624 | 214 | 1.539394 | 3.29430316 | Bacteria | 2 | Bacteria | Bacteria | 140 | 1.58e-38 | NR | MCL5011141.1 | 2052139 | g21306 | i0 | 84.1 | 9.67289719626168 | 69 | 11 | 96.7 | 0 | 6 | 212 | 182 | 250 | MCL5011141.1 helix-turn-helix domain-containing protein [Patescibacteria group bacterium] | diamond | 2070 | 140 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 8022119 | 8022119 | PRJNA255848_P_NODE_37207_length_166_cov_0.871795_g36889_i0 | PRJNA255848 | 37207 | 166 | 0.871795 | 1.4471797 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 296 | 5.82e-76 | NTclustered | gi|2070571752|gb|CP072208.2| | 2725942 | g36889 | i0 | 98.795 | 71.9096385542169 | 166 | 2 | 100 | 0 | 1 | 166 | 113046 | 112881 | MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome | blastn | 11937 | 296 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 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 | ||||||
| 14397692 | 14397692 | PRJNA255848_P_NODE_26512_length_193_cov_1.729167_g26194_i0 | PRJNA255848 | 26512 | 193 | 1.729167 | 3.33729231 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 313 | 6.91e-81 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g26194 | i0 | 95.855 | 126.295336787565 | 193 | 8 | 100 | 0 | 1 | 193 | 850677 | 850869 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 24375 | 313 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 19494621 | 19494621 | PRJNA255848_P_NODE_41096_length_164_cov_0.886957_g40778_i0 | PRJNA255848 | 41096 | 164 | 0.886957 | 1.45460948 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 265 | 1.6199999999999998e-66 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g40778 | i0 | 95.732 | 127.115853658537 | 164 | 7 | 100 | 0 | 1 | 164 | 667477 | 667640 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 20847 | 265 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 23320662 | 23320662 | PRJNA255848_P_NODE_18139_length_234_cov_1.091892_g17821_i0 | PRJNA255848 | 18139 | 234 | 1.091892 | 2.55502728 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 320 | 5.1999999999999994e-83 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g17821 | i0 | 91.453 | 62.0470085470085 | 234 | 19 | 100 | 1 | 1 | 234 | 883918 | 884150 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 14519 | 320 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27073993 | 27073993 | PRJNA255848_P_NODE_5682_length_463_cov_1.367150_g5365_i0 | PRJNA255848 | 5682 | 463 | 1.36715 | 6.3299045 | Candidatus Microgenomates bacterium | 2093373 | Bacteria | Bacteria | 47.4 | 0.00786 | NR | RJQ35878.1 | 2093373 | g5365 | i0 | 33.3 | 0.660907127429806 | 102 | 51 | 55.1 | 2 | 461 | 207 | 126 | 227 | RJQ35878.1 MAG: hypothetical protein C4559_05970 [Candidatus Microgenomates bacterium] | diamond | 306 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Microgenomatota | Candidatus Microgenomates bacterium | ||||||
| 27737723 | 27737723 | PRJNA255848_P_NODE_35904_length_167_cov_0.864407_g35586_i0 | PRJNA255848 | 35904 | 167 | 0.864407 | 1.44355969 | Candidatus Hydrothermia bacterium | 3014280 | Bacteria | Bacteria | 86.3 | 1.24e-18 | NR | HOP33351.1 | 3014280 | g35586 | i0 | 66.7 | 0.970059880239521 | 54 | 18 | 97 | 0 | 2 | 163 | 68 | 121 | HOP33351.1 DNA adenine methylase [Candidatus Hydrothermia bacterium] | diamond | 162 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Hydrothermota | Candidatus Hydrothermia | Candidatus Hydrothermia bacterium | |||||
| 29032173 | 29032173 | PRJNA255848_P_NODE_19088_length_228_cov_0.921788_g18770_i0 | PRJNA255848 | 19088 | 228 | 0.921788 | 2.10167664 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 44.3 | 0.00286 | NR | HEX9409770.1 | 2072417 | g18770 | i0 | 33.9 | 1.55263157894737 | 59 | 37 | 77.6 | 1 | 47 | 223 | 54 | 110 | HEX9409770.1 RidA family protein [Candidatus Methylomirabilota bacterium] | diamond | 354 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31812417 | 31812417 | PRJNA255848_P_NODE_26057_length_195_cov_1.280822_g25739_i0 | PRJNA255848 | 26057 | 195 | 1.280822 | 2.4976029 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 44.3 | 0.00475 | NR | MEK7184073.1 | 2052139 | g25739 | i0 | 40.6 | 0.984615384615385 | 64 | 28 | 96.9 | 2 | 195 | 7 | 97 | 151 | MEK7184073.1 dTMP kinase [Patescibacteria group bacterium] | diamond | 192 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;