contig_metadata
7 rows where bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4625994 | 4625994 | PRJNA800090_P_NODE_1544_length_2461_cov_3.339883_g1328_i0 | PRJNA800090 | 1544 | 2461 | 3.339883 | 82.19452063 | RD114 retrovirus | 11834 | Viruses | Viruses | 4098 | 0 | NTclustered | gi|306482054|dbj|AB559882.1| | 11834 | g1328 | i0 | 99.91 | 41.1767574156847 | 2225 | 2 | 100 | 0 | 1 | 2225 | 8107 | 5883 | RD114 retrovirus proviral DNA, complete genome, strain: CRT1 | blastn | 101336 | 4098 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | RD114 retrovirus | ||
| 8450842 | 8450842 | PRJNA800090_P_NODE_1647_length_2420_cov_4.449171_g1421_i0 | PRJNA800090 | 1647 | 2420 | 4.449171 | 107.6699382 | Betaretrovirus maspfimon | 3427294 | Viruses | Viruses | 4030 | 0 | NTclustered | gi|334702|gb|M12349.1|SIVMPCG | 11855 | g1421 | i0 | 99.773 | 16.4223140495868 | 2198 | 3 | 100 | 1 | 1 | 2196 | 8437 | 6240 | Simian Mason-Pfizer D-type retrovirus (MPMV/6A), complete genome | blastn | 39742 | 4030 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 13553451 | 13553451 | PRJNA800090_P_NODE_79131_length_377_cov_1.185065_g76946_i0 | PRJNA800090 | 79131 | 377 | 1.185065 | 4.46769505 | Betaretrovirus maspfimon | 3427294 | Viruses | Viruses | 693 | 0 | NTclustered | gi|334702|gb|M12349.1|SIVMPCG | 11855 | g76946 | i0 | 100 | 9.86737400530504 | 375 | 0 | 99 | 0 | 1 | 375 | 5661 | 6035 | Simian Mason-Pfizer D-type retrovirus (MPMV/6A), complete genome | blastn | 3720 | 693 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 17379153 | 17379153 | PRJNA800090_S_NODE_294_length_1639_cov_7.617834_g277_i0 | PRJNA800090 | 294 | 1639 | 7.617834 | 124.85629926 | Gammaretrovirus Kimursar | 3428956 | Viruses | Viruses | 1829 | 0 | NTclustered | gi|1694998360|ref|NC_043426.1| | 11808 | g277 | i0 | 97.672 | 50.1781574130567 | 1074 | 8 | 65 | 11 | 9 | 1079 | 1060 | 1 | Kirsten murine sarcoma virus (KiMSV) p15 env coding region and long terminal repeat (LTR) | blastn | 82242 | 1829 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus Kimursar | ||
| 21202466 | 21202466 | PRJNA800090_P_NODE_88897_length_350_cov_2.434164_g86712_i0 | PRJNA800090 | 88897 | 350 | 2.434164 | 8.519574 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|1625847814|gb|MK384866.1| | 11676 | g86712 | i0 | 100 | 0.08 | 28 | 0 | 8 | 0 | 30 | 57 | 6057 | 6084 | HIV-1 isolate 37Pt1-2010-P2E2 from USA defective genome | blastn | 28 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 25024925 | 25024925 | PRJNA800090_P_NODE_190380_length_229_cov_0.900000_g188195_i0 | PRJNA800090 | 190380 | 229 | 0.9 | 2.061 | Alpharetrovirus avileu | 3426267 | Viruses | Viruses | 405 | 1.36e-108 | NTclustered | gi|1765883905|gb|MK683481.1| | 11864 | g188195 | i0 | 98.684 | 97.8558951965066 | 228 | 3 | 99 | 0 | 2 | 229 | 6803 | 6576 | Avian leukosis virus isolate GDHN-YH2, complete genome | blastn | 22409 | 405 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 25027297 | 25027297 | PRJNA800090_S_NODE_29600_length_236_cov_1.724551_g29488_i0 | PRJNA800090 | 29600 | 236 | 1.724551 | 4.06994036 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|1625847814|gb|MK384866.1| | 11676 | g29488 | i0 | 100 | 0.11864406779661 | 28 | 0 | 12 | 0 | 30 | 57 | 6057 | 6084 | HIV-1 isolate 37Pt1-2010-P2E2 from USA defective genome | blastn | 28 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 |
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);;