contig_metadata
6 rows where bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6376370 | 6376370 | PRJNA986547_P_NODE_3725_length_295_cov_1.914414_g3643_i0 | PRJNA986547 | 3725 | 295 | 1.914414 | 5.6475213 | root | 1 | Root_unresolved | Root_unresolved | 545 | 1.03e-150 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g3643 | i0 | 100 | 99.5593220338983 | 295 | 0 | 100 | 0 | 1 | 295 | 2064 | 2358 | Moloney murine leukemia virus, complete genome | blastn | 29370 | 545 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 10200900 | 10200900 | PRJNA986547_P_NODE_428_length_703_cov_2.507937_g348_i0 | PRJNA986547 | 428 | 703 | 2.507937 | 17.63079711 | Gammaretrovirus | 153135 | Viruses | Viruses | 1293 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g348 | i0 | 99.858 | 99.9815078236131 | 703 | 1 | 100 | 0 | 1 | 703 | 3235 | 3937 | Moloney murine leukemia virus, complete genome | blastn | 70287 | 1293 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 19123558 | 19123558 | PRJNA986547_P_NODE_1175_length_411_cov_1.804734_g1093_i0 | PRJNA986547 | 1175 | 411 | 1.804734 | 7.41745674 | Gammaretrovirus | 153135 | Viruses | Viruses | 754 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g1093 | i0 | 99.757 | 94.5474452554745 | 411 | 1 | 100 | 0 | 1 | 411 | 4604 | 4194 | Moloney murine leukemia virus, complete genome | blastn | 38859 | 754 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 24223895 | 24223895 | PRJNA986547_P_NODE_139_length_1398_cov_2.373585_g94_i0 | PRJNA986547 | 139 | 1398 | 2.373585 | 33.1827183 | Gammaretrovirus | 153135 | Viruses | Viruses | 2410 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g94 | i0 | 99.472 | 87.6466380543634 | 1327 | 6 | 99 | 1 | 73 | 1398 | 8007 | 6681 | Moloney murine leukemia virus, complete genome | blastn | 122530 | 2410 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 24223943 | 24223943 | PRJNA986547_P_NODE_479_length_660_cov_1.797274_g399_i0 | PRJNA986547 | 479 | 660 | 1.797274 | 11.8620084 | Gammaretrovirus | 153135 | Viruses | Viruses | 1203 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g399 | i0 | 99.545 | 57.4515151515152 | 660 | 3 | 100 | 0 | 1 | 660 | 5239 | 4580 | Moloney murine leukemia virus, complete genome | blastn | 37918 | 1203 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 24223945 | 24223945 | PRJNA986547_P_NODE_519_length_628_cov_1.398198_g439_i0 | PRJNA986547 | 519 | 628 | 1.398198 | 8.78068344 | root | 1 | Root_unresolved | Root_unresolved | 1122 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g439 | i0 | 98.885 | 99.9585987261146 | 628 | 7 | 100 | 0 | 1 | 628 | 2948 | 2321 | Moloney murine leukemia virus, complete genome | blastn | 62774 | 1122 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;