contig_metadata
5 rows where bioproject = "PRJNA766854" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5848498 | 5848498 | PRJNA766854_P_NODE_2045_length_298_cov_4.386617_g1919_i0 | PRJNA766854 | 2045 | 298 | 4.386617 | 13.07211866 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 183 | 9.41e-42 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g1919 | i0 | 94.215 | 46.6677852348993 | 121 | 6 | 40 | 1 | 179 | 298 | 5636817 | 5636937 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 13907 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 7123707 | 7123707 | PRJNA766854_P_NODE_66_length_1007_cov_12.182004_g53_i0 | PRJNA766854 | 66 | 1007 | 12.182004 | 122.67278028 | Ruficoccus sp. ZRK36 | 2866311 | Bacteria | Bacteria | 542 | 4.97e-149 | NTclustered | gi|2080888260|gb|CP080649.1| | 2866311 | g53 | i0 | 80.397 | 141.98311817279 | 755 | 112 | 73 | 24 | 126 | 859 | 381788 | 381049 | Ruficoccus sp. ZRK36 chromosome, complete genome | blastn | 142977 | 542 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Ruficoccus | Ruficoccus sp. ZRK36 | |
| 9673422 | 9673422 | PRJNA766854_P_NODE_2088_length_295_cov_3.338346_g1962_i0 | PRJNA766854 | 2088 | 295 | 3.338346 | 9.8481207 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 183 | 9.309999999999998e-42 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g1962 | i0 | 94.215 | 47.1423728813559 | 121 | 6 | 41 | 1 | 176 | 295 | 5636817 | 5636937 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 13907 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 21147508 | 21147508 | PRJNA766854_P_NODE_2037_length_299_cov_3.203704_g1911_i0 | PRJNA766854 | 2037 | 299 | 3.203704 | 9.57907496 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 183 | 9.449999999999998e-42 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g1911 | i0 | 94.215 | 47.3612040133779 | 121 | 6 | 40 | 1 | 180 | 299 | 5636817 | 5636937 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 14161 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 22422245 | 22422245 | PRJNA766854_P_NODE_1578_length_330_cov_3.504983_g1453_i0 | PRJNA766854 | 1578 | 330 | 3.504983 | 11.5664439 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 183 | 1.06e-41 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g1453 | i0 | 94.215 | 39.1151515151515 | 121 | 6 | 36 | 1 | 211 | 330 | 5636817 | 5636937 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 12908 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus |
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);;