contig_metadata
13 rows where bioproject = "PRJEB14175", tax_phylum = "Negarnaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25510879 | 25510879 | PRJEB14175_P_NODE_65609_length_456_cov_17.468354_g63352_i0 | PRJEB14175 | 65609 | 456 | 17.468354 | 79.65569424 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 710 | 0 | NTclustered | gi|2895664184|gb|PQ658357.1| | 3395899 | g63352 | i0 | 96.512 | 0.942982456140351 | 430 | 14 | 94 | 1 | 24 | 452 | 2465 | 2894 | Grapevine wood holobiome associated mycoophiovirus 1 hypothetical protein genes, complete cds | blastn | 430 | 710 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 25642192 | 25642192 | PRJEB14175_P_NODE_216770_length_216_cov_1.238710_g214503_i0 | PRJEB14175 | 216770 | 216 | 1.23871 | 2.6756136 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 353 | 4.669999999999999e-93 | NTclustered | gi|2895664184|gb|PQ658357.1| | 3395899 | g214503 | i0 | 96.279 | 0.99537037037037 | 215 | 8 | 99 | 0 | 1 | 215 | 632 | 846 | Grapevine wood holobiome associated mycoophiovirus 1 hypothetical protein genes, complete cds | blastn | 215 | 353 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26046919 | 26046919 | PRJEB14175_P_NODE_136429_length_294_cov_9.051502_g134162_i0 | PRJEB14175 | 136429 | 294 | 9.051502 | 26.61141588 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 468 | 2.29e-127 | NTclustered | gi|2895664182|gb|PQ658356.1| | 3395899 | g134162 | i0 | 97.445 | 0.931972789115646 | 274 | 7 | 93 | 0 | 1 | 274 | 2353 | 2080 | Grapevine wood holobiome associated mycoophiovirus 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 274 | 468 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26053036 | 26053036 | PRJEB14175_P_NODE_29885_length_680_cov_1.331179_g27802_i0 | PRJEB14175 | 29885 | 680 | 1.331179 | 9.0520172 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 1123 | 0 | NTclustered | gi|2895664182|gb|PQ658356.1| | 3395899 | g27802 | i0 | 96.471 | 1 | 680 | 24 | 100 | 0 | 1 | 680 | 7280 | 6601 | Grapevine wood holobiome associated mycoophiovirus 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 680 | 1123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26192882 | 26192882 | PRJEB14175_P_NODE_93590_length_372_cov_9.546624_g91324_i0 | PRJEB14175 | 93590 | 372 | 9.546624 | 35.51344128 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 584 | 2.819999999999999e-162 | NTclustered | gi|2895664182|gb|PQ658356.1| | 3395899 | g91324 | i0 | 97.647 | 1.29301075268817 | 340 | 8 | 91 | 0 | 8 | 347 | 5094 | 4755 | Grapevine wood holobiome associated mycoophiovirus 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 481 | 584 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26454088 | 26454088 | PRJEB14175_P_NODE_114488_length_329_cov_4.033582_g112222_i0 | PRJEB14175 | 114488 | 329 | 4.033582 | 13.27048478 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 507 | 5.5e-139 | NTclustered | gi|2895664184|gb|PQ658357.1| | 3395899 | g112222 | i0 | 96.429 | 0.936170212765957 | 308 | 10 | 93 | 1 | 23 | 329 | 1454 | 1761 | Grapevine wood holobiome associated mycoophiovirus 1 hypothetical protein genes, complete cds | blastn | 308 | 507 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26457939 | 26457939 | PRJEB14175_P_NODE_194760_length_232_cov_3.269006_g192493_i0 | PRJEB14175 | 194760 | 232 | 3.269006 | 7.58409392 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 398 | 2.3099999999999995e-106 | NTclustered | gi|2895664184|gb|PQ658357.1| | 3395899 | g192493 | i0 | 98.661 | 0.96551724137931 | 224 | 3 | 97 | 0 | 9 | 232 | 1936 | 1713 | Grapevine wood holobiome associated mycoophiovirus 1 hypothetical protein genes, complete cds | blastn | 224 | 398 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 26464294 | 26464294 | PRJEB14175_P_NODE_81032_length_405_cov_8.061047_g78770_i0 | PRJEB14175 | 81032 | 405 | 8.061047 | 32.64724035 | Grapevine wood holobiome associated mycoophiovirus 1 | 3395899 | Viruses | Viruses | 652 | 0 | NTclustered | gi|2895664184|gb|PQ658357.1| | 3395899 | g78770 | i0 | 97.878 | 1.06913580246914 | 377 | 8 | 93 | 0 | 29 | 405 | 1 | 377 | Grapevine wood holobiome associated mycoophiovirus 1 hypothetical protein genes, complete cds | blastn | 433 | 652 | 1 | Viruses | Orthornavirae | Negarnaviricota | Milneviricetes | Naedrevirales | Aspiviridae | Ophiovirus | Grapevine wood holobiome associated mycoophiovirus 1 | ||
| 33027983 | 33027983 | PRJEB14175_P_NODE_117396_length_324_cov_3.372624_g115130_i0 | PRJEB14175 | 117396 | 324 | 3.372624 | 10.92730176 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 76.3 | 1.79e-13 | NR | XKB76342.1 | 3240187 | g115130 | i0 | 68 | 0.925925925925926 | 50 | 16 | 46.3 | 0 | 171 | 22 | 774 | 823 | XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] | diamond | 300 | 76.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 33029455 | 33029455 | PRJEB14175_P_NODE_37372_length_610_cov_15.362477_g35200_i0 | PRJEB14175 | 37372 | 610 | 15.362477 | 93.7111097 | Plasmopara viticola lesion associated mymonavirus 1 | 2692022 | Viruses | Viruses | 100 | 5.2499999999999996e-23 | NR | YP_010798436.1 | 2692022 | g35200 | i0 | 38 | 0.673770491803279 | 137 | 82 | 65.9 | 1 | 479 | 78 | 5 | 141 | YP_010798436.1 putative nucleocapsid [Plasmopara viticola lesion associated mymonavirus 1] | diamond | 411 | 100 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Sclerotimonavirus | Sclerotimonavirus alphaplasmoparae | ||
| 33029897 | 33029897 | PRJEB14175_P_NODE_85132_length_394_cov_1.930931_g82867_i0 | PRJEB14175 | 85132 | 394 | 1.930931 | 7.60786814 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 108 | 2.61e-24 | NR | XKB76342.1 | 3240187 | g82867 | i0 | 42.3 | 1.97969543147208 | 130 | 75 | 99 | 0 | 392 | 3 | 356 | 485 | XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] | diamond | 780 | 108 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 33041948 | 33041948 | PRJEB14175_P_NODE_129660_length_304_cov_6.506173_g127393_i0 | PRJEB14175 | 129660 | 304 | 6.506173 | 19.77876592 | Bunyaviricetes | 3151693 | Viruses | Viruses | 117 | 3.53e-28 | NR | YP_010840311.1 | 2485920 | g127393 | i0 | 79.4 | 1.34210526315789 | 68 | 14 | 67.1 | 0 | 16 | 219 | 1453 | 1520 | YP_010840311.1 RNA-dependent RNA polymerase [Penicillium roseopurpureum negative ssRNA virus 1] | diamond | 408 | 118 | 0.991525423728814 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus penicillii | ||
| 33097233 | 33097233 | PRJEB14175_P_NODE_23038_length_766_cov_25.547518_g21111_i0 | PRJEB14175 | 23038 | 766 | 25.547518 | 195.69398788 | Grapevine wood holobiome associated mycobunyavirales-like virus 1 | 3381422 | Viruses | Viruses | 375 | 2.04e-115 | NR | XKM51328.1 | 3381422 | g21111 | i0 | 70.2 | 0.998694516971279 | 255 | 75 | 99.5 | 1 | 763 | 2 | 1809 | 2063 | XKM51328.1 RdRp [Grapevine wood holobiome associated mycobunyavirales-like virus 1] | diamond | 765 | 375 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Grapevine wood holobiome associated mycobunyavirales-like virus 1 |
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);;