contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26318479 | 26318479 | PRJEB14175_P_NODE_127487_length_307_cov_13.500000_g125220_i0 | PRJEB14175 | 127487 | 307 | 13.5 | 41.445 | Clover yellow mosaic virus | 12177 | Viruses | Viruses | 160 | 5.32e-43 | NR | UZP17127.1 | 12177 | g125220 | i0 | 86.5 | 0.86970684039088 | 89 | 12 | 87 | 0 | 285 | 19 | 781 | 869 | UZP17127.1 ORF1 [Clover yellow mosaic virus] | diamond | 267 | 160 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 32908317 | 32908317 | PRJEB14175_P_NODE_120217_length_319_cov_4.488372_g117951_i0 | PRJEB14175 | 120217 | 319 | 4.488372 | 14.31790668 | Clover yellow mosaic virus | 12177 | Viruses | Viruses | 96.3 | 9.88e-22 | NR | UZP17131.1 | 12177 | g117951 | i0 | 81.7 | 1.12852664576802 | 60 | 11 | 56.4 | 0 | 21 | 200 | 198 | 257 | UZP17131.1 ORF5 [Clover yellow mosaic virus] | diamond | 360 | 96.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 32925849 | 32925849 | PRJEB14175_P_NODE_164609_length_260_cov_2.417085_g162342_i0 | PRJEB14175 | 164609 | 260 | 2.417085 | 6.284421 | Pleurotus pulmonarius virga-like virus 1 | 3231516 | Viruses | Viruses | 56.2 | 8.05e-7 | NR | XCI72490.1 | 3231516 | g162342 | i0 | 56.6 | 0.611538461538462 | 53 | 21 | 60 | 2 | 23 | 178 | 540 | 591 | XCI72490.1 methyltransferase [Pleurotus pulmonarius virga-like virus 1] | diamond | 159 | 56.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Pleurotus pulmonarius virga-like virus 1 | |||
| 32926265 | 32926265 | PRJEB14175_P_NODE_208625_length_221_cov_32.750000_g206358_i0 | PRJEB14175 | 208625 | 221 | 32.75 | 72.3775 | Fusarium graminearum alphavirus-like virus 1 | 2683609 | Viruses | Viruses | 42.4 | 0.0396 | NR | QGW08824.1 | 2683609 | g206358 | i0 | 69.6 | 0.312217194570136 | 23 | 7 | 31.2 | 0 | 24 | 92 | 1951 | 1973 | QGW08824.1 hypothetical protein [Fusarium graminearum alphavirus-like virus 1] | diamond | 69 | 42.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Mycoalphaviridae | Betasclernavirus | Betasclernavirus alphafusarii | ||
| 32927437 | 32927437 | PRJEB14175_P_NODE_93601_length_372_cov_8.167203_g91335_i0 | PRJEB14175 | 93601 | 372 | 8.167203 | 30.38199516 | Armillaria borealis mycovirgavirus 1 | 2827441 | Viruses | Viruses | 49.7 | 4.16e-4 | NR | QUD20346.1 | 2827441 | g91335 | i0 | 44.9 | 0.629032258064516 | 78 | 34 | 59.7 | 4 | 235 | 14 | 145 | 217 | QUD20346.1 ORF2 protein [Armillaria borealis mycovirgavirus 1] | diamond | 234 | 49.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Armillaria borealis mycovirgavirus 1 | |||
| 32944574 | 32944574 | PRJEB14175_P_NODE_95282_length_368_cov_7.045603_g93016_i0 | PRJEB14175 | 95282 | 368 | 7.045603 | 25.92781904 | Botryosphaeria dothidea tobamo-like virus | 2601607 | Viruses | Viruses | 128 | 1.82e-31 | NR | QED22727.1 | 2601607 | g93016 | i0 | 57.8 | 0.831521739130435 | 102 | 43 | 83.2 | 0 | 345 | 40 | 1033 | 1134 | QED22727.1 RNA-dependent RNA polymerase [Botryosphaeria dothidea tobamo-like virus] | diamond | 306 | 128 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Botryosphaeria dothidea tobamo-like virus | |||
| 32960395 | 32960395 | PRJEB14175_P_NODE_181530_length_243_cov_4.390110_g179263_i0 | PRJEB14175 | 181530 | 243 | 4.39011 | 10.6679673 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 44.3 | 0.00449 | NR | UVF62070.1 | 2743097 | g179263 | i0 | 50 | 0.518518518518518 | 42 | 21 | 51.9 | 0 | 220 | 95 | 98 | 139 | UVF62070.1 MAG: hypothetical protein [Erysiphe necator associated deltaflexivirus 4] | diamond | 126 | 44.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 33008155 | 33008155 | PRJEB14175_P_NODE_70659_length_438_cov_10.427056_g68400_i0 | PRJEB14175 | 70659 | 438 | 10.427056 | 45.67050528 | Potexvirus | 12176 | Viruses | Viruses | 175 | 1.2299999999999999e-47 | NR | QLJ11034.1 | 12177 | g68400 | i0 | 69 | 4.88356164383562 | 113 | 34 | 77.4 | 1 | 24 | 362 | 366 | 477 | QLJ11034.1 RNA-dependent RNA polymerase [Clover yellow mosaic virus] | diamond | 2139 | 175 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 33011277 | 33011277 | PRJEB14175_P_NODE_162732_length_262_cov_1.925373_g160465_i0 | PRJEB14175 | 162732 | 262 | 1.925373 | 5.04447726 | Chrysanthemum kita-like virus | 3051860 | Viruses | Viruses | 58.5 | 1.26e-7 | NR | WIM36808.1 | 3051860 | g160465 | i0 | 42 | 0.790076335877863 | 69 | 38 | 79 | 1 | 246 | 40 | 68 | 134 | WIM36808.1 hypothetical protein [Chrysanthemum kita-like virus] | diamond | 207 | 58.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Kitaviridae | Chrysanthemum kita-like virus | |||
| 33059345 | 33059345 | PRJEB14175_P_NODE_87013_length_389_cov_1.426829_g84748_i0 | PRJEB14175 | 87013 | 389 | 1.426829 | 5.55036481 | Deltaflexivirus | 2169569 | Viruses | Viruses | 209 | 6.77e-60 | NR | QKN22684.1 | 2743096 | g84748 | i0 | 81.1 | 3.91773778920308 | 127 | 24 | 97.9 | 0 | 381 | 1 | 1080 | 1206 | QKN22684.1 RNA-dependent RNA polymerase [Erysiphe necator associated deltaflexivirus 3] | diamond | 1524 | 209 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 3 | ||
| 33062202 | 33062202 | PRJEB14175_P_NODE_136477_length_294_cov_6.695279_g134210_i0 | PRJEB14175 | 136477 | 294 | 6.695279 | 19.68412026 | Phytophthora heveae alphaendornavirus 1 | 3044010 | Viruses | Viruses | 69.7 | 2.45e-11 | NR | WGT76336.1 | 3044010 | g134210 | i0 | 50.7 | 0.704081632653061 | 69 | 34 | 70.4 | 0 | 213 | 7 | 1209 | 1277 | WGT76336.1 polyprotein [Phytophthora heveae alphaendornavirus 1] | diamond | 207 | 69.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Phytophthora heveae alphaendornavirus 1 | ||
| 33064024 | 33064024 | PRJEB14175_P_NODE_96613_length_365_cov_6.743421_g94347_i0 | PRJEB14175 | 96613 | 365 | 6.743421 | 24.61348665 | Gengado virus | 2689362 | Viruses | Viruses | 75.1 | 6.88e-13 | NR | QHA33697.1 | 2689362 | g94347 | i0 | 40.4 | 0.772602739726027 | 94 | 56 | 77.3 | 0 | 284 | 3 | 1 | 94 | QHA33697.1 viral methyltransferase [Gengado virus] | diamond | 282 | 75.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Gengado virus | |||
| 33078938 | 33078938 | PRJEB14175_P_NODE_101766_length_354_cov_1.310580_g99500_i0 | PRJEB14175 | 101766 | 354 | 1.31058 | 4.6394532 | Elderberry carlavirus B | 1569053 | Viruses | Viruses | 199 | 1.3099999999999998e-56 | NR | YP_009224934.1 | 1569053 | g99500 | i0 | 95.7 | 0.779661016949153 | 92 | 4 | 78 | 0 | 24 | 299 | 207 | 298 | YP_009224934.1 replicase polyprotein [Elderberry carlavirus B] | diamond | 276 | 199 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Elderberry carlavirus B | ||
| 33097519 | 33097519 | PRJEB14175_P_NODE_263518_length_198_cov_2.145985_g261250_i0 | PRJEB14175 | 263518 | 198 | 2.145985 | 4.2490503 | Pleurotus pulmonarius virga-like virus 1 | 3231516 | Viruses | Viruses | 45.8 | 0.00172 | NR | XCI72489.1 | 3231516 | g261250 | i0 | 54.1 | 0.560606060606061 | 37 | 17 | 56.1 | 0 | 198 | 88 | 523 | 559 | XCI72489.1 RNA-dependent RNA polymerase [Pleurotus pulmonarius virga-like virus 1] | diamond | 111 | 45.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Pleurotus pulmonarius virga-like virus 1 | |||
| 33097883 | 33097883 | PRJEB14175_P_NODE_64222_length_462_cov_1.276808_g61966_i0 | PRJEB14175 | 64222 | 462 | 1.276808 | 5.89885296 | Qingyuan Delta tick virus 1 | 2972096 | Viruses | Viruses | 195 | 2.3299999999999998e-54 | NR | UYL95308.1 | 2972096 | g61966 | i0 | 85.3 | 1.49350649350649 | 102 | 15 | 66.2 | 0 | 311 | 6 | 1267 | 1368 | UYL95308.1 MAG: RNA-dependent RNA polymerase [Qingyuan Delta tick virus 1] | diamond | 690 | 195 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Qingyuan Delta tick virus 1 | |||
| 33114227 | 33114227 | PRJEB14175_P_NODE_233567_length_207_cov_5.712329_g231299_i0 | PRJEB14175 | 233567 | 207 | 5.712329 | 11.82452103 | Grapevine rupestris vein feathering virus | 204933 | Viruses | Viruses | 115 | 4.17e-28 | NR | QIN93588.1 | 204933 | g231299 | i0 | 96.4 | 0.811594202898551 | 56 | 2 | 81.2 | 0 | 39 | 206 | 690 | 745 | QIN93588.1 MAG: hypothetical protein [Grapevine rupestris vein feathering virus] | diamond | 168 | 115 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Grapevine rupestris vein feathering virus | ||
| 33130446 | 33130446 | PRJEB14175_P_NODE_132735_length_300_cov_1.317992_g130468_i0 | PRJEB14175 | 132735 | 300 | 1.317992 | 3.953976 | Clover yellow mosaic virus | 12177 | Viruses | Viruses | 165 | 6.08e-45 | NR | NP_077079.1 | 12177 | g130468 | i0 | 84.8 | 0.99 | 99 | 15 | 99 | 0 | 3 | 299 | 436 | 534 | NP_077079.1 replicase [Clover yellow mosaic virus] | diamond | 297 | 165 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii |
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);;