contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 26757371 | 26757371 | PRJNA270367_P_NODE_16001_length_316_cov_1.089888_g15796_i0 | PRJNA270367 | 16001 | 316 | 1.089888 | 3.44404608 | Mollivirus kamchatka | 2700071 | Viruses | Viruses | 86.3 | 4.5e-17 | NR | QHN71019.1 | 2700071 | g15796 | i0 | 41.8 | 0.930379746835443 | 98 | 57 | 93 | 0 | 294 | 1 | 185 | 282 | QHN71019.1 hypothetical protein [Mollivirus kamchatka] | diamond | 294 | 86.3 | 1 | Viruses | Mollivirus kamchatka | ||||||||
| 27074017 | 27074017 | PRJNA270367_P_NODE_32782_length_192_cov_1.104895_g32577_i0 | PRJNA270367 | 32782 | 192 | 1.104895 | 2.1213984 | phage Lak_Megaphage_RVC_AP1_GC26 | 3109224 | Viruses | Viruses | 44.3 | 0.00551 | NR | WQJ54389.1 | 3109224 | g32577 | i0 | 39.6 | 0.828125 | 53 | 30 | 79.7 | 1 | 168 | 16 | 142 | 194 | WQJ54389.1 MAG: nucleotidyltransferase [phage Lak_Megaphage_RVC_AP1_GC26] | diamond | 159 | 44.3 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 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. | |||
| 30263932 | 30263932 | PRJNA270367_P_NODE_35992_length_180_cov_1.587786_g35787_i0 | PRJNA270367 | 35992 | 180 | 1.587786 | 2.8580148 | Saccharomyces paradoxus virus L-A-1939 | 2048540 | Viruses | Viruses | 75.1 | 6.17e-14 | NR | ATL63188.1 | 2048540 | g35787 | i0 | 61 | 0.983333333333333 | 59 | 23 | 98.3 | 0 | 3 | 179 | 818 | 876 | ATL63188.1 gag-pol fusion protein [Saccharomyces paradoxus virus L-A-1939] | diamond | 177 | 75.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Saccharomyces paradoxus virus L-A-1939 | |||
| 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. | |||
| 30737427 | 30737427 | PRJNA270367_P_NODE_45574_length_163_cov_0.912281_g45369_i0 | PRJNA270367 | 45574 | 163 | 0.912281 | 1.48701803 | Pseudomonas phage PaBG | 1335230 | Viruses | Viruses | 58.2 | 6.96e-9 | NR | YP_008433468.1 | 1335230 | g45369 | i0 | 52.3 | 0.809815950920245 | 44 | 21 | 81 | 0 | 4 | 135 | 90 | 133 | YP_008433468.1 hypothetical protein O152_gp138 [Pseudomonas phage PaBG] | diamond | 132 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Baikalvirus | Baikalvirus PaBG | ||||
| 30850012 | 30850012 | PRJNA270367_P_NODE_38794_length_171_cov_0.827869_g38589_i0 | PRJNA270367 | 38794 | 171 | 0.827869 | 1.41565599 | Cotonvirus | 3044693 | Viruses | Viruses | 51.6 | 1.03e-5 | NR | QHN71019.1 | 2700071 | g38589 | i0 | 44.4 | 2.94736842105263 | 54 | 30 | 94.7 | 0 | 2 | 163 | 246 | 299 | QHN71019.1 hypothetical protein [Mollivirus kamchatka] | diamond | 504 | 51.6 | 1 | Viruses | Mollivirus kamchatka | ||||||||
| 31147862 | 31147862 | PRJNA270367_P_NODE_24235_length_235_cov_1.112903_g24030_i0 | PRJNA270367 | 24235 | 235 | 1.112903 | 2.61532205 | Urbanus proteus nucleopolyhedrovirus | 1675866 | Viruses | Viruses | 45.1 | 0.0048 | NR | YP_009250095.1 | 1675866 | g24030 | i0 | 42.1 | 0.727659574468085 | 57 | 25 | 62.6 | 1 | 36 | 182 | 249 | 305 | YP_009250095.1 BRO-F [Urbanus proteus nucleopolyhedrovirus] | diamond | 171 | 45.1 | 1 | Viruses | Naldaviricetes | Lefavirales | Baculoviridae | Alphabaculovirus | Alphabaculovirus urprotei | ||||
| 32160680 | 32160680 | PRJNA270367_P_NODE_46438_length_162_cov_0.920354_g46233_i0 | PRJNA270367 | 46438 | 162 | 0.920354 | 1.49097348 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.3 | 1.35e-19 | NR | XOR53229.1 | 2832643 | g46233 | i0 | 88.7 | 0.981481481481482 | 53 | 6 | 98.1 | 0 | 161 | 3 | 96 | 148 | XOR53229.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 86.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;