contig_metadata
5 rows where bioproject = "PRJNA1249535", tax_phylum = "Cossaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10562923 | 10562923 | PRJNA1249535_S_NODE_73129_length_414_cov_1.369501_g69748_i0 | PRJNA1249535 | 73129 | 414 | 1.369501 | 5.66973414 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 749 | 0 | NTclustered | gi|1347731934|ref|NC_037053.1| | 172297 | g69748 | i0 | 99.275 | 9.83091787439614 | 414 | 3 | 100 | 0 | 1 | 414 | 2675 | 3088 | Bovine parvovirus 3 isolate ujs1794 nonstructural protein and structural protein genes, complete cds | blastn | 4070 | 749 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 14387097 | 14387097 | PRJNA1249535_S_NODE_337292_length_227_cov_3.538961_g333909_i0 | PRJNA1249535 | 337292 | 227 | 3.538961 | 8.03344147 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 414 | 2.2399999999999998e-111 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g333909 | i0 | 99.559 | 7 | 227 | 1 | 100 | 0 | 1 | 227 | 4614 | 4388 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 1589 | 414 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 15658760 | 15658760 | PRJNA1249535_S_NODE_159873_length_329_cov_2.675781_g156490_i0 | PRJNA1249535 | 159873 | 329 | 2.675781 | 8.80331949 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 608 | 1.4599999999999995e-169 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g156490 | i0 | 100 | 7.57142857142857 | 329 | 0 | 100 | 0 | 1 | 329 | 4170 | 3842 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2491 | 608 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 15660414 | 15660414 | PRJNA1249535_S_NODE_294253_length_256_cov_1.601093_g290870_i0 | PRJNA1249535 | 294253 | 256 | 1.601093 | 4.09879808 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 473 | 4.189999999999999e-129 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g290870 | i0 | 100 | 8.9140625 | 256 | 0 | 100 | 0 | 1 | 256 | 1980 | 2235 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2282 | 473 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 23307502 | 23307502 | PRJNA1249535_S_NODE_111459_length_364_cov_1.323024_g108076_i0 | PRJNA1249535 | 111459 | 364 | 1.323024 | 4.81580736 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 348 | 3.93e-91 | NTclustered | gi|2277478564|gb|MZ502233.1| | 172297 | g108076 | i0 | 99.476 | 3.65384615384615 | 191 | 1 | 52 | 0 | 1 | 191 | 3508 | 3318 | Bovine parvovirus 3 isolate BCS1/USA nonstructural protein and structural protein genes, complete cds | blastn | 1330 | 348 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 |
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);;