contig_metadata
8 rows where bioproject = "PRJEB10140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14041218 | 14041218 | PRJEB10140_P_NODE_42052_length_853_cov_8.063433_g27473_i0 | PRJEB10140 | 42052 | 853 | 8.063433 | 68.78108349 | Deltaretrovirus bovleu | 3428211 | Viruses | Viruses | 1565 | 0 | NTclustered | gi|924371543|gb|KT122858.1| | 11901 | g27473 | i0 | 99.766 | 100 | 853 | 2 | 100 | 0 | 1 | 853 | 2019 | 2871 | Bovine leukemia virus isolate YR2, complete genome | blastn | 85300 | 1565 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Deltaretrovirus | Deltaretrovirus bovleu | ||
| 26842863 | 26842863 | PRJEB10140_P_NODE_152021_length_244_cov_2.133333_g134713_i0 | PRJEB10140 | 152021 | 244 | 2.133333 | 5.20533252 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 47.8 | 6.45e-4 | NR | DBA46637.1 | 3117324 | g134713 | i0 | 31.6 | 0.934426229508197 | 76 | 52 | 93.4 | 0 | 233 | 6 | 447 | 522 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 228 | 47.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 | ||||
| 27000772 | 27000772 | PRJEB10140_P_NODE_230262_length_177_cov_1.171875_g212953_i0 | PRJEB10140 | 230262 | 177 | 1.171875 | 2.07421875 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 59.7 | 1.65e-8 | NR | DBA46637.1 | 3117324 | g212953 | i0 | 57.6 | 1 | 59 | 25 | 100 | 0 | 1 | 177 | 1344 | 1402 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 177 | 59.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 | ||||
| 27538257 | 27538257 | PRJEB10140_P_NODE_201124_length_194_cov_1.972414_g183815_i0 | PRJEB10140 | 201124 | 194 | 1.972414 | 3.82648316 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 66.6 | 7.38e-11 | NR | DBA46637.1 | 3117324 | g183815 | i0 | 53.2 | 0.958762886597938 | 62 | 29 | 95.9 | 0 | 9 | 194 | 1367 | 1428 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 186 | 66.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 | ||||
| 27885493 | 27885493 | PRJEB10140_P_NODE_254445_length_167_cov_1.796610_g237136_i0 | PRJEB10140 | 254445 | 167 | 1.79661 | 3.0003387 | Spiretrovirus nemertoderma9428 | 3117326 | Viruses | Viruses | 48.9 | 8.95e-5 | NR | DBA49513.1 | 3117326 | g237136 | i0 | 51.2 | 0.736526946107784 | 41 | 20 | 73.7 | 0 | 5 | 127 | 1519 | 1559 | DBA49513.1 MAG TPA_asm: Gag-Pol [Spiretrovirus nemertoderma9428] | diamond | 123 | 48.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus nemertoderma9428 | ||||
| 28074831 | 28074831 | PRJEB10140_P_NODE_198545_length_196_cov_2.040816_g181236_i0 | PRJEB10140 | 198545 | 196 | 2.040816 | 3.99999936 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 97.1 | 1.47e-21 | NR | DBA46637.1 | 3117324 | g181236 | i0 | 70.3 | 2.93877551020408 | 64 | 19 | 98 | 0 | 194 | 3 | 629 | 692 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 576 | 97.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 | ||||
| 29779872 | 29779872 | PRJEB10140_P_NODE_145411_length_254_cov_1.800000_g128103_i0 | PRJEB10140 | 145411 | 254 | 1.8 | 4.572 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 78.6 | 1.07e-14 | NR | DBA46637.1 | 3117324 | g128103 | i0 | 53.7 | 0.791338582677165 | 67 | 30 | 79.1 | 1 | 2 | 202 | 978 | 1043 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 201 | 78.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 | ||||
| 30285758 | 30285758 | PRJEB10140_P_NODE_178432_length_214_cov_1.272727_g161123_i0 | PRJEB10140 | 178432 | 214 | 1.272727 | 2.72363578 | Spiretrovirus marine7 | 3117324 | Viruses | Viruses | 102 | 2.5499999999999998e-23 | NR | DBA46637.1 | 3117324 | g161123 | i0 | 71 | 2.92990654205607 | 69 | 20 | 96.7 | 0 | 208 | 2 | 919 | 987 | DBA46637.1 MAG TPA_asm: Gag-Pol [Spiretrovirus marine7064] | diamond | 627 | 102 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Spiretrovirus marine7064 |
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);;