contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1842702 | 1842702 | PRJNA594101_S_NODE_44242_length_262_cov_2.661376_g43940_i0 | PRJNA594101 | 44242 | 262 | 2.661376 | 6.97280512 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 62.1 | 3.97e-5 | NTclustered | gi|407734945|gb|JX447155.1| | 11676 | g43940 | i0 | 95 | 0.305343511450382 | 40 | 0 | 15 | 2 | 129 | 168 | 4394 | 4357 | HIV-1 isolate AA039a03R from Thailand pol protein (pol) gene, partial cds; and vif protein (vif), vpr protein (vpr), vpu protein (vpu), envelope glycoprotein (env), and nef protein (nef) genes, complete cds | blastn | 80 | 62.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 3117959 | 3117959 | PRJNA594101_S_NODE_22483_length_355_cov_1.705674_g22181_i0 | PRJNA594101 | 22483 | 355 | 1.705674 | 6.0551427 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g22181 | i0 | 100 | 8.16901408450704 | 29 | 0 | 8 | 0 | 51 | 79 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 4394636 | 4394636 | PRJNA594101_S_NODE_32904_length_300_cov_1.726872_g32602_i0 | PRJNA594101 | 32904 | 300 | 1.726872 | 5.180616 | Pithovirus LCDPAC01 | 2506600 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|1588058088|gb|MK500295.1| | 2506600 | g32602 | i0 | 100 | 0.186666666666667 | 28 | 0 | 9 | 0 | 148 | 175 | 1296 | 1269 | MAG: Pithovirus LCDPAC01 genomic sequence | blastn | 56 | 52.8 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 10771429 | 10771429 | PRJNA594101_S_NODE_43909_length_263_cov_2.178947_g43607_i0 | PRJNA594101 | 43909 | 263 | 2.178947 | 5.73063061 | Mitovirus sp. | 2587224 | Viruses | Viruses | 148 | 2.9799999999999997e-31 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g43607 | i0 | 93.878 | 3.5171102661597 | 98 | 6 | 37 | 0 | 1 | 98 | 15 | 112 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 925 | 148 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 17144676 | 17144676 | PRJNA594101_S_NODE_25974_length_332_cov_13.498069_g25672_i0 | PRJNA594101 | 25974 | 332 | 13.498069 | 44.81358908 | Escherichia phage A4 | 2950725 | Viruses | Viruses | 58.4 | 6.72e-4 | NTclustered | gi|2258073376|gb|ON286972.1| | 2950725 | g25672 | i0 | 100 | 0.635542168674699 | 31 | 0 | 9 | 0 | 4 | 34 | 69167 | 69197 | Escherichia phage A4, complete genome | blastn | 211 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Asteriusvirus | Escherichia phage A4 | ||||
| 17144770 | 17144770 | PRJNA594101_S_NODE_38254_length_281_cov_1.105769_g37952_i0 | PRJNA594101 | 38254 | 281 | 1.105769 | 3.10721089 | Hubei orthoptera virus 4 | 1923012 | Viruses | Viruses | 58.4 | 5.57e-4 | NTclustered | gi|2717470121|gb|PP272689.1| | 1923012 | g37952 | i0 | 100 | 0.110320284697509 | 31 | 0 | 11 | 0 | 250 | 280 | 2700 | 2730 | MAG: Hubei orthoptera virus 4 isolate ribo_32 RNA-dependent RNA polymerase gene, partial cds | blastn | 31 | 58.4 | 1 | Viruses | Hubei orthoptera virus 4 | ||||||||
| 18419050 | 18419050 | PRJNA594101_S_NODE_47495_length_254_cov_1.254144_g47193_i0 | PRJNA594101 | 47495 | 254 | 1.254144 | 3.18552576 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 265 | 2.7199999999999996e-66 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g47193 | i0 | 85.887 | 176.05905511811 | 248 | 35 | 98 | 0 | 5 | 252 | 162555 | 162802 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 44719 | 265 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 22244084 | 22244084 | PRJNA594101_S_NODE_10098_length_516_cov_1.790068_g9798_i0 | PRJNA594101 | 10098 | 516 | 1.790068 | 9.23675088 | Pandoravirus quercus | 2107709 | Viruses | Viruses | 69.4 | 5.02e-7 | NTclustered | gi|1408259612|ref|NC_037667.1| | 2107709 | g9798 | i0 | 84.286 | 0.631782945736434 | 70 | 11 | 14 | 0 | 82 | 151 | 1563577 | 1563508 | Pandoravirus quercus, complete genome | blastn | 326 | 69.4 | 1 | Viruses | Pandoravirus | Pandoravirus quercus | |||||||
| 24091389 | 24091389 | PRJNA594101_S_NODE_8819_length_551_cov_2.594142_g8519_i0 | PRJNA594101 | 8819 | 551 | 2.594142 | 14.29372242 | Lambdapapillomavirus | 325462 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|21039033|gb|AF377865.1| | 181667 | g8519 | i0 | 96.97 | 0.17967332123412 | 33 | 1 | 6 | 0 | 516 | 548 | 3175 | 3207 | Feline papillomavirus putative transforming protein E6 (E6), putative transforming protein E7 (E7), putative replication protein E1 (E1), and putative regulatory protein E2 (E2) genes, complete cds; putative protein E4 (E4) gene, partial cds; and putative minor capsid protein L2 (L2) and putative major capsid protein L1 (L1) genes, complete cds | blastn | 99 | 56.5 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Lambdapapillomavirus | Lambdapapillomavirus 1 | ||
| 24793409 | 24793409 | PRJNA594101_S_NODE_6760_length_627_cov_10.691336_g6464_i0 | PRJNA594101 | 6760 | 627 | 10.691336 | 67.03467672 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 56.5 | 0.005 | NTclustered | gi|1839202119|emb|LR797277.1| | 2100421 | g6464 | i0 | 94.444 | 0.114832535885167 | 36 | 2 | 6 | 0 | 201 | 236 | 12643 | 12608 | uncultured Caudovirales phage genome assembly | blastn | 72 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;