contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 969671 | 969671 | PRJNA983848_P_NODE_51601_length_477_cov_3.099010_g45724_i0 | PRJNA983848 | 51601 | 477 | 3.09901 | 14.7822777 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 876 | 0 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g45724 | i0 | 99.79 | 1 | 477 | 1 | 100 | 0 | 1 | 477 | 6777 | 7253 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 477 | 876 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 1271595 | 1271595 | PRJNA983848_P_NODE_150081_length_247_cov_0.896552_g144198_i0 | PRJNA983848 | 150081 | 247 | 0.896552 | 2.21448344 | Viruses | 10239 | Viruses | Viruses | 248 | 2.65e-61 | NTclustered | gi|1817928471|gb|MN988496.1| | 2509575 | g144198 | i0 | 87.736 | 2.78542510121457 | 212 | 26 | 86 | 0 | 36 | 247 | 45134 | 44923 | Rhizobium phage RHph_TM3_3_14B, complete genome | blastn | 688 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHph_TM3_3_14B | |||||
| 2242768 | 2242768 | PRJNA983848_P_NODE_138702_length_252_cov_3.575419_g132819_i0 | PRJNA983848 | 138702 | 252 | 3.575419 | 9.01005588 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 457 | 4.14e-124 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g132819 | i0 | 99.602 | 0.996031746031746 | 251 | 0 | 99 | 1 | 2 | 252 | 2551 | 2800 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 251 | 457 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 2245710 | 2245710 | PRJNA983848_P_NODE_72862_length_368_cov_1.515254_g66979_i0 | PRJNA983848 | 72862 | 368 | 1.515254 | 5.57613472 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|2057905075|tpg|BK051223.1| | 2832643 | g66979 | i0 | 100 | 0.152173913043478 | 28 | 0 | 8 | 0 | 23 | 50 | 18602 | 18575 | MAG TPA_asm: Caudoviricetes sp. isolate ctHTF4, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2246544 | 2246544 | PRJNA983848_P_NODE_95302_length_311_cov_2.663866_g89419_i0 | PRJNA983848 | 95302 | 311 | 2.663866 | 8.28462326 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 575 | 1.3899999999999995e-159 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g89419 | i0 | 100 | 1 | 311 | 0 | 100 | 0 | 1 | 311 | 4983 | 5293 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 311 | 575 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 3517543 | 3517543 | PRJNA983848_P_NODE_123443_length_269_cov_1.591837_g117560_i0 | PRJNA983848 | 123443 | 269 | 1.591837 | 4.28204153 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 497 | 2.63e-136 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g117560 | i0 | 100 | 1 | 269 | 0 | 100 | 0 | 1 | 269 | 5997 | 6265 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 269 | 497 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 3518304 | 3518304 | PRJNA983848_P_NODE_145623_length_249_cov_0.886364_g139740_i0 | PRJNA983848 | 145623 | 249 | 0.886364 | 2.20704636 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 440 | 4.1199999999999984e-119 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g139740 | i0 | 98.785 | 0.991967871485944 | 247 | 3 | 99 | 0 | 3 | 249 | 50808 | 51054 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 247 | 440 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 4795619 | 4795619 | PRJNA983848_P_NODE_143704_length_250_cov_0.881356_g137821_i0 | PRJNA983848 | 143704 | 250 | 0.881356 | 2.20339 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 246 | 9.679999999999999e-61 | NTclustered | gi|1707904021|gb|MK892738.1| | 2591644 | g137821 | i0 | 96.026 | 0.604 | 151 | 6 | 60 | 0 | 1 | 151 | 28219 | 28369 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome | blastn | 151 | 246 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 6069768 | 6069768 | PRJNA983848_P_NODE_110745_length_286_cov_1.267606_g104862_i0 | PRJNA983848 | 110745 | 286 | 1.267606 | 3.62535316 | Bivalve RNA virus G5 | 1926968 | Viruses | Viruses | 202 | 2.4799999999999996e-47 | NTclustered | gi|2032488565|gb|MW588039.1| | 1926968 | g104862 | i0 | 80.702 | 3.88461538461538 | 285 | 34 | 98 | 14 | 6 | 286 | 349 | 82 | Bivalve RNA virus G5 strain Abbotsbury/A/2016 replicative protein and structural protein genes, complete cds | blastn | 1111 | 202 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Bivalve RNA virus G5 | |||
| 7344335 | 7344335 | PRJNA983848_P_NODE_112586_length_283_cov_1.866667_g106703_i0 | PRJNA983848 | 112586 | 283 | 1.866667 | 5.28266761 | Halhan virus 1 | 2480176 | Viruses | Viruses | 215 | 3.15e-51 | NTclustered | gi|1496298283|gb|MG210797.1| | 2480176 | g106703 | i0 | 81.712 | 0.908127208480565 | 257 | 47 | 91 | 0 | 27 | 283 | 4514 | 4258 | Halhan virus 1 replicative protein and structural protein genes, complete cds | blastn | 257 | 215 | 1 | Viruses | Halhan virus 1 | ||||||||
| 9894991 | 9894991 | PRJNA983848_P_NODE_119808_length_274_cov_1.164179_g113925_i0 | PRJNA983848 | 119808 | 274 | 1.164179 | 3.18985046 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g113925 | i0 | 100 | 1 | 274 | 0 | 100 | 0 | 1 | 274 | 1199 | 1472 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 274 | 507 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 11171078 | 11171078 | PRJNA983848_P_NODE_143989_length_250_cov_0.881356_g138106_i0 | PRJNA983848 | 143989 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.91e-122 | NTclustered | gi|2915024281|gb|OR222600.1| | 2832643 | g138106 | i0 | 99.595 | 99.14 | 247 | 1 | 99 | 0 | 1 | 247 | 27305 | 27551 | MAG: Caudoviricetes sp. isolate MSP0334 genomic sequence | blastn | 24785 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11171205 | 11171205 | PRJNA983848_P_NODE_148009_length_248_cov_0.891429_g142126_i0 | PRJNA983848 | 148009 | 248 | 0.891429 | 2.21074392 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 346 | 9.19e-91 | NTclustered | gi|1707904021|gb|MK892738.1| | 2591644 | g142126 | i0 | 92.593 | 0.979838709677419 | 243 | 15 | 98 | 2 | 1 | 243 | 3478 | 3239 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_122_MES_72010_1, partial genome | blastn | 243 | 346 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 12448476 | 12448476 | PRJNA983848_P_NODE_40210_length_598_cov_1.666667_g34383_i0 | PRJNA983848 | 40210 | 598 | 1.666667 | 9.96666866 | Microviridae sp. | 2202644 | Viruses | Viruses | 62.1 | 9.83e-5 | NTclustered | gi|2906149564|gb|PQ646469.1| | 2202644 | g34383 | i0 | 97.222 | 0.523411371237458 | 36 | 1 | 6 | 0 | 167 | 202 | 4331 | 4296 | MAG: Microviridae sp. isolate k127_2075901 genomic sequence | blastn | 313 | 62.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 12448687 | 12448687 | PRJNA983848_P_NODE_46310_length_525_cov_2.196903_g40440_i0 | PRJNA983848 | 46310 | 525 | 2.196903 | 11.53374075 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 970 | 0 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g40440 | i0 | 100 | 1 | 525 | 0 | 100 | 0 | 1 | 525 | 5278 | 5802 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 525 | 970 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 13722936 | 13722936 | PRJNA983848_P_NODE_42031_length_574_cov_2.808383_g36182_i0 | PRJNA983848 | 42031 | 574 | 2.808383 | 16.12011842 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|2057056863|tpg|BK037435.1| | 2832643 | g36182 | i0 | 100 | 0.0505226480836237 | 29 | 0 | 5 | 0 | 180 | 208 | 13449 | 13421 | MAG TPA_asm: Caudoviricetes sp. isolate ctKbT3, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14994470 | 14994470 | PRJNA983848_P_NODE_110832_length_286_cov_0.741784_g104949_i0 | PRJNA983848 | 110832 | 286 | 0.741784 | 2.12150224 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 126 | 1.5399999999999999e-24 | NTclustered | gi|2059608416|tpg|BK037250.1| | 2832643 | g104949 | i0 | 82.313 | 0.513986013986014 | 147 | 24 | 51 | 2 | 16 | 161 | 17633 | 17778 | MAG TPA_asm: Caudoviricetes sp. isolate ctmNp13, partial genome | blastn | 147 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14998779 | 14998779 | PRJNA983848_P_NODE_82192_length_340_cov_3.310861_g76309_i0 | PRJNA983848 | 82192 | 340 | 3.310861 | 11.2569274 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 329 | 1.32e-85 | NTclustered | gi|2245490222|gb|ON164086.1| | 2583949 | g76309 | i0 | 86.184 | 0.894117647058824 | 304 | 42 | 89 | 0 | 37 | 340 | 625 | 322 | MAG: Narnaviridae sp. isolate 17-k141_152900 RNA dependent RNA polymerase gene, partial cds | blastn | 304 | 329 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 16270946 | 16270946 | PRJNA983848_P_NODE_155933_length_244_cov_0.912281_g150050_i0 | PRJNA983848 | 155933 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.48e-103 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g150050 | i0 | 96.97 | 1.90983606557377 | 231 | 7 | 95 | 0 | 1 | 231 | 31141 | 30911 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 466 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16271424 | 16271424 | PRJNA983848_P_NODE_20053_length_1243_cov_4.450427_g15566_i0 | PRJNA983848 | 20053 | 1243 | 4.450427 | 55.31880761 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 987 | 0 | NTclustered | gi|2245490222|gb|ON164086.1| | 2583949 | g15566 | i0 | 81.518 | 0.975060337892196 | 1212 | 213 | 97 | 10 | 1 | 1206 | 1868 | 662 | MAG: Narnaviridae sp. isolate 17-k141_152900 RNA dependent RNA polymerase gene, partial cds | blastn | 1212 | 987 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 17545754 | 17545754 | PRJNA983848_P_NODE_150134_length_247_cov_0.896552_g144251_i0 | PRJNA983848 | 150134 | 247 | 0.896552 | 2.21448344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2915019340|gb|OR222551.1| | 2832643 | g144251 | i0 | 100 | 9.93117408906883 | 247 | 0 | 100 | 0 | 1 | 247 | 39676 | 39430 | MAG: Caudoviricetes sp. isolate MSP0382 genomic sequence | blastn | 2453 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20094569 | 20094569 | PRJNA983848_P_NODE_158176_length_243_cov_0.917647_g152293_i0 | PRJNA983848 | 158176 | 243 | 0.917647 | 2.22988221 | uncultured phage | 278008 | Viruses | Viruses | 169 | 2.0799999999999997e-37 | NTclustered | gi|1804151425|emb|LR756502.1| | 278008 | g152293 | i0 | 79.447 | 1.04115226337449 | 253 | 40 | 99 | 4 | 3 | 243 | 578111 | 577859 | uncultured phage genome assembly, chromosome: 1 | blastn | 253 | 169 | 1 | Viruses | uncultured phage | ||||||||
| 25192841 | 25192841 | PRJNA983848_P_NODE_114520_length_280_cov_3.096618_g108637_i0 | PRJNA983848 | 114520 | 280 | 3.096618 | 8.6705304 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 518 | 2.12e-142 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g108637 | i0 | 100 | 1 | 280 | 0 | 100 | 0 | 1 | 280 | 754 | 1033 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 280 | 518 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 | |||
| 25193152 | 25193152 | PRJNA983848_P_NODE_122640_length_270_cov_1.583756_g116757_i0 | PRJNA983848 | 122640 | 270 | 1.583756 | 4.2761412 | Torque teno midi virus | 432261 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2168962627|gb|MN778391.1| | 432261 | g116757 | i0 | 100 | 0.622222222222222 | 28 | 0 | 10 | 0 | 198 | 225 | 1718 | 1691 | MAG: Torque teno midi virus isolate SAfiA-360-43 ORF1 gene, complete cds | blastn | 168 | 52.8 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Torque teno midi virus | |||
| 25196722 | 25196722 | PRJNA983848_P_NODE_74280_length_363_cov_1.917241_g68397_i0 | PRJNA983848 | 74280 | 363 | 1.917241 | 6.95958483 | Callinectes sapidus toti-like virus 2 | 2916963 | Viruses | Viruses | 632 | 9.67e-177 | NTclustered | gi|2193951683|gb|OL456200.1| | 2916963 | g68397 | i0 | 99.71 | 0.950413223140496 | 345 | 1 | 95 | 0 | 1 | 345 | 3212 | 2868 | Callinectes sapidus toti-like virus 2 isolate AR25, complete genome | blastn | 345 | 632 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Callinectes sapidus toti-like virus 2 |
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);;