contig_metadata
5 rows where bioproject = "PRJNA1144090" and tax_clade = "Pithoviruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29438478 | 29438478 | PRJNA1144090_P_NODE_30310_length_478_cov_2.066667_g29776_i0 | PRJNA1144090 | 30310 | 478 | 2.066667 | 9.87866826 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 166 | 3.54e-44 | NR | QBK92355.1 | 2506594 | g29776 | i0 | 56.1 | 0.928870292887029 | 148 | 65 | 92.9 | 0 | 475 | 32 | 1129 | 1276 | QBK92355.1 MAG: DEAD-like helicase family protein [Pithovirus LCPAC304] | diamond | 444 | 166 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 29964772 | 29964772 | PRJNA1144090_P_NODE_42631_length_394_cov_1.900312_g42096_i0 | PRJNA1144090 | 42631 | 394 | 1.900312 | 7.48722928 | Alphapithovirus | 3153073 | Viruses | Viruses | 67.8 | 2.46e-11 | NR | YP_009000979.1 | 1450746 | g42096 | i0 | 36.8 | 1.61421319796954 | 106 | 59 | 76.1 | 3 | 392 | 93 | 40 | 143 | YP_009000979.1 esterase lipase superfamily protein [Pithovirus sibericum] | diamond | 636 | 67.8 | 1 | Viruses | Pithoviruses | Alphapithovirus | Alphapithovirus sibericum | ||||||
| 30512743 | 30512743 | PRJNA1144090_P_NODE_119493_length_230_cov_3.426752_g118958_i0 | PRJNA1144090 | 119493 | 230 | 3.426752 | 7.8815296 | Pithovirus LCDPAC | 2506600 | Viruses | Viruses | 64.7 | 5.79e-10 | NR | QBK84714.1 | 2506600 | g118958 | i0 | 46.7 | 0.978260869565217 | 75 | 39 | 97.8 | 1 | 4 | 228 | 777 | 850 | QBK84714.1 MAG: DEAD/SNF2-like helicase [Pithovirus LCDPAC01] | diamond | 225 | 64.7 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 31872039 | 31872039 | PRJNA1144090_P_NODE_118097_length_236_cov_2.527607_g117562_i0 | PRJNA1144090 | 118097 | 236 | 2.527607 | 5.96515252 | Pithovirus LCPAC3 | 2506594 | Viruses | Viruses | 60.8 | 1.43e-8 | NR | QBK92355.1 | 2506594 | g117562 | i0 | 42.4 | 0.838983050847458 | 66 | 36 | 81.4 | 1 | 16 | 207 | 57 | 122 | QBK92355.1 MAG: DEAD-like helicase family protein [Pithovirus LCPAC304] | diamond | 198 | 60.8 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC304 | |||||||
| 32599798 | 32599798 | PRJNA1144090_P_NODE_40240_length_407_cov_1.380240_g39705_i0 | PRJNA1144090 | 40240 | 407 | 1.38024 | 5.6175768 | Pithovirus LCPAC1 | 2506586 | Viruses | Viruses | 87.4 | 1.92e-17 | NR | QBK89984.1 | 2506586 | g39705 | i0 | 46.6 | 0.86977886977887 | 118 | 56 | 87 | 3 | 52 | 405 | 11 | 121 | QBK89984.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] | diamond | 354 | 87.4 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 |
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);;