contig_metadata
6 rows where bioproject = "PRJNA1160211", tax_phylum = "Peploviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1038527 | 1038527 | PRJNA1160211_S_NODE_222681_length_287_cov_1.037383_g221448_i0 | PRJNA1160211 | 222681 | 287 | 1.037383 | 2.97728921 | Heunggongvirae | 2731360 | Viruses | Viruses | 102 | 2.6e-17 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g221448 | i0 | 98.305 | 280.271777003484 | 59 | 0 | 44 | 1 | 1 | 59 | 272 | 215 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 80438 | 102 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 7963025 | 7963025 | PRJNA1160211_S_NODE_212847_length_297_cov_0.950893_g211614_i0 | PRJNA1160211 | 212847 | 297 | 0.950893 | 2.82415221 | Cytomegalovirus cercopithecinebeta5 | 3050258 | Viruses | Viruses | 446 | 1.0799999999999999e-120 | NTclustered | gi|346331209|gb|AF191077.2| | 36452 | g211614 | i0 | 99.19 | 121.734006734007 | 247 | 2 | 83 | 0 | 46 | 292 | 606 | 360 | Stealth virus 1 clone 3B528, genomic sequence | blastn | 36155 | 446 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 | ||
| 12517712 | 12517712 | PRJNA1160211_S_NODE_72030_length_516_cov_26.611738_g70821_i0 | PRJNA1160211 | 72030 | 516 | 26.611738 | 137.31656808 | Heunggongvirae | 2731360 | Viruses | Viruses | 130 | 2.27e-25 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g70821 | i0 | 93.258 | 114.945736434109 | 89 | 4 | 17 | 2 | 429 | 516 | 174 | 261 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 59312 | 130 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 13063429 | 13063429 | PRJNA1160211_S_NODE_218091_length_291_cov_3.334862_g216858_i0 | PRJNA1160211 | 218091 | 291 | 3.334862 | 9.70444842 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 80.5 | 1.24e-10 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g216858 | i0 | 100 | 59.3058419243986 | 43 | 0 | 15 | 0 | 249 | 291 | 213 | 255 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 17258 | 80.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 20164784 | 20164784 | PRJNA1160211_S_NODE_194716_length_317_cov_1.368852_g193483_i0 | PRJNA1160211 | 194716 | 317 | 1.368852 | 4.33926084 | Heunggongvirae | 2731360 | Viruses | Viruses | 106 | 2.25e-18 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g193483 | i0 | 95.588 | 265.675078864353 | 68 | 0 | 42 | 3 | 252 | 317 | 206 | 272 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 84219 | 106 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 23262503 | 23262503 | PRJNA1160211_S_NODE_288539_length_234_cov_2.068323_g287306_i0 | PRJNA1160211 | 288539 | 234 | 2.068323 | 4.83987582 | Cytomegalovirus cercopithecinebeta5 | 3050258 | Viruses | Viruses | 429 | 8.289999999999998e-116 | NTclustered | gi|6561414|gb|AF191075.1|AF191075 | 36452 | g287306 | i0 | 100 | 6.78205128205128 | 232 | 0 | 99 | 0 | 1 | 232 | 1487 | 1256 | Stealth virus 1 clone 3B512, genomic sequence | blastn | 1587 | 429 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 |
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);;