contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA663960" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904869 | 1904869 | PRJNA663960_S_NODE_37782_length_198_cov_1.456954_g37546_i0 | PRJNA663960 | 37782 | 198 | 1.456954 | 2.88476892 | Clostridium phage phiCT9441A | 1567014 | Viruses | Viruses | 113 | 7.76e-21 | NTclustered | gi|971821641|ref|NC_029022.1| | 1567014 | g37546 | i0 | 89.13 | 3.53030303030303 | 92 | 9 | 46 | 1 | 107 | 198 | 22673 | 22763 | Clostridium phage phiCT9441A, complete genome | blastn | 699 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Clostridium phage phiCT9441A | |||||
| 3179722 | 3179722 | PRJNA663960_S_NODE_4783_length_417_cov_11.337838_g4548_i0 | PRJNA663960 | 4783 | 417 | 11.337838 | 47.27878446 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 616 | 1.13e-171 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g4548 | i0 | 93.301 | 358.666666666667 | 418 | 26 | 100 | 2 | 1 | 417 | 17864 | 18280 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 149564 | 616 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5732255 | 5732255 | PRJNA663960_S_NODE_43305_length_185_cov_1.275362_g43069_i0 | PRJNA663960 | 43305 | 185 | 1.275362 | 2.3594197 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 337 | 3.89e-88 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g43069 | i0 | 99.459 | 6.42162162162162 | 185 | 1 | 100 | 0 | 1 | 185 | 7030 | 6846 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1188 | 337 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9557088 | 9557088 | PRJNA663960_S_NODE_15348_length_293_cov_1.239837_g15112_i0 | PRJNA663960 | 15348 | 293 | 1.239837 | 3.63272241 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 311 | 4.0600000000000005e-80 | NTclustered | gi|2057842709|tpg|BK055738.1| | 2832643 | g15112 | i0 | 87.879 | 1.62116040955631 | 264 | 32 | 90 | 0 | 30 | 293 | 30441 | 30178 | MAG TPA_asm: Caudoviricetes sp. isolate ct6kF3, partial genome | blastn | 475 | 311 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13382605 | 13382605 | PRJNA663960_S_NODE_1191_length_661_cov_2.817590_g1020_i0 | PRJNA663960 | 1191 | 661 | 2.81759 | 18.6242699 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 6.05e-62 | NTclustered | gi|2054596226|tpg|BK021635.1| | 2832643 | g1020 | i0 | 79.348 | 3.70499243570348 | 368 | 69 | 56 | 4 | 4 | 370 | 13327 | 13688 | MAG TPA_asm: Caudoviricetes sp. isolate ctG972, partial genome | blastn | 2449 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21031207 | 21031207 | PRJNA663960_S_NODE_31197_length_217_cov_2.311765_g30961_i0 | PRJNA663960 | 31197 | 217 | 2.311765 | 5.01653005 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.6499999999999994e-107 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g30961 | i0 | 100 | 3.95852534562212 | 217 | 0 | 100 | 0 | 1 | 217 | 7691 | 7475 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 859 | 401 | 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);;