viruses_fish_associated_curated
6 rows where tax_family_NTorNR = "Picornaviridae" and tax_species_NTorNR = "Picornaviridae sp."
This data as json, CSV (advanced)
| Link | rowid ▼ | contig_withLCA_withcluster | clusterLCA_curated | Category | contig_withLCA | shortcontigname | clusterLCA | clusterLCAcurated_contigcount | clusterLCAcurated_bioprojectcount | clusterLCAcurated_clustercount | shortclustername | cluster | clustersize | bioprojectsbycluster | bioproject | node | length | coverage | rel_abundance | taxname_lca_NTorNR | taxid_lca_NTorNR | taxoncategory_NTorNR | taxoncategorysimple_NTorNR | bits_NTorNR | evalue_NTorNR | viruscategory_NTorNR | viruscategorysimple_NTorNR | analysis_used | contig_name | lowcoverage_flag | target_title_NTorNR | target_NTorNR | taxid_NTorNR | gene_NTorNR | allele_NTorNR | pident_NTorNR | sumperc_cov_NTorNR | alnlen_NTorNR | mismatch_NTorNR | qcov_NTorNR | gapopen_NTorNR | qstart_NTorNR | qend_NTorNR | tstart_NTorNR | tend_NTorNR | sumalnlen_NTorNR | maxbits_NTorNR | bits_percmax_NTorNR | tax_superkingdom_NTorNR | tax_clade_NTorNR | tax_kingdom_NTorNR | tax_phylum_NTorNR | tax_class_NTorNR | tax_order_NTorNR | tax_family_NTorNR | tax_genus_NTorNR | tax_species_NTorNR | classification | taxname_lca_NTclustered | taxname_lca_NR | target_NTclustered | taxoncategory_NTclustered | taxoncategory_NR | taxoncategorysimple_NTclustered | taxoncategorysimple_NR | bits_NTclustered | bits_NR | evalue_NTclustered | evalue_NR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2456 | 2456 | PRJNA1001808_CONTIG_1887|Picornaviridae_sp.|CLUSTER1_Zebrafish_picornavirus_2|1382|320 | Danio blood picornavirus/Zebrafish picornavirus 2 | Novel | PRJNA1001808_CONTIG_1887|Picornaviridae_sp. | PRJNA1001808_CONTIG_1887 | Zebrafish picornavirus 2 | 1369 | 320 | 1 | CLUSTER1_Zebrafish_picornavirus_2|1382|320 | PRJNA924006_P_NODE_1_length_7278_cov_16.682998_g0_i0|Zebrafish_picornavirus_2|NR|0|NA | 1370 | 320 | PRJNA1001808 | 1887 | 270 | 1.488584 | 4.0191768 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 72.8 | 1.41e-12 | Picornaviridae sp. | Non-phage | NR | PRJNA1001808_P_NODE_1887_length_270_cov_1.488584_g1848_i0 | QKE55046.1 MAG: polyprotein [Picornaviridae sp.] | QKE55046.1 | 1530251 | g1848 | i0 | 69.6 | 1.044444444 | 46 | 13 | 51.1 | 1 | 139 | 2 | 774 | 818 | 282 | 72.8 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2 | Picornaviridae sp. | Viruses | Viruses | 72.8 | 1.41e-12 | ||||||||
| 8362 | 8362 | PRJNA854078_CONTIG_1632|Picornaviridae_sp.|CLUSTER1_Coleura_bat_picornavirus|100|37 | Zebrafish jaw picornavirus | Novel | PRJNA854078_CONTIG_1632|Picornaviridae_sp. | PRJNA854078_CONTIG_1632 | Coleura bat picornavirus | 89 | 37 | 1 | CLUSTER1_Coleura_bat_picornavirus|100|37 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA | 93 | 37 | PRJNA854078 | 1632 | 749 | 4.998521 | 37.43892229 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 150.0 | 3.91e-37 | Picornaviridae sp. | Non-phage | NR | PRJNA854078_P_NODE_1632_length_749_cov_4.998521_g261_i1 | QKE55033.1 MAG: polyprotein [Picornaviridae sp.] | QKE55033.1 | 1530251 | g261 | i1 | 47.9 | 0.660881175 | 165 | 84 | 65.3 | 2 | 5 | 493 | 2152 | 2316 | 495 | 150.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus | Picornaviridae sp. | Viruses | Viruses | 150.0 | 3.91e-37 | ||||||||
| 8373 | 8373 | PRJNA854078_CONTIG_3582|Picornaviridae|CLUSTER1_Coleura_bat_picornavirus|100|37 | Zebrafish jaw picornavirus | Novel | PRJNA854078_CONTIG_3582|Picornaviridae | PRJNA854078_CONTIG_3582 | Coleura bat picornavirus | 89 | 37 | 1 | CLUSTER1_Coleura_bat_picornavirus|100|37 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA | 93 | 37 | PRJNA854078 | 3582 | 503 | 1.493023 | 7.50990569 | Picornaviridae | 12058 | Viruses | Viruses | 47.0 | 0.0169 | Picornaviridae | Non-phage | NR | PRJNA854078_P_NODE_3582_length_503_cov_1.493023_g3370_i0 | UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] | UCS96340.1 | 1530251 | g3370 | i0 | 38.4 | 2.439363817 | 73 | 43 | 42.3 | 1 | 291 | 503 | 1203 | 1275 | 1227 | 47.4 | 0.991561181 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus | Picornaviridae | Viruses | Viruses | 47.0 | 0.0169 | ||||||||
| 8376 | 8376 | PRJNA690124_CONTIG_4675|Picornaviridae_sp.|CLUSTER1_Coleura_bat_picornavirus|100|37 | Zebrafish jaw picornavirus | Novel | PRJNA690124_CONTIG_4675|Picornaviridae_sp. | PRJNA690124_CONTIG_4675 | Coleura bat picornavirus | 89 | 37 | 1 | CLUSTER1_Coleura_bat_picornavirus|100|37 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA | 93 | 37 | PRJNA690124 | 4675 | 732 | 2.883156 | 21.10470192 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 168.0 | 1.65e-43 | Picornaviridae sp. | Non-phage | NR | PRJNA690124_P_NODE_4675_length_732_cov_2.883156_g4340_i0 | QKE55033.1 MAG: polyprotein [Picornaviridae sp.] | QKE55033.1 | 1530251 | g4340 | i0 | 49.4 | 0.721311475 | 176 | 87 | 71.3 | 2 | 2 | 523 | 2141 | 2316 | 528 | 168.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus | Picornaviridae sp. | Viruses | Viruses | 168.0 | 1.65e-43 | ||||||||
| 8397 | 8397 | PRJNA688736_CONTIG_19651|Picornaviridae_sp.|CLUSTER1_Coleura_bat_picornavirus|100|37 | Zebrafish jaw picornavirus | Novel | PRJNA688736_CONTIG_19651|Picornaviridae_sp. | PRJNA688736_CONTIG_19651 | Coleura bat picornavirus | 89 | 37 | 1 | CLUSTER1_Coleura_bat_picornavirus|100|37 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA | 93 | 37 | PRJNA688736 | 19651 | 351 | 1.402878 | 4.92410178 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 141.0 | 3.84e-36 | Picornaviridae sp. | Non-phage | NR | PRJNA688736_P_NODE_19651_length_351_cov_1.402878_g19366_i0 | QKE55033.1 MAG: polyprotein [Picornaviridae sp.] | QKE55033.1 | 1530251 | g19366 | i0 | 59.5 | 3.965811966 | 116 | 47 | 99.1 | 0 | 2 | 349 | 2126 | 2241 | 1392 | 141.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus | Picornaviridae sp. | Viruses | Viruses | 141.0 | 3.84e-36 | ||||||||
| 8417 | 8417 | PRJNA611476_CONTIG_54401|Kobuvirus|CLUSTER1_Coleura_bat_picornavirus|100|37 | Zebrafish jaw picornavirus | Novel | PRJNA611476_CONTIG_54401|Kobuvirus | PRJNA611476_CONTIG_54401 | Coleura bat picornavirus | 89 | 37 | 1 | CLUSTER1_Coleura_bat_picornavirus|100|37 | PRJNA670521_P_NODE_5_length_8668_cov_14.621640_g3_i0|Kobuvirus|NR|2.54e-153|NA | 93 | 37 | PRJNA611476 | 54401 | 296 | 2.475336 | 7.32699456 | Kobuvirus | 194960 | Viruses | Viruses | 46.2 | 0.0044 | Kobuvirus | Non-phage | NR | PRJNA611476_P_NODE_54401_length_296_cov_2.475336_g53610_i0 | UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] | UCS96340.1 | 1530251 | g53610 | i0 | 40.8 | 3.314189189 | 71 | 40 | 69.9 | 1 | 13 | 219 | 1208 | 1278 | 981 | 46.6 | 0.991416309 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus | Kobuvirus | Viruses | Viruses | 46.2 | 0.0044 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE viruses_fish_associated_curated(contig_withLCA_withcluster VARCHAR, clusterLCA_curated VARCHAR, Category VARCHAR, contig_withLCA VARCHAR, shortcontigname VARCHAR, clusterLCA VARCHAR, clusterLCAcurated_contigcount BIGINT, clusterLCAcurated_bioprojectcount BIGINT, clusterLCAcurated_clustercount BIGINT, shortclustername VARCHAR, "cluster" VARCHAR, clustersize BIGINT, bioprojectsbycluster BIGINT, bioproject VARCHAR, node BIGINT, length BIGINT, coverage DOUBLE, rel_abundance DOUBLE, taxname_lca_NTorNR VARCHAR, taxid_lca_NTorNR BIGINT, taxoncategory_NTorNR VARCHAR, taxoncategorysimple_NTorNR VARCHAR, bits_NTorNR DOUBLE, evalue_NTorNR DOUBLE, viruscategory_NTorNR VARCHAR, viruscategorysimple_NTorNR VARCHAR, analysis_used VARCHAR, contig_name VARCHAR, lowcoverage_flag DOUBLE, target_title_NTorNR VARCHAR, target_NTorNR VARCHAR, taxid_NTorNR BIGINT, gene_NTorNR VARCHAR, allele_NTorNR VARCHAR, pident_NTorNR DOUBLE, sumperc_cov_NTorNR DOUBLE, alnlen_NTorNR BIGINT, mismatch_NTorNR BIGINT, qcov_NTorNR DOUBLE, gapopen_NTorNR BIGINT, qstart_NTorNR BIGINT, qend_NTorNR BIGINT, tstart_NTorNR BIGINT, tend_NTorNR BIGINT, sumalnlen_NTorNR BIGINT, maxbits_NTorNR DOUBLE, bits_percmax_NTorNR DOUBLE, tax_superkingdom_NTorNR VARCHAR, tax_clade_NTorNR VARCHAR, tax_kingdom_NTorNR VARCHAR, tax_phylum_NTorNR VARCHAR, tax_class_NTorNR VARCHAR, tax_order_NTorNR VARCHAR, tax_family_NTorNR VARCHAR, tax_genus_NTorNR VARCHAR, tax_species_NTorNR VARCHAR, classification VARCHAR, taxname_lca_NTclustered VARCHAR, taxname_lca_NR VARCHAR, target_NTclustered VARCHAR, taxoncategory_NTclustered VARCHAR, taxoncategory_NR VARCHAR, taxoncategorysimple_NTclustered VARCHAR, taxoncategorysimple_NR VARCHAR, bits_NTclustered DOUBLE, bits_NR DOUBLE, evalue_NTclustered DOUBLE, evalue_NR DOUBLE);; CREATE INDEX idx_vfac_bioproject ON viruses_fish_associated_curated(bioproject);; CREATE INDEX idx_vfac_category ON viruses_fish_associated_curated(Category);; CREATE INDEX idx_vfac_clusterLCA_curated ON viruses_fish_associated_curated(clusterLCA_curated);; CREATE INDEX idx_vfac_tax_family ON viruses_fish_associated_curated(tax_family_NTorNR);; CREATE INDEX idx_vfac_tax_genus ON viruses_fish_associated_curated(tax_genus_NTorNR);; CREATE INDEX idx_vfac_tax_species ON viruses_fish_associated_curated(tax_species_NTorNR);;