RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA793147" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA793147 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28948809 28948809 PRJNA793147_P_NODE_29568_length_307_cov_1.512605_g29302_i0 PRJNA793147 29568 307 1.512605 4.64369735 Escherichia phage UPEC 3102713 Viruses Viruses 129 2.97e-36   NR QUL77285.1 2811509 g29302 i0 59.5 0.820846905537459 84 34 82.1 0 254 3 4 87 QUL77285.1 hypothetical protein [Escherichia phage UPEC06] diamond 252 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage UPEC06
28980354 28980354 PRJNA793147_P_NODE_55408_length_231_cov_1.333333_g55142_i0 PRJNA793147 55408 231 1.333333 3.07999923 Hafnia phage TS33 3110108 Viruses Viruses 154 4.82e-43   NR WQY91232.1 3110108 g55142 i0 100 0.987012987012987 76 0 98.7 0 229 2 30 105 WQY91232.1 terminase large subunit [Hafnia phage TS33] diamond 228 154 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
30338612 30338612 PRJNA793147_P_NODE_51032_length_235_cov_0.867470_g50766_i0 PRJNA793147 51032 235 0.86747 2.0385545 Caudoviricetes sp. 2832643 Viruses Viruses 143 3.2e-38   NR XOR76521.1 2832643 g50766 i0 88.5 0.995744680851064 78 9 99.6 0 1 234 311 388 XOR76521.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 234 143 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30653971 30653971 PRJNA793147_P_NODE_37413_length_275_cov_1.310680_g37147_i0 PRJNA793147 37413 275 1.31068 3.60437 Shigella phage vB_SboS_Gloob 2902746 Viruses Viruses 97.8 2.39e-21   NR UHS65013.1 2902746 g37147 i0 54.1 0.927272727272727 85 39 92.7 0 20 274 235 319 UHS65013.1 putative tail spike protein [Shigella phage vB_SboS_Gloob] diamond 255 97.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Agtrevirus Shigella phage vB_SboS_Gloob
31823673 31823673 PRJNA793147_P_NODE_35677_length_281_cov_2.551887_g35411_i0 PRJNA793147 35677 281 2.551887 7.17080247 Salmonella phage vB_SalM-LPST94 2282399 Viruses Viruses 154 1.93e-41   NR AXF41693.1 2282399 g35411 i0 84.9 0.99288256227758 93 14 99.3 0 279 1 626 718 AXF41693.1 hypothetical protein LPST94_00131 [Salmonella phage vB_SalM-LPST94] diamond 279 154 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Kuttervirus Salmonella phage vB_SalM-LPST94
32140259 32140259 PRJNA793147_P_NODE_61378_length_226_cov_1.834395_g61112_i0 PRJNA793147 61378 226 1.834395 4.1457327 Serratia phage Tsm2 2787014 Viruses Viruses 67.8 8.3e-13   NR YP_010582716.1 2787014 g61112 i0 56.9 0.769911504424779 58 24 75.7 1 225 55 28 85 YP_010582716.1 hypothetical protein PF629_gp08 [Serratia phage Tsm2] diamond 174 67.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Otakuvirus Otakuvirus Tsm2

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