contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA804229" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4630377 | 4630377 | PRJNA804229_S_NODE_122864_length_184_cov_1.397163_g121906_i0 | PRJNA804229 | 122864 | 184 | 1.397163 | 2.57077992 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g121906 | i0 | 100 | 0.152173913043478 | 28 | 0 | 15 | 0 | 157 | 184 | 28 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 10150514 | 10150514 | PRJNA804229_S_NODE_137608_length_174_cov_1.320611_g136650_i0 | PRJNA804229 | 137608 | 174 | 1.320611 | 2.29786314 | Copiparvovirus | 1511888 | Viruses | Viruses | 311 | 2.19e-80 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g136650 | i0 | 98.851 | 5 | 174 | 2 | 100 | 0 | 1 | 174 | 4777 | 4604 | Bosavirus MS-2016a, complete genome | blastn | 870 | 311 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 11425903 | 11425903 | PRJNA804229_S_NODE_57689_length_265_cov_2.153153_g56731_i0 | PRJNA804229 | 57689 | 265 | 2.153153 | 5.70585545 | Copiparvovirus | 1511888 | Viruses | Viruses | 444 | 3.42e-120 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g56731 | i0 | 99.588 | 3.93962264150943 | 243 | 1 | 92 | 0 | 1 | 243 | 2415 | 2657 | Bosavirus MS-2016a, complete genome | blastn | 1044 | 444 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 16524749 | 16524749 | PRJNA804229_S_NODE_110933_length_193_cov_3.673333_g109975_i0 | PRJNA804229 | 110933 | 193 | 3.673333 | 7.08953269 | Copiparvovirus | 1511888 | Viruses | Viruses | 357 | 3.1499999999999996e-94 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g109975 | i0 | 100 | 5 | 193 | 0 | 100 | 0 | 1 | 193 | 4149 | 4341 | Bosavirus MS-2016a, complete genome | blastn | 965 | 357 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 21624015 | 21624015 | PRJNA804229_S_NODE_117477_length_188_cov_1.655172_g116519_i0 | PRJNA804229 | 117477 | 188 | 1.655172 | 3.11172336 | Tetraparvovirus | 1511911 | Viruses | Viruses | 342 | 8.539999999999999e-90 | NTclustered | gi|1372080036|gb|MG745679.1| | 494651 | g116519 | i0 | 99.468 | 73.563829787234 | 188 | 1 | 100 | 0 | 1 | 188 | 2896 | 3083 | Bovine hokovirus 1 isolate Guarapuava nonstructural protein 1 and capsid protein 1 genes, complete cds | blastn | 13830 | 342 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Tetraparvovirus | Tetraparvovirus ungulate1 | ||
| 25448724 | 25448724 | PRJNA804229_S_NODE_7120_length_558_cov_13.246602_g6249_i0 | PRJNA804229 | 7120 | 558 | 13.246602 | 73.91603916 | Copiparvovirus | 1511888 | Viruses | Viruses | 992 | 0 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g6249 | i0 | 99.815 | 4.54121863799283 | 540 | 1 | 97 | 0 | 19 | 558 | 4808 | 5347 | Bosavirus MS-2016a, complete genome | blastn | 2534 | 992 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 |
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);;