RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA293022" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA293022 · 15 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
2923991 2923991 PRJNA293022_P_NODE_48283_length_200_cov_6.629139_g47546_i0 PRJNA293022 48283 200 6.629139 13.258278 brine shrimp iflavirus 3 2900464 Viruses Viruses 361 2.5399999999999998e-95   NTclustered gi|2209094746|gb|OL472445.1| 2900464 g47546 i0 99.495 10.91 198 1 99 0 1 198 202 5 MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds blastn 2182 361 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
4200464 4200464 PRJNA293022_P_NODE_4_length_8990_cov_8.789173_g1_i0 PRJNA293022 4 8990 8.789173 790.1466527 brine shrimp iflavirus 3 2900464 Viruses Viruses 16449 0   NTclustered gi|2209094744|gb|OL472444.1| 2900464 g1 i0 99.7 11.0094549499444 8988 27 99 0 1 8988 9230 243 MAG: Brine shrimp iflavirus 3 isolate RUS/14-15 RNA-dependent RNA polymerase gene, complete cds blastn 98975 16449 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
8026762 8026762 PRJNA293022_P_NODE_74227_length_165_cov_0.896552_g73490_i0 PRJNA293022 74227 165 0.896552 1.4793108 Dill cryptic virus 1 1408895 Viruses Viruses 291 2.69e-74   NTclustered gi|551701372|gb|KF484726.1| 1408895 g73490 i0 98.773 4.92121212121212 163 2 99 0 1 163 792 954 Dill cryptic virus 1 isolate IPP_hortorum segment 1, complete sequence blastn 812 291 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Dill cryptic virus 1
10577155 10577155 PRJNA293022_P_NODE_26149_length_276_cov_1.669604_g25412_i0 PRJNA293022 26149 276 1.669604 4.60810704 Chronilont virus 3129882 Viruses Viruses 182 3.1e-41   NTclustered gi|2717318562|gb|PP172279.1| 3129882 g25412 i0 89.116 241.260869565217 147 15 53 1 2 147 3672 3526 MAG: Chronilont virus isolate CN1B_k141_68688 genomic sequence blastn 66588 182 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Chronilont virus
11851960 11851960 PRJNA293022_P_NODE_43710_length_211_cov_1.666667_g42973_i0 PRJNA293022 43710 211 1.666667 3.51666737 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 94.4 1.69e-20   NR XHA87929.1 3347367 g42973 i0 64.7 0.966824644549763 68 24 96.7 0 205 2 1322 1389 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 204 94.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
20774679 20774679 PRJNA293022_P_NODE_25297_length_281_cov_0.887931_g24560_i0 PRJNA293022 25297 281 0.887931 2.49508611 brine shrimp partiti-like virus 4 2900391 Viruses Viruses 510 3.56e-140   NTclustered gi|2209094901|gb|OL472522.1| 2900391 g24560 i0 99.642 12.9074733096085 279 1 99 0 1 279 373 95 MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds blastn 3627 510 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partiti-like virus 4
26599044 26599044 PRJNA293022_P_NODE_25641_length_279_cov_1.343478_g24904_i0 PRJNA293022 25641 279 1.343478 3.74830362 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 91.3 5.12e-19   NR XHA87929.1 3347367 g24904 i0 47.8 0.967741935483871 90 46 96.8 1 274 5 1398 1486 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 270 91.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
27579653 27579653 PRJNA293022_P_NODE_80744_length_159_cov_2.754545_g80007_i0 PRJNA293022 80744 159 2.754545 4.37972655 Bactrocera dorsalis partiti-like virus 1 2933674 Viruses Viruses 59.3 1.65e-8   NR UPT53663.1 2933674 g80007 i0 52.2 1.83018867924528 46 22 86.8 0 148 11 153 198 UPT53663.1 MAG: hypothetical protein 1 [Bactrocera dorsalis partiti-like virus 1] diamond 291 59.3 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Bactrocera dorsalis partiti-like virus 1
28274224 28274224 PRJNA293022_P_NODE_42086_length_215_cov_1.843373_g41349_i0 PRJNA293022 42086 215 1.843373 3.96325195 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 63.2 1.66e-9   NR XHA87929.1 3347367 g41349 i0 53 0.92093023255814 66 30 90.7 1 213 19 963 1028 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 198 63.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
29600196 29600196 PRJNA293022_P_NODE_55870_length_186_cov_2.175182_g55133_i0 PRJNA293022 55870 186 2.175182 4.04583852 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 45.4 0.00196   NR XCM68027.1 3003959 g55133 i0 41.4 0.935483870967742 58 27 82.3 1 172 20 525 582 XCM68027.1 MAG: polyprotein [Picornavirales sp.] diamond 174 45.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31401620 31401620 PRJNA293022_P_NODE_62696_length_175_cov_1.984127_g61959_i0 PRJNA293022 62696 175 1.984127 3.47222225 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 67 3.99e-11   NR XHA87929.1 3347367 g61959 i0 61.5 0.891428571428571 52 20 89.1 0 173 18 521 572 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 156 67 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
31907482 31907482 PRJNA293022_P_NODE_67717_length_169_cov_0.866667_g66980_i0 PRJNA293022 67717 169 0.866667 1.46466723 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 45.8 0.00115   NR XHA87929.1 3347367 g66980 i0 43.6 0.976331360946746 55 31 97.6 0 166 2 1936 1990 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 165 45.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
31938998 31938998 PRJNA293022_P_NODE_26197_length_276_cov_0.832599_g25460_i0 PRJNA293022 26197 276 0.832599 2.29797324 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 87 1.51e-17   NR XHA87929.1 3347367 g25460 i0 47.8 0.978260869565217 90 43 97.8 1 3 272 1755 1840 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 270 87 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
32224009 32224009 PRJNA293022_P_NODE_40298_length_220_cov_1.204678_g39561_i0 PRJNA293022 40298 220 1.204678 2.6502916 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 95.1 1.03e-20   NR XHA87929.1 3347367 g39561 i0 61.4 0.954545454545455 70 27 95.5 0 4 213 2115 2184 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 210 95.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
32729409 32729409 PRJNA293022_P_NODE_52580_length_192_cov_1.636364_g51843_i0 PRJNA293022 52580 192 1.636364 3.14181888 Qianjiang dicistro-like virus 51 3347467 Viruses Viruses 63.9 6.31e-10   NR XHA87803.1 3347467 g51843 i0 52.7 1.71875 55 26 85.9 0 166 2 1575 1629 XHA87803.1 MAG: polyprotein [Qianjiang dicistro-like virus 51] diamond 330 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 51

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;