contig_metadata
11 rows where bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1881584 | 1881584 | PRJNA635397_P_NODE_11442_length_508_cov_1.940230_g10989_i0 | PRJNA635397 | 11442 | 508 | 1.94023 | 9.8563684 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 822 | 0 | NTclustered | gi|1958122490|gb|CP065015.1| | 2026720 | g10989 | i0 | 95.89 | 226.403543307087 | 511 | 15 | 100 | 6 | 1 | 508 | 511896 | 511389 | Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome | blastn | 115013 | 822 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 5709667 | 5709667 | PRJNA635397_P_NODE_46305_length_242_cov_1.372781_g45851_i0 | PRJNA635397 | 46305 | 242 | 1.372781 | 3.32213002 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 442 | 1.1099999999999995e-119 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g45851 | i0 | 99.587 | 294.07438016528903 | 242 | 1 | 100 | 0 | 1 | 242 | 138842 | 139083 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 71166 | 442 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 8806616 | 8806616 | PRJNA635397_P_NODE_24007_length_326_cov_2.166008_g23553_i0 | PRJNA635397 | 24007 | 326 | 2.166008 | 7.06118608 | Bacteria | 2 | Bacteria | Bacteria | 603 | 6.749999999999998e-168 | NTclustered | gi|402243568|gb|JX294354.1| | 1226340 | g23553 | i0 | 100 | 86.4110429447853 | 326 | 0 | 100 | 0 | 1 | 326 | 1136 | 1461 | GN02 bacterium oral taxon 873 clone 4Q04 16S ribosomal RNA gene, partial sequence | blastn | 28170 | 603 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium oral taxon 873 | ||||||
| 8806658 | 8806658 | PRJNA635397_P_NODE_34547_length_269_cov_2.071429_g34093_i0 | PRJNA635397 | 34547 | 269 | 2.071429 | 5.57214401 | Bacteria | 2 | Bacteria | Bacteria | 497 | 2.63e-136 | NTclustered | gi|402243568|gb|JX294354.1| | 1226340 | g34093 | i0 | 100 | 97.2453531598513 | 269 | 0 | 100 | 0 | 1 | 269 | 1066 | 798 | GN02 bacterium oral taxon 873 clone 4Q04 16S ribosomal RNA gene, partial sequence | blastn | 26159 | 497 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Gracilibacteria bacterium oral taxon 873 | ||||||
| 17731563 | 17731563 | PRJNA635397_P_NODE_16954_length_398_cov_1.458462_g16500_i0 | PRJNA635397 | 16954 | 398 | 1.458462 | 5.80467876 | Candidatus Southlakia | 3350975 | Bacteria | Bacteria | 649 | 0 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g16500 | i0 | 96 | 72.3643216080402 | 400 | 14 | 100 | 2 | 1 | 398 | 906677 | 906278 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 28801 | 649 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 18458082 | 18458082 | PRJNA635397_P_NODE_45895_length_243_cov_0.911765_g45441_i0 | PRJNA635397 | 45895 | 243 | 0.911765 | 2.21558895 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 444 | 3.09e-120 | NTclustered | gi|2890901196|gb|CP128407.1| | 713059 | g45441 | i0 | 99.588 | 10.9917695473251 | 243 | 1 | 100 | 0 | 1 | 243 | 391415 | 391657 | Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome | blastn | 2671 | 444 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 19732234 | 19732234 | PRJNA635397_P_NODE_20956_length_352_cov_0.910394_g20502_i0 | PRJNA635397 | 20956 | 352 | 0.910394 | 3.20458688 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 560 | 4.47e-155 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g20502 | i0 | 95.467 | 402.40625 | 353 | 13 | 100 | 3 | 1 | 352 | 150727 | 150377 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 141647 | 560 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 28975823 | 28975823 | PRJNA635397_P_NODE_30008_length_290_cov_1.437788_g29554_i0 | PRJNA635397 | 30008 | 290 | 1.437788 | 4.1695852 | Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_1 | 2099671 | Bacteria | Bacteria | 70.9 | 8.81e-12 | NR | OGG44698.1 | 1817868 | g29554 | i0 | 45.4 | 1.00344827586207 | 97 | 52 | 99.3 | 1 | 288 | 1 | 798 | 894 | OGG44698.1 MAG: hypothetical protein A3F84_28760 [Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10] | diamond | 291 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Handelsmaniibacteriota | Candidatus Handelsmanbacteria bacterium RIFCSPLOWO2_12_FULL_64_10 | ||||||
| 28975830 | 28975830 | PRJNA635397_P_NODE_41428_length_249_cov_0.886364_g40974_i0 | PRJNA635397 | 41428 | 249 | 0.886364 | 2.20704636 | Candidatus Nanosynbacter sp. | 2725945 | Bacteria | Bacteria | 126 | 2.8099999999999998e-34 | NR | MBF1034843.1 | 2725945 | g40974 | i0 | 96.8 | 0.759036144578313 | 63 | 2 | 75.9 | 0 | 3 | 191 | 148 | 210 | MBF1034843.1 hypothetical protein [Candidatus Nanosynbacter sp.] | diamond | 189 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. | ||
| 29386311 | 29386311 | PRJNA635397_P_NODE_35549_length_265_cov_2.375000_g35095_i0 | PRJNA635397 | 35549 | 265 | 2.375 | 6.29375 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 47 | 0.00137 | NR | RTL06913.1 | 2030827 | g35095 | i0 | 37.5 | 0.815094339622642 | 72 | 42 | 78.1 | 1 | 265 | 59 | 98 | 169 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 216 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 31325758 | 31325758 | PRJNA635397_P_NODE_45595_length_243_cov_1.082353_g45141_i0 | PRJNA635397 | 45595 | 243 | 1.082353 | 2.63011779 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.4 | 2.2e-5 | NR | MBN1695075.1 | 2052148 | g45141 | i0 | 41.5 | 2.2716049382716 | 53 | 31 | 65.4 | 0 | 164 | 6 | 22 | 74 | MBN1695075.1 Hsp20/alpha crystallin family protein [candidate division WOR-3 bacterium] | diamond | 552 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 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);;