contig_metadata
23 rows where bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9063449 | 9063449 | PRJEB75230_P_NODE_134188_length_249_cov_0.875000_g134006_i0 | PRJEB75230 | 134188 | 249 | 0.875 | 2.17875 | Betaretrovirus | 140052 | Viruses | Viruses | 109 | 1.5e-25 | NR | P51517.2 | 39068 | g134006 | i0 | 76.8 | 6.69879518072289 | 69 | 16 | 83.1 | 0 | 233 | 27 | 943 | 1011 | P51517.2 RecName: Full=Gag-Pro-Pol polyprotein; Contains: RecName: Full=Matrix protein p10; Contains: RecName: Full=Phosphorylated protein pp24; Contains: RecName: Full=Phosphorylated protein pp18; Contains: RecName: Full=p12; Contains: RecName: Full=Capsid protein p27; Contains: RecName: Full=Nucleocapsid protein-dUTPase; Short=NC-dUTPase; Contains: RecName: Full=Protease 17 kDa; Contains: RecName: Full=Protease 13 kDa; Contains: RecName: Full=G-patch peptide; Contains: RecName: Full=Reverse transcriptase/ribonuclease H; Short=RT; Contains: RecName: Full=Integrase; Short=IN [Simian retrovirus 2] | diamond | 1668 | 110 | 0.990909090909091 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 9924193 | 9924193 | PRJEB75230_P_NODE_53108_length_308_cov_1.174468_g52926_i0 | PRJEB75230 | 53108 | 308 | 1.174468 | 3.61736144 | Betaretrovirus | 140052 | Viruses | Viruses | 154 | 5.61e-41 | NR | P51517.2 | 39068 | g52926 | i0 | 72.5 | 9.92532467532468 | 102 | 28 | 99.4 | 0 | 1 | 306 | 630 | 731 | P51517.2 RecName: Full=Gag-Pro-Pol polyprotein; Contains: RecName: Full=Matrix protein p10; Contains: RecName: Full=Phosphorylated protein pp24; Contains: RecName: Full=Phosphorylated protein pp18; Contains: RecName: Full=p12; Contains: RecName: Full=Capsid protein p27; Contains: RecName: Full=Nucleocapsid protein-dUTPase; Short=NC-dUTPase; Contains: RecName: Full=Protease 17 kDa; Contains: RecName: Full=Protease 13 kDa; Contains: RecName: Full=G-patch peptide; Contains: RecName: Full=Reverse transcriptase/ribonuclease H; Short=RT; Contains: RecName: Full=Integrase; Short=IN [Simian retrovirus 2] | diamond | 3057 | 155 | 0.993548387096774 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 10340232 | 10340232 | PRJEB75230_P_NODE_38189_length_331_cov_1.492248_g38007_i0 | PRJEB75230 | 38189 | 331 | 1.492248 | 4.93934088 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 84.2 | 1.11e-11 | NTclustered | gi|2514203914|gb|OQ751943.1| | 11676 | g38007 | i0 | 81.553 | 2.69486404833837 | 103 | 18 | 31 | 1 | 161 | 263 | 1642 | 1541 | HIV-1 isolate BC003_proviral_154_Chimera from Canada defective provirus genomic sequence | blastn | 892 | 84.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 11198989 | 11198989 | PRJEB75230_P_NODE_107829_length_258_cov_1.135135_g107647_i0 | PRJEB75230 | 107829 | 258 | 1.135135 | 2.9286483 | root | 1 | Root_unresolved | Root_unresolved | 86.3 | 2.14e-17 | NR | pir|D40899| | 11751 | g107647 | i0 | 51.9 | 8.01162790697674 | 77 | 37 | 89.5 | 0 | 232 | 2 | 246 | 322 | pir|D40899| pol polyprotein - Chinese hamster intracisternal A-particle CHIAP34 [Chinese hamster Intracisternal A-particle CHIAP34] | diamond | 2067 | 86.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Chinese hamster Intracisternal A-particle CHIAP34 | ||
| 12890613 | 12890613 | PRJEB75230_P_NODE_31111_length_346_cov_1.520147_g30929_i0 | PRJEB75230 | 31111 | 346 | 1.520147 | 5.25970862 | Prosimian retrovirus 1 | 2821277 | Viruses | Viruses | 132 | 6.889999999999998e-35 | NR | QTI96651.1 | 2821277 | g30929 | i0 | 72.8 | 1.40462427745665 | 81 | 22 | 70.2 | 0 | 245 | 3 | 189 | 269 | QTI96651.1 pro, partial [Prosimian retrovirus 1] | diamond | 486 | 132 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Prosimian retrovirus 1 | ||
| 15439471 | 15439471 | PRJEB75230_P_NODE_29593_length_350_cov_1.599278_g29411_i0 | PRJEB75230 | 29593 | 350 | 1.599278 | 5.597473 | Simian retrovirus 8 | 1904439 | Viruses | Viruses | 162 | 1.6599999999999996e-43 | NR | AOS48109.1 | 1904439 | g29411 | i0 | 69 | 6 | 100 | 31 | 85.7 | 0 | 301 | 2 | 755 | 854 | AOS48109.1 pol protein, partial [Simian retrovirus 8] | diamond | 2100 | 162 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Simian retrovirus 8 | ||
| 19262540 | 19262540 | PRJEB75230_P_NODE_28136_length_355_cov_0.950355_g27954_i0 | PRJEB75230 | 28136 | 355 | 0.950355 | 3.37376025 | Betaretrovirus | 140052 | Viruses | Viruses | 146 | 3.21e-41 | NR | NP_954564.1 | 11855 | g27954 | i0 | 71.8 | 7.83380281690141 | 103 | 27 | 85.4 | 1 | 355 | 53 | 98 | 200 | NP_954564.1 DU [Mason-Pfizer monkey virus] | diamond | 2781 | 146 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 27974546 | 27974546 | PRJEB75230_P_NODE_103565_length_261_cov_1.218085_g103383_i0 | PRJEB75230 | 103565 | 261 | 1.218085 | 3.17920185 | root | 1 | Root_unresolved | Root_unresolved | 125 | 2.75e-31 | NR | AAC97567.1 | 1048243 | g103383 | i0 | 72 | 4.79310344827586 | 82 | 23 | 94.3 | 0 | 10 | 255 | 312 | 393 | AAC97567.1 polymerase, partial [Simian endogenous retrovirus] | diamond | 1251 | 125 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 28226869 | 28226869 | PRJEB75230_P_NODE_35126_length_337_cov_1.587121_g34944_i0 | PRJEB75230 | 35126 | 337 | 1.587121 | 5.34859777 | Betaretrovirus | 140052 | Viruses | Viruses | 144 | 3.34e-37 | NR | ADC52788.1 | 723802 | g34944 | i0 | 62.9 | 8.3946587537092 | 105 | 39 | 93.5 | 0 | 9 | 323 | 386 | 490 | ADC52788.1 pol protein, partial [Simian retrovirus 4] | diamond | 2829 | 144 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Simian retrovirus 4 | ||
| 29024129 | 29024129 | PRJEB75230_P_NODE_132808_length_249_cov_0.875000_g132626_i0 | PRJEB75230 | 132808 | 249 | 0.875 | 2.17875 | Mason-Pfizer monkey virus | 11855 | Viruses | Viruses | 76.3 | 6.4e-14 | NR | NP_056891.1 | 11855 | g132626 | i0 | 56.4 | 1.87951807228916 | 55 | 24 | 66.3 | 0 | 80 | 244 | 1715 | 1769 | NP_056891.1 RT-IN [Mason-Pfizer monkey virus] | diamond | 468 | 76.6 | 0.996083550913838 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 29363958 | 29363958 | PRJEB75230_P_NODE_33209_length_341_cov_1.485075_g33027_i0 | PRJEB75230 | 33209 | 341 | 1.485075 | 5.06410575 | Betaretrovirus | 140052 | Viruses | Viruses | 166 | 4.28e-45 | NR | NP_056891.1 | 11855 | g33027 | i0 | 67 | 3.94134897360704 | 112 | 37 | 98.5 | 0 | 341 | 6 | 1559 | 1670 | NP_056891.1 RT-IN [Mason-Pfizer monkey virus] | diamond | 1344 | 166 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 30160376 | 30160376 | PRJEB75230_P_NODE_72872_length_286_cov_1.230047_g72690_i0 | PRJEB75230 | 72872 | 286 | 1.230047 | 3.51793442 | Simian endogenous retrovirus | 1048243 | Viruses | Viruses | 54.3 | 5.24e-6 | NR | AAC97567.1 | 1048243 | g72690 | i0 | 47.8 | 2.06643356643357 | 67 | 30 | 70.3 | 1 | 6 | 206 | 441 | 502 | AAC97567.1 polymerase, partial [Simian endogenous retrovirus] | diamond | 591 | 54.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 30406451 | 30406451 | PRJEB75230_P_NODE_71713_length_287_cov_1.317757_g71531_i0 | PRJEB75230 | 71713 | 287 | 1.317757 | 3.78196259 | Betaretrovirus | 140052 | Viruses | Viruses | 129 | 2.4599999999999995e-32 | NR | NP_056891.1 | 11855 | g71531 | i0 | 66.7 | 7.80836236933798 | 93 | 28 | 97.2 | 1 | 8 | 286 | 1479 | 1568 | NP_056891.1 RT-IN [Mason-Pfizer monkey virus] | diamond | 2241 | 129 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 30595504 | 30595504 | PRJEB75230_P_NODE_40633_length_327_cov_0.937008_g40451_i0 | PRJEB75230 | 40633 | 327 | 0.937008 | 3.06401616 | Betaretrovirus | 140052 | Viruses | Viruses | 96.3 | 1.7e-20 | NR | BAA03767.1 | 11757 | g40451 | i0 | 49.5 | 7 | 109 | 51 | 100 | 2 | 327 | 1 | 420 | 524 | BAA03767.1 gag pro pol polyprotein, partial [Mouse mammary tumor virus] | diamond | 2289 | 96.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 30919103 | 30919103 | PRJEB75230_P_NODE_183974_length_241_cov_0.916667_g183792_i0 | PRJEB75230 | 183974 | 241 | 0.916667 | 2.20916747 | Bovine retrovirus CH15 | 1822365 | Viruses | Viruses | 88.2 | 3.7e-18 | NR | YP_009243641.1 | 1822365 | g183792 | i0 | 55.4 | 1.8298755186722 | 74 | 33 | 92.1 | 0 | 241 | 20 | 22 | 95 | YP_009243641.1 putative viral DNA polymerase [Bovine retrovirus CH15] | diamond | 441 | 88.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Bovine retrovirus CH15 | ||
| 31171390 | 31171390 | PRJEB75230_P_NODE_138355_length_248_cov_0.880000_g138173_i0 | PRJEB75230 | 138355 | 248 | 0.88 | 2.1824 | Retroviridae sp. | 2681591 | Viruses | Viruses | 63.5 | 1.86e-9 | NR | XNT20491.1 | 2681591 | g138173 | i0 | 59.6 | 0.689516129032258 | 57 | 20 | 65.3 | 1 | 29 | 190 | 539 | 595 | XNT20491.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 171 | 63.5 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 31796757 | 31796757 | PRJEB75230_P_NODE_157457_length_245_cov_0.895349_g157275_i0 | PRJEB75230 | 157457 | 245 | 0.895349 | 2.19360505 | Alpharetrovirus | 153057 | Viruses | Viruses | 103 | 2.06e-23 | NR | CAA45618.1 | 11961 | g157275 | i0 | 59.3 | 9.91836734693878 | 81 | 33 | 99.2 | 0 | 3 | 245 | 92 | 172 | CAA45618.1 Reverse Transcriptase-and Integrase precursor [Lymphoproliferative disease virus] | diamond | 2430 | 104 | 0.990384615384615 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Lymphoproliferative disease virus | ||
| 31994022 | 31994022 | PRJEB75230_P_NODE_173218_length_242_cov_0.934911_g173036_i0 | PRJEB75230 | 173218 | 242 | 0.934911 | 2.26248462 | Simian endogenous retrovirus | 1048243 | Viruses | Viruses | 100 | 1.74e-22 | NR | AAC97567.1 | 1048243 | g173036 | i0 | 60.3 | 3.6198347107438 | 73 | 29 | 90.5 | 0 | 23 | 241 | 295 | 367 | AAC97567.1 polymerase, partial [Simian endogenous retrovirus] | diamond | 876 | 100 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 32057287 | 32057287 | PRJEB75230_P_NODE_59518_length_300_cov_1.281938_g59336_i0 | PRJEB75230 | 59518 | 300 | 1.281938 | 3.845814 | Black Syrian hamster retrovirus | 2594425 | Viruses | Viruses | 59.7 | 8.44e-8 | NR | QDK64674.1 | 2594425 | g59336 | i0 | 34.6 | 2.91 | 107 | 47 | 86 | 3 | 297 | 40 | 696 | 800 | QDK64674.1 pro-pol, partial [Black Syrian hamster retrovirus] | diamond | 873 | 59.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Black Syrian hamster retrovirus | ||
| 32120728 | 32120728 | PRJEB75230_P_NODE_138658_length_248_cov_0.880000_g138476_i0 | PRJEB75230 | 138658 | 248 | 0.88 | 2.1824 | Simian retrovirus 8 | 1904439 | Viruses | Viruses | 129 | 1.4e-32 | NR | AOS48109.1 | 1904439 | g138476 | i0 | 72 | 4.95967741935484 | 82 | 21 | 99.2 | 1 | 246 | 1 | 744 | 823 | AOS48109.1 pol protein, partial [Simian retrovirus 8] | diamond | 1230 | 129 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Simian retrovirus 8 | ||
| 32145043 | 32145043 | PRJEB75230_P_NODE_9578_length_478_cov_1.412346_g9396_i0 | PRJEB75230 | 9578 | 478 | 1.412346 | 6.75101388 | Betaretrovirus | 140052 | Viruses | Viruses | 225 | 5.21e-66 | NR | NP_041261.1 | 11856 | g9396 | i0 | 69 | 4.88284518828452 | 155 | 48 | 97.3 | 0 | 12 | 476 | 304 | 458 | NP_041261.1 pol protein [Squirrel monkey retrovirus] | diamond | 2334 | 225 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 32279027 | 32279027 | PRJEB75230_P_NODE_73399_length_286_cov_0.882629_g73217_i0 | PRJEB75230 | 73399 | 286 | 0.882629 | 2.52431894 | Squirrel monkey retrovirus | 11856 | Viruses | Viruses | 113 | 8.17e-27 | NR | NP_041261.1 | 11856 | g73217 | i0 | 55.8 | 1.99300699300699 | 95 | 41 | 99.7 | 1 | 1 | 285 | 475 | 568 | NP_041261.1 pol protein [Squirrel monkey retrovirus] | diamond | 570 | 113 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 32405451 | 32405451 | PRJEB75230_P_NODE_180859_length_241_cov_0.916667_g180677_i0 | PRJEB75230 | 180859 | 241 | 0.916667 | 2.20916747 | Mason-Pfizer monkey virus | 11855 | Viruses | Viruses | 123 | 1.82e-30 | NR | NP_056891.1 | 11855 | g180677 | i0 | 69.6 | 1.96680497925311 | 79 | 24 | 98.3 | 0 | 3 | 239 | 1266 | 1344 | NP_056891.1 RT-IN [Mason-Pfizer monkey virus] | diamond | 474 | 123 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon |
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);;