viruses_fish_associated_curated
9 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA168635"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9395 | 9395 | PRJNA168635_CONTIG_25809|Pimephales_minnow_adintovirus|CLUSTER1_Pimephales_minnow_adintovirus|59|59 | Pimephales minnow adintovirus | Endogenous or not fish-associated | PRJNA168635_CONTIG_25809|Pimephales_minnow_adintovirus | PRJNA168635_CONTIG_25809 | Pimephales minnow adintovirus | 168 | 104 | 20 | CLUSTER1_Pimephales_minnow_adintovirus|59|59 | PRJNA551453_P_NODE_4881_length_284_cov_1.883117_g4799_i0|Pimephales_minnow_adintovirus|NR|1.25e-07|NA | 52 | 52 | PRJNA168635 | 25809 | 168 | 2.87395 | 4.828236 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 60.1 | 5.64e-09 | Pimephales minnow adintovirus | Non-phage | NR | PRJNA168635_P_NODE_25809_length_168_cov_2.873950_g25393_i0 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | DAC81394.1 | 2609864 | g25393 | i0 | 68.4 | 0.678571429 | 38 | 12 | 67.9 | 0 | 114 | 1 | 7 | 44 | 114 | 60.1 | 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 | 60.1 | 5.64e-09 | ||||||||
| 9791 | 9791 | PRJNA168635_CONTIG_19976|Shotokuvirae|CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 | Fish-associated parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA168635_CONTIG_19976|Shotokuvirae | PRJNA168635_CONTIG_19976 | Fish-associated parvo-like hybrid virus | 35 | 19 | 4 | CLUSTER1_Fish-associated_parvo-like_hybrid_virus|21|14 | MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence | 21 | 14 | PRJNA168635 | 19976 | 182 | 2.87218 | 5.2273676 | Shotokuvirae | 2732092 | Viruses | Viruses | 337.0 | 3.82e-88 | Shotokuvirae | Non-phage | NTclustered | PRJNA168635_P_NODE_19976_length_182_cov_2.872180_g19560_i0 | Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds | gi|530787446|ref|NC_022089.1| | 1341019 | g19560 | i0 | 100.0 | 15.91758242 | 182 | 0 | 100.0 | 0 | 1 | 182 | 230 | 411 | 2897 | 337.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Nicoomyvirus moldensis | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus | Shotokuvirae | Shotokuvirae | gi|530787446|ref|NC_022089.1| | Viruses | Viruses | Viruses | Viruses | 337.0 | 123.0 | 3.82e-88 | 1.5399999999999999e-34 | ||||||
| 10014 | 10014 | PRJNA168635_CONTIG_868|Qianjiang_marna-like_virus_71|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_868|Qianjiang_marna-like_virus_71 | PRJNA168635_CONTIG_868 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 868 | 816 | 37.794003 | 308.3990645 | Qianjiang marna-like virus 71 | 3347720 | Viruses | Viruses | 211.0 | 1.13e-58 | Qianjiang marna-like virus 71 | Non-phage | NR | PRJNA168635_P_NODE_868_length_816_cov_37.794003_g634_i0 | XHA88176.1 MAG: putative viral coat protein [Qianjiang marna-like virus 71] | XHA88176.1 | 3347720 | g634 | i0 | 42.9 | 1.011029412 | 275 | 142 | 97.1 | 5 | 794 | 3 | 147 | 417 | 825 | 211.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 71 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | Qianjiang marna-like virus 71 | Viruses | Viruses | 211.0 | 1.13e-58 | ||||||||
| 10015 | 10015 | PRJNA168635_CONTIG_1125|Fish-associated_picorna-like_virus_3|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_1125|Fish-associated_picorna-like_virus_3 | PRJNA168635_CONTIG_1125 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 1125 | 738 | 49.291727 | 363.7729453 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 89.0 | 5.04e-16 | Fish-associated picorna-like virus 3 | Non-phage | NR | PRJNA168635_P_NODE_1125_length_738_cov_49.291727_g840_i0 | WAQ80627.1 MAG: hypothetical protein [Fish-associated picorna-like virus 3] | WAQ80627.1 | 3003959 | g840 | i0 | 25.6 | 2.495934959 | 258 | 168 | 95.5 | 5 | 16 | 720 | 1868 | 2124 | 1842 | 89.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | Fish-associated picorna-like virus 3 | Viruses | Viruses | 89.0 | 5.04e-16 | |||||||||
| 10016 | 10016 | PRJNA168635_CONTIG_1126|Fish-associated_picorna-like_virus_3|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_1126|Fish-associated_picorna-like_virus_3 | PRJNA168635_CONTIG_1126 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 1126 | 738 | 43.969521 | 324.495065 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 89.7 | 2.75e-16 | Fish-associated picorna-like virus 3 | Non-phage | NR | PRJNA168635_P_NODE_1126_length_738_cov_43.969521_g841_i0 | WAQ80627.1 MAG: hypothetical protein [Fish-associated picorna-like virus 3] | WAQ80627.1 | 3003959 | g841 | i0 | 25.6 | 1.048780488 | 258 | 168 | 95.5 | 5 | 16 | 720 | 1868 | 2124 | 774 | 89.7 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | Fish-associated picorna-like virus 3 | Viruses | Viruses | 89.7 | 2.75e-16 | |||||||||
| 10026 | 10026 | PRJNA168635_CONTIG_5432|Qianjiang_marna-like_virus_71|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_5432|Qianjiang_marna-like_virus_71 | PRJNA168635_CONTIG_5432 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 5432 | 362 | 10.744409 | 38.89476058 | Qianjiang marna-like virus 71 | 3347720 | Viruses | Viruses | 83.6 | 7.28e-16 | Qianjiang marna-like virus 71 | Non-phage | NR | PRJNA168635_P_NODE_5432_length_362_cov_10.744409_g5027_i0 | XHA88176.1 MAG: putative viral coat protein [Qianjiang marna-like virus 71] | XHA88176.1 | 3347720 | g5027 | i0 | 43.0 | 0.886740331 | 107 | 60 | 87.8 | 1 | 334 | 17 | 188 | 294 | 321 | 83.6 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 71 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | Qianjiang marna-like virus 71 | Viruses | Viruses | 83.6 | 7.28e-16 | ||||||||
| 10029 | 10029 | PRJNA168635_CONTIG_9512|clirnapec_virus_2|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_9512|clirnapec_virus_2 | PRJNA168635_CONTIG_9512 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 9512 | 270 | 4.900452 | 13.2312204 | clirnapec virus 2 | 3368191 | Viruses | Viruses | 72.4 | 1.85e-12 | clirnapec virus 2 | Non-phage | NR | PRJNA168635_P_NODE_9512_length_270_cov_4.900452_g9097_i0 | XII42891.1 MAG: capsid protein, partial [clirnapec virus 201] | XII42891.1 | 3368194 | g9097 | i0 | 49.4 | 0.9 | 81 | 38 | 86.7 | 1 | 268 | 35 | 510 | 590 | 243 | 72.4 | 1.0 | Viruses | clirnapec virus 201 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | clirnapec virus 2 | Viruses | Viruses | 72.4 | 1.85e-12 | ||||||||||||||
| 10041 | 10041 | PRJNA168635_CONTIG_20215|Qianjiang_marna-like_virus_71|CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | Fish-associated picorna-like virus 3 | Endogenous or not fish-associated | PRJNA168635_CONTIG_20215|Qianjiang_marna-like_virus_71 | PRJNA168635_CONTIG_20215 | Fish-associated picorna-like virus 3 | 12 | 3 | 1 | CLUSTER1_Fish-associated_picorna-like_virus_3|12|3 | PRJEB64798_P_NODE_1247_length_1574_cov_19.076721_g909_i0|Fish-associated_picorna-like_virus_3|NR|4.87e-42|NA | 12 | 3 | PRJNA168635 | 20215 | 181 | 5.484848 | 9.92757488 | Qianjiang marna-like virus 71 | 3347720 | Viruses | Viruses | 69.3 | 6.93e-12 | Qianjiang marna-like virus 71 | Non-phage | NR | PRJNA168635_P_NODE_20215_length_181_cov_5.484848_g19799_i0 | XHA88176.1 MAG: putative viral coat protein [Qianjiang marna-like virus 71] | XHA88176.1 | 3347720 | g19799 | i0 | 56.9 | 0.961325967 | 58 | 25 | 96.1 | 0 | 180 | 7 | 278 | 335 | 174 | 69.3 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 71 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Pisoniviricetes;Picornavirales;Fish-associated picorna-like virus 3 | Qianjiang marna-like virus 71 | Viruses | Viruses | 69.3 | 6.93e-12 | ||||||||
| 10427 | 10427 | PRJNA168635_CONTIG_21627|Luscinia_sibilans_parvo-like_hybrid_virus|CLUSTER2_Luscinia_sibilans_parvo-like_hybrid_virus|1|1 | Luscinia sibilans parvo-like hybrid virus | Endogenous or not fish-associated | PRJNA168635_CONTIG_21627|Luscinia_sibilans_parvo-like_hybrid_virus | PRJNA168635_CONTIG_21627 | Luscinia sibilans parvo-like hybrid virus | 8 | 5 | 4 | CLUSTER2_Luscinia_sibilans_parvo-like_hybrid_virus|1|1 | PRJNA168635_P_NODE_21627_length_177_cov_2.398438_g21211_i0|Luscinia_sibilans_parvo-like_hybrid_virus|NR|4.88e-21|NA | 1 | 1 | PRJNA168635 | 21627 | 177 | 2.398438 | 4.24523526 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 95.1 | 4.8800000000000004e-21 | Luscinia sibilans parvo-like hybrid virus | Non-phage | NR | PRJNA168635_P_NODE_21627_length_177_cov_2.398438_g21211_i0 | QTE03983.1 MAG: capsid protein, partial [Luscinia sibilans parvo-like hybrid virus] | QTE03983.1 | 2794515 | g21211 | i0 | 75.9 | 0.983050847 | 58 | 14 | 98.3 | 0 | 177 | 4 | 248 | 305 | 174 | 95.1 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Luscinia sibilans parvo-like hybrid virus | Luscinia sibilans parvo-like hybrid virus | Viruses | Viruses | 95.1 | 4.8800000000000004e-21 |
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);;