viruses_fish_associated_curated
10 rows where Category = "Endogenous or not fish-associated", tax_genus_NTorNR = "Aveparvovirus" and tax_species_NTorNR = "Psittacidae aveparvovirus"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9905 | 9905 | PRJNA283169_CONTIG_1049|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA283169_CONTIG_1049|Psittacidae_aveparvovirus | PRJNA283169_CONTIG_1049 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA283169 | 1049 | 260 | 0.132701 | 0.3450226 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 152.0 | 1.06e-41 | Psittacidae aveparvovirus | Non-phage | NR | PRJNA283169_S_NODE_1049_length_260_cov_0.132701_g1035_i0 | QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] | QTE03752.1 | 2794556 | g1035 | i0 | 82.4 | 0.980769231 | 85 | 15 | 98.1 | 0 | 5 | 259 | 334 | 418 | 255 | 152.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Viruses | Viruses | 152.0 | 1.06e-41 | |||||||
| 9912 | 9912 | PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA784979_CONTIG_3690|Psittacidae_aveparvovirus | PRJNA784979_CONTIG_3690 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA784979 | 3690 | 242 | 1.948187 | 4.71461254 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 327.0 | 3.23e-85 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA784979_S_NODE_3690_length_242_cov_1.948187_g3648_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g3648 | i0 | 91.561 | 1.946280992 | 237 | 20 | 98.0 | 0 | 6 | 242 | 1647 | 1883 | 471 | 327.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | Viruses | Viruses | 327.0 | 159.0 | 3.23e-85 | 3.87e-45 | |
| 9913 | 9913 | PRJNA407368_CONTIG_4786|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA407368_CONTIG_4786|Psittacidae_aveparvovirus | PRJNA407368_CONTIG_4786 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA407368 | 4786 | 257 | 3.061404 | 7.86780828 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 263.0 | 9.92e-66 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA407368_S_NODE_4786_length_257_cov_3.061404_g4684_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g4684 | i0 | 94.675 | 0.929961089 | 169 | 9 | 92.0 | 0 | 21 | 189 | 681 | 513 | 239 | 263.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | Viruses | Viruses | 263.0 | 104.0 | 9.92e-66 | 9.870000000000001e-26 | |
| 9919 | 9919 | PRJNA407368_CONTIG_7698|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA407368_CONTIG_7698|Psittacidae_aveparvovirus | PRJNA407368_CONTIG_7698 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA407368 | 7698 | 186 | 2.382166 | 4.43082876 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 289.0 | 1.11e-73 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA407368_S_NODE_7698_length_186_cov_2.382166_g7596_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g7596 | i0 | 94.624 | 1.0 | 186 | 10 | 100.0 | 0 | 1 | 186 | 469 | 284 | 186 | 289.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | Viruses | Viruses | 289.0 | 112.0 | 1.11e-73 | 2.62e-29 | |
| 9926 | 9926 | PRJNA309466_CONTIG_15363|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA309466_CONTIG_15363|Psittacidae_aveparvovirus | PRJNA309466_CONTIG_15363 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA309466 | 15363 | 169 | 3.391667 | 5.73191723 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 254.0 | 3.6e-63 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA309466_P_NODE_15363_length_169_cov_3.391667_g15306_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g15306 | i0 | 94.545 | 0.976331361 | 165 | 8 | 98.0 | 1 | 1 | 165 | 817 | 654 | 165 | 254.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | Viruses | Viruses | 254.0 | 84.7 | 3.6e-63 | 1.33e-18 | |
| 9930 | 9930 | PRJNA474426_CONTIG_20814|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA474426_CONTIG_20814|Psittacidae_aveparvovirus | PRJNA474426_CONTIG_20814 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA474426 | 20814 | 218 | 2.763314 | 6.02402452 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 248.0 | 2.29e-61 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA474426_P_NODE_20814_length_218_cov_2.763314_g20609_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g20609 | i0 | 87.215 | 1.004587156 | 219 | 26 | 100.0 | 2 | 1 | 218 | 1536 | 1753 | 219 | 248.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | Viruses | Viruses | 248.0 | 140.0 | 2.29e-61 | 4.96e-38 | |
| 9937 | 9937 | PRJNA558770_CONTIG_41702|Psittacidae_aveparvovirus|CLUSTER1_Psittacidae_aveparvovirus|15|6 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA558770_CONTIG_41702|Psittacidae_aveparvovirus | PRJNA558770_CONTIG_41702 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER1_Psittacidae_aveparvovirus|15|6 | MW046380_1_MAG_Avoomyvirus_meijunae_isolate_fmg67par043_genomic_sequence | 15 | 6 | PRJNA558770 | 41702 | 329 | 8.064626 | 26.53261954 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 440.0 | 5.66e-119 | Psittacidae aveparvovirus | Non-phage | NTclustered | PRJNA558770_P_NODE_41702_length_329_cov_8.064626_g39704_i0 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | gi|2015372674|gb|MW046380.1| | 2794556 | g39704 | i0 | 91.562 | 0.972644377 | 320 | 25 | 97.0 | 2 | 1 | 319 | 347 | 29 | 320 | 440.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | gi|2015372674|gb|MW046380.1| | Viruses | Viruses | 440.0 | 5.66e-119 | ||||||
| 10217 | 10217 | PRJNA630162_CONTIG_16732|Psittacidae_aveparvovirus|CLUSTER2_Psittacidae_aveparvovirus|3|3 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA630162_CONTIG_16732|Psittacidae_aveparvovirus | PRJNA630162_CONTIG_16732 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER2_Psittacidae_aveparvovirus|3|3 | PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0|Psittacidae_aveparvovirus|NR|1.21e-18|NA | 3 | 3 | PRJNA630162 | 16732 | 457 | 2.938725 | 13.42997325 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 92.0 | 1.21e-18 | Psittacidae aveparvovirus | Non-phage | NR | PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0 | QTE03751.1 MAG: replication protein [Psittacidae aveparvovirus] | QTE03751.1 | 2794556 | g15229 | i0 | 39.3 | 0.800875274 | 122 | 58 | 78.1 | 3 | 97 | 453 | 16 | 124 | 366 | 92.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Viruses | Viruses | 92.0 | 1.21e-18 | |||||||
| 10311 | 10311 | PRJNA489308_CONTIG_214|Psittacidae_aveparvovirus|CLUSTER3_Psittacidae_aveparvovirus|1|1 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJNA489308_CONTIG_214|Psittacidae_aveparvovirus | PRJNA489308_CONTIG_214 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER3_Psittacidae_aveparvovirus|1|1 | PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0|Psittacidae_aveparvovirus|NR|1.74e-86|NA | 1 | 1 | PRJNA489308 | 214 | 1473 | 66.962857 | 986.3628836 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 285.0 | 1.74e-86 | Psittacidae aveparvovirus | Non-phage | NR | PRJNA489308_P_NODE_214_length_1473_cov_66.962857_g184_i0 | QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] | QTE03752.1 | 2794556 | g184 | i0 | 45.3 | 1.50509165 | 369 | 187 | 73.5 | 9 | 1110 | 28 | 165 | 526 | 2217 | 285.0 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Flumine parvovirus 18 | Psittacidae aveparvovirus | gi|2235497426|gb|OM954002.1| | Viruses | Viruses | Viruses | Viruses | 121.0 | 285.0 | 4.0900000000000002e-22 | 1.74e-86 | |
| 10489 | 10489 | PRJEB10140_CONTIG_251847|Psittacidae_aveparvovirus|CLUSTER4_Psittacidae_aveparvovirus|1|1 | Psittacidae aveparvovirus | Endogenous or not fish-associated | PRJEB10140_CONTIG_251847|Psittacidae_aveparvovirus | PRJEB10140_CONTIG_251847 | Psittacidae aveparvovirus | 18 | 10 | 4 | CLUSTER4_Psittacidae_aveparvovirus|1|1 | PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0|Psittacidae_aveparvovirus|NR|3.45e-16|NA | 1 | 1 | PRJEB10140 | 251847 | 168 | 0.87395 | 1.468236 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 81.3 | 3.45e-16 | Psittacidae aveparvovirus | Non-phage | NR | PRJEB10140_P_NODE_251847_length_168_cov_0.873950_g234538_i0 | QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] | QTE03752.1 | 2794556 | g234538 | i0 | 61.8 | 0.982142857 | 55 | 21 | 98.2 | 0 | 166 | 2 | 305 | 359 | 165 | 81.3 | 1.0 | Viruses | Monodnaviria | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus | Psittacidae aveparvovirus | Viruses | Viruses | 81.3 | 3.45e-16 |
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);;