contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 920646 | 920646 | PRJNA940501_S_NODE_335501_length_160_cov_1.606838_g334683_i0 | PRJNA940501 | 335501 | 160 | 1.606838 | 2.5709408 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 182 | 1.62e-41 | NTclustered | gi|1624806707|gb|MK638720.1| | 1543320 | g334683 | i0 | 91.603 | 16.59375 | 131 | 11 | 82 | 0 | 1 | 131 | 235 | 105 | Erythrocytic necrosis virus isolate SEQ_18 putative RNA-dependent DNA polymerase mRNA, partial cds | blastn | 2655 | 182 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 2534240 | 2534240 | PRJNA940501_S_NODE_80802_length_252_cov_1.679426_g79984_i0 | PRJNA940501 | 80802 | 252 | 1.679426 | 4.23215352 | Alphatectivirus | 2169669 | Viruses | Viruses | 424 | 4.2e-114 | NTclustered | gi|2693686684|gb|PP412828.1| | 3127592 | g79984 | i0 | 100 | 54.8849206349206 | 229 | 0 | 91 | 0 | 1 | 229 | 1612 | 1840 | Enterobacteria phage PRDcobalt, complete genome | blastn | 13831 | 424 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Enterobacteria phage PRDcobalt | |||
| 4747759 | 4747759 | PRJNA940501_S_NODE_226004_length_185_cov_1.535211_g225186_i0 | PRJNA940501 | 226004 | 185 | 1.535211 | 2.84014035 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|325073632|gb|HM133903.1| | 10258 | g225186 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 2 | 29 | 133678 | 133705 | Orf virus strain D1701, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 5085740 | 5085740 | PRJNA940501_S_NODE_168504_length_204_cov_1.167702_g167686_i0 | PRJNA940501 | 168504 | 204 | 1.167702 | 2.38211208 | Deltaentomopoxvirus | 2733302 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|9631294|ref|NC_001993.1| | 83191 | g167686 | i0 | 100 | 0.274509803921569 | 28 | 0 | 14 | 0 | 22 | 49 | 192478 | 192505 | Melanoplus sanguinipes entomopoxvirus, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Deltaentomopoxvirus | Deltaentomopoxvirus msanguinipes | ||
| 6020686 | 6020686 | PRJNA940501_S_NODE_103405_length_236_cov_0.984456_g102587_i0 | PRJNA940501 | 103405 | 236 | 0.984456 | 2.32331616 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 361 | 3.1e-95 | NTclustered | gi|1624806635|gb|MK638688.1| | 1543320 | g102587 | i0 | 93.878 | 7.16101694915254 | 245 | 6 | 100 | 2 | 1 | 236 | 152 | 396 | Erythrocytic necrosis virus isolate SEQ_16 hypothetical protein mRNA, partial cds | blastn | 1690 | 361 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 7636028 | 7636028 | PRJNA940501_S_NODE_274326_length_173_cov_1.084615_g273508_i0 | PRJNA940501 | 274326 | 173 | 1.084615 | 1.87638395 | Mimiviridae | 549779 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|363539767|ref|NC_016072.1| | 1094892 | g273508 | i0 | 100 | 1.45664739884393 | 28 | 0 | 16 | 0 | 138 | 165 | 862557 | 862584 | Megavirus chiliensis, complete genome | blastn | 252 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus chilense | ||
| 8571304 | 8571304 | PRJNA940501_S_NODE_158407_length_208_cov_1.169697_g157589_i0 | PRJNA940501 | 158407 | 208 | 1.169697 | 2.43296976 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 340 | 3.4699999999999996e-89 | NTclustered | gi|1624806662|gb|MK638698.1| | 1543320 | g157589 | i0 | 96.154 | 5.84615384615385 | 208 | 8 | 100 | 0 | 1 | 208 | 375 | 168 | Erythrocytic necrosis virus isolate SEQ_13 putative RNA-dependent DNA polymerase mRNA, complete cds | blastn | 1216 | 340 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 9848113 | 9848113 | PRJNA940501_S_NODE_275348_length_172_cov_15.372093_g274530_i0 | PRJNA940501 | 275348 | 172 | 15.372093 | 26.43999996 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g274530 | i0 | 100 | 16.8604651162791 | 29 | 0 | 17 | 0 | 69 | 97 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 17498330 | 17498330 | PRJNA940501_S_NODE_271914_length_173_cov_2.092308_g271096_i0 | PRJNA940501 | 271914 | 173 | 2.092308 | 3.61969284 | Megavirus baoshanense | 3060196 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2500365504|ref|NC_075367.1| | 2496520 | g271096 | i0 | 100 | 0.167630057803468 | 29 | 0 | 17 | 0 | 23 | 51 | 218853 | 218825 | Megavirus baoshan strain SH, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus baoshanense | ||
| 17835477 | 17835477 | PRJNA940501_S_NODE_314614_length_164_cov_1.752066_g313796_i0 | PRJNA940501 | 314614 | 164 | 1.752066 | 2.87338824 | Alphatectivirus | 2169669 | Viruses | Viruses | 298 | 1.59e-76 | NTclustered | gi|2693687230|gb|PP412836.1| | 3127600 | g313796 | i0 | 99.39 | 65.0975609756098 | 164 | 1 | 100 | 0 | 1 | 164 | 1173 | 1336 | Enterobacteria phage PRDhazel, complete genome | blastn | 10676 | 298 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Enterobacteria phage PRDhazel | |||
| 21321424 | 21321424 | PRJNA940501_S_NODE_22197_length_352_cov_194.673139_g21379_i0 | PRJNA940501 | 22197 | 352 | 194.673139 | 685.24944928 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g21379 | i0 | 94.286 | 0.0994318181818182 | 35 | 1 | 10 | 1 | 211 | 244 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 24209076 | 24209076 | PRJNA940501_S_NODE_178839_length_200_cov_1.496815_g178021_i0 | PRJNA940501 | 178839 | 200 | 1.496815 | 2.99363 | Alphatectivirus | 2169669 | Viruses | Viruses | 370 | 4.22e-98 | NTclustered | gi|2127008276|gb|OK041468.1| | 2884452 | g178021 | i0 | 100 | 73 | 200 | 0 | 100 | 0 | 1 | 200 | 1468 | 1667 | Burkholderia phage BCE1, complete genome | blastn | 14600 | 370 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Alphatectivirus | Alphatectivirus PRD1 |
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);;