RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 13 ✖

tax_clade 1

bioproject 1

  • PRJEB50332 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
27665577 27665577 PRJEB50332_P_NODE_9604_length_226_cov_2.430303_g9522_i0 PRJEB50332 9604 226 2.430303 5.49248478 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 137 1.5499999999999998e-35   NR WKU61618.1 3063761 g9522 i0 98.6 0.915929203539823 69 1 91.6 0 17 223 143 211 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 207 137 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
27728921 27728921 PRJEB50332_P_NODE_2024_length_395_cov_1.167665_g1943_i0 PRJEB50332 2024 395 1.167665 4.61227675 Caudoviricetes sp. 2832643 Viruses Viruses 127 6.2099999999999985e-34   NR XOR06219.1 2832643 g1943 i0 56.5 0.994936708860759 131 57 99.5 0 1 393 12 142 XOR06219.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 393 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28486345 28486345 PRJEB50332_P_NODE_16687_length_204_cov_0.909091_g16605_i0 PRJEB50332 16687 204 0.909091 1.85454564 Caudoviricetes sp. 2832643 Viruses Viruses 57 8.75e-8   NR XOS25586.1 2832643 g16605 i0 44.9 1.01470588235294 69 37 100 1 1 204 60 128 XOS25586.1 MAG: hypothetical protein MSP0005_221 [Caudoviricetes sp.] diamond 207 57 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29338902 29338902 PRJEB50332_P_NODE_14689_length_207_cov_1.335616_g14607_i0 PRJEB50332 14689 207 1.335616 2.76472512 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 48.9 1.56e-4   NR YP_009104360.1 3063761 g14607 i0 44.3 2.66666666666667 61 30 84.1 2 206 33 808 867 YP_009104360.1 polyprotein [Crohivirus A] diamond 552 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Crohivirus Danio blood picornavirus/Zebrafish picornavirus 2
29464716 29464716 PRJEB50332_P_NODE_6890_length_242_cov_1.436464_g6808_i0 PRJEB50332 6890 242 1.436464 3.47624288 Achromobacter phage vB_AxyP_19-32_Axy11 2591042 Viruses Viruses 78.6 9.16e-15   NR YP_010079427.1 2591042 g6808 i0 51.7 1.48760330578512 60 29 74.4 0 2 181 3375 3434 YP_010079427.1 virion RNA polymerase [Achromobacter phage vB_AxyP_19-32_Axy11] diamond 360 78.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Pourcelvirus Pourcelvirus Axy11
29685797 29685797 PRJEB50332_P_NODE_6290_length_249_cov_1.957447_g6208_i0 PRJEB50332 6290 249 1.957447 4.87404303 Caudoviricetes sp. 2832643 Viruses Viruses 93.2 2.11e-22   NR XOR90598.1 2832643 g6208 i0 72.6 0.746987951807229 62 17 74.7 0 3 188 48 109 XOR90598.1 MAG: hypothetical protein MSP1590_1 [Caudoviricetes sp.] diamond 186 93.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30350051 30350051 PRJEB50332_P_NODE_11472_length_216_cov_1.916129_g11390_i0 PRJEB50332 11472 216 1.916129 4.13883864 Pithovirus LCPAC1 2506586 Viruses Viruses 53.5 4.08e-6   NR QBK89990.1 2506586 g11390 i0 46.9 1.47222222222222 49 26 68.1 0 147 1 137 185 QBK89990.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] diamond 318 53.5 1 Viruses Pithoviruses             Pithovirus LCPAC101
30760316 30760316 PRJEB50332_P_NODE_7654_length_238_cov_1.101695_g7572_i0 PRJEB50332 7654 238 1.101695 2.6220341 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 142 3.2499999999999996e-37   NR AVM87439.1 3063761 g7572 i0 84.8 0.995798319327731 79 12 99.6 0 1 237 1231 1309 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 237 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
31076319 31076319 PRJEB50332_P_NODE_18575_length_186_cov_4.144000_g18493_i0 PRJEB50332 18575 186 4.144 7.70784 Citromicrobium phage vB_CbaS-RXM 2909582 Viruses Viruses 122 1.19e-30   NR USM11579.1 2909582 g18493 i0 87.1 1 62 8 100 0 1 186 67 128 USM11579.1 putative tail protein [Citromicrobium phage vB_CbaS-RXM] diamond 186 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Citromicrobium phage vB_CbaS-RXM
31740113 31740113 PRJEB50332_P_NODE_2457_length_362_cov_1.614618_g2375_i0 PRJEB50332 2457 362 1.614618 5.84491716 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 94.7 9.32e-20   NR AVM87439.1 3063761 g2375 i0 52.9 0.704419889502762 85 40 70.4 0 256 2 928 1012 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 255 94.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
31834982 31834982 PRJEB50332_P_NODE_8437_length_233_cov_1.773256_g8355_i0 PRJEB50332 8437 233 1.773256 4.13168648 Fadolivirus algeromassiliense 3060017 Viruses Viruses 104 2.63e-24   NR YP_010803269.1 3060017 g8355 i0 62.3 0.991416309012876 77 29 99.1 0 1 231 260 336 YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] diamond 231 104 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Fadolivirus Fadolivirus algeromassiliense
32151585 32151585 PRJEB50332_P_NODE_13178_length_210_cov_0.872483_g13096_i0 PRJEB50332 13178 210 0.872483 1.8322143 Pseudomonas phage pPa_SNUABM_DT 2820398 Viruses Viruses 117 5.0199999999999993e-29   NR QTH80268.1 2820398 g13096 i0 73.9 0.985714285714286 69 18 98.6 0 209 3 109 177 QTH80268.1 hypothetical protein PA10_00068 [Pseudomonas phage pPa_SNUABM_DT01] diamond 207 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage pPa_SNUABM_DT01
32783138 32783138 PRJEB50332_P_NODE_11120_length_218_cov_1.656051_g11038_i0 PRJEB50332 11120 218 1.656051 3.61019118 Myxococcus phage Mx1 2994995 Viruses Viruses 54.7 1.67e-6   NR WNM70322.1 2994995 g11038 i0 57.1 0.577981651376147 42 18 57.8 0 205 80 137 178 WNM70322.1 putative prohead protease [Myxococcus phage Mx1] diamond 126 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myxococcus phage Mx1

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