contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4567968 | 4567968 | PRJNA758398_S_NODE_18524_length_234_cov_1.378378_g18383_i0 | PRJNA758398 | 18524 | 234 | 1.378378 | 3.22540452 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 132 | 2.62e-26 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g18383 | i0 | 79.208 | 0.863247863247863 | 202 | 32 | 84 | 9 | 19 | 215 | 773747 | 773551 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 202 | 132 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 4568235 | 4568235 | PRJNA758398_S_NODE_404_length_1214_cov_13.658369_g358_i0 | PRJNA758398 | 404 | 1214 | 13.658369 | 165.81259966 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 75 | 2.64e-8 | NTclustered | gi|2500384359|ref|NC_077067.1| | 3060017 | g358 | i0 | 97.674 | 0.150741350906096 | 43 | 1 | 4 | 0 | 715 | 757 | 465857 | 465899 | Fadolivirus 1 strain FV1/VV64, partial genome | blastn | 183 | 75 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 6308446 | 6308446 | PRJNA758398_S_NODE_39345_length_172_cov_1.406504_g39204_i0 | PRJNA758398 | 39345 | 172 | 1.406504 | 2.41918688 | Mimivirus | 315393 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2267817464|gb|MW685904.1| | 212035 | g39204 | i0 | 94.286 | 2.37209302325581 | 35 | 2 | 20 | 0 | 79 | 113 | 295752 | 295786 | Acanthamoeba polyphaga mimivirus isolate M4, complete genome | blastn | 408 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 10943915 | 10943915 | PRJNA758398_S_NODE_34469_length_183_cov_0.977612_g34328_i0 | PRJNA758398 | 34469 | 183 | 0.977612 | 1.78902996 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 150 | 5.37e-32 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g34328 | i0 | 89.831 | 0.644808743169399 | 118 | 10 | 64 | 2 | 25 | 141 | 148714 | 148830 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 118 | 150 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 13493855 | 13493855 | PRJNA758398_S_NODE_9991_length_306_cov_2.143969_g9850_i0 | PRJNA758398 | 9991 | 306 | 2.143969 | 6.56054514 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g9850 | i0 | 100 | 9.47712418300654 | 29 | 0 | 9 | 0 | 65 | 93 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 21142477 | 21142477 | PRJNA758398_S_NODE_47417_length_164_cov_1.330435_g47276_i0 | PRJNA758398 | 47417 | 164 | 1.330435 | 2.1819134 | Tupanvirus salinum | 3060758 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2500358058|ref|NC_075039.1| | 2126985 | g47276 | i0 | 90.476 | 0.25609756097561 | 42 | 4 | 26 | 0 | 36 | 77 | 699101 | 699060 | Tupanvirus soda lake, partial genome | blastn | 42 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum |
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);;