contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB75227" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135616 | 135616 | PRJEB75227_P_NODE_11421_length_243_cov_0.917647_g11250_i0 | PRJEB75227 | 11421 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 333 | 6.989999999999999e-87 | NTclustered | gi|2914753680|gb|OR221409.1| | 2832643 | g11250 | i0 | 91.358 | 3.03292181069959 | 243 | 21 | 100 | 0 | 1 | 243 | 36180 | 36422 | MAG: Caudoviricetes sp. isolate MSP1678 genomic sequence | blastn | 737 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 135652 | 135652 | PRJEB75227_P_NODE_6901_length_273_cov_1.660000_g6730_i0 | PRJEB75227 | 6901 | 273 | 1.66 | 4.5318 | Pseudomonas phage PS-1 | 1573458 | Viruses | Viruses | 326 | 1.34e-84 | NTclustered | gi|985757644|ref|NC_029066.1| | 1573458 | g6730 | i0 | 88.235 | 0.996336996336996 | 272 | 32 | 99 | 0 | 2 | 273 | 28496 | 28225 | Pseudomonas phage PS-1 DNA, complete sequence | blastn | 272 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PS-1 | |||||
| 135660 | 135660 | PRJEB75227_P_NODE_8461_length_252_cov_0.871508_g8290_i0 | PRJEB75227 | 8461 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 422 | 1.51e-113 | NTclustered | gi|2059825520|tpg|BK040067.1| | 2832643 | g8290 | i0 | 96.825 | 20.0396825396825 | 252 | 8 | 100 | 0 | 1 | 252 | 11099 | 11350 | MAG TPA_asm: Caudoviricetes sp. isolate ctJwv2, partial genome | blastn | 5050 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2685755 | 2685755 | PRJEB75227_P_NODE_9083_length_250_cov_0.881356_g8912_i0 | PRJEB75227 | 9083 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.7 | 3.74e-10 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g8912 | i0 | 94.118 | 0.608 | 51 | 3 | 20 | 0 | 46 | 96 | 9501 | 9451 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 152 | 78.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14164032 | 14164032 | PRJEB75227_P_NODE_6852_length_274_cov_1.407960_g6681_i0 | PRJEB75227 | 6852 | 274 | 1.40796 | 3.8578104 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.9 | 1.16e-5 | NTclustered | gi|2054560186|tpg|BK048230.1| | 2832643 | g6681 | i0 | 88.889 | 0.197080291970803 | 54 | 3 | 19 | 3 | 160 | 212 | 39598 | 39649 | MAG TPA_asm: Caudoviricetes sp. isolate ctSe04, partial genome | blastn | 54 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14164036 | 14164036 | PRJEB75227_P_NODE_7392_length_265_cov_1.625000_g7221_i0 | PRJEB75227 | 7392 | 265 | 1.625 | 4.30625 | Pormufvirus salinum | 3431827 | Viruses | Viruses | 171 | 6.41e-38 | NTclustered | gi|2231638396|ref|NC_062761.1| | 2878009 | g7221 | i0 | 80 | 0.943396226415094 | 250 | 34 | 94 | 10 | 17 | 265 | 12526 | 12292 | Halorubrum virus HRTV-28, complete genome | blastn | 250 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Suolaviridae | Pormufvirus | Pormufvirus salinum | |||
| 15023558 | 15023558 | PRJEB75227_P_NODE_11052_length_244_cov_0.912281_g10881_i0 | PRJEB75227 | 11052 | 244 | 0.912281 | 2.22596564 | Viruses | 10239 | Viruses | Viruses | 296 | 9.21e-76 | NTclustered | gi|2548228115|gb|MZ573780.2| | 2861056 | g10881 | i0 | 88.797 | 1.98770491803279 | 241 | 27 | 99 | 0 | 1 | 241 | 120320 | 120560 | Mammaliicoccus phage vB_MscM-PMS3, complete genome | blastn | 485 | 296 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Mammaliicoccus phage vB_MscM-PMS3 | ||||
| 15438129 | 15438129 | PRJEB75227_P_NODE_7993_length_255_cov_1.714286_g7822_i0 | PRJEB75227 | 7993 | 255 | 1.714286 | 4.3714293 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g7822 | i0 | 100 | 1 | 255 | 0 | 100 | 0 | 1 | 255 | 18855 | 19109 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 255 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21812444 | 21812444 | PRJEB75227_P_NODE_6618_length_278_cov_1.258537_g6447_i0 | PRJEB75227 | 6618 | 278 | 1.258537 | 3.49873286 | Percavirus equidgamma2 | 3050281 | Viruses | Viruses | 353 | 6.26e-93 | NTclustered | gi|2271301500|gb|MW322569.1| | 12657 | g6447 | i0 | 89.606 | 14.7086330935252 | 279 | 28 | 100 | 1 | 1 | 278 | 104003 | 104281 | Equid gammaherpesvirus 2 strain 1-141/67, complete genome | blastn | 4089 | 353 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Percavirus | Percavirus equidgamma2 |
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);;