viruses_fish_associated_curated
6 rows where tax_family_NTorNR = "Astroviridae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10252 | 10252 | PRJEB64798_CONTIG_6282|Flumine_Astrovirus_3|CLUSTER1_Flumine_Astrovirus_3|2|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJEB64798_CONTIG_6282|Flumine_Astrovirus_3 | PRJEB64798_CONTIG_6282 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER1_Flumine_Astrovirus_3|2|1 | PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0|Flumine_Astrovirus_3|NR|1.32e-19|NA | 2 | 1 | PRJEB64798 | 6282 | 781 | 14.681694 | 114.6640301 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 99.4 | 1.32e-19 | Flumine Astrovirus 3 | Non-phage | NR | PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g5068 | i0 | 37.8 | 0.518565941 | 135 | 73 | 47.6 | 2 | 410 | 781 | 9 | 143 | 405 | 99.4 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 99.4 | 1.32e-19 | ||||||||
| 10265 | 10265 | PRJEB64798_CONTIG_27348|Flumine_Astrovirus_3|CLUSTER1_Flumine_Astrovirus_3|2|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJEB64798_CONTIG_27348|Flumine_Astrovirus_3 | PRJEB64798_CONTIG_27348 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER1_Flumine_Astrovirus_3|2|1 | PRJEB64798_P_NODE_6282_length_781_cov_14.681694_g5068_i0|Flumine_Astrovirus_3|NR|1.32e-19|NA | 2 | 1 | PRJEB64798 | 27348 | 376 | 10.954128 | 41.18752128 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 106.0 | 5.74e-24 | Flumine Astrovirus 3 | Non-phage | NR | PRJEB64798_P_NODE_27348_length_376_cov_10.954128_g25593_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g25593 | i0 | 43.8 | 0.965425532 | 121 | 66 | 95.7 | 2 | 363 | 4 | 119 | 238 | 363 | 106.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 106.0 | 5.74e-24 | ||||||||
| 10371 | 10371 | PRJEB64798_CONTIG_3959|Flumine_Astrovirus_3|CLUSTER2_Flumine_Astrovirus_3|1|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJEB64798_CONTIG_3959|Flumine_Astrovirus_3 | PRJEB64798_CONTIG_3959 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER2_Flumine_Astrovirus_3|1|1 | PRJEB64798_P_NODE_3959_length_956_cov_10.364939_g3087_i0|Flumine_Astrovirus_3|NR|3.68e-89|NA | 1 | 1 | PRJEB64798 | 3959 | 956 | 10.364939 | 99.08881684 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 287.0 | 3.68e-89 | Flumine Astrovirus 3 | Non-phage | NR | PRJEB64798_P_NODE_3959_length_956_cov_10.364939_g3087_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g3087 | i0 | 48.6 | 0.988493724 | 315 | 157 | 98.5 | 3 | 10 | 951 | 225 | 535 | 945 | 287.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 287.0 | 3.68e-89 | ||||||||
| 10421 | 10421 | PRJNA630162_CONTIG_20357|Flumine_Astrovirus_3|CLUSTER3_Flumine_Astrovirus_3|1|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJNA630162_CONTIG_20357|Flumine_Astrovirus_3 | PRJNA630162_CONTIG_20357 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER3_Flumine_Astrovirus_3|1|1 | PRJNA630162_P_NODE_20357_length_410_cov_2.520776_g18842_i0|Flumine_Astrovirus_3|NR|3.47e-09|NA | 1 | 1 | PRJNA630162 | 20357 | 410 | 2.520776 | 10.3351816 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 65.1 | 3.47e-09 | Flumine Astrovirus 3 | Non-phage | NR | PRJNA630162_P_NODE_20357_length_410_cov_2.520776_g18842_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g18842 | i0 | 34.1 | 1.324390244 | 91 | 60 | 66.6 | 0 | 278 | 6 | 60 | 150 | 543 | 65.1 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 65.1 | 3.47e-09 | ||||||||
| 10460 | 10460 | PRJNA630162_CONTIG_44607|Flumine_Astrovirus_3|CLUSTER4_Flumine_Astrovirus_3|1|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJNA630162_CONTIG_44607|Flumine_Astrovirus_3 | PRJNA630162_CONTIG_44607 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER4_Flumine_Astrovirus_3|1|1 | PRJNA630162_P_NODE_44607_length_265_cov_2.009259_g43084_i0|Flumine_Astrovirus_3|NR|1.85e-15|NA | 1 | 1 | PRJNA630162 | 44607 | 265 | 2.009259 | 5.32453635 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 80.9 | 1.85e-15 | Flumine Astrovirus 3 | Non-phage | NR | PRJNA630162_P_NODE_44607_length_265_cov_2.009259_g43084_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g43084 | i0 | 44.2 | 1.743396226 | 77 | 43 | 87.2 | 0 | 252 | 22 | 231 | 307 | 462 | 80.9 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 80.9 | 1.85e-15 | ||||||||
| 10477 | 10477 | PRJEB64798_CONTIG_74732|Flumine_Astrovirus_3|CLUSTER5_Flumine_Astrovirus_3|1|1 | Flumine Astrovirus 3 | Endogenous or not fish-associated | PRJEB64798_CONTIG_74732|Flumine_Astrovirus_3 | PRJEB64798_CONTIG_74732 | Flumine Astrovirus 3 | 6 | 2 | 5 | CLUSTER5_Flumine_Astrovirus_3|1|1 | PRJEB64798_P_NODE_74732_length_223_cov_4.143678_g72967_i0|Flumine_Astrovirus_3|NR|4.95e-28|NA | 1 | 1 | PRJEB64798 | 74732 | 223 | 4.143678 | 9.24040194 | Flumine Astrovirus 3 | 2940955 | Viruses | Viruses | 115.0 | 4.95e-28 | Flumine Astrovirus 3 | Non-phage | NR | PRJEB64798_P_NODE_74732_length_223_cov_4.143678_g72967_i0 | UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3] | UQB76172.1 | 2940955 | g72967 | i0 | 69.9 | 0.98206278 | 73 | 22 | 98.2 | 0 | 3 | 221 | 471 | 543 | 219 | 115.0 | 1.0 | Viruses | Riboviria | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Flumine Astrovirus 3 | Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3 | Flumine Astrovirus 3 | Viruses | Viruses | 115.0 | 4.95e-28 |
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);;