contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13040833 | 13040833 | PRJNA1144090_P_NODE_2531_length_1707_cov_8.988372_g2363_i0 | PRJNA1144090 | 2531 | 1707 | 8.988372 | 153.43151004 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 245 | 1.05e-70 | NR | AYV75677.1 | 2487775 | g2363 | i0 | 31.9 | 1.8207381370826 | 518 | 302 | 89.1 | 12 | 1672 | 152 | 7 | 484 | AYV75677.1 MAG: putative AAA+ family ATPase [Terrestrivirus sp.] | diamond | 3108 | 245 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 26817490 | 26817490 | PRJNA1144090_P_NODE_27801_length_502_cov_2.065268_g27267_i0 | PRJNA1144090 | 27801 | 502 | 2.065268 | 10.36764536 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 56.6 | 7.71e-6 | NR | AYV84345.1 | 2487770 | g27267 | i0 | 40.2 | 0.49003984063745 | 82 | 48 | 49 | 1 | 70 | 315 | 611 | 691 | AYV84345.1 MAG: hypothetical protein Hyperionvirus23_12 [Hyperionvirus sp.] | diamond | 246 | 56.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 26880774 | 26880774 | PRJNA1144090_P_NODE_12861_length_782_cov_1.588152_g12400_i0 | PRJNA1144090 | 12861 | 782 | 1.588152 | 12.41934864 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 60.1 | 2.2e-6 | NR | YP_010780186.1 | 2126984 | g12400 | i0 | 31.7 | 0.483375959079284 | 126 | 42 | 48.3 | 3 | 383 | 6 | 5 | 86 | YP_010780186.1 phenylalanyl tRNA-synthetase [Tupanvirus deep ocean] | diamond | 378 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 27133309 | 27133309 | PRJNA1144090_P_NODE_22022_length_575_cov_8.121514_g21496_i0 | PRJNA1144090 | 22022 | 575 | 8.121514 | 46.6987055 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 130 | 1.78e-34 | NR | YP_010804235.1 | 3060017 | g21496 | i0 | 42.2 | 0.975652173913043 | 187 | 77 | 93.4 | 7 | 38 | 574 | 7 | 170 | YP_010804235.1 hypothetical protein QKU48_gp1352 [Fadolivirus algeromassiliense] | diamond | 561 | 130 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27260227 | 27260227 | PRJNA1144090_P_NODE_63723_length_318_cov_1.191837_g63188_i0 | PRJNA1144090 | 63723 | 318 | 1.191837 | 3.79004166 | Gaeavirus sp. | 2487767 | Viruses | Viruses | 72 | 4.86e-12 | NR | AYV80375.1 | 2487767 | g63188 | i0 | 32.3 | 1.64150943396226 | 99 | 67 | 93.4 | 0 | 22 | 318 | 608 | 706 | AYV80375.1 MAG: hypothetical protein Gaeavirus44_1, partial [Gaeavirus sp.] | diamond | 522 | 72 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Gaeavirus sp. | |||
| 27828688 | 27828688 | PRJNA1144090_P_NODE_92644_length_260_cov_2.470588_g92109_i0 | PRJNA1144090 | 92644 | 260 | 2.470588 | 6.4235288 | Megavirus chiliensis | 1094892 | Viruses | Viruses | 50.4 | 4.58e-5 | NR | YP_004894320.1 | 1094892 | g92109 | i0 | 26.8 | 0.946153846153846 | 82 | 60 | 94.6 | 0 | 251 | 6 | 97 | 178 | YP_004894320.1 hypothetical protein MegaChil _gp0269 [Megavirus chiliensis] | diamond | 246 | 50.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus chilense | ||
| 27986477 | 27986477 | PRJNA1144090_P_NODE_37065_length_426_cov_1.781870_g36530_i0 | PRJNA1144090 | 37065 | 426 | 1.78187 | 7.5907662 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 133 | 1.42e-35 | NR | ARF11372.1 | 1977640 | g36530 | i0 | 44 | 0.992957746478873 | 141 | 64 | 97.2 | 3 | 13 | 426 | 26 | 154 | ARF11372.1 START domain protein [Klosneuvirus KNV1] | diamond | 423 | 133 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 27986520 | 27986520 | PRJNA1144090_P_NODE_76985_length_287_cov_2.915888_g76450_i0 | PRJNA1144090 | 76985 | 287 | 2.915888 | 8.36859856 | Dishui Lake phycodnavirus 4 | 2704072 | Viruses | Viruses | 97.1 | 5.1800000000000006e-21 | NR | QIG59935.1 | 2704072 | g76450 | i0 | 42.3 | 1.01393728222997 | 97 | 51 | 97.2 | 3 | 2 | 280 | 319 | 414 | QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4] | diamond | 291 | 97.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Dishui Lake phycodnavirus 4 | |||
| 28333801 | 28333801 | PRJNA1144090_P_NODE_75326_length_291_cov_1.412844_g74791_i0 | PRJNA1144090 | 75326 | 291 | 1.412844 | 4.11137604 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 52 | 3.71e-5 | NR | ARF09007.1 | 1977631 | g74791 | i0 | 45.6 | 1.5979381443299 | 57 | 30 | 58.8 | 1 | 93 | 263 | 457 | 512 | ARF09007.1 DEAD/SNF2-like helicase [Catovirus CTV1] | diamond | 465 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 28775713 | 28775713 | PRJNA1144090_P_NODE_16707_length_674_cov_3.103161_g16192_i0 | PRJNA1144090 | 16707 | 674 | 3.103161 | 20.91530514 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 184 | 1.27e-51 | NR | ARF11252.1 | 1977640 | g16192 | i0 | 41.4 | 0.956973293768546 | 215 | 122 | 94.4 | 3 | 674 | 39 | 299 | 512 | ARF11252.1 methionyl-tRNA synthetase [Klosneuvirus KNV1] | diamond | 645 | 184 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 29154998 | 29154998 | PRJNA1144090_P_NODE_61829_length_323_cov_0.912000_g61294_i0 | PRJNA1144090 | 61829 | 323 | 0.912 | 2.94576 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 110 | 2.75e-27 | NR | ARF10905.1 | 1977638 | g61294 | i0 | 54.4 | 1.94117647058824 | 103 | 44 | 95.7 | 1 | 311 | 3 | 8 | 107 | ARF10905.1 exonuclease [Hokovirus HKV1] | diamond | 627 | 110 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 29722774 | 29722774 | PRJNA1144090_P_NODE_78210_length_285_cov_1.452830_g77675_i0 | PRJNA1144090 | 78210 | 285 | 1.45283 | 4.1405655 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 47 | 0.00195 | NR | AYV83068.1 | 2487770 | g77675 | i0 | 38.3 | 0.989473684210526 | 94 | 51 | 93.7 | 2 | 267 | 1 | 298 | 389 | AYV83068.1 MAG: hypothetical protein Hyperionvirus4_33 [Hyperionvirus sp.] | diamond | 282 | 47 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 29881090 | 29881090 | PRJNA1144090_P_NODE_18091_length_643_cov_14.682456_g17570_i0 | PRJNA1144090 | 18091 | 643 | 14.682456 | 94.40819208 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 137 | 6.15e-37 | NR | YP_010803991.1 | 3060017 | g17570 | i0 | 42 | 0.732503888024883 | 157 | 90 | 72.8 | 1 | 608 | 141 | 2 | 158 | YP_010803991.1 hypothetical protein QKU48_gp1108 [Fadolivirus algeromassiliense] | diamond | 471 | 137 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29944271 | 29944271 | PRJNA1144090_P_NODE_7371_length_1052_cov_5.297242_g7017_i0 | PRJNA1144090 | 7371 | 1052 | 5.297242 | 55.72698584 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 394 | 1.0099999999999998e-131 | NR | ARF12356.1 | 1977640 | g7017 | i0 | 58.6 | 0.958174904942966 | 336 | 116 | 95.5 | 4 | 1029 | 25 | 5 | 318 | ARF12356.1 fructose-1,6-bisphosphatase [Klosneuvirus KNV1] | diamond | 1008 | 394 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 30165084 | 30165084 | PRJNA1144090_P_NODE_30272_length_478_cov_3.088889_g29738_i0 | PRJNA1144090 | 30272 | 478 | 3.088889 | 14.76488942 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 87.4 | 4.98e-18 | NR | YP_010780168.1 | 2126984 | g29738 | i0 | 32.3 | 1.01046025104603 | 161 | 100 | 97.9 | 5 | 5 | 472 | 29 | 185 | YP_010780168.1 START domain containing protein [Tupanvirus deep ocean] | diamond | 483 | 87.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 30797108 | 30797108 | PRJNA1144090_P_NODE_54154_length_346_cov_1.230769_g53619_i0 | PRJNA1144090 | 54154 | 346 | 1.230769 | 4.25846074 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 97.8 | 8.59e-22 | NR | VBB17651.1 | 2420051 | g53619 | i0 | 46.5 | 0.875722543352601 | 101 | 53 | 86.7 | 1 | 301 | 2 | 4 | 104 | VBB17651.1 2OG-FeII oxygenase superfamily protein [Yasminevirus sp. GU-2018] | diamond | 303 | 97.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 31050298 | 31050298 | PRJNA1144090_P_NODE_88875_length_266_cov_2.259067_g88340_i0 | PRJNA1144090 | 88875 | 266 | 2.259067 | 6.00911822 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 47.4 | 0.00113 | NR | YP_010804011.1 | 3060017 | g88340 | i0 | 47.6 | 0.473684210526316 | 42 | 22 | 47.4 | 0 | 145 | 20 | 166 | 207 | YP_010804011.1 globin/protoglobin [Fadolivirus algeromassiliense] | diamond | 126 | 47.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31366252 | 31366252 | PRJNA1144090_P_NODE_37036_length_426_cov_2.181303_g36501_i0 | PRJNA1144090 | 37036 | 426 | 2.181303 | 9.29235078 | Gaeavirus sp. | 2487767 | Viruses | Viruses | 66.6 | 1.28e-9 | NR | AYV80034.1 | 2487767 | g36501 | i0 | 33.8 | 0.957746478873239 | 136 | 74 | 91.5 | 5 | 396 | 7 | 264 | 389 | AYV80034.1 MAG: DEAD/SNF2-like helicase [Gaeavirus sp.] | diamond | 408 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Gaeavirus sp. | |||
| 31461216 | 31461216 | PRJNA1144090_P_NODE_77676_length_286_cov_1.708920_g77141_i0 | PRJNA1144090 | 77676 | 286 | 1.70892 | 4.8875112 | Bodo saltans virus | 2024608 | Viruses | Viruses | 43.5 | 0.0323 | NR | YP_010778817.1 | 2024608 | g77141 | i0 | 42.4 | 0.618881118881119 | 59 | 31 | 58.7 | 1 | 281 | 114 | 355 | 413 | YP_010778817.1 putative transposase [Bodo saltans virus] | diamond | 177 | 43.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 32061889 | 32061889 | PRJNA1144090_P_NODE_117398_length_238_cov_3.539394_g116863_i0 | PRJNA1144090 | 117398 | 238 | 3.539394 | 8.42375772 | Feldmannia irregularis virus a | 231992 | Viruses | Viruses | 46.2 | 0.00194 | NR | YP_009665604.1 | 231992 | g116863 | i0 | 40.2 | 1.86554621848739 | 82 | 39 | 97.1 | 2 | 233 | 3 | 215 | 291 | YP_009665604.1 FirrV-1-E3 [Feldmannia irregularis virus a] | diamond | 444 | 46.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Phaeovirus | Phaeovirus irregularis | ||
| 32599814 | 32599814 | PRJNA1144090_P_NODE_56200_length_339_cov_1.646617_g55665_i0 | PRJNA1144090 | 56200 | 339 | 1.646617 | 5.58203163 | Mimivirus LCMiAC | 2506609 | Viruses | Viruses | 143 | 4.569999999999999e-37 | NR | QBK89191.1 | 2506609 | g55665 | i0 | 64.6 | 1 | 113 | 40 | 100 | 0 | 339 | 1 | 421 | 533 | QBK89191.1 MAG: peptidase family M49 [Mimivirus LCMiAC02] | diamond | 339 | 143 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC02 |
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);;