contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA835051" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2101119 | 2101119 | PRJNA835051_S_NODE_133262_length_150_cov_1.327103_g132966_i0 | PRJNA835051 | 133262 | 150 | 1.327103 | 1.9906545 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.012 | NTclustered | gi|2906145171|gb|PQ646171.1| | 2832643 | g132966 | i0 | 100 | 0.186666666666667 | 28 | 0 | 19 | 0 | 62 | 89 | 43898 | 43871 | MAG: Caudoviricetes sp. isolate k127_374151 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2101417 | 2101417 | PRJNA835051_S_NODE_34102_length_242_cov_1.195980_g33806_i0 | PRJNA835051 | 34102 | 242 | 1.19598 | 2.8942716 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2053098917|tpg|BK020461.1| | 2832643 | g33806 | i0 | 100 | 0.119834710743802 | 29 | 0 | 12 | 0 | 208 | 236 | 85857 | 85885 | MAG TPA_asm: Caudoviricetes sp. isolate ct8Hk17, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4653933 | 4653933 | PRJNA835051_S_NODE_124184_length_154_cov_1.630631_g123888_i0 | PRJNA835051 | 124184 | 154 | 1.630631 | 2.51117174 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 285 | 1.14e-72 | NTclustered | gi|2915002188|gb|OR222317.1| | 2832643 | g123888 | i0 | 100 | 3.94155844155844 | 154 | 0 | 100 | 0 | 1 | 154 | 50749 | 50902 | MAG: Caudoviricetes sp. isolate MSP1091 genomic sequence | blastn | 607 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4654056 | 4654056 | PRJNA835051_S_NODE_14364_length_299_cov_1.675781_g14068_i0 | PRJNA835051 | 14364 | 299 | 1.675781 | 5.01058519 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 6.76e-98 | NTclustered | gi|2059992605|tpg|BK026306.1| | 2832643 | g14068 | i0 | 88.963 | 1 | 299 | 33 | 100 | 0 | 1 | 299 | 20598 | 20896 | MAG TPA_asm: Caudoviricetes sp. isolate ct5Vs3, partial genome | blastn | 299 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8478532 | 8478532 | PRJNA835051_S_NODE_14147_length_300_cov_1.657588_g13851_i0 | PRJNA835051 | 14147 | 300 | 1.657588 | 4.972764 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|557356596|dbj|AP013490.1| | 1407671 | g13851 | i0 | 96.774 | 0.103333333333333 | 31 | 1 | 10 | 0 | 16 | 46 | 11346 | 11316 | Uncultured Mediterranean phage uvMED DNA, complete genome, group G19, isolate: uvMED-CGR-C30B-MedDCM-OCT-S46-C80 | blastn | 31 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 16128240 | 16128240 | PRJNA835051_S_NODE_133313_length_150_cov_1.317757_g133017_i0 | PRJNA835051 | 133313 | 150 | 1.317757 | 1.9766355 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 67.6 | 4.36e-7 | NTclustered | gi|2915002964|gb|OR222328.1| | 2832643 | g133017 | i0 | 87.931 | 0.386666666666667 | 58 | 6 | 39 | 1 | 77 | 134 | 27140 | 27084 | MAG: Caudoviricetes sp. isolate MSP1077 genomic sequence | blastn | 58 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17404141 | 17404141 | PRJNA835051_S_NODE_2834_length_464_cov_4.866983_g2543_i0 | PRJNA835051 | 2834 | 464 | 4.866983 | 22.58280112 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 774 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g2543 | i0 | 96.767 | 404.463362068966 | 464 | 15 | 100 | 0 | 1 | 464 | 18299 | 17836 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 187671 | 774 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25052166 | 25052166 | PRJNA835051_S_NODE_33820_length_242_cov_2.381910_g33524_i0 | PRJNA835051 | 33820 | 242 | 2.38191 | 5.7642222 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2052189786|tpg|BK055894.1| | 2832643 | g33524 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 64 | 91 | 69624 | 69651 | MAG TPA_asm: Caudoviricetes sp. isolate ctubV7, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;