RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

viruses_fish_associated_curated

10 rows where Category = "Endogenous or not fish-associated" and bioproject = "PRJNA1249535"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_family_NTorNR 1

clusterLCA_curated 1

bioproject 1

  • PRJNA1249535 · 10 ✖

Category 1

  • Endogenous or not fish-associated · 10 ✖

tax_genus_NTorNR 0

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
10032 10032 PRJNA1249535_CONTIG_11960|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_11960|Adintovirus_anguilla1 PRJNA1249535_CONTIG_11960 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 11960 782 16.507757 129.0906597 Adintovirus anguilla1 3115889 Viruses Viruses 72.8 1.27e-11 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g9425 i0 28.6 0.510230179 133 92 49.9 2 15 404 40 172 399 72.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   72.8   1.27e-11
10038 10038 PRJNA1249535_CONTIG_19610|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_19610|Adintovirus_anguilla1 PRJNA1249535_CONTIG_19610 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 19610 662 98.758913 653.7840041 Adintovirus anguilla1 3115889 Viruses Viruses 73.2 4.4e-12 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_19610_length_662_cov_98.758913_g16574_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g16574 i0 28.6 0.602719033 133 92 58.9 2 648 259 40 172 399 73.2 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   73.2   4.4e-12
10039 10039 PRJNA1249535_CONTIG_19614|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_19614|Adintovirus_anguilla1 PRJNA1249535_CONTIG_19614 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 19614 662 75.651952 500.8159222 Adintovirus anguilla1 3115889 Viruses Viruses 70.1 6.2e-11 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_19614_length_662_cov_75.651952_g16578_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g16578 i0 27.8 0.987915408 133 93 58.9 2 648 259 40 172 654 70.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   70.1   6.2e-11
10042 10042 PRJNA1249535_CONTIG_20343|Strongylocentrotus_sea_urchin_adintovirus|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_20343|Strongylocentrotus_sea_urchin_adintovirus PRJNA1249535_CONTIG_20343 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 20343 655 3.524055 23.08256025 Strongylocentrotus sea urchin adintovirus 2609855 Viruses Viruses 72.8 4.81e-12 Strongylocentrotus sea urchin adintovirus Non-phage NR PRJNA1249535_S_NODE_20343_length_655_cov_3.524055_g17270_i0   DAC81423.1 TPA_asm: adenain [Strongylocentrotus sea urchin adintovirus] DAC81423.1 2609855 g17270 i0 28.6 1.40610687 154 110 70.5 0 475 14 1 154 921 72.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Strongylocentrotus sea urchin adintovirus Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Strongylocentrotus sea urchin adintovirus     Viruses   Viruses   72.8   4.81e-12
10047 10047 PRJNA1249535_CONTIG_33391|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_33391|Adintovirus_anguilla1 PRJNA1249535_CONTIG_33391 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 33391 553 51.891667 286.9609185 Adintovirus anguilla1 3115889 Viruses Viruses 55.8 5.59e-06 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_33391_length_553_cov_51.891667_g30120_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g30120 i0 25.0 1.03074141 100 73 53.2 1 5 298 73 172 570 55.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   55.8   5.59e-06
10054 10054 PRJNA1249535_CONTIG_108182|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_108182|Adintovirus_anguilla1 PRJNA1249535_CONTIG_108182 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 108182 366 72.952218 267.0051179 Adintovirus anguilla1 3115889 Viruses Viruses 71.6 1.22e-12 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_108182_length_366_cov_72.952218_g104799_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g104799 i0 31.3 1.639344262 115 76 91.8 2 15 350 40 154 600 71.6 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   71.6   1.22e-12
10058 10058 PRJNA1249535_CONTIG_175500|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_175500|Adintovirus_anguilla1 PRJNA1249535_CONTIG_175500 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 175500 320 1.578947 5.0526304 Adintovirus anguilla1 3115889 Viruses Viruses 47.4 0.00113 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_175500_length_320_cov_1.578947_g172117_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g172117 i0 23.9 2.296875 88 60 82.5 1 289 26 86 166 735 47.4 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   47.4   0.00113
10060 10060 PRJNA1249535_CONTIG_251628|Adintovirus_bos4377|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_251628|Adintovirus_bos4377 PRJNA1249535_CONTIG_251628 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 251628 279 2.519417 7.02917343 Adintovirus bos4377 3115894 Viruses Viruses 43.9 0.0132 Adintovirus bos4377 Non-phage NR PRJNA1249535_S_NODE_251628_length_279_cov_2.519417_g248245_i0   DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] DBA50495.1 3115894 g248245 i0 35.8 0.569892473 53 34 57.0 0 14 172 84 136 159 43.9 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus bos4377     Viruses   Viruses   43.9   0.0132
10061 10061 PRJNA1249535_CONTIG_256425|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_256425|Adintovirus_anguilla1 PRJNA1249535_CONTIG_256425 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 256425 276 4.374384 12.07329984 Adintovirus anguilla1 3115889 Viruses Viruses 50.8 3.58e-05 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_256425_length_276_cov_4.374384_g253042_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g253042 i0 25.3 0.945652174 87 63 92.4 1 269 15 68 154 261 50.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   50.8   3.58e-05
10062 10062 PRJNA1249535_CONTIG_280610|Adintovirus_anguilla1|CLUSTER2_Adintovirus_anguilla1|12|3 Adintovirus anguilla10665 Endogenous or not fish-associated PRJNA1249535_CONTIG_280610|Adintovirus_anguilla1 PRJNA1249535_CONTIG_280610 Adintovirus anguilla1 34 19 10 CLUSTER2_Adintovirus_anguilla1|12|3 PRJNA1249535_S_NODE_11960_length_782_cov_16.507757_g9425_i0|Adintovirus_anguilla1|NR|1.27e-11|NA 12 3 PRJNA1249535 280610 263 3.694737 9.71715831 Adintovirus anguilla1 3115889 Viruses Viruses 52.8 5.9e-06 Adintovirus anguilla1 Non-phage NR PRJNA1249535_S_NODE_280610_length_263_cov_3.694737_g277227_i0   DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] DBA49783.1 3115889 g277227 i0 31.1 1.02661597 90 59 99.2 2 261 1 54 143 270 52.8 1.0 Viruses Varidnaviria Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665 Viruses;Varidnaviria;Bamfordvirae;Preplasmiviricota;Polintoviricetes;Orthopolintovirales;Adintoviridae;Adintovirus anguilla10665   Adintovirus anguilla1     Viruses   Viruses   52.8   5.9e-06

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