contig_metadata
17 rows where bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2332861 | 2332861 | PRJNA270367_P_NODE_13622_length_352_cov_3.201320_g13417_i0 | PRJNA270367 | 13622 | 352 | 3.20132 | 11.2686464 | root | 1 | Root_unresolved | Root_unresolved | 187 | 8.74e-43 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g13417 | i0 | 100 | 41.7613636363636 | 101 | 0 | 42 | 0 | 1 | 101 | 28638 | 28538 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14700 | 187 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 16360057 | 16360057 | PRJNA270367_P_NODE_13573_length_353_cov_1.921053_g13368_i0 | PRJNA270367 | 13573 | 353 | 1.921053 | 6.78131709 | root | 1 | Root_unresolved | Root_unresolved | 180 | 1.47e-40 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g13368 | i0 | 99.01 | 41.7932011331445 | 101 | 0 | 42 | 1 | 1 | 101 | 11551 | 11452 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 14753 | 180 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 18909017 | 18909017 | PRJNA270367_P_NODE_13575_length_353_cov_1.825658_g13370_i0 | PRJNA270367 | 13575 | 353 | 1.825658 | 6.44457274 | root | 1 | Root_unresolved | Root_unresolved | 187 | 8.77e-43 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g13370 | i0 | 100 | 56.9376770538244 | 101 | 0 | 57 | 0 | 253 | 353 | 18402 | 18302 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 20099 | 187 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 18909250 | 18909250 | PRJNA270367_P_NODE_21735_length_253_cov_4.098039_g21530_i0 | PRJNA270367 | 21735 | 253 | 4.098039 | 10.36803867 | root | 1 | Root_unresolved | Root_unresolved | 459 | 1.1599999999999999e-124 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g21530 | i0 | 100 | 98.0237154150198 | 248 | 0 | 98 | 0 | 1 | 248 | 14926 | 15173 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 24800 | 459 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22734405 | 22734405 | PRJNA270367_P_NODE_13558_length_353_cov_2.618421_g13353_i0 | PRJNA270367 | 13558 | 353 | 2.618421 | 9.24302613 | root | 1 | Root_unresolved | Root_unresolved | 187 | 8.77e-43 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g13353 | i0 | 100 | 54.8951841359773 | 101 | 0 | 56 | 0 | 6 | 106 | 11379 | 11279 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 19378 | 187 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 24596067 | 24596067 | PRJNA270367_P_NODE_17740_length_294_cov_1.232653_g17535_i0 | PRJNA270367 | 17740 | 294 | 1.232653 | 3.62399982 | Mimiviridae | 549779 | Viruses | Viruses | 93.6 | 8.71e-20 | NR | ARF11293.1 | 1977640 | g17535 | i0 | 45.5 | 2.03061224489796 | 101 | 51 | 99 | 3 | 3 | 293 | 3 | 103 | ARF11293.1 asparagine synthase [Klosneuvirus KNV1] | diamond | 597 | 93.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 27263817 | 27263817 | PRJNA270367_P_NODE_35003_length_184_cov_1.044444_g34798_i0 | PRJNA270367 | 35003 | 184 | 1.044444 | 1.92177696 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 45.1 | 0.00266 | NR | CAK7596888.1 | 3072188 | g34798 | i0 | 34.1 | 1.33695652173913 | 41 | 27 | 66.8 | 0 | 7 | 129 | 878 | 918 | CAK7596888.1 Ubiquitin-activating enzyme E1 [Catovirus sp. 'naegleriensis'] | diamond | 246 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 27958445 | 27958445 | PRJNA270367_P_NODE_19805_length_272_cov_1.165919_g19600_i0 | PRJNA270367 | 19805 | 272 | 1.165919 | 3.17129968 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 46.2 | 0.00277 | NR | YP_010804027.1 | 3060017 | g19600 | i0 | 38.2 | 0.606617647058823 | 55 | 31 | 60.7 | 1 | 270 | 106 | 146 | 197 | YP_010804027.1 hypothetical protein QKU48_gp1144 [Fadolivirus algeromassiliense] | diamond | 165 | 46.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 28242442 | 28242442 | PRJNA270367_P_NODE_33906_length_188_cov_0.913669_g33701_i0 | PRJNA270367 | 33906 | 188 | 0.913669 | 1.71769772 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 51.6 | 1.32e-5 | NR | AYV80981.1 | 2487768 | g33701 | i0 | 46.9 | 0.781914893617021 | 49 | 26 | 78.2 | 0 | 179 | 33 | 246 | 294 | AYV80981.1 MAG: chromosome condensation regulator [Harvfovirus sp.] | diamond | 147 | 51.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 29316131 | 29316131 | PRJNA270367_P_NODE_8229_length_468_cov_2.474940_g8030_i0 | PRJNA270367 | 8229 | 468 | 2.47494 | 11.5827192 | Bodo saltans virus | 2024608 | Viruses | Viruses | 50.4 | 7.17e-4 | NR | YP_010778267.1 | 2024608 | g8030 | i0 | 50 | 0.538461538461538 | 42 | 21 | 26.9 | 0 | 287 | 412 | 509 | 550 | YP_010778267.1 asparagine synthetase B [Bodo saltans virus] | diamond | 252 | 50.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 29568648 | 29568648 | PRJNA270367_P_NODE_27130_length_218_cov_1.076923_g26925_i0 | PRJNA270367 | 27130 | 218 | 1.076923 | 2.34769214 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 66.2 | 1.38e-10 | NR | CAK7597024.1 | 3072188 | g26925 | i0 | 48.6 | 1.98165137614679 | 72 | 36 | 99.1 | 1 | 3 | 218 | 57 | 127 | CAK7597024.1 Asparagine synthase, glutamine-hydrolyzing [Catovirus sp. 'naegleriensis'] | diamond | 432 | 66.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 29600047 | 29600047 | PRJNA270367_P_NODE_39370_length_169_cov_1.300000_g39165_i0 | PRJNA270367 | 39370 | 169 | 1.3 | 2.197 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 55.8 | 3.15e-7 | NR | AYV75160.1 | 2487775 | g39165 | i0 | 57.1 | 0.745562130177515 | 42 | 18 | 74.6 | 0 | 129 | 4 | 257 | 298 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 126 | 55.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 29947727 | 29947727 | PRJNA270367_P_NODE_2211_length_940_cov_2.510662_g2046_i0 | PRJNA270367 | 2211 | 940 | 2.510662 | 23.6002228 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 138 | 3.1699999999999996e-32 | NR | YP_009449258.1 | 2023057 | g2046 | i0 | 41.2 | 0.673404255319149 | 211 | 107 | 65.4 | 7 | 687 | 73 | 13 | 212 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 633 | 138 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 30073914 | 30073914 | PRJNA270367_P_NODE_6892_length_516_cov_1.218415_g6694_i0 | PRJNA270367 | 6892 | 516 | 1.218415 | 6.2870214 | Barrevirus sp. | 2487763 | Viruses | Viruses | 72.8 | 4.06e-12 | NR | AYV77273.1 | 2487763 | g6694 | i0 | 25.3 | 0.918604651162791 | 158 | 114 | 91.9 | 3 | 38 | 511 | 9 | 162 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 474 | 72.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 30674260 | 30674260 | PRJNA270367_P_NODE_8773_length_452_cov_1.734491_g8574_i0 | PRJNA270367 | 8773 | 452 | 1.734491 | 7.83989932 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 155 | 4.99e-42 | NR | ARF12058.1 | 1977640 | g8574 | i0 | 57.6 | 1.74557522123894 | 132 | 54 | 87.6 | 1 | 1 | 396 | 333 | 462 | ARF12058.1 aminotransferase class-III [Klosneuvirus KNV1] | diamond | 789 | 155 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 30705828 | 30705828 | PRJNA270367_P_NODE_20094_length_269_cov_1.159091_g19889_i0 | PRJNA270367 | 20094 | 269 | 1.159091 | 3.11795479 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 45.8 | 9.91e-4 | NR | AYV76392.1 | 2487775 | g19889 | i0 | 50 | 0.557620817843866 | 50 | 23 | 53.5 | 1 | 235 | 92 | 1 | 50 | AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] | diamond | 150 | 45.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32571998 | 32571998 | PRJNA270367_P_NODE_20359_length_266_cov_1.364055_g20154_i0 | PRJNA270367 | 20359 | 266 | 1.364055 | 3.6283863 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 104 | 4.8e-24 | NR | AYV78014.1 | 2487765 | g20154 | i0 | 55.2 | 0.981203007518797 | 87 | 38 | 98.1 | 1 | 1 | 261 | 182 | 267 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 261 | 104 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus 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);;