contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA675042" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1922643 | 1922643 | PRJNA675042_P_NODE_173602_length_242_cov_0.911243_g173152_i0 | PRJNA675042 | 173602 | 242 | 0.911243 | 2.20520806 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 63.9 | 1.01e-5 | NTclustered | gi|1512480947|gb|MK072445.1| | 2487771 | g173152 | i0 | 95.122 | 0.466942148760331 | 41 | 1 | 17 | 1 | 120 | 159 | 24790 | 24750 | MAG: Satyrvirus sp. clone Satyrvirus_9 genomic sequence | blastn | 113 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 9576147 | 9576147 | PRJNA675042_P_NODE_89028_length_270_cov_1.289340_g88578_i0 | PRJNA675042 | 89028 | 270 | 1.28934 | 3.481218 | Megaviridae environmental sample | 1737588 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1758107324|gb|MN448292.1| | 1737588 | g88578 | i0 | 100 | 0.111111111111111 | 30 | 0 | 11 | 0 | 93 | 122 | 2551 | 2580 | Megaviridae environmental sample isolate oPacV-421 clone oPacV-421_c9 genomic sequence | blastn | 30 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megaviridae environmental sample | |||
| 12647661 | 12647661 | PRJNA675042_P_NODE_70170_length_293_cov_1.050000_g69720_i0 | PRJNA675042 | 70170 | 293 | 1.05 | 3.0765 | Megaviricetes | 2732523 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|939177347|ref|NC_028094.1| | 455364 | g69720 | i0 | 100 | 0.197952218430034 | 29 | 0 | 10 | 0 | 251 | 279 | 37484 | 37512 | Chrysochromulina ericina virus isolate CeV-01B, complete genome | blastn | 58 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chrysochromulina ericina virus | |||
| 21048636 | 21048636 | PRJNA675042_P_NODE_13257_length_460_cov_1.193798_g12807_i0 | PRJNA675042 | 13257 | 460 | 1.193798 | 5.4914708 | Biavirus raunefjordenense | 3059777 | Viruses | Viruses | 52.8 | 0.045 | NTclustered | gi|2500387999|ref|NC_077221.1| | 1499987 | g12807 | i0 | 100 | 0.0608695652173913 | 28 | 0 | 6 | 0 | 160 | 187 | 662093 | 662066 | Prymnesium kappa virus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Schizomimiviridae | Biavirus | Biavirus raunefjordenense | ||
| 21049730 | 21049730 | PRJNA675042_P_NODE_58777_length_310_cov_0.966245_g58327_i0 | PRJNA675042 | 58777 | 310 | 0.966245 | 2.9953595 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 52.8 | 0.029 | NTclustered | gi|1512476317|gb|MK072250.1| | 2487768 | g58327 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 145 | 172 | 6028 | 6001 | MAG: Harvfovirus sp. clone Harvfovirus_8 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 23599243 | 23599243 | PRJNA675042_P_NODE_16419_length_434_cov_0.853186_g15969_i0 | PRJNA675042 | 16419 | 434 | 0.853186 | 3.70282724 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 52.8 | 0.042 | NTclustered | gi|2500384359|ref|NC_077067.1| | 3060017 | g15969 | i0 | 100 | 0.0645161290322581 | 28 | 0 | 6 | 0 | 159 | 186 | 1050821 | 1050848 | Fadolivirus 1 strain FV1/VV64, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 24872866 | 24872866 | PRJNA675042_P_NODE_24100_length_394_cov_1.077882_g23650_i0 | PRJNA675042 | 24100 | 394 | 1.077882 | 4.24685508 | Mimivirus sp. | 2742700 | Viruses | Viruses | 52.8 | 0.038 | NTclustered | gi|2246796486|gb|MT663335.2| | 2742700 | g23650 | i0 | 100 | 0.0710659898477157 | 28 | 0 | 7 | 0 | 111 | 138 | 187404 | 187431 | Mimivirus sp. strain daqing, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus sp. | ||
| 24873785 | 24873785 | PRJNA675042_P_NODE_95860_length_262_cov_1.629630_g95410_i0 | PRJNA675042 | 95860 | 262 | 1.62963 | 4.2696306 | Megaviridae environmental sample | 1737588 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1758107560|gb|MN448297.1| | 1737588 | g95410 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 153 | 181 | 16171 | 16143 | MAG: Megaviridae environmental sample isolate oPacV-421 clone oPacV-421_c8 | blastn | 29 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megaviridae environmental sample |
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);;