contig_metadata
7 rows where analysis = "blastn", 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 |
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);;