contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2513352 | 2513352 | PRJNA874604_P_NODE_28462_length_351_cov_2.604317_g28110_i0 | PRJNA874604 | 28462 | 351 | 2.604317 | 9.14115267 | root | 1 | Root_unresolved | Root_unresolved | 638 | 1.9999999999999996e-178 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g28110 | i0 | 99.43 | 58.8945868945869 | 351 | 2 | 100 | 0 | 1 | 351 | 2263 | 1913 | Moloney murine leukemia virus, complete genome | blastn | 20672 | 638 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 8891035 | 8891035 | PRJNA874604_P_NODE_57887_length_270_cov_1.005076_g57535_i0 | PRJNA874604 | 57887 | 270 | 1.005076 | 2.7137052 | root | 1 | Root_unresolved | Root_unresolved | 431 | 2.719999999999999e-116 | NTclustered | gi|1045515|gb|U36800.1|MLU36800 | 11786 | g57535 | i0 | 97.984 | 85.2185185185185 | 248 | 5 | 100 | 0 | 23 | 270 | 2000 | 2247 | Murine leukemia virus Mo Ampho Delta recombinant envelope polyprotein (env) mRNA, complete cds | blastn | 23009 | 431 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 15265817 | 15265817 | PRJNA874604_P_NODE_35572_length_323_cov_1.692000_g35220_i0 | PRJNA874604 | 35572 | 323 | 1.692 | 5.46516 | root | 1 | Root_unresolved | Root_unresolved | 586 | 6.72e-163 | NTclustered | gi|1431162560|gb|EU075332.2| | 11786 | g35220 | i0 | 99.381 | 16.5603715170279 | 323 | 2 | 100 | 0 | 1 | 323 | 4949 | 4627 | Mutant Murine leukemia virus clone 8-6w_c2 gag-pro-pol polyprotein gene, complete cds | blastn | 5349 | 586 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 17815236 | 17815236 | PRJNA874604_P_NODE_19534_length_407_cov_1.248503_g19182_i0 | PRJNA874604 | 19534 | 407 | 1.248503 | 5.08140721 | root | 1 | Root_unresolved | Root_unresolved | 747 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g19182 | i0 | 99.754 | 100 | 407 | 1 | 100 | 0 | 1 | 407 | 2707 | 2301 | Moloney murine leukemia virus, complete genome | blastn | 40700 | 747 | 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);;