contig_metadata
7 rows where bioproject = "PRJNA663960" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904892 | 1904892 | PRJNA663960_S_NODE_4182_length_437_cov_4.892308_g3947_i0 | PRJNA663960 | 4182 | 437 | 4.892308 | 21.37938596 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g3947 | i0 | 100 | 0.551487414187643 | 30 | 0 | 7 | 0 | 406 | 435 | 30 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 241 | 56.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 4456655 | 4456655 | PRJNA663960_S_NODE_35384_length_204_cov_3.248408_g35148_i0 | PRJNA663960 | 35384 | 204 | 3.248408 | 6.62675232 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 372 | 1.2e-98 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g35148 | i0 | 99.51 | 6 | 204 | 1 | 100 | 0 | 1 | 204 | 3560 | 3763 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 1224 | 372 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 7539924 | 7539924 | PRJNA663960_S_NODE_16086_length_288_cov_1.925311_g15850_i0 | PRJNA663960 | 16086 | 288 | 1.925311 | 5.54489568 | Copiparvovirus | 1511888 | Viruses | Viruses | 483 | 7.969999999999997e-132 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g15850 | i0 | 98.889 | 4.20486111111111 | 270 | 3 | 94 | 0 | 1 | 270 | 5320 | 5051 | Bosavirus MS-2016a, complete genome | blastn | 1211 | 483 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 8815147 | 8815147 | PRJNA663960_S_NODE_60227_length_159_cov_1.633929_g59991_i0 | PRJNA663960 | 60227 | 159 | 1.633929 | 2.59794711 | Copiparvovirus | 1511888 | Viruses | Viruses | 294 | 1.98e-75 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g59991 | i0 | 100 | 4 | 159 | 0 | 100 | 0 | 1 | 159 | 2596 | 2438 | Bosavirus MS-2016a, complete genome | blastn | 636 | 294 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 9557123 | 9557123 | PRJNA663960_S_NODE_19708_length_267_cov_1.418182_g19472_i0 | PRJNA663960 | 19708 | 267 | 1.418182 | 3.78654594 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 488 | 1.5699999999999998e-133 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g19472 | i0 | 99.625 | 8.73782771535581 | 267 | 1 | 100 | 0 | 1 | 267 | 2282 | 2016 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2333 | 488 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 12108044 | 12108044 | PRJNA663960_S_NODE_29770_length_222_cov_3.160000_g29534_i0 | PRJNA663960 | 29770 | 222 | 3.16 | 7.0152 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 401 | 1.6999999999999994e-107 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g29534 | i0 | 99.545 | 9.09009009009009 | 220 | 1 | 99 | 0 | 3 | 222 | 2361 | 2580 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2018 | 401 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 13382787 | 13382787 | PRJNA663960_S_NODE_36291_length_202_cov_1.316129_g36055_i0 | PRJNA663960 | 36291 | 202 | 1.316129 | 2.65858058 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g36055 | i0 | 100 | 1.14851485148515 | 29 | 0 | 14 | 0 | 3 | 31 | 1 | 29 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 232 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 |
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);;