contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA934332" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 910634 | 910634 | PRJNA934332_P_NODE_5281_length_290_cov_0.921659_g5194_i0 | PRJNA934332 | 5281 | 290 | 0.921659 | 2.6728111 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 536 | 6.079999999999999e-148 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g5194 | i0 | 100 | 79.3172413793103 | 290 | 0 | 100 | 0 | 1 | 290 | 2384 | 2673 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 23002 | 536 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 7288749 | 7288749 | PRJNA934332_P_NODE_526_length_813_cov_1.825676_g455_i0 | PRJNA934332 | 526 | 813 | 1.825676 | 14.84274588 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 1496 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g455 | i0 | 99.877 | 39.559655596556 | 813 | 1 | 100 | 0 | 1 | 813 | 5924 | 6736 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 32162 | 1496 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 9838587 | 9838587 | PRJNA934332_P_NODE_3128_length_360_cov_1.428571_g3041_i0 | PRJNA934332 | 3128 | 360 | 1.428571 | 5.1428556 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 665 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g3041 | i0 | 100 | 20.9361111111111 | 360 | 0 | 100 | 0 | 1 | 360 | 8035 | 7676 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 7537 | 665 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 11114223 | 11114223 | PRJNA934332_P_NODE_109_length_1589_cov_1.317942_g88_i0 | PRJNA934332 | 109 | 1589 | 1.317942 | 20.94209838 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 2913 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g88 | i0 | 99.748 | 61.803650094399 | 1589 | 4 | 100 | 0 | 1 | 1589 | 3513 | 5101 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 98206 | 2913 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 12389753 | 12389753 | PRJNA934332_P_NODE_2490_length_395_cov_1.149068_g2403_i0 | PRJNA934332 | 2490 | 395 | 1.149068 | 4.5388186 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 725 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g2403 | i0 | 99.747 | 15.4430379746835 | 395 | 1 | 100 | 0 | 1 | 395 | 1464 | 1070 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 6100 | 725 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 12734843 | 12734843 | PRJNA934332_P_NODE_2530_length_392_cov_0.940439_g2443_i0 | PRJNA934332 | 2530 | 392 | 0.940439 | 3.6865208799999998 | Betaretrovirus | 140052 | Viruses | Viruses | 719 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g2443 | i0 | 99.745 | 4 | 392 | 1 | 100 | 0 | 1 | 392 | 7036 | 7427 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1568 | 719 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 20037298 | 20037298 | PRJNA934332_P_NODE_896_length_636_cov_1.275311_g814_i0 | PRJNA934332 | 896 | 636 | 1.275311 | 8.11097796 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g814 | i0 | 99.843 | 20.4245283018868 | 636 | 1 | 100 | 0 | 1 | 636 | 7417 | 6782 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 12990 | 1170 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 21312676 | 21312676 | PRJNA934332_P_NODE_3457_length_346_cov_1.128205_g3370_i0 | PRJNA934332 | 3457 | 346 | 1.128205 | 3.9035893 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 640 | 5.4999999999999996e-179 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g3370 | i0 | 100 | 30.4190751445087 | 346 | 0 | 100 | 0 | 1 | 346 | 3150 | 3495 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 10525 | 640 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu |
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);;