contig_metadata
12 rows where bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8572756 | 8572756 | PRJNA940501_S_NODE_255487_length_177_cov_2.044776_g254669_i0 | PRJNA940501 | 255487 | 177 | 2.044776 | 3.61925352 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 327 | 2.2199999999999996e-85 | NTclustered | gi|1167936849|gb|KY574517.1| | 11786 | g254669 | i0 | 100 | 62.4011299435028 | 177 | 0 | 100 | 0 | 1 | 177 | 7633 | 7457 | Murine leukemia virus isolate MCF247, complete genome | blastn | 11045 | 327 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 14948269 | 14948269 | PRJNA940501_S_NODE_300892_length_167_cov_1.491935_g300074_i0 | PRJNA940501 | 300892 | 167 | 1.491935 | 2.49153145 | Bovine endogenous retrovirus beta 1 | 1105057 | Viruses | Viruses | 265 | 1.65e-66 | NTclustered | gi|354681771|emb|HE608663.1| | 1105057 | g300074 | i0 | 95.21 | 3 | 167 | 8 | 100 | 0 | 1 | 167 | 517 | 351 | Bovine endogenous retrovirus beta 1 proviral partial pro gene for protease and partial pol gene for reverse transcriptase | blastn | 501 | 265 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Bovine endogenous retrovirus beta 1 | ||
| 16222440 | 16222440 | PRJNA940501_S_NODE_2293_length_2191_cov_91.374302_g2155_i0 | PRJNA940501 | 2293 | 2191 | 91.374302 | 2002.01095682 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 1294 | 0 | NR | NP_057933.2 | 11801 | g2155 | i0 | 97.6 | 2.70698311273391 | 659 | 16 | 90.2 | 0 | 143 | 2119 | 677 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 5931 | 1294 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 17834964 | 17834964 | PRJNA940501_S_NODE_182894_length_199_cov_0.903846_g182076_i0 | PRJNA940501 | 182894 | 199 | 0.903846 | 1.79865354 | root | 1 | Root_unresolved | Root_unresolved | 335 | 1.5299999999999996e-87 | NTclustered | gi|332097|gb|K00556.1|MMTENV | 11757 | g182076 | i0 | 96.985 | 68.2964824120603 | 199 | 6 | 100 | 0 | 1 | 199 | 2350 | 2152 | mouse mammary tumor virus env mrna | blastn | 13591 | 335 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 23870977 | 23870977 | PRJNA940501_S_NODE_168439_length_204_cov_1.248447_g167621_i0 | PRJNA940501 | 168439 | 204 | 1.248447 | 2.54683188 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 372 | 1.2e-98 | NTclustered | gi|3273865|gb|AF071010.1|AF071010 | 11757 | g167621 | i0 | 99.51 | 5.67156862745098 | 204 | 1 | 100 | 0 | 1 | 204 | 3960 | 3757 | Mouse mammary tumor virus putative integrase, env polyprotein, and superantigen mRNA, complete cds | blastn | 1157 | 372 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 25484265 | 25484265 | PRJNA940501_S_NODE_22500_length_351_cov_3.993506_g21682_i0 | PRJNA940501 | 22500 | 351 | 3.993506 | 14.01720606 | Betaretrovirus | 140052 | Viruses | Viruses | 604 | 2.0299999999999991e-168 | NTclustered | gi|332127|gb|M15122.1|MMTPROCG | 11757 | g21682 | i0 | 97.721 | 55.042735042735 | 351 | 8 | 100 | 0 | 1 | 351 | 1721 | 1371 | Mouse mammary tumor virus complete proviral genome and mouse DNA | blastn | 19320 | 610 | 0.99016393442623 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 27972788 | 27972788 | PRJNA940501_S_NODE_153605_length_210_cov_1.275449_g152787_i0 | PRJNA940501 | 153605 | 210 | 1.275449 | 2.6784429 | Marsupial endogenous gammaretrovirus 2 | 3386030 | Viruses | Viruses | 67 | 6.93e-11 | NR | DBA62711.1 | 3386030 | g152787 | i0 | 73.2 | 1.18571428571429 | 41 | 11 | 58.6 | 0 | 10 | 132 | 177 | 217 | DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] | diamond | 249 | 67 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Marsupial endogenous gammaretrovirus 2 | ||
| 30183166 | 30183166 | PRJNA940501_S_NODE_287312_length_170_cov_1.173228_g286494_i0 | PRJNA940501 | 287312 | 170 | 1.173228 | 1.9944876 | Marsupial endogenous betaretrovirus 5 | 3386028 | Viruses | Viruses | 68.9 | 7.95e-12 | NR | DBA62705.1 | 3386028 | g286494 | i0 | 57.7 | 7.44705882352941 | 52 | 22 | 91.8 | 0 | 6 | 161 | 638 | 689 | DBA62705.1 TPA_asm: Pol [Marsupial endogenous betaretrovirus 5] | diamond | 1266 | 68.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Marsupial endogenous betaretrovirus 5 | ||
| 31036559 | 31036559 | PRJNA940501_S_NODE_296755_length_168_cov_1.128000_g295937_i0 | PRJNA940501 | 296755 | 168 | 1.128 | 1.89504 | Retroviridae sp. | 2681591 | Viruses | Viruses | 43.1 | 0.0099 | NR | XNT20491.1 | 2681591 | g295937 | i0 | 43.9 | 0.732142857142857 | 41 | 23 | 73.2 | 0 | 32 | 154 | 536 | 576 | XNT20491.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 123 | 43.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 31068047 | 31068047 | PRJNA940501_S_NODE_341995_length_159_cov_1.215517_g341177_i0 | PRJNA940501 | 341995 | 159 | 1.215517 | 1.93267203 | Marsupial endogenous gammaretrovirus 2 | 3386030 | Viruses | Viruses | 65.1 | 1.52e-10 | NR | DBA62711.1 | 3386030 | g341177 | i0 | 61.1 | 5.09433962264151 | 54 | 18 | 96.2 | 1 | 155 | 3 | 901 | 954 | DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] | diamond | 810 | 65.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Marsupial endogenous gammaretrovirus 2 | ||
| 31193873 | 31193873 | PRJNA940501_S_NODE_57535_length_275_cov_1.801724_g56717_i0 | PRJNA940501 | 57535 | 275 | 1.801724 | 4.954741 | Walleye epidermal hyperplasia virus 1 | 64462 | Viruses | Viruses | 51.2 | 5.82e-5 | NR | AAD30048.1 | 64462 | g56717 | i0 | 55.6 | 2.19272727272727 | 45 | 19 | 48 | 1 | 64 | 195 | 690 | 734 | AAD30048.1 pol polyprotein, partial [Walleye epidermal hyperplasia virus 1] | diamond | 603 | 51.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Epsilonretrovirus | Epsilonretrovirus walepihyp1 | ||
| 31700339 | 31700339 | PRJNA940501_S_NODE_333797_length_160_cov_2.410256_g332979_i0 | PRJNA940501 | 333797 | 160 | 2.410256 | 3.8564096 | Marsupial endogenous gammaretrovirus 2 | 3386030 | Viruses | Viruses | 51.6 | 9.04e-6 | NR | DBA62710.1 | 3386030 | g332979 | i0 | 53.1 | 0.91875 | 49 | 23 | 91.9 | 0 | 151 | 5 | 430 | 478 | DBA62710.1 TPA_asm: Gag [Marsupial endogenous gammaretrovirus 2] | diamond | 147 | 51.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Marsupial endogenous gammaretrovirus 2 |
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);;