contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2951830 | 2951830 | PRJNA379145_P_NODE_9223_length_996_cov_3.191070_g848_i1 | PRJNA379145 | 9223 | 996 | 3.19107 | 31.7830572 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 65.8 | 1.3e-5 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g848 | i1 | 90 | 9.25502008032129 | 50 | 5 | 5 | 0 | 946 | 995 | 655182 | 655231 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 9218 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 10604811 | 10604811 | PRJNA379145_P_NODE_57769_length_197_cov_2.396341_g55615_i0 | PRJNA379145 | 57769 | 197 | 2.396341 | 4.72079177 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 134 | 5.92e-27 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g55615 | i0 | 80 | 0.913705583756345 | 180 | 36 | 91 | 0 | 13 | 192 | 900337 | 900516 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 180 | 134 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 14429945 | 14429945 | PRJNA379145_P_NODE_8152_length_1065_cov_3.426357_g7180_i0 | PRJNA379145 | 8152 | 1065 | 3.426357 | 36.49070205 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 616 | 3.059999999999999e-171 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g7180 | i0 | 78.02 | 1.20657276995305 | 1010 | 201 | 93 | 13 | 62 | 1054 | 727159 | 728164 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 1285 | 616 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 16977884 | 16977884 | PRJNA379145_P_NODE_11734_length_866_cov_3.178872_g10406_i0 | PRJNA379145 | 11734 | 866 | 3.178872 | 27.52903152 | Orthopoxvirus cowpox | 3431481 | Viruses | Viruses | 56.5 | 0.007 | NTclustered | gi|1243284674|gb|KY569022.1| | 10243 | g10406 | i0 | 100 | 0.207852193995381 | 30 | 0 | 3 | 0 | 444 | 473 | 154342 | 154313 | Cowpox virus strain CPXV CheTopCut_DK_2011 | blastn | 180 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus cowpox | ||
| 20802198 | 20802198 | PRJNA379145_P_NODE_28377_length_440_cov_2.808354_g26284_i0 | PRJNA379145 | 28377 | 440 | 2.808354 | 12.3567576 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|1512470699|gb|MK071980.1| | 2487775 | g26284 | i0 | 97.059 | 0.0772727272727273 | 34 | 1 | 8 | 0 | 207 | 240 | 106899 | 106866 | MAG: Terrestrivirus sp. clone Terrestrivirus_2 genomic sequence | blastn | 34 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. |
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);;