RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

3 rows where bioproject = "PRJNA490132", clusterLCA_curated = "African cichlid piscichuvirus" and tax_family_NTorNR = "Chuviridae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_genus_NTorNR 1

tax_family_NTorNR 1

  • Chuviridae · 3 ✖

clusterLCA_curated 1

  • African cichlid piscichuvirus · 3 ✖

bioproject 1

  • PRJNA490132 · 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
8121 8121 PRJNA490132_CONTIG_30200|African_cichlid_piscichuvirus|CLUSTER1_African_cichlid_piscichuvirus|150|125 African cichlid piscichuvirus Endogenous or not fish-associated PRJNA490132_CONTIG_30200|African_cichlid_piscichuvirus PRJNA490132_CONTIG_30200 African cichlid piscichuvirus 151 125 2 CLUSTER1_African_cichlid_piscichuvirus|150|125 PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0|African_cichlid_piscichuvirus|NR|2.83e-43|NA 150 125 PRJNA490132 30200 214 3.106145 6.6471503 African cichlid piscichuvirus 3065075 Viruses Viruses 71.6 1.72e-12 African cichlid piscichuvirus Non-phage NR PRJNA490132_P_NODE_30200_length_214_cov_3.106145_g29826_i0   WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] WLN26256.1 3065075 g29826 i0 45.1 0.995327103 71 39 99.5 0 2 214 147 217 213 71.6 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus   African cichlid piscichuvirus     Viruses   Viruses   71.6   1.72e-12
8142 8142 PRJNA490132_CONTIG_52449|African_cichlid_piscichuvirus|CLUSTER1_African_cichlid_piscichuvirus|150|125 African cichlid piscichuvirus Endogenous or not fish-associated PRJNA490132_CONTIG_52449|African_cichlid_piscichuvirus PRJNA490132_CONTIG_52449 African cichlid piscichuvirus 151 125 2 CLUSTER1_African_cichlid_piscichuvirus|150|125 PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0|African_cichlid_piscichuvirus|NR|2.83e-43|NA 150 125 PRJNA490132 52449 166 3.717557 6.17114462 African cichlid piscichuvirus 3065075 Viruses Viruses 41.2 0.046 African cichlid piscichuvirus Non-phage NR PRJNA490132_P_NODE_52449_length_166_cov_3.717557_g52075_i0   WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] WLN26256.1 3065075 g52075 i0 40.0 0.903614458 50 30 90.4 0 12 161 98 147 150 41.2 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus   African cichlid piscichuvirus     Viruses   Viruses   41.2   0.046
8143 8143 PRJNA490132_CONTIG_59511|Hardyhead_chuvirus|CLUSTER1_African_cichlid_piscichuvirus|150|125 African cichlid piscichuvirus Endogenous or not fish-associated PRJNA490132_CONTIG_59511|Hardyhead_chuvirus PRJNA490132_CONTIG_59511 African cichlid piscichuvirus 151 125 2 CLUSTER1_African_cichlid_piscichuvirus|150|125 PRJEB66218_P_NODE_16107_length_1017_cov_4.283473_g14250_i0|African_cichlid_piscichuvirus|NR|2.83e-43|NA 150 125 PRJNA490132 59511 158 0.96748 1.5286184 Hardyhead chuvirus 2830721 Viruses Viruses 42.7 0.0119 Hardyhead chuvirus Non-phage NR PRJNA490132_P_NODE_59511_length_158_cov_0.967480_g59137_i0   YP_010840939.1 L protein [Hardyhead chuvirus] YP_010840939.1 2830721 g59137 i0 45.3 1.006329114 53 28 98.7 1 3 158 14 66 159 42.7 1.0 Viruses Riboviria Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Piscichuvirus craterocephali Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;African cichlid piscichuvirus   Hardyhead chuvirus     Viruses   Viruses   42.7   0.0119

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