contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26949882 | 26949882 | PRJNA493632_P_NODE_314182_length_291_cov_1.284404_g310743_i0 | PRJNA493632 | 314182 | 291 | 1.284404 | 3.73761564 | Mouse Intracisternal A-particle | 11932 | Viruses | Viruses | 60.1 | 5.14e-8 | NR | P31789.1 | 11932 | g310743 | i0 | 40.7 | 0.938144329896907 | 91 | 54 | 93.8 | 0 | 275 | 3 | 463 | 553 | P31789.1 RecName: Full=Envelope glycoprotein; AltName: Full=Env polyprotein; Contains: RecName: Full=Surface protein; Short=SU; Contains: RecName: Full=Transmembrane protein; Short=TM; Flags: Precursor [Mouse Intracisternal A-particle] | diamond | 273 | 60.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Mouse Intracisternal A-particle | ||
| 27139490 | 27139490 | PRJNA493632_P_NODE_607802_length_244_cov_1.456140_g604361_i0 | PRJNA493632 | 607802 | 244 | 1.45614 | 3.5529816 | Retroviridae sp. | 2681591 | Viruses | Viruses | 119 | 5.32e-29 | NR | UGO47158.1 | 2681591 | g604361 | i0 | 70.4 | 7.90573770491803 | 81 | 24 | 99.6 | 0 | 1 | 243 | 451 | 531 | UGO47158.1 MAG: envelope protein [Retroviridae sp.] | diamond | 1929 | 119 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 27361201 | 27361201 | PRJNA493632_P_NODE_221423_length_331_cov_1.344961_g217988_i0 | PRJNA493632 | 221423 | 331 | 1.344961 | 4.45182091 | Mouse Intracisternal A-particle | 11932 | Viruses | Viruses | 91.3 | 9.56e-19 | NR | P31789.1 | 11932 | g217988 | i0 | 57.3 | 0.806646525679758 | 89 | 38 | 80.7 | 0 | 291 | 25 | 393 | 481 | P31789.1 RecName: Full=Envelope glycoprotein; AltName: Full=Env polyprotein; Contains: RecName: Full=Surface protein; Short=SU; Contains: RecName: Full=Transmembrane protein; Short=TM; Flags: Precursor [Mouse Intracisternal A-particle] | diamond | 267 | 91.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Mouse Intracisternal A-particle | ||
| 28055638 | 28055638 | PRJNA493632_P_NODE_541485_length_249_cov_0.875000_g538046_i0 | PRJNA493632 | 541485 | 249 | 0.875 | 2.17875 | Lampyris noctiluca errantivirus 1 | 2552986 | Viruses | Viruses | 120 | 1.32e-29 | NR | QBP37036.1 | 2552986 | g538046 | i0 | 74.4 | 1.97590361445783 | 82 | 21 | 98.8 | 0 | 3 | 248 | 316 | 397 | QBP37036.1 putative RdRP [Lampyris noctiluca errantivirus 1] | diamond | 492 | 120 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Metaviridae | Errantivirus | Lampyris noctiluca errantivirus 1 | ||
| 28560985 | 28560985 | PRJNA493632_P_NODE_220227_length_332_cov_0.895753_g216792_i0 | PRJNA493632 | 220227 | 332 | 0.895753 | 2.97389996 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 72 | 1.18e-12 | NR | 6HWW_A | 11786 | g216792 | i0 | 82 | 1.31927710843373 | 50 | 9 | 45.2 | 0 | 289 | 140 | 172 | 221 | 6HWW_A Chain A, Putative gag polyprotein [Murine leukemia virus] | diamond | 438 | 72 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 29350365 | 29350365 | PRJNA493632_P_NODE_541309_length_249_cov_0.875000_g537870_i0 | PRJNA493632 | 541309 | 249 | 0.875 | 2.17875 | Prosimian retrovirus 1 | 2821277 | Viruses | Viruses | 48.5 | 3.81e-4 | NR | QTI96652.1 | 2821277 | g537870 | i0 | 48.9 | 1.10843373493976 | 47 | 24 | 56.6 | 0 | 28 | 168 | 630 | 676 | QTI96652.1 pol [Prosimian retrovirus 1] | diamond | 276 | 48.5 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Prosimian retrovirus 1 | ||
| 29539548 | 29539548 | PRJNA493632_P_NODE_319950_length_289_cov_3.009259_g316511_i0 | PRJNA493632 | 319950 | 289 | 3.009259 | 8.69675851 | Atlantic salmon swim bladder sarcoma virus | 348296 | Viruses | Viruses | 94.7 | 3.65e-20 | NR | YP_443922.1 | 348296 | g316511 | i0 | 60.3 | 1.45328719723183 | 73 | 29 | 75.8 | 0 | 288 | 70 | 929 | 1001 | YP_443922.1 polyprotein [Atlantic salmon swim bladder sarcoma virus] | diamond | 420 | 94.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Atlantic salmon swim bladder sarcoma virus | |||
| 29602505 | 29602505 | PRJNA493632_P_NODE_420010_length_268_cov_1.482051_g416571_i0 | PRJNA493632 | 420010 | 268 | 1.482051 | 3.97189668 | Baboon endogenous virus strain M7 | 11764 | Viruses | Viruses | 175 | 1.25e-48 | NR | YP_009109689.1 | 11764 | g416571 | i0 | 95.5 | 11.955223880597 | 89 | 4 | 99.6 | 0 | 1 | 267 | 1511 | 1599 | YP_009109689.1 gag-pol precursor polyprotein [Baboon endogenous virus strain M7] | diamond | 3204 | 176 | 0.994318181818182 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Baboon endogenous virus | ||
| 29760545 | 29760545 | PRJNA493632_P_NODE_332591_length_287_cov_0.836449_g329152_i0 | PRJNA493632 | 332591 | 287 | 0.836449 | 2.40060863 | Mouse Intracisternal A-particle | 11932 | Viruses | Viruses | 94.4 | 4.43e-20 | NR | P31789.1 | 11932 | g329152 | i0 | 63.6 | 0.804878048780488 | 77 | 28 | 80.5 | 0 | 4 | 234 | 476 | 552 | P31789.1 RecName: Full=Envelope glycoprotein; AltName: Full=Env polyprotein; Contains: RecName: Full=Surface protein; Short=SU; Contains: RecName: Full=Transmembrane protein; Short=TM; Flags: Precursor [Mouse Intracisternal A-particle] | diamond | 231 | 94.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Mouse Intracisternal A-particle | ||
| 29950244 | 29950244 | PRJNA493632_P_NODE_349371_length_283_cov_1.447619_g345932_i0 | PRJNA493632 | 349371 | 283 | 1.447619 | 4.09676177 | Mouse Intracisternal A-particle | 11932 | Viruses | Viruses | 66.2 | 1.54e-10 | NR | P31790.1 | 11932 | g345932 | i0 | 58.1 | 0.657243816254417 | 62 | 26 | 65.7 | 0 | 19 | 204 | 1 | 62 | P31790.1 RecName: Full=Intracisternal A-particle Gag-related polyprotein [Mouse Intracisternal A-particle] | diamond | 186 | 66.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Mouse Intracisternal A-particle | ||
| 30613642 | 30613642 | PRJNA493632_P_NODE_564513_length_247_cov_1.258621_g561074_i0 | PRJNA493632 | 564513 | 247 | 1.258621 | 3.10879387 | Mus dunni endogenous virus | 75986 | Viruses | Viruses | 43.1 | 0.0289 | NR | AAC31803.1 | 75986 | g561074 | i0 | 51.9 | 0.631578947368421 | 52 | 25 | 63.2 | 0 | 44 | 199 | 64 | 115 | AAC31803.1 glycosylated gag protein [Mus dunni endogenous virus] | diamond | 156 | 43.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 30929752 | 30929752 | PRJNA493632_P_NODE_643834_length_242_cov_0.911243_g640393_i0 | PRJNA493632 | 643834 | 242 | 0.911243 | 2.20520806 | Golden hamster intracisternal A-particle H18 | 11752 | Viruses | Viruses | 95.1 | 1.36e-20 | NR | P04026.1 | 11752 | g640393 | i0 | 52.6 | 0.966942148760331 | 78 | 37 | 96.7 | 0 | 2 | 235 | 113 | 190 | 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 | 234 | 95.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Golden hamster intracisternal A-particle H18 | ||
| 31056399 | 31056399 | PRJNA493632_P_NODE_435775_length_265_cov_0.802083_g432336_i0 | PRJNA493632 | 435775 | 265 | 0.802083 | 2.12551995 | Simian retrovirus 2 | 39068 | Viruses | Viruses | 44.7 | 0.0103 | NR | P51517.2 | 39068 | g432336 | i0 | 39.4 | 1.49433962264151 | 66 | 34 | 67.9 | 2 | 254 | 75 | 1536 | 1601 | 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 | 396 | 44.7 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus maspfimon | ||
| 31941279 | 31941279 | PRJNA493632_P_NODE_114817_length_430_cov_0.843137_g111406_i0 | PRJNA493632 | 114817 | 430 | 0.843137 | 3.6254891 | Chinese hamster Intracisternal A-particle CHIAP34 | 11751 | Viruses | Viruses | 80.9 | 1.35e-14 | NR | pir|D40899| | 11751 | g111406 | i0 | 51.6 | 0.872093023255814 | 64 | 31 | 44.7 | 0 | 237 | 428 | 107 | 170 | pir|D40899| pol polyprotein - Chinese hamster intracisternal A-particle CHIAP34 [Chinese hamster Intracisternal A-particle CHIAP34] | diamond | 375 | 80.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Intracisternal A-particles | Chinese hamster Intracisternal A-particle CHIAP34 | ||
| 32353202 | 32353202 | PRJNA493632_P_NODE_557799_length_248_cov_0.880000_g554360_i0 | PRJNA493632 | 557799 | 248 | 0.88 | 2.1824 | Halyomorpha halys erranti-like virus 1 | 2950329 | Viruses | Viruses | 83.6 | 1.7e-16 | NR | URQ09129.1 | 2950329 | g554360 | i0 | 56.5 | 0.834677419354839 | 69 | 30 | 83.5 | 0 | 2 | 208 | 663 | 731 | URQ09129.1 replicase [Halyomorpha halys erranti-like virus 1] | diamond | 207 | 83.6 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Metaviridae | Halyomorpha halys erranti-like virus 1 | |||
| 32763233 | 32763233 | PRJNA493632_P_NODE_46420_length_625_cov_0.920290_g43213_i0 | PRJNA493632 | 46420 | 625 | 0.92029 | 5.7518125 | Lampyris noctiluca errantivirus 1 | 2552986 | Viruses | Viruses | 200 | 2.1099999999999993e-55 | NR | QBP37036.1 | 2552986 | g43213 | i0 | 70.6 | 0.6864 | 143 | 42 | 68.6 | 0 | 430 | 2 | 264 | 406 | QBP37036.1 putative RdRP [Lampyris noctiluca errantivirus 1] | diamond | 429 | 200 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Metaviridae | Errantivirus | Lampyris noctiluca errantivirus 1 |
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);;