contig_metadata
10 rows where bioproject = "PRJEB6584" and tax_phylum = "Nucleocytoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523743 | 25523743 | PRJEB6584d_S_NODE_9129_length_200_cov_2.424242_g9061_i0 | PRJEB6584 | 9129 | 200 | 2.424242 | 4.848484 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g9061 | i0 | 94.286 | 0.175 | 35 | 1 | 17 | 1 | 81 | 114 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 25659802 | 25659802 | PRJEB6584i_S_NODE_562_length_331_cov_12.283784_g550_i0 | PRJEB6584 | 562 | 331 | 12.283784 | 40.65932504 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g550 | i0 | 94.286 | 0.105740181268882 | 35 | 1 | 10 | 1 | 104 | 137 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 25795755 | 25795755 | PRJEB6584g_S_NODE_5219_length_198_cov_6.926380_g5207_i0 | PRJEB6584 | 5219 | 198 | 6.92638 | 13.7142324 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g5207 | i0 | 94.286 | 0.176767676767677 | 35 | 1 | 17 | 1 | 103 | 136 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 25795839 | 25795839 | PRJEB6584j_S_NODE_17171_length_167_cov_4.954545_g17142_i0 | PRJEB6584 | 17171 | 167 | 4.954545 | 8.27409015 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g17142 | i0 | 94.286 | 0.209580838323353 | 35 | 1 | 20 | 1 | 99 | 132 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26204175 | 26204175 | PRJEB6584b_S_NODE_5830_length_175_cov_6.642857_g5812_i0 | PRJEB6584 | 5830 | 175 | 6.642857 | 11.62499975 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g5812 | i0 | 94.286 | 0.2 | 35 | 1 | 19 | 1 | 88 | 121 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26204427 | 26204427 | PRJEB6584k_S_NODE_702_length_302_cov_12.329588_g681_i0 | PRJEB6584 | 702 | 302 | 12.329588 | 37.23535576 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g681 | i0 | 94.286 | 0.115894039735099 | 35 | 1 | 11 | 1 | 100 | 133 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26340064 | 26340064 | PRJEB6584e_S_NODE_2111_length_198_cov_8.319018_g2096_i0 | PRJEB6584 | 2111 | 198 | 8.319018 | 16.47165564 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g2096 | i0 | 94.286 | 0.176767676767677 | 35 | 1 | 17 | 1 | 63 | 96 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26340193 | 26340193 | PRJEB6584h_S_NODE_9951_length_203_cov_22.696429_g9889_i0 | PRJEB6584 | 9951 | 203 | 22.696429 | 46.07375087 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g9889 | i0 | 94.286 | 0.172413793103448 | 35 | 1 | 17 | 1 | 103 | 136 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26568361 | 26568361 | PRJEB6584o_S_NODE_25744_length_188_cov_3.071895_g25636_i0 | PRJEB6584 | 25744 | 188 | 3.071895 | 5.7751626 | Mimivirus | 315393 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|55416625|gb|AY653733.1| | 212035 | g25636 | i0 | 96.97 | 2.63297872340426 | 33 | 0 | 18 | 1 | 113 | 145 | 87047 | 87078 | Acanthamoeba polyphaga mimivirus, complete genome | blastn | 495 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 33134320 | 33134320 | PRJEB6584o_S_NODE_2455_length_449_cov_4.398551_g2357_i0 | PRJEB6584 | 2455 | 449 | 4.398551 | 19.74949399 | Spodoptera frugiperda ascovirus 1a | 113370 | Viruses | Viruses | 51.6 | 1.5e-4 | NR | YP_762380.1 | 113370 | g2357 | i0 | 39 | 0.394209354120267 | 59 | 33 | 39.4 | 1 | 428 | 252 | 170 | 225 | YP_762380.1 25.7 Inhibitor of apoptosis/RING/U box [Spodoptera frugiperda ascovirus 1a] | diamond | 177 | 51.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Ascovirus | Ascovirus sfav1a |
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);;