viruses_fish_associated_curated
4 rows where Category = "Novel" and clusterLCA_curated = "Zebrafish arterivirus"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10279 | 10279 | PRJNA545942_CONTIG_1|Wuhan_japanese_halfbeak_arterivirus|CLUSTER1_Wuhan_japanese_halfbeak_arterivirus|1|1 | Zebrafish arterivirus | Novel | PRJNA545942_CONTIG_1|Wuhan_japanese_halfbeak_arterivirus | PRJNA545942_CONTIG_1 | Wuhan japanese halfbeak arterivirus | 4 | 1 | 4 | CLUSTER1_Wuhan_japanese_halfbeak_arterivirus|1|1 | PRJNA545942_P_NODE_1_length_7419_cov_24.791043_g0_i0|Wuhan_japanese_halfbeak_arterivirus|NR|0|NA | 1 | 1 | PRJNA545942 | 1 | 7419 | 24.791043 | 1839.24748 | Wuhan japanese halfbeak arterivirus | 2116443 | Viruses | Viruses | 1303.0 | 0.0 | Wuhan japanese halfbeak arterivirus | Non-phage | NR | PRJNA545942_P_NODE_1_length_7419_cov_24.791043_g0_i0 | YP_009755852.1 1b protein [Wuhan japanese halfbeak arterivirus] | YP_009755852.1 | 2116443 | g0 | i0 | 39.4 | 0.834613829 | 2064 | 1039 | 76.9 | 43 | 1 | 5706 | 851 | 2864 | 6192 | 1303.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Nanhypoviridae | Sajorinivirus | Sajorinivirus hyporhamphi | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Nidovirales;Nanhypoviridae;Sajorinivirus;Zebrafish arterivirus | Wuhan japanese halfbeak arterivirus | Viruses | Viruses | 1303.0 | 0.0 | |||||||
| 10346 | 10346 | PRJNA545942_CONTIG_1483|Wuhan_japanese_halfbeak_arterivirus|CLUSTER2_Wuhan_japanese_halfbeak_arterivirus|1|1 | Zebrafish arterivirus | Novel | PRJNA545942_CONTIG_1483|Wuhan_japanese_halfbeak_arterivirus | PRJNA545942_CONTIG_1483 | Wuhan japanese halfbeak arterivirus | 4 | 1 | 4 | CLUSTER2_Wuhan_japanese_halfbeak_arterivirus|1|1 | PRJNA545942_P_NODE_1483_length_1164_cov_3.281393_g1323_i0|Wuhan_japanese_halfbeak_arterivirus|NR|5.61e-130|NA | 1 | 1 | PRJNA545942 | 1483 | 1164 | 3.281393 | 38.19541452 | Wuhan japanese halfbeak arterivirus | 2116443 | Viruses | Viruses | 423.0 | 5.61e-130 | Wuhan japanese halfbeak arterivirus | Non-phage | NR | PRJNA545942_P_NODE_1483_length_1164_cov_3.281393_g1323_i0 | YP_009755852.1 1b protein [Wuhan japanese halfbeak arterivirus] | YP_009755852.1 | 2116443 | g1323 | i0 | 52.8 | 1.0 | 388 | 178 | 99.0 | 3 | 1156 | 5 | 470 | 856 | 1164 | 423.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Nanhypoviridae | Sajorinivirus | Sajorinivirus hyporhamphi | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Nidovirales;Nanhypoviridae;Sajorinivirus;Zebrafish arterivirus | Pseudoterpna coronillaria | Wuhan japanese halfbeak arterivirus | gi|2918369770|emb|OZ237837.1| | Arthropoda | Viruses | Arthropoda | Viruses | 56.5 | 423.0 | 0.009 | 5.61e-130 | |
| 10396 | 10396 | PRJNA545942_CONTIG_10409|Wuhan_japanese_halfbeak_arterivirus|CLUSTER3_Wuhan_japanese_halfbeak_arterivirus|1|1 | Zebrafish arterivirus | Novel | PRJNA545942_CONTIG_10409|Wuhan_japanese_halfbeak_arterivirus | PRJNA545942_CONTIG_10409 | Wuhan japanese halfbeak arterivirus | 4 | 1 | 4 | CLUSTER3_Wuhan_japanese_halfbeak_arterivirus|1|1 | PRJNA545942_P_NODE_10409_length_450_cov_1.594164_g10103_i0|Wuhan_japanese_halfbeak_arterivirus|NR|5.18e-17|NA | 1 | 1 | PRJNA545942 | 10409 | 450 | 1.594164 | 7.173738 | Wuhan japanese halfbeak arterivirus | 2116443 | Viruses | Viruses | 88.2 | 5.18e-17 | Wuhan japanese halfbeak arterivirus | Non-phage | NR | PRJNA545942_P_NODE_10409_length_450_cov_1.594164_g10103_i0 | YP_009755851.1 1A [Wuhan japanese halfbeak arterivirus] | YP_009755851.1 | 2116443 | g10103 | i0 | 35.8 | 1.08 | 162 | 83 | 96.0 | 3 | 448 | 17 | 2037 | 2195 | 486 | 88.2 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Nanhypoviridae | Sajorinivirus | Sajorinivirus hyporhamphi | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Nidovirales;Nanhypoviridae;Sajorinivirus;Zebrafish arterivirus | Wuhan japanese halfbeak arterivirus | Viruses | Viruses | 88.2 | 5.18e-17 | |||||||
| 10444 | 10444 | PRJNA545942_CONTIG_32648|Wuhan_japanese_halfbeak_arterivirus|CLUSTER4_Wuhan_japanese_halfbeak_arterivirus|1|1 | Zebrafish arterivirus | Novel | PRJNA545942_CONTIG_32648|Wuhan_japanese_halfbeak_arterivirus | PRJNA545942_CONTIG_32648 | Wuhan japanese halfbeak arterivirus | 4 | 1 | 4 | CLUSTER4_Wuhan_japanese_halfbeak_arterivirus|1|1 | PRJNA545942_P_NODE_32648_length_251_cov_0.865169_g32342_i0|Wuhan_japanese_halfbeak_arterivirus|NR|2.23e-10|NA | 1 | 1 | PRJNA545942 | 32648 | 251 | 0.865169 | 2.17157419 | Wuhan japanese halfbeak arterivirus | 2116443 | Viruses | Viruses | 66.2 | 2.23e-10 | Wuhan japanese halfbeak arterivirus | Non-phage | NR | PRJNA545942_P_NODE_32648_length_251_cov_0.865169_g32342_i0 | YP_009755851.1 1A [Wuhan japanese halfbeak arterivirus] | YP_009755851.1 | 2116443 | g32342 | i0 | 39.0 | 0.920318725 | 77 | 47 | 92.0 | 0 | 251 | 21 | 1034 | 1110 | 231 | 66.2 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Nanhypoviridae | Sajorinivirus | Sajorinivirus hyporhamphi | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Nidovirales;Nanhypoviridae;Sajorinivirus;Zebrafish arterivirus | Wuhan japanese halfbeak arterivirus | Viruses | Viruses | 66.2 | 2.23e-10 |
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);;