contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27021660 | 27021660 | PRJNA770826_P_NODE_17882_length_191_cov_1.830986_g17711_i0 | PRJNA770826 | 17882 | 191 | 1.830986 | 3.49718326 | Clandestinovirus | 2831644 | Viruses | Viruses | 52.4 | 6.65e-6 | NR | QYA18570.1 | 2831644 | g17711 | i0 | 44.6 | 2.67015706806283 | 56 | 30 | 88 | 1 | 19 | 186 | 158 | 212 | QYA18570.1 agglutinin [Clandestinovirus] | diamond | 510 | 52.4 | 1 | Viruses | Clandestinovirus | ||||||||
| 27116280 | 27116280 | PRJNA770826_P_NODE_41802_length_162_cov_0.920354_g41631_i0 | PRJNA770826 | 41802 | 162 | 0.920354 | 1.49097348 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 67 | 2e-11 | NR | VBB17800.1 | 2420051 | g41631 | i0 | 58.5 | 0.981481481481482 | 53 | 22 | 98.1 | 0 | 3 | 161 | 138 | 190 | VBB17800.1 RING zinc finger-containing protein [Yasminevirus sp. GU-2018] | diamond | 159 | 67 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 27410770 | 27410770 | PRJNA770826_P_NODE_7563_length_298_cov_1.670683_g7392_i0 | PRJNA770826 | 7563 | 298 | 1.670683 | 4.97863534 | Pandoravirus | 2060084 | Viruses | Viruses | 166 | 3.2699999999999995e-48 | NR | BCU03170.1 | 2823154 | g7392 | i0 | 78.6 | 6.9261744966443 | 98 | 21 | 98.7 | 0 | 294 | 1 | 8 | 105 | BCU03170.1 chorismate synthase [Pandoravirus japonicus] | diamond | 2064 | 166 | 1 | Viruses | Pandoravirus | Pandoravirus japonicus | |||||||
| 28316659 | 28316659 | PRJNA770826_P_NODE_25406_length_168_cov_1.310924_g25235_i0 | PRJNA770826 | 25406 | 168 | 1.310924 | 2.20235232 | uncultured virus | 340016 | Viruses | Viruses | 43.1 | 0.0098 | NR | CAK7994547.1 | 340016 | g25235 | i0 | 44.4 | 0.803571428571429 | 45 | 24 | 80.4 | 1 | 157 | 23 | 418 | 461 | CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus] | diamond | 135 | 43.1 | 1 | Viruses | uncultured virus | ||||||||
| 28663971 | 28663971 | PRJNA770826_P_NODE_17967_length_191_cov_1.154930_g17796_i0 | PRJNA770826 | 17967 | 191 | 1.15493 | 2.2059163 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 60.1 | 1.42e-8 | NR | AYV76622.1 | 2487775 | g17796 | i0 | 44.4 | 0.989528795811518 | 63 | 33 | 99 | 1 | 2 | 190 | 642 | 702 | AYV76622.1 MAG: putative von willebrand factor type A domain protein [Terrestrivirus sp.] | diamond | 189 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28758583 | 28758583 | PRJNA770826_P_NODE_847_length_906_cov_2.558926_g735_i0 | PRJNA770826 | 847 | 906 | 2.558926 | 23.18386956 | Clandestinovirus | 2831644 | Viruses | Viruses | 105 | 3.23e-23 | NR | QYA18369.1 | 2831644 | g735 | i0 | 51.7 | 0.294701986754967 | 89 | 43 | 29.5 | 0 | 292 | 26 | 137 | 225 | QYA18369.1 bifunctional linker histone H1/H5 [Clandestinovirus] | diamond | 267 | 105 | 1 | Viruses | Clandestinovirus | ||||||||
| 29074560 | 29074560 | PRJNA770826_P_NODE_43028_length_162_cov_0.920354_g42857_i0 | PRJNA770826 | 43028 | 162 | 0.920354 | 1.49097348 | Megaviridae environmental sample | 1737588 | Viruses | Viruses | 46.6 | 5.29e-4 | NR | QFG74153.1 | 1737588 | g42857 | i0 | 51 | 0.944444444444444 | 51 | 22 | 90.7 | 2 | 149 | 3 | 7 | 56 | QFG74153.1 MAG: aminotransferase class I and II [Megaviridae environmental sample] | diamond | 153 | 46.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megaviridae environmental sample | |||
| 29673926 | 29673926 | PRJNA770826_P_NODE_10690_length_247_cov_0.939394_g10519_i0 | PRJNA770826 | 10690 | 247 | 0.939394 | 2.32030318 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 52.4 | 1.55e-5 | NR | YP_009448666.1 | 2023057 | g10519 | i0 | 37.7 | 0.935222672064777 | 77 | 37 | 93.5 | 1 | 232 | 2 | 352 | 417 | YP_009448666.1 Flotillin domain-containing protein [Orpheovirus IHUMI-LCC2] | diamond | 231 | 52.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 30021856 | 30021856 | PRJNA770826_P_NODE_41851_length_162_cov_0.920354_g41680_i0 | PRJNA770826 | 41851 | 162 | 0.920354 | 1.49097348 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 69.7 | 3.71e-12 | NR | YP_010803071.1 | 3060017 | g41680 | i0 | 62.2 | 0.833333333333333 | 45 | 17 | 83.3 | 0 | 137 | 3 | 241 | 285 | YP_010803071.1 DHH phosphoesterase [Fadolivirus algeromassiliense] | diamond | 135 | 69.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30621856 | 30621856 | PRJNA770826_P_NODE_16913_length_197_cov_1.054054_g16742_i0 | PRJNA770826 | 16913 | 197 | 1.054054 | 2.07648638 | Indivirus ILV1 | 1977633 | Viruses | Viruses | 53.9 | 2.31e-6 | NR | ARF09660.1 | 1977633 | g16742 | i0 | 46.4 | 0.852791878172589 | 56 | 30 | 85.3 | 0 | 194 | 27 | 686 | 741 | ARF09660.1 glycosyltransferase [Indivirus ILV1] | diamond | 168 | 53.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Indivirus | Indivirus ILV1 | ||
| 30685063 | 30685063 | PRJNA770826_P_NODE_37613_length_164_cov_0.904348_g37442_i0 | PRJNA770826 | 37613 | 164 | 0.904348 | 1.48313072 | Pseudomonas phage ZQG1 | 3032261 | Viruses | Viruses | 67.4 | 3.17e-12 | NR | WID41973.1 | 3032261 | g37442 | i0 | 62.7 | 8.12195121951219 | 51 | 18 | 93.3 | 1 | 162 | 10 | 110 | 159 | WID41973.1 GTP cyclohydrolase [Pseudomonas phage ZQG1] | diamond | 1332 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mesyanzhinovviridae | Pseudomonas phage ZQG1 | ||||
| 30843247 | 30843247 | PRJNA770826_P_NODE_134_length_1726_cov_5.794872_g102_i0 | PRJNA770826 | 134 | 1726 | 5.794872 | 100.01949072 | Tomato associated partiti-like virus 1 | 2950886 | Viruses | Viruses | 121 | 2.07e-25 | NR | UTQ50833.1 | 2950886 | g102 | i0 | 28.4 | 1.34878331402086 | 483 | 292 | 80 | 20 | 1630 | 251 | 16 | 467 | UTQ50833.1 MAG: RNA-dependent RNA polymerase [Tomato associated partiti-like virus 1] | diamond | 2328 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Tomato associated partiti-like virus 1 | |||
| 30843250 | 30843250 | PRJNA770826_P_NODE_16574_length_199_cov_1.040000_g16403_i0 | PRJNA770826 | 16574 | 199 | 1.04 | 2.0696 | Florenciella sp. virus SA2 | 3240092 | Viruses | Viruses | 74.7 | 1.13e-13 | NR | XDO02147.1 | 3240092 | g16403 | i0 | 55.6 | 0.949748743718593 | 63 | 27 | 95 | 1 | 199 | 11 | 554 | 615 | XDO02147.1 Ferrochelatase [Florenciella sp. virus SA2] | diamond | 189 | 74.7 | 1 | Viruses | Florenciella sp. virus SA2 | ||||||||
| 30906536 | 30906536 | PRJNA770826_P_NODE_16014_length_202_cov_1.359477_g15843_i0 | PRJNA770826 | 16014 | 202 | 1.359477 | 2.74614354 | Solumvirus sp. | 2487773 | Viruses | Viruses | 60.5 | 5.71e-9 | NR | AYV86227.1 | 2487773 | g15843 | i0 | 56.5 | 0.920792079207921 | 62 | 25 | 89.1 | 1 | 181 | 2 | 28 | 89 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 186 | 60.5 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 31285485 | 31285485 | PRJNA770826_P_NODE_42155_length_162_cov_0.920354_g41984_i0 | PRJNA770826 | 42155 | 162 | 0.920354 | 1.49097348 | Pithovirus LCPAC1 | 2506586 | Viruses | Viruses | 51.2 | 1.26e-5 | NR | QBK89984.1 | 2506586 | g41984 | i0 | 54 | 0.925925925925926 | 50 | 23 | 92.6 | 0 | 7 | 156 | 45 | 94 | QBK89984.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] | diamond | 150 | 51.2 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 31696748 | 31696748 | PRJNA770826_P_NODE_14817_length_210_cov_0.962733_g14646_i0 | PRJNA770826 | 14817 | 210 | 0.962733 | 2.0217393 | Chlorovirus sp. | 2809302 | Viruses | Viruses | 70.5 | 3.95e-12 | NR | XOK35624.1 | 2809302 | g14646 | i0 | 63.8 | 0.671428571428571 | 47 | 17 | 67.1 | 0 | 3 | 143 | 287 | 333 | XOK35624.1 Oxidoreductase [Chlorovirus sp.] | diamond | 141 | 70.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Chlorovirus sp. | ||
| 31728302 | 31728302 | PRJNA770826_P_NODE_27337_length_168_cov_0.873950_g27166_i0 | PRJNA770826 | 27337 | 168 | 0.87395 | 1.468236 | Agave betaflexivirus 1 | 2794400 | Viruses | Viruses | 103 | 6.83e-24 | NR | QQG34580.1 | 2794400 | g27166 | i0 | 92.7 | 0.982142857142857 | 55 | 4 | 98.2 | 0 | 167 | 3 | 258 | 312 | QQG34580.1 RdRp [Agave betaflexivirus 1] | diamond | 165 | 103 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Agave betaflexivirus 1 | |||
| 31981336 | 31981336 | PRJNA770826_P_NODE_19538_length_183_cov_1.552239_g19367_i0 | PRJNA770826 | 19538 | 183 | 1.552239 | 2.84059737 | uncultured virus | 340016 | Viruses | Viruses | 54.3 | 1.41e-6 | NR | CAK7994547.1 | 340016 | g19367 | i0 | 44.6 | 0.918032786885246 | 56 | 29 | 88.5 | 1 | 19 | 180 | 440 | 495 | CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus] | diamond | 168 | 54.3 | 1 | Viruses | uncultured virus | ||||||||
| 31981338 | 31981338 | PRJNA770826_P_NODE_22038_length_172_cov_1.268293_g21867_i0 | PRJNA770826 | 22038 | 172 | 1.268293 | 2.18146396 | Marseillevirus LCMAC2 | 2506606 | Viruses | Viruses | 90.1 | 2.82e-19 | NR | QBK87824.1 | 2506606 | g21867 | i0 | 71.4 | 0.976744186046512 | 56 | 16 | 97.7 | 0 | 3 | 170 | 280 | 335 | QBK87824.1 MAG: peptidase family M49 [Marseillevirus LCMAC202] | diamond | 168 | 90.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC202 | |||
| 32139742 | 32139742 | PRJNA770826_P_NODE_10198_length_253_cov_0.833333_g10027_i0 | PRJNA770826 | 10198 | 253 | 0.833333 | 2.10833249 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 158 | 9.85e-45 | NR | AYV76711.1 | 2487775 | g10027 | i0 | 89.3 | 0.99604743083004 | 84 | 9 | 99.6 | 0 | 252 | 1 | 144 | 227 | AYV76711.1 MAG: hypothetical protein Terrestrivirus12_14 [Terrestrivirus sp.] | diamond | 252 | 158 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32645245 | 32645245 | PRJNA770826_P_NODE_6300_length_332_cov_7.349823_g6129_i0 | PRJNA770826 | 6300 | 332 | 7.349823 | 24.40141236 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 46.6 | 9.46e-4 | NR | AYV76392.1 | 2487775 | g6129 | i0 | 52 | 0.451807228915663 | 50 | 22 | 43.4 | 1 | 238 | 95 | 1 | 50 | AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] | diamond | 150 | 46.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus 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);;