contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5787689 | 5787689 | PRJNA703759_P_NODE_21305_length_302_cov_1.362445_g20829_i0 | PRJNA703759 | 21305 | 302 | 1.362445 | 4.1145839 | Mimivirus LCMiAC | 2506609 | Viruses | Viruses | 79.7 | 1.25e-15 | NR | QBK89152.1 | 2506609 | g20829 | i0 | 56.9 | 2.8112582781457 | 65 | 26 | 62.6 | 1 | 1 | 189 | 128 | 192 | QBK89152.1 MAG: uncharacterized protein LCMiAC02_02460 [Mimivirus LCMiAC02] | diamond | 849 | 79.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC02 | |||
| 5787748 | 5787748 | PRJNA703759_P_NODE_23885_length_289_cov_1.444444_g23409_i0 | PRJNA703759 | 23885 | 289 | 1.444444 | 4.17444316 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 102 | 9.64e-23 | NR | ARF09002.1 | 1977631 | g23409 | i0 | 54.5 | 1.04844290657439 | 101 | 41 | 99.7 | 2 | 288 | 1 | 729 | 829 | ARF09002.1 Hsp70 protein [Catovirus CTV1] | diamond | 303 | 102 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 26797951 | 26797951 | PRJNA703759_P_NODE_16921_length_332_cov_1.054054_g16445_i0 | PRJNA703759 | 16921 | 332 | 1.054054 | 3.49945928 | Dasosvirus sp. | 2487764 | Viruses | Viruses | 85.1 | 1.24e-17 | NR | AYV77638.1 | 2487764 | g16445 | i0 | 51.3 | 0.72289156626506 | 80 | 39 | 72.3 | 0 | 3 | 242 | 145 | 224 | AYV77638.1 MAG: transcription elongation factor TFIIS [Dasosvirus sp.] | diamond | 240 | 85.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Dasosvirus sp. | |||
| 26987748 | 26987748 | PRJNA703759_P_NODE_27522_length_275_cov_1.544554_g27046_i0 | PRJNA703759 | 27522 | 275 | 1.544554 | 4.2475235 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 61.6 | 1.27e-8 | NR | AYV84673.1 | 2487770 | g27046 | i0 | 36.7 | 0.981818181818182 | 90 | 55 | 97.1 | 2 | 8 | 274 | 255 | 343 | AYV84673.1 MAG: hypothetical protein Hyperionvirus33_16 [Hyperionvirus sp.] | diamond | 270 | 61.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 27240794 | 27240794 | PRJNA703759_P_NODE_40323_length_249_cov_0.886364_g39847_i0 | PRJNA703759 | 40323 | 249 | 0.886364 | 2.20704636 | Mimivirus LCMiAC | 2506608 | Viruses | Viruses | 53.9 | 4.83e-6 | NR | QBK88617.1 | 2506608 | g39847 | i0 | 59.1 | 0.530120481927711 | 44 | 18 | 53 | 0 | 159 | 28 | 1179 | 1222 | QBK88617.1 MAG: DNA polymerase family B elongation subunit [Mimivirus LCMiAC01] | diamond | 132 | 53.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC01 | |||
| 27430730 | 27430730 | PRJNA703759_P_NODE_8163_length_481_cov_1.147059_g7687_i0 | PRJNA703759 | 8163 | 481 | 1.147059 | 5.51735379 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 57.8 | 2.27e-6 | NR | VBB17943.1 | 2420051 | g7687 | i0 | 36.4 | 0.823284823284823 | 132 | 71 | 76.1 | 7 | 8 | 373 | 254 | 382 | VBB17943.1 hypothetical protein YASMINEVIRUS_406 [Yasminevirus sp. GU-2018] | diamond | 396 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 27746433 | 27746433 | PRJNA703759_P_NODE_52064_length_233_cov_2.487500_g51588_i0 | PRJNA703759 | 52064 | 233 | 2.4875 | 5.795875 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 112 | 3.58e-27 | NR | YP_010803269.1 | 3060017 | g51588 | i0 | 59.7 | 0.991416309012876 | 77 | 31 | 99.1 | 0 | 232 | 2 | 171 | 247 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 231 | 112 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27840730 | 27840730 | PRJNA703759_P_NODE_50544_length_242_cov_0.923077_g50068_i0 | PRJNA703759 | 50544 | 242 | 0.923077 | 2.23384634 | Bodo saltans virus | 2024608 | Viruses | Viruses | 62 | 6.07e-9 | NR | YP_010806472.1 | 2024608 | g50068 | i0 | 40.3 | 0.954545454545455 | 77 | 45 | 95.5 | 1 | 239 | 9 | 982 | 1057 | YP_010806472.1 DNA-dependent DNA polymerase family B [Bodo saltans virus] | diamond | 231 | 62 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 27883544 | 27883544 | PRJNA703759_P_NODE_43685_length_247_cov_0.896552_g43209_i0 | PRJNA703759 | 43685 | 247 | 0.896552 | 2.21448344 | Viruses | 10239 | Viruses | Viruses | 72 | 1.38e-13 | NR | AYV76003.1 | 2487775 | g43209 | i0 | 58.5 | 1.57894736842105 | 65 | 25 | 78.9 | 1 | 195 | 1 | 16 | 78 | AYV76003.1 MAG: hypothetical protein Terrestrivirus4_51 [Terrestrivirus sp.] | diamond | 390 | 72 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28030416 | 28030416 | PRJNA703759_P_NODE_46965_length_244_cov_2.152047_g46489_i0 | PRJNA703759 | 46965 | 244 | 2.152047 | 5.25099468 | Bodo saltans virus | 2024608 | Viruses | Viruses | 96.3 | 2.4300000000000003e-21 | NR | YP_010778234.1 | 2024608 | g46489 | i0 | 54.3 | 0.995901639344262 | 81 | 37 | 99.6 | 0 | 1 | 243 | 40 | 120 | YP_010778234.1 DNA-dependent RNA polymerase 2 subunit Rpb3 [Bodo saltans virus] | diamond | 243 | 96.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 28282742 | 28282742 | PRJNA703759_P_NODE_46446_length_245_cov_0.906977_g45970_i0 | PRJNA703759 | 46446 | 245 | 0.906977 | 2.22209365 | Bodo saltans virus | 2024608 | Viruses | Viruses | 56.2 | 6.45e-7 | NR | YP_010778661.1 | 2024608 | g45970 | i0 | 68.4 | 1.68979591836735 | 38 | 12 | 46.5 | 0 | 2 | 115 | 215 | 252 | YP_010778661.1 exodeoxyribonuclease VII large subunit [Bodo saltans virus] | diamond | 414 | 56.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 30030826 | 30030826 | PRJNA703759_P_NODE_17751_length_325_cov_1.238095_g17275_i0 | PRJNA703759 | 17751 | 325 | 1.238095 | 4.02380875 | Catovirus | 1977635 | Viruses | Viruses | 59.7 | 2.17e-8 | NR | ARF09226.1 | 1977631 | g17275 | i0 | 40.4 | 1.59692307692308 | 89 | 49 | 78.5 | 2 | 306 | 52 | 75 | 163 | ARF09226.1 hypothetical protein Catovirus_2_175 [Catovirus CTV1] | diamond | 519 | 59.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 30410256 | 30410256 | PRJNA703759_P_NODE_42573_length_247_cov_1.741379_g42097_i0 | PRJNA703759 | 42573 | 247 | 1.741379 | 4.30120613 | Theiavirus | 3044842 | Viruses | Viruses | 44.7 | 0.00847 | NR | YP_010778709.1 | 2024608 | g42097 | i0 | 33.8 | 1.74898785425101 | 77 | 48 | 89.9 | 1 | 2 | 223 | 1137 | 1213 | YP_010778709.1 mRNA capping enzyme [Bodo saltans virus] | diamond | 432 | 45.1 | 0.991130820399113 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 30493613 | 30493613 | PRJNA703759_P_NODE_23273_length_292_cov_1.168950_g22797_i0 | PRJNA703759 | 23273 | 292 | 1.16895 | 3.413334 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 95.1 | 2.63e-20 | NR | ARF09224.1 | 1977631 | g22797 | i0 | 46.3 | 0.976027397260274 | 95 | 49 | 95.5 | 1 | 281 | 3 | 133 | 227 | ARF09224.1 mRNA capping enzyme [Catovirus CTV1] | diamond | 285 | 95.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 30694233 | 30694233 | PRJNA703759_P_NODE_20073_length_309_cov_2.364407_g19597_i0 | PRJNA703759 | 20073 | 309 | 2.364407 | 7.30601763 | Mimiviridae | 549779 | Viruses | Viruses | 60.1 | 6.66e-8 | NR | AQN68586.1 | 1956188 | g19597 | i0 | 40 | 4.32038834951456 | 75 | 44 | 71.8 | 1 | 228 | 7 | 266 | 340 | AQN68586.1 putative transposase [Saudi moumouvirus] | diamond | 1335 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Saudi moumouvirus | ||
| 30757489 | 30757489 | PRJNA703759_P_NODE_23254_length_292_cov_1.255708_g22778_i0 | PRJNA703759 | 23254 | 292 | 1.255708 | 3.66666736 | Mimivirus | 315393 | Viruses | Viruses | 105 | 4.26e-26 | NR | AEQ60260.1 | 554168 | g22778 | i0 | 59.6 | 2.74315068493151 | 89 | 25 | 91.4 | 1 | 26 | 292 | 1 | 78 | AEQ60260.1 putative resolvase [Acanthamoeba castellanii mamavirus] | diamond | 801 | 105 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Acanthamoeba castellanii mamavirus | ||
| 30777948 | 30777948 | PRJNA703759_P_NODE_26354_length_280_cov_0.869565_g25878_i0 | PRJNA703759 | 26354 | 280 | 0.869565 | 2.434782 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 43.5 | 0.0293 | NR | ARF10981.1 | 1977638 | g25878 | i0 | 69.2 | 0.278571428571429 | 26 | 8 | 27.9 | 0 | 279 | 202 | 70 | 95 | ARF10981.1 hypothetical protein Hokovirus_3_254 [Hokovirus HKV1] | diamond | 78 | 43.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 31188309 | 31188309 | PRJNA703759_P_NODE_39035_length_250_cov_0.881356_g38559_i0 | PRJNA703759 | 39035 | 250 | 0.881356 | 2.20339 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 125 | 3.19e-31 | NR | ARF08988.1 | 1977631 | g38559 | i0 | 74.7 | 0.996 | 83 | 21 | 99.6 | 0 | 250 | 2 | 428 | 510 | ARF08988.1 DNA-directed RNA polymerase subunit beta [Catovirus CTV1] | diamond | 249 | 125 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 31884430 | 31884430 | PRJNA703759_P_NODE_39677_length_249_cov_1.772727_g39201_i0 | PRJNA703759 | 39677 | 249 | 1.772727 | 4.41409023 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 115 | 5.9899999999999985e-28 | NR | AYV76198.1 | 2487775 | g39201 | i0 | 67.5 | 0.927710843373494 | 77 | 17 | 92.8 | 2 | 1 | 231 | 376 | 444 | AYV76198.1 MAG: deoxyribodipyrimidine photo-lyase [Terrestrivirus sp.] | diamond | 231 | 115 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32769340 | 32769340 | PRJNA703759_P_NODE_43300_length_247_cov_0.896552_g42824_i0 | PRJNA703759 | 43300 | 247 | 0.896552 | 2.21448344 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 48.9 | 2.55e-4 | NR | CAK7597053.1 | 3072188 | g42824 | i0 | 35.3 | 1.03238866396761 | 85 | 52 | 99.6 | 2 | 246 | 1 | 57 | 141 | CAK7597053.1 ADP-ribosylation/Crystallin J1 [Catovirus sp. 'naegleriensis'] | diamond | 255 | 48.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' |
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);;