contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1215774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6148456 | 6148456 | PRJNA1215774_P_NODE_41585_length_327_cov_1.212598_g41265_i0 | PRJNA1215774 | 41585 | 327 | 1.212598 | 3.96519546 | Gammaretrovirus | 153135 | Viruses | Viruses | 592 | 1.4699999999999999e-164 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g41265 | i0 | 99.387 | 17.2140672782875 | 326 | 2 | 99 | 0 | 1 | 326 | 4614 | 4939 | Moloney murine leukemia virus, complete genome | blastn | 5629 | 592 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 7423457 | 7423457 | PRJNA1215774_P_NODE_29586_length_389_cov_1.762658_g29266_i0 | PRJNA1215774 | 29586 | 389 | 1.762658 | 6.85673962 | root | 1 | Root_unresolved | Root_unresolved | 702 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g29266 | i0 | 99.229 | 100.012853470437 | 389 | 3 | 100 | 0 | 1 | 389 | 2437 | 2825 | Moloney murine leukemia virus, complete genome | blastn | 38905 | 702 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 7423626 | 7423626 | PRJNA1215774_P_NODE_66266_length_256_cov_1.027322_g65946_i0 | PRJNA1215774 | 66266 | 256 | 1.027322 | 2.62994432 | Gammaretrovirus | 153135 | Viruses | Viruses | 468 | 1.95e-127 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g65946 | i0 | 99.609 | 90.09765625 | 256 | 1 | 100 | 0 | 1 | 256 | 5595 | 5340 | Moloney murine leukemia virus, complete genome | blastn | 23065 | 468 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 11248947 | 11248947 | PRJNA1215774_P_NODE_38909_length_338_cov_1.543396_g38589_i0 | PRJNA1215774 | 38909 | 338 | 1.543396 | 5.21667848 | root | 1 | Root_unresolved | Root_unresolved | 625 | 1.4999999999999999e-174 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g38589 | i0 | 100 | 26.7840236686391 | 338 | 0 | 100 | 0 | 1 | 338 | 5861 | 6198 | Moloney murine leukemia virus, complete genome | blastn | 9053 | 625 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 23997797 | 23997797 | PRJNA1215774_P_NODE_55659_length_282_cov_1.354067_g55339_i0 | PRJNA1215774 | 55659 | 282 | 1.354067 | 3.81846894 | Gammaretrovirus | 153135 | Viruses | Viruses | 488 | 1.6699999999999998e-133 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g55339 | i0 | 97.872 | 98.0957446808511 | 282 | 6 | 100 | 0 | 1 | 282 | 4380 | 4099 | Moloney murine leukemia virus, complete genome | blastn | 27663 | 488 | 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);;