RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

3 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA1150539"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 2

tax_genus_NTorNR 1

bioproject 1

  • PRJNA1150539 · 3 ✖

Category 1

  • Endogenous or not fish-associated · 3 ✖
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
9250 9250 PRJNA1150539_CONTIG_92434|Hardyhead_chuvirus|CLUSTER1_Salarius_guttatus_piscichuvirus|63|56 Salarius guttatus piscichuvirus Endogenous or not fish-associated PRJNA1150539_CONTIG_92434|Hardyhead_chuvirus PRJNA1150539_CONTIG_92434 Salarius guttatus piscichuvirus 67 58 5 CLUSTER1_Salarius_guttatus_piscichuvirus|63|56 PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0|Salarius_guttatus_piscichuvirus|NR|7.17e-28|NA 63 56 PRJNA1150539 92434 251 0.865169 2.17157419 Hardyhead chuvirus 2830721 Viruses Viruses 52.8 1.25e-05 Hardyhead chuvirus Non-phage NR PRJNA1150539_S_NODE_92434_length_251_cov_0.865169_g91838_i0   YP_010840939.1 L protein [Hardyhead chuvirus] YP_010840939.1 2830721 g91838 i0 40.7 1.027888446 86 47 98.0 2 246 1 24 109 258 52.8 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Piscichuvirus craterocephali Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus   Hardyhead chuvirus     Viruses   Viruses   52.8   1.25e-05
9986 9986 PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1|CLUSTER1_Adintovirus_anguilla1|13|12 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1150539_CONTIG_16621|Adintovirus_anguilla1 PRJNA1150539_CONTIG_16621 Adintovirus anguilla1 34 19 10 CLUSTER1_Adintovirus_anguilla1|13|12 PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0|Astyanax_tetra_cavefish_adintovirus|NR|1.59e-05|NA 13 12 PRJNA1150539 16621 396 2.439628 9.66092688 Adintovirus anguilla1 3115889 Viruses Viruses 65.1 3.06e-10 Adintovirus anguilla1 Non-phage NR PRJNA1150539_S_NODE_16621_length_396_cov_2.439628_g16026_i0   DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] DBA49781.1 3115889 g16026 i0 62.2 0.340909091 45 17 34.1 0 269 135 7 51 135 65.1 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   65.1   3.06e-10
10480 10480 PRJNA1150539_CONTIG_80848|Pimephales_minnow_adintovirus|CLUSTER19_Pimephales_minnow_adintovirus|1|1 Pimephales minnow adintovirus Endogenous or not fish-associated PRJNA1150539_CONTIG_80848|Pimephales_minnow_adintovirus PRJNA1150539_CONTIG_80848 Pimephales minnow adintovirus 168 104 20 CLUSTER19_Pimephales_minnow_adintovirus|1|1 PRJNA1150539_S_NODE_80848_length_265_cov_1.244792_g80252_i0|Pimephales_minnow_adintovirus|NR|3.42e-08|NA 1 1 PRJNA1150539 80848 265 1.244792 3.2986988 Pimephales minnow adintovirus 2609864 Viruses Viruses 58.5 3.42e-08 Pimephales minnow adintovirus Non-phage NR PRJNA1150539_S_NODE_80848_length_265_cov_1.244792_g80252_i0   DAC81397.1 TPA_asm: adenain [Pimephales minnow adintovirus] DAC81397.1 2609864 g80252 i0 46.3 1.833962264 54 29 61.1 0 58 219 71 124 486 58.5 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Pimephales minnow adintovirus   Pimephales minnow adintovirus     Viruses   Viruses   58.5   3.42e-08

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