RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA793147" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA793147 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
13532021 13532021 PRJNA793147_P_NODE_9151_length_578_cov_2.060904_g8889_i0 PRJNA793147 9151 578 2.060904 11.91202512 Pineapple secovirus A 2726258 Viruses Viruses 364 3.82e-113   NR WCR39255.1 2726258 g8889 i0 90.5 1.97231833910035 190 18 98.6 0 572 3 1268 1457 WCR39255.1 polyprotein 1 [Pineapple secovirus A] diamond 1140 364 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
27085468 27085468 PRJNA793147_P_NODE_50422_length_235_cov_2.602410_g50156_i0 PRJNA793147 50422 235 2.60241 6.1156635 Pineapple secovirus A 2726258 Viruses Viruses 133 5.34e-34   NR WCR39275.1 2726258 g50156 i0 80.8 1.99148936170213 78 15 99.6 0 235 2 271 348 WCR39275.1 polyprotein 2 [Pineapple secovirus A] diamond 468 133 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
27433273 27433273 PRJNA793147_P_NODE_47343_length_244_cov_2.057143_g47077_i0 PRJNA793147 47343 244 2.057143 5.01942892 Pineapple secovirus A 2726258 Viruses Viruses 155 6.429999999999998e-42   NR YP_010840337.1 2726258 g47077 i0 93.8 1.9672131147541 80 5 98.4 0 242 3 567 646 YP_010840337.1 polyprotein [Pineapple secovirus A] diamond 480 155 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
27559141 27559141 PRJNA793147_P_NODE_27224_length_319_cov_1.508000_g26958_i0 PRJNA793147 27224 319 1.508 4.81052 Pineapple secovirus A 2726258 Viruses Viruses 129 5.27e-32   NR YP_010840337.1 2726258 g26958 i0 61.3 0.874608150470219 93 36 87.5 0 2 280 1769 1861 YP_010840337.1 polyprotein [Pineapple secovirus A] diamond 279 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
28515782 28515782 PRJNA793147_P_NODE_43407_length_256_cov_1.278075_g43141_i0 PRJNA793147 43407 256 1.278075 3.271872 Zebrafish jaw picornavirus RQ13 Viruses Viruses 96.7 4.82e-21   NR DAZ91113.1 RQ13 g43141 i0 55.3 5.96484375 85 34 99.6 1 256 2 512 592 DAZ91113.1 TPA_asm: polyprotein, partial [Red-eared slider pemapivirus] diamond 1527 96.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Pemapivirus Zebrafish jaw picornavirus
28633061 28633061 PRJNA793147_P_NODE_37627_length_274_cov_1.404878_g37361_i0 PRJNA793147 37627 274 1.404878 3.84936572 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 96.3 8.59e-21   NR AVM87439.1 3063761 g37361 i0 51.1 1.02919708029197 94 42 98.5 1 274 5 917 1010 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 282 96.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28696155 28696155 PRJNA793147_P_NODE_21367_length_361_cov_0.982877_g21101_i0 PRJNA793147 21367 361 0.982877 3.54818597 Pineapple secovirus A 2726258 Viruses Viruses 185 1.37e-51   NR YP_010840337.1 2726258 g21101 i0 74.8 1.97783933518006 119 30 98.9 0 3 359 1171 1289 YP_010840337.1 polyprotein [Pineapple secovirus A] diamond 714 185 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
28948804 28948804 PRJNA793147_P_NODE_10768_length_527_cov_2.058952_g10505_i0 PRJNA793147 10768 527 2.058952 10.85067704 Pineapple secovirus A 2726258 Viruses Viruses 296 2.02e-90   NR YP_010840336.1 2726258 g10505 i0 89 1.75332068311195 154 17 87.7 0 1 462 964 1117 YP_010840336.1 polyprotein [Pineapple secovirus A] diamond 924 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
30062836 30062836 PRJNA793147_P_NODE_37771_length_273_cov_3.176471_g37505_i0 PRJNA793147 37771 273 3.176471 8.67176583 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 80.5 2.88e-15   NR WZI33513.1 3063761 g37505 i0 48.2 2.74725274725275 85 36 87.9 2 272 33 874 955 WZI33513.1 MAG: polyprotein, partial [Crohivirus A] diamond 750 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Crohivirus Danio blood picornavirus/Zebrafish picornavirus 2
30812026 30812026 PRJNA793147_P_NODE_26314_length_324_cov_3.662745_g26048_i0 PRJNA793147 26314 324 3.662745 11.8672938 Pineapple secovirus A 2726258 Viruses Viruses 207 8.03e-60   NR WCR39275.1 2726258 g26048 i0 89.7 1.98148148148148 107 11 99.1 0 323 3 646 752 WCR39275.1 polyprotein 2 [Pineapple secovirus A] diamond 642 207 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
30812037 30812037 PRJNA793147_P_NODE_55374_length_231_cov_1.438272_g55108_i0 PRJNA793147 55374 231 1.438272 3.32240832 Pineapple secovirus A 2726258 Viruses Viruses 129 1.57e-32   NR YP_010840336.1 2726258 g55108 i0 75 0.987012987012987 76 19 98.7 0 228 1 17 92 YP_010840336.1 polyprotein [Pineapple secovirus A] diamond 228 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
31285976 31285976 PRJNA793147_P_NODE_30035_length_305_cov_1.220339_g29769_i0 PRJNA793147 30035 305 1.220339 3.72203395 Pineapple secovirus A 2726258 Viruses Viruses 197 3.25e-56   NR WCR39275.1 2726258 g29769 i0 89.1 1.98688524590164 101 11 99.3 0 3 305 651 751 WCR39275.1 polyprotein 2 [Pineapple secovirus A] diamond 606 197 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
31349492 31349492 PRJNA793147_P_NODE_51936_length_234_cov_1.066667_g51670_i0 PRJNA793147 51936 234 1.066667 2.49600078 Pineapple secovirus A 2726258 Viruses Viruses 145 1.7999999999999998e-38   NR WCR39275.1 2726258 g51670 i0 90.9 1.97435897435897 77 7 98.7 0 233 3 516 592 WCR39275.1 polyprotein 2 [Pineapple secovirus A] diamond 462 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
31633951 31633951 PRJNA793147_P_NODE_18396_length_390_cov_2.445483_g18130_i0 PRJNA793147 18396 390 2.445483 9.5373837 Pineapple secovirus A 2726258 Viruses Viruses 254 1.19e-75   NR YP_010840337.1 2726258 g18130 i0 92.2 2.97692307692308 129 10 99.2 0 388 2 1498 1626 YP_010840337.1 polyprotein [Pineapple secovirus A] diamond 1161 254 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
31697282 31697282 PRJNA793147_P_NODE_31597_length_298_cov_1.253275_g31331_i0 PRJNA793147 31597 298 1.253275 3.7347595 Pineapple secovirus A 2726258 Viruses Viruses 178 2.17e-49   NR YP_010840337.1 2726258 g31331 i0 89.9 1.99328859060403 99 10 99.7 0 2 298 1306 1404 YP_010840337.1 polyprotein [Pineapple secovirus A] diamond 594 178 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
32803429 32803429 PRJNA793147_P_NODE_61700_length_226_cov_0.917197_g61434_i0 PRJNA793147 61700 226 0.917197 2.07286522 Pineapple secovirus A 2726258 Viruses Viruses 143 1.0699999999999998e-37   NR WCR39275.1 2726258 g61434 i0 86.7 1.99115044247788 75 10 99.6 0 226 2 826 900 WCR39275.1 polyprotein 2 [Pineapple secovirus A] diamond 450 143 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas

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