contig_metadata
17 rows where bioproject = "PRJNA485080" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8102090 | 8102090 | PRJNA485080_P_NODE_18187_length_272_cov_0.869347_g18093_i0 | PRJNA485080 | 18187 | 272 | 0.869347 | 2.36462384 | IAP H10 | 11968 | Viruses | Viruses | 172 | 1.84e-38 | NTclustered | gi|61590|emb|X00024.1| | 11968 | g18093 | i0 | 82.828 | 47.6397058823529 | 198 | 29 | 72 | 5 | 78 | 272 | 164 | 359 | Syrian hamster intracisternal A particle H10 3'end with long terminal repeat and flanking region | blastn | 12958 | 172 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | IAP H10 | ||
| 10652708 | 10652708 | PRJNA485080_P_NODE_16529_length_282_cov_1.641148_g16435_i0 | PRJNA485080 | 16529 | 282 | 1.641148 | 4.62803736 | Retroviridae sp. | 2681591 | Viruses | Viruses | 184 | 1.7e-52 | NR | XNT20575.1 | 2681591 | g16435 | i0 | 87.1 | 0.98936170212766 | 93 | 12 | 98.9 | 0 | 2 | 280 | 474 | 566 | XNT20575.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 279 | 184 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 23401211 | 23401211 | PRJNA485080_P_NODE_12359_length_314_cov_0.834025_g12265_i0 | PRJNA485080 | 12359 | 314 | 0.834025 | 2.6188385 | Intracisternal A-particles | 11749 | Viruses | Viruses | 123 | 3.52e-30 | NR | pir|D40899| | 11751 | g12265 | i0 | 77 | 1.4140127388535 | 74 | 17 | 70.7 | 0 | 93 | 314 | 82 | 155 | pir|D40899| pol polyprotein - Chinese hamster intracisternal A-particle CHIAP34 [Chinese hamster Intracisternal A-particle CHIAP34] | diamond | 444 | 123 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Chinese hamster Intracisternal A-particle CHIAP34 | ||
| 23401679 | 23401679 | PRJNA485080_P_NODE_4419_length_451_cov_1.222222_g4325_i0 | PRJNA485080 | 4419 | 451 | 1.222222 | 5.51222122 | Retroviridae sp. | 2681591 | Viruses | Viruses | 89.7 | 1.38e-17 | NR | XNT20490.1 | 2681591 | g4325 | i0 | 50 | 0.545454545454545 | 82 | 41 | 54.5 | 0 | 3 | 248 | 173 | 254 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 246 | 89.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 26918150 | 26918150 | PRJNA485080_P_NODE_9882_length_337_cov_1.071970_g9788_i0 | PRJNA485080 | 9882 | 337 | 1.07197 | 3.6125389 | Retroviridae sp. | 2681591 | Viruses | Viruses | 103 | 3.75e-23 | NR | XNT20490.1 | 2681591 | g9788 | i0 | 47.6 | 0.934718100890208 | 105 | 55 | 93.5 | 0 | 23 | 337 | 240 | 344 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 315 | 103 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 27076297 | 27076297 | PRJNA485080_P_NODE_1682_length_680_cov_1.602965_g1596_i0 | PRJNA485080 | 1682 | 680 | 1.602965 | 10.900162 | Simian retrovirus 4 | 723802 | Viruses | Viruses | 73.6 | 4.98e-11 | NR | ADC52788.1 | 723802 | g1596 | i0 | 41.3 | 0.644117647058824 | 75 | 44 | 33.1 | 0 | 61 | 285 | 389 | 463 | ADC52788.1 pol protein, partial [Simian retrovirus 4] | diamond | 438 | 73.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Simian retrovirus 4 | ||
| 27234351 | 27234351 | PRJNA485080_P_NODE_27483_length_249_cov_0.875000_g27389_i0 | PRJNA485080 | 27483 | 249 | 0.875 | 2.17875 | Gunnison's prairie dog retrovirus | 2744145 | Viruses | Viruses | 77 | 2.09e-14 | NR | QKU38050.1 | 2744145 | g27389 | i0 | 52.8 | 1.07228915662651 | 89 | 31 | 100 | 2 | 1 | 249 | 9 | 92 | QKU38050.1 Pro, partial [Gunnison's prairie dog retrovirus] | diamond | 267 | 77 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gunnison's prairie dog retrovirus | |||
| 27802985 | 27802985 | PRJNA485080_P_NODE_17104_length_279_cov_0.898058_g17010_i0 | PRJNA485080 | 17104 | 279 | 0.898058 | 2.50558182 | Retroviridae sp. | 2681591 | Viruses | Viruses | 112 | 2.48e-26 | NR | XNT20490.1 | 2681591 | g17010 | i0 | 60.2 | 0.89247311827957 | 83 | 33 | 89.2 | 0 | 30 | 278 | 502 | 584 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 249 | 112 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 28055294 | 28055294 | PRJNA485080_P_NODE_11045_length_325_cov_1.222222_g10951_i0 | PRJNA485080 | 11045 | 325 | 1.222222 | 3.9722215 | Mouse mammary tumor virus | 11757 | Viruses | Viruses | 97.1 | 8.78e-21 | NR | BAA03767.1 | 11757 | g10951 | i0 | 57.5 | 7.19076923076923 | 80 | 34 | 73.8 | 0 | 47 | 286 | 721 | 800 | BAA03767.1 gag pro pol polyprotein, partial [Mouse mammary tumor virus] | diamond | 2337 | 97.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 29160796 | 29160796 | PRJNA485080_P_NODE_2829_length_546_cov_1.684989_g2735_i0 | PRJNA485080 | 2829 | 546 | 1.684989 | 9.20003994 | Retroviridae sp. | 2681591 | Viruses | Viruses | 57.8 | 4.29e-6 | NR | XNT20490.1 | 2681591 | g2735 | i0 | 28.9 | 1.43406593406593 | 135 | 82 | 70.3 | 2 | 161 | 544 | 366 | 493 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 783 | 57.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 29539301 | 29539301 | PRJNA485080_P_NODE_31150_length_247_cov_0.885057_g31056_i0 | PRJNA485080 | 31150 | 247 | 0.885057 | 2.18609079 | Golden hamster intracisternal A-particle H18 | 11752 | Viruses | Viruses | 125 | 2.3e-31 | NR | P04026.1 | 11752 | g31056 | i0 | 76.8 | 0.995951417004049 | 82 | 19 | 99.6 | 0 | 247 | 2 | 402 | 483 | P04026.1 RecName: Full=Intracisternal A-particle Pol-related polyprotein; Contains: RecName: Full=Reverse transcriptase/ribonuclease H; Short=RT; Contains: RecName: Full=Integrase; Short=IN [Golden hamster intracisternal A-particle H18] | diamond | 246 | 125 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Golden hamster intracisternal A-particle H18 | ||
| 29839639 | 29839639 | PRJNA485080_P_NODE_11651_length_320_cov_0.821862_g11557_i0 | PRJNA485080 | 11651 | 320 | 0.821862 | 2.6299584 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 2.56e-4 | NR | P51517.2 | 39068 | g11557 | i0 | 42.6 | 3.58125 | 54 | 31 | 50.6 | 0 | 166 | 5 | 1265 | 1318 | 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 | 1146 | 50.4 | 0.994047619047619 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 30644831 | 30644831 | PRJNA485080_P_NODE_15693_length_288_cov_1.074419_g15599_i0 | PRJNA485080 | 15693 | 288 | 1.074419 | 3.09432672 | Retroviridae sp. | 2681591 | Viruses | Viruses | 71.2 | 5.97e-12 | NR | XNT20490.1 | 2681591 | g15599 | i0 | 48 | 0.78125 | 75 | 39 | 78.1 | 0 | 2 | 226 | 419 | 493 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 225 | 71.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 31150098 | 31150098 | PRJNA485080_P_NODE_14655_length_295_cov_1.527027_g14561_i0 | PRJNA485080 | 14655 | 295 | 1.527027 | 4.50472965 | Retroviridae sp. | 2681591 | Viruses | Viruses | 79.3 | 9.67e-15 | NR | XNT20490.1 | 2681591 | g14561 | i0 | 77.8 | 0.457627118644068 | 45 | 10 | 45.8 | 0 | 135 | 1 | 569 | 613 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 135 | 79.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 31561849 | 31561849 | PRJNA485080_P_NODE_8036_length_360_cov_0.857143_g7942_i0 | PRJNA485080 | 8036 | 360 | 0.857143 | 3.0857148 | Retroviridae sp. | 2681591 | Viruses | Viruses | 81.6 | 3.38e-15 | NR | XNT20490.1 | 2681591 | g7942 | i0 | 47.9 | 0.608333333333333 | 73 | 38 | 60.8 | 0 | 127 | 345 | 309 | 381 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 219 | 81.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 32036158 | 32036158 | PRJNA485080_P_NODE_218_length_1465_cov_1.155891_g186_i0 | PRJNA485080 | 218 | 1465 | 1.155891 | 16.93380315 | Retroviridae sp. | 2681591 | Viruses | Viruses | 169 | 2.13e-41 | NR | XNT20490.1 | 2681591 | g186 | i0 | 55 | 0.327645051194539 | 160 | 64 | 31.1 | 2 | 1393 | 938 | 462 | 621 | XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.] | diamond | 480 | 169 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 32621496 | 32621496 | PRJNA485080_P_NODE_14220_length_299_cov_0.823009_g14126_i0 | PRJNA485080 | 14220 | 299 | 0.823009 | 2.46079691 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 6.180000000000001e-21 | NR | BAA03767.1 | 11757 | g14126 | i0 | 43.2 | 6.70234113712375 | 95 | 54 | 95.3 | 0 | 3 | 287 | 376 | 470 | BAA03767.1 gag pro pol polyprotein, partial [Mouse mammary tumor virus] | diamond | 2004 | 97.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum |
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);;