contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9827244 | 9827244 | PRJNA924320_S_NODE_8288_length_337_cov_1.711806_g8146_i0 | PRJNA924320 | 8288 | 337 | 1.711806 | 5.76878622 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 171 | 3.8e-49 | NR | YP_010803269.1 | 3060017 | g8146 | i0 | 69.4 | 0.98813056379822 | 111 | 33 | 98.8 | 1 | 5 | 337 | 28 | 137 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 333 | 171 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 26676208 | 26676208 | PRJNA924320_S_NODE_52741_length_163_cov_1.789474_g52599_i0 | PRJNA924320 | 52741 | 163 | 1.789474 | 2.91684262 | Vibrio virus VPMCC5 | 2900301 | Viruses | Viruses | 75.5 | 1.2e-14 | NR | UIW11075.1 | 2900301 | g52599 | i0 | 68.5 | 2.98159509202454 | 54 | 17 | 99.4 | 0 | 2 | 163 | 162 | 215 | UIW11075.1 putative head completion adaptor [Vibrio virus VPMCC5] | diamond | 486 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio virus VPMCC5 | ||||
| 26961203 | 26961203 | PRJNA924320_S_NODE_32162_length_193_cov_2.666667_g32020_i0 | PRJNA924320 | 32162 | 193 | 2.666667 | 5.14666731 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 76.3 | 2.64e-14 | NR | YP_010803269.1 | 3060017 | g32020 | i0 | 56.9 | 0.901554404145078 | 58 | 25 | 90.2 | 0 | 193 | 20 | 283 | 340 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 174 | 76.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27372693 | 27372693 | PRJNA924320_S_NODE_32443_length_193_cov_1.062500_g32301_i0 | PRJNA924320 | 32443 | 193 | 1.0625 | 2.050625 | Pithovirus LCDPAC | 2506600 | Viruses | Viruses | 43.9 | 0.00621 | NR | QBK84707.1 | 2506600 | g32301 | i0 | 36.4 | 1.0259067357513 | 66 | 38 | 99.5 | 2 | 2 | 193 | 22 | 85 | QBK84707.1 MAG: hypothetical protein LCDPAC01_01880 [Pithovirus LCDPAC01] | diamond | 198 | 43.9 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC01 | |||||||
| 27435774 | 27435774 | PRJNA924320_S_NODE_4463_length_446_cov_1.921914_g4322_i0 | PRJNA924320 | 4463 | 446 | 1.921914 | 8.57173644 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 202 | 9.21e-61 | NR | YP_010803269.1 | 3060017 | g4322 | i0 | 63.5 | 0.995515695067265 | 148 | 54 | 99.6 | 0 | 444 | 1 | 134 | 281 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 444 | 202 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27467208 | 27467208 | PRJNA924320_S_NODE_24843_length_213_cov_2.487805_g24701_i0 | PRJNA924320 | 24843 | 213 | 2.487805 | 5.29902465 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 104 | 1.97e-24 | NR | YP_010803269.1 | 3060017 | g24701 | i0 | 67.1 | 0.985915492957746 | 70 | 23 | 98.6 | 0 | 212 | 3 | 337 | 406 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 210 | 104 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27783002 | 27783002 | PRJNA924320_S_NODE_18904_length_237_cov_1.207447_g18762_i0 | PRJNA924320 | 18904 | 237 | 1.207447 | 2.86164939 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 66.2 | 2.15e-11 | NR | QDP53372.1 | 2591644 | g18762 | i0 | 50 | 1.91139240506329 | 78 | 37 | 98.7 | 1 | 1 | 234 | 14 | 89 | QDP53372.1 MAG: hypothetical protein Unbinned6805contig1000_34 [Prokaryotic dsDNA virus sp.] | diamond | 453 | 66.2 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 28856183 | 28856183 | PRJNA924320_S_NODE_1128_length_838_cov_2.510773_g1041_i0 | PRJNA924320 | 1128 | 838 | 2.510773 | 21.04027774 | uncultured virus | 340016 | Viruses | Viruses | 102 | 3.4e-20 | NR | CAH6419193.1 | 340016 | g1041 | i0 | 28.1 | 1.99045346062053 | 278 | 178 | 94.9 | 6 | 795 | 1 | 672 | 940 | CAH6419193.1 2-5 RNA ligase superfamily [uncultured virus] | diamond | 1668 | 102 | 1 | Viruses | uncultured virus | ||||||||
| 28856211 | 28856211 | PRJNA924320_S_NODE_48408_length_166_cov_0.871795_g48266_i0 | PRJNA924320 | 48408 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 3.56e-22 | NR | XOS48669.1 | 2832643 | g48266 | i0 | 80 | 0.993975903614458 | 55 | 11 | 99.4 | 0 | 166 | 2 | 52 | 106 | XOS48669.1 MAG: hypothetical protein MSP0393_28 [Caudoviricetes sp.] | diamond | 165 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28856212 | 28856212 | PRJNA924320_S_NODE_49188_length_165_cov_1.698276_g49046_i0 | PRJNA924320 | 49188 | 165 | 1.698276 | 2.8021554 | Chuvivirus | 2842604 | Viruses | Viruses | 47.8 | 2.26e-4 | NR | WET19891.1 | 2842604 | g49046 | i0 | 58.8 | 0.618181818181818 | 34 | 14 | 61.8 | 0 | 159 | 58 | 464 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 102 | 47.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 29172244 | 29172244 | PRJNA924320_S_NODE_17069_length_247_cov_1.227273_g16927_i0 | PRJNA924320 | 17069 | 247 | 1.227273 | 3.03136431 | Pithovirus LCPAC1 | 2506586 | Viruses | Viruses | 66.2 | 1.92e-10 | NR | QBK89990.1 | 2506586 | g16927 | i0 | 49.2 | 0.716599190283401 | 59 | 30 | 71.7 | 0 | 70 | 246 | 137 | 195 | QBK89990.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] | diamond | 177 | 66.2 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 29495100 | 29495100 | PRJNA924320_S_NODE_50250_length_165_cov_0.879310_g50108_i0 | PRJNA924320 | 50250 | 165 | 0.87931 | 1.4508615 | Orthopoxvirus | 10242 | Viruses | Viruses | 85.5 | 1.31e-19 | NR | AHF22124.1 | 10245 | g50108 | i0 | 70.4 | 19.6363636363636 | 54 | 16 | 98.2 | 0 | 2 | 163 | 53 | 106 | AHF22124.1 thymidine kinase, partial [Vaccinia virus] | diamond | 3240 | 85.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus vaccinia | ||
| 29613803 | 29613803 | PRJNA924320_S_NODE_53850_length_163_cov_0.894737_g53708_i0 | PRJNA924320 | 53850 | 163 | 0.894737 | 1.45842131 | Mimivirus LCMiAC | 2506609 | Viruses | Viruses | 41.2 | 0.00556 | NR | QBK89300.1 | 2506609 | g53708 | i0 | 42.6 | 0.865030674846626 | 47 | 27 | 86.5 | 0 | 155 | 15 | 1 | 47 | QBK89300.1 MAG: hypothetical protein LCMiAC02_03950, partial [Mimivirus LCMiAC02] | diamond | 141 | 41.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC02 | |||
| 29645288 | 29645288 | PRJNA924320_S_NODE_15870_length_254_cov_1.756098_g15728_i0 | PRJNA924320 | 15870 | 254 | 1.756098 | 4.46048892 | uncultured virus | 340016 | Viruses | Viruses | 82 | 5.1e-16 | NR | CAH6419317.1 | 340016 | g15728 | i0 | 51.9 | 0.933070866141732 | 79 | 38 | 93.3 | 0 | 13 | 249 | 105 | 183 | CAH6419317.1 Domain of unknown function (DUF4419)-containing protein [uncultured virus] | diamond | 237 | 82 | 1 | Viruses | uncultured virus | ||||||||
| 29740194 | 29740194 | PRJNA924320_S_NODE_56370_length_161_cov_1.821429_g56228_i0 | PRJNA924320 | 56370 | 161 | 1.821429 | 2.93250069 | Acinetobacter phage APK2 | 2865959 | Viruses | Viruses | 45.4 | 0.00137 | NR | UAW10085.1 | 2873375 | g56228 | i0 | 45 | 0.745341614906832 | 40 | 22 | 74.5 | 0 | 34 | 153 | 184 | 223 | UAW10085.1 tailspike protein [Acinetobacter phage APK20] | diamond | 120 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Friunavirus | Friunavirus APK20 | ||
| 30435753 | 30435753 | PRJNA924320_S_NODE_7373_length_354_cov_3.577049_g7231_i0 | PRJNA924320 | 7373 | 354 | 3.577049 | 12.66275346 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 70.9 | 1.62e-11 | NR | YP_010803269.1 | 3060017 | g7231 | i0 | 55.2 | 0.966101694915254 | 58 | 26 | 49.2 | 0 | 2 | 175 | 356 | 413 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 342 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30593341 | 30593341 | PRJNA924320_S_NODE_55213_length_162_cov_0.902655_g55071_i0 | PRJNA924320 | 55213 | 162 | 0.902655 | 1.4623011 | Pseudoalteromonas phage vB_PtuP_Slicky | 3038240 | Viruses | Viruses | 81.6 | 5.98e-17 | NR | WGH49963.1 | 3038240 | g55071 | i0 | 71.4 | 0.907407407407407 | 49 | 14 | 90.7 | 0 | 3 | 149 | 16 | 64 | WGH49963.1 hypothetical protein [Pseudoalteromonas phage vB_PtuP_Slicky01] | diamond | 147 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudoalteromonas phage vB_PtuP_Slicky01 | |||||
| 31067561 | 31067561 | PRJNA924320_S_NODE_7095_length_360_cov_3.418006_g6953_i0 | PRJNA924320 | 7095 | 360 | 3.418006 | 12.3048216 | Pseudomonas phage GP1 | 2055238 | Viruses | Viruses | 49.3 | 7.01e-4 | NR | SPF82137.1 | 2055238 | g6953 | i0 | 56.8 | 0.308333333333333 | 37 | 16 | 30.8 | 0 | 4 | 114 | 557 | 593 | SPF82137.1 The actual alignment was detected with superfamily member TIGR01709: [Pseudomonas phage GP100] | diamond | 111 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 31256968 | 31256968 | PRJNA924320_S_NODE_46215_length_167_cov_0.864407_g46073_i0 | PRJNA924320 | 46215 | 167 | 0.864407 | 1.44355969 | Acanthamoeba castellanii medusavirus | 2080449 | Viruses | Viruses | 63.9 | 4.35e-10 | NR | YP_010804667.1 | 2080449 | g46073 | i0 | 51.8 | 2.01197604790419 | 56 | 25 | 97 | 1 | 164 | 3 | 232 | 287 | YP_010804667.1 poly A polymerase regulatory subunit [Acanthamoeba castellanii medusavirus] | diamond | 336 | 63.9 | 1 | Viruses | Acanthamoeba castellanii medusavirus | ||||||||
| 31288502 | 31288502 | PRJNA924320_S_NODE_38275_length_180_cov_2.885496_g38133_i0 | PRJNA924320 | 38275 | 180 | 2.885496 | 5.1938928 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 79 | 2.71e-16 | NR | ARF08354.1 | 1977631 | g38133 | i0 | 60.3 | 7.76666666666667 | 58 | 23 | 96.7 | 0 | 6 | 179 | 6 | 63 | ARF08354.1 Ras family GTPase [Catovirus CTV1] | diamond | 1398 | 79 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 31351962 | 31351962 | PRJNA924320_S_NODE_56696_length_161_cov_1.232143_g56554_i0 | PRJNA924320 | 56696 | 161 | 1.232143 | 1.98375023 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 59.3 | 9.64e-9 | NR | DAC81394.1 | 2609864 | g56554 | i0 | 56.9 | 0.950310559006211 | 51 | 22 | 95 | 0 | 9 | 161 | 51 | 101 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 153 | 59.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31668076 | 31668076 | PRJNA924320_S_NODE_13377_length_273_cov_1.138393_g13235_i0 | PRJNA924320 | 13377 | 273 | 1.138393 | 3.10781289 | Vibrio phage 1.235.O._1 | 1881352 | Viruses | Viruses | 117 | 3.05e-28 | NR | AUR96941.1 | 1881352 | g13235 | i0 | 71.2 | 2.37362637362637 | 73 | 21 | 80.2 | 0 | 53 | 271 | 1 | 73 | AUR96941.1 head-to-tail joining protein [Vibrio phage 1.235.O._10N.261.52.B2] | diamond | 648 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio phage 1.235.O._10N.261.52.B2 | ||||
| 31738502 | 31738502 | PRJNA924320_S_NODE_48177_length_166_cov_0.871795_g48035_i0 | PRJNA924320 | 48177 | 166 | 0.871795 | 1.4471797 | Viruses | 10239 | Viruses | Viruses | 73.2 | 9.8e-14 | NR | SPF82143.1 | 2055238 | g48035 | i0 | 72.9 | 2.63855421686747 | 48 | 13 | 86.7 | 0 | 148 | 5 | 5 | 52 | SPF82143.1 Phage protein [Pseudomonas phage GP100] | diamond | 438 | 73.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 31928440 | 31928440 | PRJNA924320_S_NODE_817_length_960_cov_2.003293_g744_i0 | PRJNA924320 | 817 | 960 | 2.003293 | 19.2316128 | Viruses | 10239 | Viruses | Viruses | 248 | 6.79e-77 | NR | AUR96944.1 | 1881352 | g744 | i0 | 75 | 1.00625 | 160 | 40 | 50 | 0 | 474 | 953 | 1 | 160 | AUR96944.1 major capsid protein [Vibrio phage 1.235.O._10N.261.52.B2] | diamond | 966 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio phage 1.235.O._10N.261.52.B2 | ||||
| 32111129 | 32111129 | PRJNA924320_S_NODE_28818_length_202_cov_1.215686_g28676_i0 | PRJNA924320 | 28818 | 202 | 1.215686 | 2.45568572 | Rheinheimera phage vB_RspM_Barba18A | 2565657 | Viruses | Viruses | 70.9 | 8.35e-14 | NR | YP_009823000.1 | 2565657 | g28676 | i0 | 53.1 | 1.9009900990099 | 64 | 30 | 95 | 0 | 197 | 6 | 47 | 110 | YP_009823000.1 endolysin [Rheinheimera phage vB_RspM_Barba18A] | diamond | 384 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Barbavirus | Barbavirus barba18A | ||||
| 32490953 | 32490953 | PRJNA924320_S_NODE_39099_length_179_cov_1.176923_g38957_i0 | PRJNA924320 | 39099 | 179 | 1.176923 | 2.10669217 | Barrevirus sp. | 2487763 | Viruses | Viruses | 45.1 | 0.00238 | NR | AYV77211.1 | 2487763 | g38957 | i0 | 32.3 | 1.08938547486034 | 65 | 32 | 88.8 | 1 | 163 | 5 | 33 | 97 | AYV77211.1 MAG: hypothetical protein Barrevirus19_6 [Barrevirus sp.] | diamond | 195 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 32743166 | 32743166 | PRJNA924320_S_NODE_26860_length_207_cov_1.936709_g26718_i0 | PRJNA924320 | 26860 | 207 | 1.936709 | 4.00898763 | Citrobacter phage CVT22 | 1622234 | Viruses | Viruses | 83.6 | 9.33e-17 | NR | YP_009168387.1 | 1622234 | g26718 | i0 | 63.6 | 1.91304347826087 | 66 | 24 | 95.7 | 0 | 6 | 203 | 515 | 580 | YP_009168387.1 head-tail adaptor [Citrobacter phage CVT22] | diamond | 396 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Citrovirus | Citrovirus coptotermitis | |||
| 32900317 | 32900317 | PRJNA924320_S_NODE_20000_length_232_cov_0.836066_g19858_i0 | PRJNA924320 | 20000 | 232 | 0.836066 | 1.93967312 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 78.6 | 4.47e-17 | NR | AYV85056.1 | 2487771 | g19858 | i0 | 68.5 | 1.39655172413793 | 54 | 17 | 69.8 | 0 | 2 | 163 | 23 | 76 | AYV85056.1 MAG: ubiquitin-domain-containing protein [Satyrvirus sp.] | diamond | 324 | 78.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus 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);;