RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

6 rows where bioproject = "PRJNA951388"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 4

tax_family_NTorNR 1

clusterLCA_curated 1

bioproject 1

  • PRJNA951388 · 6 ✖

Category 1

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
8354 8354 PRJNA951388_CONTIG_383|Mink_kobuvirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_383|Mink_kobuvirus PRJNA951388_CONTIG_383 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 PRJNA951388 383 894 3.880633 34.69285902 Mink kobuvirus 3242813 Viruses Viruses 75.5 5.22e-11 Mink kobuvirus Non-phage NR PRJNA951388_S_NODE_383_length_894_cov_3.880633_g292_i0   XEQ84337.1 polyprotein, partial [Mink kobuvirus] XEQ84337.1 3242813 g292 i0 30.4 1.691275168 168 104 52.0 3 92 556 288 455 1512 75.5 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Mink kobuvirus Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Mink kobuvirus     Viruses   Viruses   75.5   5.22e-11
8355 8355 PRJNA951388_CONTIG_684|Kobuvirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_684|Kobuvirus PRJNA951388_CONTIG_684 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 PRJNA951388 684 743 4.432836 32.93597148 Kobuvirus 194960 Viruses Viruses 271.0 4.46e-86 Kobuvirus Non-phage NR PRJNA951388_S_NODE_684_length_743_cov_4.432836_g574_i0   ADI48258.1 3D, partial [Bat kobuvirus TM003k] ADI48258.1 795373 g574 i0 55.2 2.951547779 239 101 96.5 4 719 3 1 233 2193 272.0 0.996323529 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Bat kobuvirus TM003k Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Kobuvirus     Viruses   Viruses   271.0   4.46e-86
8356 8356 PRJNA951388_CONTIG_808|Kobuvirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_808|Kobuvirus PRJNA951388_CONTIG_808 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 PRJNA951388 808 705 4.901899 34.55838795 Kobuvirus 194960 Viruses Viruses 59.3 4.47e-06 Kobuvirus Non-phage NR PRJNA951388_S_NODE_808_length_705_cov_4.901899_g695_i0   XOL43542.1 polyprotein [Kobuvirus dekago] XOL43542.1 1897731 g695 i0 29.0 3.059574468 183 98 65.1 7 574 116 950 1130 2157 59.3 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Kobuvirus dekago Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Kobuvirus     Viruses   Viruses   59.3   4.47e-06
8358 8358 PRJNA951388_CONTIG_931|Salivirus_A|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_931|Salivirus_A PRJNA951388_CONTIG_931 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 PRJNA951388 931 668 134.105882 895.8272918 Salivirus A 1330524 Viruses Viruses 77.0 3.34e-12 Salivirus A Non-phage NR PRJNA951388_S_NODE_931_length_668_cov_134.105882_g816_i0   QJX58422.1 polyprotein [Salivirus A] QJX58422.1 1330524 g816 i0 43.8 3.017964072 96 52 42.2 2 4 285 2264 2359 2016 77.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Salivirus Salivirus aklasse Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Salivirus A     Viruses   Viruses   77.0   3.34e-12
8378 8378 PRJNA951388_CONTIG_5393|Tropivirus|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_5393|Tropivirus PRJNA951388_CONTIG_5393 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 PRJNA951388 5393 363 1.593103 5.78296389 Tropivirus 2733283 Viruses Viruses 114.0 9.06e-27 Tropivirus Non-phage NR PRJNA951388_S_NODE_5393_length_363_cov_1.593103_g5266_i0   YP_010796386.1 polyprotein [tropivirus A1] YP_010796386.1 2116178 g5266 i0 51.9 4.438016529 108 52 89.3 0 326 3 1354 1461 1611 115.0 0.991304348 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Tropivirus Tropivirus awaski Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   Tropivirus     Viruses   Viruses   114.0   9.06e-27
8382 8382 PRJNA951388_CONTIG_7096|ludopivirus_A1|CLUSTER1_Coleura_bat_picornavirus|100|37 Zebrafish jaw picornavirus Novel PRJNA951388_CONTIG_7096|ludopivirus_A1 PRJNA951388_CONTIG_7096 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 PRJNA951388 7096 319 3.621951 11.55402369 ludopivirus A1 2079465 Viruses Viruses 137.0 7.480000000000001e-35 ludopivirus A1 Non-phage NR PRJNA951388_S_NODE_7096_length_319_cov_3.621951_g6969_i0   QUS52515.1 polyprotein [ludopivirus A1] QUS52515.1 2079465 g6969 i0 61.2 1.937304075 103 40 96.9 0 6 314 2223 2325 618 137.0 1.0 Viruses Riboviria Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Ludopivirus Ludopivirus agrewhifrogo Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Picornaviridae;Kobuvirus;Zebrafish jaw picornavirus   ludopivirus A1     Viruses   Viruses   137.0   7.480000000000001e-35

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