contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA758398" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3291040 | 3291040 | PRJNA758398_S_NODE_33223_length_185_cov_3.669118_g33082_i0 | PRJNA758398 | 33223 | 185 | 3.669118 | 6.7878683 | Mitovirus sp. | 2587224 | Viruses | Viruses | 108 | 3.32e-19 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g33082 | i0 | 93.151 | 0.394594594594595 | 73 | 5 | 39 | 0 | 113 | 185 | 111 | 39 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 73 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 4567868 | 4567868 | PRJNA758398_S_NODE_11844_length_283_cov_2.243590_g11703_i0 | PRJNA758398 | 11844 | 283 | 2.24359 | 6.3493597 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 507 | 4.64e-139 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g11703 | i0 | 98.94 | 3.18374558303887 | 283 | 3 | 100 | 0 | 1 | 283 | 4117 | 3835 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 901 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 4567968 | 4567968 | PRJNA758398_S_NODE_18524_length_234_cov_1.378378_g18383_i0 | PRJNA758398 | 18524 | 234 | 1.378378 | 3.22540452 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 132 | 2.62e-26 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g18383 | i0 | 79.208 | 0.863247863247863 | 202 | 32 | 84 | 9 | 19 | 215 | 773747 | 773551 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 202 | 132 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 4568235 | 4568235 | PRJNA758398_S_NODE_404_length_1214_cov_13.658369_g358_i0 | PRJNA758398 | 404 | 1214 | 13.658369 | 165.81259966 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 75 | 2.64e-8 | NTclustered | gi|2500384359|ref|NC_077067.1| | 3060017 | g358 | i0 | 97.674 | 0.150741350906096 | 43 | 1 | 4 | 0 | 715 | 757 | 465857 | 465899 | Fadolivirus 1 strain FV1/VV64, partial genome | blastn | 183 | 75 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 5843107 | 5843107 | PRJNA758398_S_NODE_1805_length_677_cov_2.563694_g1685_i0 | PRJNA758398 | 1805 | 677 | 2.563694 | 17.35620838 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 1234 | 0 | NTclustered | gi|2756423555|gb|PP745568.1| | 1955144 | g1685 | i0 | 99.557 | 6.77991137370753 | 677 | 3 | 100 | 0 | 1 | 677 | 1516 | 840 | MAG: Dicistroviridae sp. isolate 024_1469 genomic sequence | blastn | 4590 | 1234 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 6308446 | 6308446 | PRJNA758398_S_NODE_39345_length_172_cov_1.406504_g39204_i0 | PRJNA758398 | 39345 | 172 | 1.406504 | 2.41918688 | Mimivirus | 315393 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2267817464|gb|MW685904.1| | 212035 | g39204 | i0 | 94.286 | 2.37209302325581 | 35 | 2 | 20 | 0 | 79 | 113 | 295752 | 295786 | Acanthamoeba polyphaga mimivirus isolate M4, complete genome | blastn | 408 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 7118400 | 7118400 | PRJNA758398_S_NODE_19726_length_228_cov_1.865922_g19585_i0 | PRJNA758398 | 19726 | 228 | 1.865922 | 4.25430216 | Bacteriophage sp. | 38018 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2052921599|tpg|BK018044.1| | 38018 | g19585 | i0 | 100 | 0.12719298245614 | 29 | 0 | 13 | 0 | 37 | 65 | 157137 | 157109 | MAG TPA_asm: Bacteriophage sp. isolate ctFT739, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 8392761 | 8392761 | PRJNA758398_S_NODE_11107_length_291_cov_3.020661_g10966_i0 | PRJNA758398 | 11107 | 291 | 3.020661 | 8.79012351 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 527 | 3.67e-145 | NTclustered | gi|2756423425|gb|PP745503.1| | 1955144 | g10966 | i0 | 99.313 | 2.45704467353952 | 291 | 2 | 100 | 0 | 1 | 291 | 1802 | 2092 | MAG: Dicistroviridae sp. isolate 146_82882 genomic sequence | blastn | 715 | 527 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393001 | 8393001 | PRJNA758398_S_NODE_29787_length_194_cov_2.365517_g29646_i0 | PRJNA758398 | 29787 | 194 | 2.365517 | 4.58910298 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 342 | 8.869999999999999e-90 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g29646 | i0 | 98.454 | 1 | 194 | 3 | 100 | 0 | 1 | 194 | 1008 | 1201 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 194 | 342 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393290 | 8393290 | PRJNA758398_S_NODE_6147_length_385_cov_0.842262_g6006_i0 | PRJNA758398 | 6147 | 385 | 0.842262 | 3.2427087 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 689 | 0 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g6006 | i0 | 98.961 | 1.88051948051948 | 385 | 4 | 100 | 0 | 1 | 385 | 268 | 652 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 724 | 689 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8393361 | 8393361 | PRJNA758398_S_NODE_9627_length_311_cov_2.702290_g9486_i0 | PRJNA758398 | 9627 | 311 | 2.70229 | 8.4041219 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 547 | 3.0399999999999987e-151 | NTclustered | gi|2756423555|gb|PP745568.1| | 1955144 | g9486 | i0 | 98.392 | 4 | 311 | 5 | 100 | 0 | 1 | 311 | 540 | 850 | MAG: Dicistroviridae sp. isolate 024_1469 genomic sequence | blastn | 1244 | 547 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 10943915 | 10943915 | PRJNA758398_S_NODE_34469_length_183_cov_0.977612_g34328_i0 | PRJNA758398 | 34469 | 183 | 0.977612 | 1.78902996 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 150 | 5.37e-32 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g34328 | i0 | 89.831 | 0.644808743169399 | 118 | 10 | 64 | 2 | 25 | 141 | 148714 | 148830 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 118 | 150 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 10944070 | 10944070 | PRJNA758398_S_NODE_48169_length_164_cov_0.886957_g48028_i0 | PRJNA758398 | 48169 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 291 | 2.67e-74 | NTclustered | gi|2915023377|gb|OR222591.1| | 2832643 | g48028 | i0 | 98.773 | 18.8414634146341 | 163 | 2 | 99 | 0 | 2 | 164 | 58510 | 58672 | MAG: Caudoviricetes sp. isolate MSP0342 genomic sequence | blastn | 3090 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12219210 | 12219210 | PRJNA758398_S_NODE_15130_length_255_cov_1.058252_g14989_i0 | PRJNA758398 | 15130 | 255 | 1.058252 | 2.6985426 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 449 | 7.03e-122 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g14989 | i0 | 98.431 | 2 | 255 | 4 | 100 | 0 | 1 | 255 | 2557 | 2811 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 510 | 449 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 13493659 | 13493659 | PRJNA758398_S_NODE_4171_length_463_cov_4.944444_g4030_i0 | PRJNA758398 | 4171 | 463 | 4.944444 | 22.89277572 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.045 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g4030 | i0 | 100 | 0.060475161987041 | 28 | 0 | 6 | 0 | 360 | 387 | 1569 | 1596 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13493855 | 13493855 | PRJNA758398_S_NODE_9991_length_306_cov_2.143969_g9850_i0 | PRJNA758398 | 9991 | 306 | 2.143969 | 6.56054514 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g9850 | i0 | 100 | 9.47712418300654 | 29 | 0 | 9 | 0 | 65 | 93 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 14768575 | 14768575 | PRJNA758398_S_NODE_2332_length_606_cov_20.962298_g2201_i0 | PRJNA758398 | 2332 | 606 | 20.962298 | 127.03152588 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 65.8 | 7.71e-6 | NTclustered | gi|37701115|gb|AY397046.1| | 11676 | g2201 | i0 | 97.368 | 2.12211221122112 | 38 | 1 | 6 | 0 | 185 | 222 | 334 | 297 | HIV-1 strain A|A15 from Ghana gag protein (gag) gene, partial cds | blastn | 1286 | 65.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 17318206 | 17318206 | PRJNA758398_S_NODE_49174_length_163_cov_1.789474_g49033_i0 | PRJNA758398 | 49174 | 163 | 1.789474 | 2.91684262 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g49033 | i0 | 100 | 1 | 163 | 0 | 100 | 0 | 1 | 163 | 1375 | 1213 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 163 | 302 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 18591258 | 18591258 | PRJNA758398_S_NODE_15775_length_250_cov_2.024876_g15634_i0 | PRJNA758398 | 15775 | 250 | 2.024876 | 5.06219 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 457 | 4.1099999999999985e-124 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g15634 | i0 | 99.6 | 2 | 250 | 1 | 100 | 0 | 1 | 250 | 1951 | 1702 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 500 | 457 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 19866352 | 19866352 | PRJNA758398_S_NODE_10056_length_305_cov_2.039062_g9915_i0 | PRJNA758398 | 10056 | 305 | 2.039062 | 6.2191391 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 514 | 3.02e-141 | NTclustered | gi|2756423425|gb|PP745503.1| | 1955144 | g9915 | i0 | 97.973 | 1.94098360655738 | 296 | 6 | 97 | 0 | 10 | 305 | 383 | 678 | MAG: Dicistroviridae sp. isolate 146_82882 genomic sequence | blastn | 592 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 21142477 | 21142477 | PRJNA758398_S_NODE_47417_length_164_cov_1.330435_g47276_i0 | PRJNA758398 | 47417 | 164 | 1.330435 | 2.1819134 | Tupanvirus salinum | 3060758 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2500358058|ref|NC_075039.1| | 2126985 | g47276 | i0 | 90.476 | 0.25609756097561 | 42 | 4 | 26 | 0 | 36 | 77 | 699101 | 699060 | Tupanvirus soda lake, partial genome | blastn | 42 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 22416925 | 22416925 | PRJNA758398_S_NODE_18158_length_236_cov_1.363636_g18017_i0 | PRJNA758398 | 18158 | 236 | 1.363636 | 3.21818096 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 409 | 1.09e-109 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g18017 | i0 | 97.881 | 2.99152542372881 | 236 | 5 | 100 | 0 | 1 | 236 | 841 | 606 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 706 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 22417290 | 22417290 | PRJNA758398_S_NODE_48798_length_164_cov_0.886957_g48657_i0 | PRJNA758398 | 48798 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|2056880381|tpg|BK053473.1| | 2832643 | g48657 | i0 | 100 | 11 | 164 | 0 | 100 | 0 | 1 | 164 | 25391 | 25228 | MAG TPA_asm: Caudoviricetes sp. isolate ctfgj2, partial genome | blastn | 1804 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24966603 | 24966603 | PRJNA758398_S_NODE_9220_length_318_cov_1.520446_g9079_i0 | PRJNA758398 | 9220 | 318 | 1.520446 | 4.83501828 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 577 | 3.9799999999999996e-160 | NTclustered | gi|2756423236|gb|PP745408.1| | 1955144 | g9079 | i0 | 99.371 | 1.25157232704403 | 318 | 2 | 100 | 0 | 1 | 318 | 1673 | 1356 | MAG: Dicistroviridae sp. isolate 145_122521 genomic sequence | blastn | 398 | 577 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. |
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);;