contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Sungiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127379 | 127379 | PRJEB64798_P_NODE_173081_length_177_cov_5.648438_g171315_i0 | PRJEB64798 | 173081 | 177 | 5.648438 | 9.99773526 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 259 | 8.21e-65 | NTclustered | gi|1950816313|gb|CP066690.1| | 2750080 | g171315 | i0 | 95.152 | 89.3446327683616 | 165 | 6 | 93 | 2 | 5 | 168 | 679666 | 679503 | MAG: Candidatus Sungiibacteriota bacterium isolate NC_groundwater_541_Ag_S-0.1um_46_50 chromosome | blastn | 15814 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota bacterium | ||||||
| 9056896 | 9056896 | PRJEB64798_P_NODE_80988_length_214_cov_5.515152_g79222_i0 | PRJEB64798 | 80988 | 214 | 5.515152 | 11.80242528 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 220 | 4.88e-53 | NTclustered | gi|1950816313|gb|CP066690.1| | 2750080 | g79222 | i0 | 88.649 | 7.90654205607477 | 185 | 15 | 85 | 4 | 22 | 203 | 83643 | 83824 | MAG: Candidatus Sungiibacteriota bacterium isolate NC_groundwater_541_Ag_S-0.1um_46_50 chromosome | blastn | 1692 | 220 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota bacterium | ||||||
| 10329638 | 10329638 | PRJEB64798_P_NODE_116529_length_208_cov_4.880503_g114763_i0 | PRJEB64798 | 116529 | 208 | 4.880503 | 10.15144624 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 82.4 | 2.32e-11 | NTclustered | gi|1950816313|gb|CP066690.1| | 2750080 | g114763 | i0 | 84.706 | 0.408653846153846 | 85 | 10 | 40 | 3 | 119 | 202 | 80961 | 81043 | MAG: Candidatus Sungiibacteriota bacterium isolate NC_groundwater_541_Ag_S-0.1um_46_50 chromosome | blastn | 85 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota bacterium | ||||||
| 15429176 | 15429176 | PRJEB64798_P_NODE_128713_length_199_cov_2.353333_g126947_i0 | PRJEB64798 | 128713 | 199 | 2.353333 | 4.68313267 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 93.5 | 1.02e-14 | NTclustered | gi|1950816313|gb|CP066690.1| | 2750080 | g126947 | i0 | 93.651 | 0.597989949748744 | 63 | 3 | 32 | 1 | 67 | 129 | 84354 | 84415 | MAG: Candidatus Sungiibacteriota bacterium isolate NC_groundwater_541_Ag_S-0.1um_46_50 chromosome | blastn | 119 | 93.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota bacterium | ||||||
| 20528698 | 20528698 | PRJEB64798_P_NODE_195497_length_168_cov_15.487395_g193731_i0 | PRJEB64798 | 195497 | 168 | 15.487395 | 26.0188236 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 104 | 3.84e-18 | NTclustered | gi|1950816313|gb|CP066690.1| | 2750080 | g193731 | i0 | 81.6 | 1.24404761904762 | 125 | 23 | 74 | 0 | 9 | 133 | 81086 | 80962 | MAG: Candidatus Sungiibacteriota bacterium isolate NC_groundwater_541_Ag_S-0.1um_46_50 chromosome | blastn | 209 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota 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);;