RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA909412", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 17 ✖

tax_phylum 1

  • Pisuviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA909412 · 17 ✖

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
2524855 2524855 PRJNA909412_P_NODE_5942_length_215_cov_0.937500_g5801_i0 PRJNA909412 5942 215 0.9375 2.015625 Viruses 10239 Viruses Viruses 141 3.93e-29   NTclustered gi|2196309042|gb|MZ679248.1| 2715102 g5801 i0 90.741 3.16279069767442 108 7 50 3 74 180 10027 9922 MAG: Marnaviridae sp. isolate R65-k141_733993 hypothetical protein gene, complete cds blastn 680 141 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
5993919 5993919 PRJNA909412_P_NODE_17285_length_151_cov_1.482143_g17144_i0 PRJNA909412 17285 151 1.482143 2.23803593 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 257 2.43e-64   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g17144 i0 97.351 1 151 4 100 0 1 151 8222 8072 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 151 257 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
11094306 11094306 PRJNA909412_P_NODE_7609_length_192_cov_1.588235_g7468_i0 PRJNA909412 7609 192 1.588235 3.0494112 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 350 5.24e-92   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g7468 i0 99.479 1.99479166666667 192 1 100 0 1 192 776 967 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 383 350 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
12369826 12369826 PRJNA909412_P_NODE_6110_length_212_cov_1.930636_g5969_i0 PRJNA909412 6110 212 1.930636 4.09294832 Crogonang virus 58 3063050 Viruses Viruses 285 1.69e-72   NTclustered gi|2626079542|gb|OR270365.1| 3063050 g5969 i0 90.995 0.995283018867924 211 19 99 0 2 212 344 554 MAG: Crogonang virus 58 isolate CGH03 genomic sequence blastn 211 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
12369831 12369831 PRJNA909412_P_NODE_7110_length_198_cov_1.962264_g6969_i0 PRJNA909412 7110 198 1.962264 3.88528272 Crogonang virus 47 3063018 Viruses Viruses 211 2.68e-50   NTclustered gi|2626079445|gb|OR270332.1| 3063018 g6969 i0 85.859 2 198 28 100 0 1 198 546 743 MAG: Crogonang virus 47 isolate CGH03 genomic sequence blastn 396 211 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
14918642 14918642 PRJNA909412_P_NODE_1612_length_433_cov_2.147208_g1472_i0 PRJNA909412 1612 433 2.147208 9.29741064 Crogonang virus 58 3063050 Viruses Viruses 510 5.7399999999999985e-140   NTclustered gi|2626079542|gb|OR270365.1| 3063050 g1472 i0 88.112 0.990762124711316 429 51 99 0 1 429 1272 844 MAG: Crogonang virus 58 isolate CGH03 genomic sequence blastn 429 510 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
26897970 26897970 PRJNA909412_P_NODE_3981_length_264_cov_0.924444_g3840_i0 PRJNA909412 3981 264 0.924444 2.44053216 Picornaviridae sp. 1530251 Viruses Viruses 95.5 1.36e-20   NR URG14535.1 1530251 g3840 i0 56.5 0.965909090909091 85 30 96.6 1 10 264 393 470 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 255 95.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
27624868 27624868 PRJNA909412_P_NODE_5744_length_218_cov_1.843575_g5603_i0 PRJNA909412 5744 218 1.843575 4.0189935 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 90.9 3.04e-19   NR XCM67722.1 3003959 g5603 i0 56.3 0.977064220183486 71 31 97.7 0 2 214 939 1009 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 213 90.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27877298 27877298 PRJNA909412_P_NODE_7905_length_189_cov_1.100000_g7764_i0 PRJNA909412 7905 189 1.1 2.079 Picornaviridae sp. 1530251 Viruses Viruses 85.5 1.54e-17   NR URG14535.1 1530251 g7764 i0 58.1 0.984126984126984 62 25 96.8 1 5 187 297 358 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 186 85.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28224426 28224426 PRJNA909412_P_NODE_2386_length_345_cov_1.696078_g2246_i0 PRJNA909412 2386 345 1.696078 5.8514691 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 116 2.0500000000000003e-27   NR XCM67722.1 3003959 g2246 i0 66.2 0.617391304347826 71 24 61.7 0 2 214 683 753 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 213 116 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29266382 29266382 PRJNA909412_P_NODE_12309_length_162_cov_2.195122_g12168_i0 PRJNA909412 12309 162 2.195122 3.55609764 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 75.5 3.47e-14   NR XCM67722.1 3003959 g12168 i0 64.2 0.981481481481482 53 18 98.1 1 3 161 1075 1126 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 159 75.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29898194 29898194 PRJNA909412_P_NODE_3451_length_282_cov_3.946502_g3310_i0 PRJNA909412 3451 282 3.946502 11.12913564 Betacoronavirus pandemicum 3418604 Viruses Viruses 46.2 0.0032   NR 8XYZ_B 2697049 g3310 i0 79.2 0.25531914893617 24 5 25.5 0 208 279 2 25 8XYZ_B Chain B, Signal peptide, Spike protein S1 [Severe acute respiratory syndrome coronavirus 2] diamond 72 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
30435461 30435461 PRJNA909412_P_NODE_6233_length_210_cov_1.619883_g6092_i0 PRJNA909412 6233 210 1.619883 3.4017543 Marnaviridae sp. 2715102 Viruses Viruses 105 1.43e-24   NR ULG00020.1 2715102 g6092 i0 67.6 1.92857142857143 68 22 97.1 0 5 208 2704 2771 ULG00020.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 405 105 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30687820 30687820 PRJNA909412_P_NODE_6173_length_211_cov_1.819767_g6032_i0 PRJNA909412 6173 211 1.819767 3.83970837 Crogonang virus 58 3063050 Viruses Viruses 113 2.93e-27   NR WPR18299.1 3063050 g6032 i0 75.7 0.995260663507109 70 17 99.5 0 1 210 466 535 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 210 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
31256695 31256695 PRJNA909412_P_NODE_4015_length_263_cov_1.424107_g3874_i0 PRJNA909412 4015 263 1.424107 3.74540141 Crogonang virus 58 3063050 Viruses Viruses 132 2.24e-35   NR XII42581.1 3063050 g3874 i0 74.7 1.98479087452471 87 21 99.2 1 3 263 212 297 XII42581.1 MAG: capsid protein, partial [Crogonang virus 58] diamond 522 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
32585545 32585545 PRJNA909412_P_NODE_2299_length_351_cov_3.544872_g2159_i0 PRJNA909412 2299 351 3.544872 12.44250072 Betacoronavirus pandemicum 3418604 Viruses Viruses 46.2 0.00645   NR 8XYZ_B 2697049 g2159 i0 79.2 0.205128205128205 24 5 20.5 0 277 348 2 25 8XYZ_B Chain B, Signal peptide, Spike protein S1 [Severe acute respiratory syndrome coronavirus 2] diamond 72 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
32805682 32805682 PRJNA909412_P_NODE_14580_length_157_cov_1.406780_g14439_i0 PRJNA909412 14580 157 1.40678 2.2086446 Crogonang virus 58 3063050 Viruses Viruses 99.8 9.85e-23   NR XII42580.1 3063050 g14439 i0 84.6 1.98726114649682 52 8 99.4 0 2 157 38 89 XII42580.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 58] diamond 312 99.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58

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