contig_metadata
21 rows where bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2028407 | 2028407 | PRJNA774958_P_NODE_142_length_2543_cov_2.832389_g126_i0 | PRJNA774958 | 142 | 2543 | 2.832389 | 72.02765227 | Deltaflexivirus pleurotii | 3428203 | Viruses | Viruses | 2453 | 0 | NTclustered | gi|2442716615|gb|OQ295989.1| | 3027515 | g126 | i0 | 84.128 | 0.998427054659851 | 2539 | 399 | 99 | 4 | 6 | 2542 | 4467 | 1931 | Pleurotus ostreatus deltaflexivirus 1 isolate ZP6, complete sequence | blastn | 2539 | 2453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus pleurotii | ||
| 7131161 | 7131161 | PRJNA774958_P_NODE_14246_length_431_cov_2.365922_g13999_i0 | PRJNA774958 | 14246 | 431 | 2.365922 | 10.19712382 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 656 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g13999 | i0 | 93.968 | 1 | 431 | 26 | 100 | 0 | 1 | 431 | 6538 | 6968 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 431 | 656 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 7131366 | 7131366 | PRJNA774958_P_NODE_33566_length_251_cov_0.865169_g33319_i0 | PRJNA774958 | 33566 | 251 | 0.865169 | 2.17157419 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 263 | 9.65e-66 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g33319 | i0 | 98.649 | 0.589641434262948 | 148 | 2 | 59 | 0 | 104 | 251 | 2 | 149 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 148 | 263 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8405785 | 8405785 | PRJNA774958_P_NODE_27_length_3701_cov_5.208931_g23_i0 | PRJNA774958 | 27 | 3701 | 5.208931 | 192.78253631 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2743 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g23 | i0 | 95.767 | 0.792758713861119 | 1701 | 68 | 79 | 4 | 2003 | 3701 | 5329 | 7027 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2934 | 2743 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 9681032 | 9681032 | PRJNA774958_P_NODE_19848_length_359_cov_1.325175_g19601_i0 | PRJNA774958 | 19848 | 359 | 1.325175 | 4.75737825 | Tribolium castaneum iflavirus | 2059679 | Viruses | Viruses | 592 | 1.6199999999999999e-164 | NTclustered | gi|1308042380|gb|MG012488.1| | 2059679 | g19601 | i0 | 96.379 | 2 | 359 | 13 | 100 | 0 | 1 | 359 | 6286 | 6644 | Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds | blastn | 718 | 592 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Tribolium castaneum iflavirus | |||
| 9681040 | 9681040 | PRJNA774958_P_NODE_20128_length_356_cov_1.088339_g19881_i0 | PRJNA774958 | 20128 | 356 | 1.088339 | 3.87448684 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 499 | 1e-136 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g19881 | i0 | 92.09 | 0.99438202247191 | 354 | 28 | 99 | 0 | 1 | 354 | 6003 | 6356 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 354 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 9681286 | 9681286 | PRJNA774958_P_NODE_4548_length_762_cov_1.117562_g4337_i0 | PRJNA774958 | 4548 | 762 | 1.117562 | 8.51582244 | Rocky Mountain birnavirus | 3077841 | Viruses | Viruses | 1009 | 0 | NTclustered | gi|2583625428|gb|OR427289.1| | 3077841 | g4337 | i0 | 90.564 | 1.00131233595801 | 763 | 70 | 100 | 2 | 1 | 762 | 1736 | 2497 | Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence | blastn | 763 | 1009 | 1 | Viruses | Orthornavirae | Birnaviridae | Rocky Mountain birnavirus | ||||||
| 10956555 | 10956555 | PRJNA774958_P_NODE_109_length_2757_cov_4.327496_g96_i0 | PRJNA774958 | 109 | 2757 | 4.327496 | 119.30906472 | Deltaflexivirus pleurotii | 3428203 | Viruses | Viruses | 3419 | 0 | NTclustered | gi|2442716615|gb|OQ295989.1| | 3027515 | g96 | i0 | 89.199 | 1.00072542618789 | 2759 | 270 | 99 | 22 | 1 | 2753 | 7625 | 4889 | Pleurotus ostreatus deltaflexivirus 1 isolate ZP6, complete sequence | blastn | 2759 | 3419 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus pleurotii | ||
| 10956584 | 10956584 | PRJNA774958_P_NODE_13089_length_450_cov_1.633952_g12842_i0 | PRJNA774958 | 13089 | 450 | 1.633952 | 7.352784 | Tribolium castaneum iflavirus | 2059679 | Viruses | Viruses | 784 | 0 | NTclustered | gi|1308042380|gb|MG012488.1| | 2059679 | g12842 | i0 | 98.009 | 2.00888888888889 | 452 | 7 | 100 | 1 | 1 | 450 | 7897 | 8348 | Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds | blastn | 904 | 784 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Tribolium castaneum iflavirus | |||
| 13506327 | 13506327 | PRJNA774958_P_NODE_23471_length_323_cov_0.968000_g23224_i0 | PRJNA774958 | 23471 | 323 | 0.968 | 3.12664 | Tribolium castaneum iflavirus | 2059679 | Viruses | Viruses | 542 | 1.48e-149 | NTclustered | gi|1308042380|gb|MG012488.1| | 2059679 | g23224 | i0 | 96.904 | 2 | 323 | 10 | 100 | 0 | 1 | 323 | 9063 | 8741 | Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds | blastn | 646 | 542 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Tribolium castaneum iflavirus | |||
| 13506531 | 13506531 | PRJNA774958_P_NODE_4691_length_750_cov_2.000000_g4479_i0 | PRJNA774958 | 4691 | 750 | 2 | 15 | Deltaflexivirus pleurotii | 3428203 | Viruses | Viruses | 821 | 0 | NTclustered | gi|2442716615|gb|OQ295989.1| | 3027515 | g4479 | i0 | 86.4 | 1 | 750 | 102 | 100 | 0 | 1 | 750 | 1121 | 1870 | Pleurotus ostreatus deltaflexivirus 1 isolate ZP6, complete sequence | blastn | 750 | 821 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus pleurotii | ||
| 16055026 | 16055026 | PRJNA774958_P_NODE_1353_length_1271_cov_1.144407_g1242_i0 | PRJNA774958 | 1353 | 1271 | 1.144407 | 14.54541297 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 502 | 1.3999999999999997e-157 | NR | AVM87439.1 | 3063761 | g1242 | i0 | 56.2 | 1.00786782061369 | 427 | 183 | 99.8 | 2 | 1 | 1269 | 259 | 685 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 1281 | 502 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 19879601 | 19879601 | PRJNA774958_P_NODE_36776_length_245_cov_0.895349_g36529_i0 | PRJNA774958 | 36776 | 245 | 0.895349 | 2.19360505 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g36529 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 7 | 34 | 685770 | 685743 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 21155437 | 21155437 | PRJNA774958_P_NODE_6837_length_630_cov_1.100539_g6607_i0 | PRJNA774958 | 6837 | 630 | 1.100539 | 6.9333957 | Tribolium castaneum iflavirus | 2059679 | Viruses | Viruses | 551 | 5.059999999999998e-152 | NTclustered | gi|1308042380|gb|MG012488.1| | 2059679 | g6607 | i0 | 96.677 | 2.01587301587302 | 331 | 11 | 100 | 0 | 300 | 630 | 4895 | 5225 | Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds | blastn | 1270 | 551 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Tribolium castaneum iflavirus | |||
| 27590724 | 27590724 | PRJNA774958_P_NODE_6424_length_648_cov_2.019130_g6196_i0 | PRJNA774958 | 6424 | 648 | 2.01913 | 13.0839624 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 124 | 1.66e-28 | NR | UVF58820.1 | 3063761 | g6196 | i0 | 41.4 | 1.69907407407407 | 191 | 92 | 82.9 | 7 | 537 | 1 | 829 | 1011 | UVF58820.1 MAG: polyprotein [Asterropteryx spinosa picornavirus] | diamond | 1101 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 28073495 | 28073495 | PRJNA774958_P_NODE_3325_length_880_cov_1.840149_g3139_i0 | PRJNA774958 | 3325 | 880 | 1.840149 | 16.1933112 | Viruses | 10239 | Viruses | Viruses | 73.2 | 2.54e-10 | NR | WZL61394.1 | 3139874 | g3139 | i0 | 29.8 | 1.08068181818182 | 168 | 111 | 55.9 | 4 | 56 | 547 | 415 | 579 | WZL61394.1 MAG: hypothetical protein [Kasler Point virus] | diamond | 951 | 73.2 | 1 | Viruses | Kasler Point virus | ||||||||
| 30147929 | 30147929 | PRJNA774958_P_NODE_17772_length_383_cov_0.993548_g17525_i0 | PRJNA774958 | 17772 | 383 | 0.993548 | 3.80528884 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 49.3 | 9.18e-4 | NR | BCT22715.1 | RQ14 | g17525 | i0 | 31.7 | 0.814621409921671 | 104 | 63 | 76 | 3 | 85 | 375 | 810 | 912 | BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus] | diamond | 312 | 49.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30274848 | 30274848 | PRJNA774958_P_NODE_9952_length_518_cov_1.364045_g9709_i0 | PRJNA774958 | 9952 | 518 | 1.364045 | 7.0657531 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 87.8 | 4.98e-17 | NR | BCT22626.1 | RQ14 | g9709 | i0 | 36 | 0.868725868725869 | 150 | 92 | 84.6 | 3 | 39 | 476 | 3 | 152 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 450 | 87.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30369831 | 30369831 | PRJNA774958_P_NODE_9132_length_542_cov_1.074627_g8890_i0 | PRJNA774958 | 9132 | 542 | 1.074627 | 5.82447834 | Phytophthora cinnamomi ormycovirus 7-5 | 3239326 | Viruses | Viruses | 114 | 1.41e-25 | NR | XDO01625.1 | 3239326 | g8890 | i0 | 38.3 | 0.968634686346863 | 175 | 105 | 95.8 | 2 | 535 | 17 | 511 | 684 | XDO01625.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 7-5] | diamond | 525 | 114 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus phytophthorae | |||
| 30442142 | 30442142 | PRJNA774958_P_NODE_14733_length_424_cov_0.985755_g14486_i0 | PRJNA774958 | 14733 | 424 | 0.985755 | 4.1796012 | Viruses | 10239 | Viruses | Viruses | 44.7 | 0.0465 | NR | DAM02168.1 | 2832643 | g14486 | i0 | 37.5 | 0.849056603773585 | 56 | 35 | 39.6 | 0 | 290 | 123 | 132 | 187 | DAM02168.1 MAG TPA: major capsid protein [Caudoviricetes sp.] | diamond | 360 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31475631 | 31475631 | PRJNA774958_P_NODE_5636_length_689_cov_2.982143_g5416_i0 | PRJNA774958 | 5636 | 689 | 2.982143 | 20.54696527 | Pleurotus ostreatus deltaflexivirus 1 | 3027515 | Viruses | Viruses | 375 | 4.62e-116 | NR | WCU24521.1 | 3027515 | g5416 | i0 | 92.2 | 0.840348330914369 | 193 | 15 | 84 | 0 | 580 | 2 | 1 | 193 | WCU24521.1 putative polyprotein [Pleurotus ostreatus deltaflexivirus 1] | diamond | 579 | 375 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus pleurotii |
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);;