RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

8 rows where tax_species_NTorNR = "Rousettus bat picornavirus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_species_NTorNR 1

  • Rousettus bat picornavirus · 8 ✖

Category 1

tax_genus_NTorNR 0

tax_family_NTorNR 0

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
2723 2723 PRJNA529759_CONTIG_5506|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA529759_CONTIG_5506|Rousettus_bat_picornavirus PRJNA529759_CONTIG_5506 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 PRJNA529759 5506 160 2.536585 4.058536 Rousettus bat picornavirus 3141905 Viruses Viruses 46.6 0.000516 Rousettus bat picornavirus Non-phage NR PRJNA529759_S_NODE_5506_length_160_cov_2.536585_g5391_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g5391 i0 54.1 0.69375 37 17 69.4 0 3 113 813 849 111 46.6 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   46.6   0.000516
2724 2724 PRJNA418766_CONTIG_5524|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA418766_CONTIG_5524|Rousettus_bat_picornavirus PRJNA418766_CONTIG_5524 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 PRJNA418766 5524 229 2.309278 5.28824662 Rousettus bat picornavirus 3141905 Viruses Viruses 87.8 4.18e-18 Rousettus bat picornavirus Non-phage NR PRJNA418766_P_NODE_5524_length_229_cov_2.309278_g5420_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g5420 i0 61.3 0.812227074 62 23 79.9 1 227 45 788 849 186 87.8 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   87.8   4.18e-18
2771 2771 PRJNA644883_CONTIG_6608|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA644883_CONTIG_6608|Rousettus_bat_picornavirus PRJNA644883_CONTIG_6608 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 PRJNA644883 6608 244 2.994872 7.30748768 Rousettus bat picornavirus 3141905 Viruses Viruses 61.6 8.36e-09 Rousettus bat picornavirus Non-phage NR PRJNA644883_S_NODE_6608_length_244_cov_2.994872_g6517_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g6517 i0 38.3 4.709016393 81 45 94.7 3 3 233 811 890 1149 61.6 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   61.6   8.36e-09
2960 2960 PRJNA897077_CONTIG_16298|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA897077_CONTIG_16298|Rousettus_bat_picornavirus PRJNA897077_CONTIG_16298 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 PRJNA897077 16298 250 2.146893 5.3672325 Rousettus bat picornavirus 3141905 Viruses Viruses 64.7 7.45e-10 Rousettus bat picornavirus Non-phage NR PRJNA897077_P_NODE_16298_length_250_cov_2.146893_g16171_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g16171 i0 41.9 1.812 74 39 85.2 2 248 36 811 883 453 64.7 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   64.7   7.45e-10
2966 2966 PRJNA274362_CONTIG_16689|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA274362_CONTIG_16689|Rousettus_bat_picornavirus PRJNA274362_CONTIG_16689 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 PRJNA274362 16689 222 1.202312 2.66913264 Rousettus bat picornavirus 3141905 Viruses Viruses 72.0 1.37e-12 Rousettus bat picornavirus Non-phage NR PRJNA274362_S_NODE_16689_length_222_cov_1.202312_g16569_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g16569 i0 60.0 2.175675676 55 21 73.0 1 220 59 795 849 483 72.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   72.0   1.37e-12
3001 3001 PRJNA1002816_CONTIG_20045|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA1002816_CONTIG_20045|Rousettus_bat_picornavirus PRJNA1002816_CONTIG_20045 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 PRJNA1002816 20045 243 1.358824 3.30194232 Rousettus bat picornavirus 3141905 Viruses Viruses 88.2 3.93e-18 Rousettus bat picornavirus Non-phage NR PRJNA1002816_P_NODE_20045_length_243_cov_1.358824_g19885_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g19885 i0 60.6 1.617283951 66 25 80.2 1 237 43 784 849 393 88.2 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   88.2   3.93e-18
3053 3053 PRJNA951810_CONTIG_27890|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA951810_CONTIG_27890|Rousettus_bat_picornavirus PRJNA951810_CONTIG_27890 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 PRJNA951810 27890 381 2.922078 11.13311718 Rousettus bat picornavirus 3141905 Viruses Viruses 53.1 4.27e-05 Rousettus bat picornavirus Non-phage NR PRJNA951810_P_NODE_27890_length_381_cov_2.922078_g27548_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g27548 i0 25.4 4.653543307 130 92 99.2 3 1 378 830 958 1773 53.1 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   53.1   4.27e-05
3201 3201 PRJNA1111146_CONTIG_438421|Rousettus_bat_picornavirus|CLUSTER1_Zebrafish_picornavirus_2|1382|320 Danio blood picornavirus/Zebrafish picornavirus 2 Novel PRJNA1111146_CONTIG_438421|Rousettus_bat_picornavirus PRJNA1111146_CONTIG_438421 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 PRJNA1111146 438421 177 0.903226 1.59871002 Rousettus bat picornavirus 3141905 Viruses Viruses 73.9 1.58e-13 Rousettus bat picornavirus Non-phage NR PRJNA1111146_P_NODE_438421_length_177_cov_0.903226_g437283_i0   XBH23991.1 MAG: polyprotein, partial [Rousettus bat picornavirus] XBH23991.1 3141905 g437283 i0 62.7 0.86440678 51 19 86.4 0 1 153 799 849 153 73.9 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Rousettus bat picornavirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Danio blood picornavirus/Zebrafish picornavirus 2   Rousettus bat picornavirus     Viruses   Viruses   73.9   1.58e-13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;