RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA492363" 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

  • PRJNA492363 · 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
32952661 32952661 PRJNA492363_S_NODE_96706_length_203_cov_2.584507_g95885_i0 PRJNA492363 96706 203 2.584507 5.24654921 Caudoviricetes sp. 2832643 Viruses Viruses 44.7 5.31e-4   NR XOR69820.1 2832643 g95885 i0 70 0.443349753694581 30 9 44.3 0 183 94 23 52 XOR69820.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 90 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32969707 32969707 PRJNA492363_S_NODE_65330_length_226_cov_1.133333_g64509_i0 PRJNA492363 65330 226 1.133333 2.56133258 Sphingobium phage Lacusarx 1980139 Viruses Viruses 45.8 0.00177   NR YP_009600749.1 1980139 g64509 i0 38.6 1.46017699115044 57 34 74.3 1 225 58 145 201 YP_009600749.1 glycoside hydrolase [Sphingobium phage Lacusarx] diamond 330 45.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lacusarxvirus Lacusarxvirus lacusarx
32969737 32969737 PRJNA492363_S_NODE_79242_length_215_cov_1.662338_g78421_i0 PRJNA492363 79242 215 1.662338 3.5740267 Caudoviricetes sp. 2832643 Viruses Viruses 76.6 1.49e-15   NR XOR41085.1 2832643 g78421 i0 97.3 1.54883720930233 37 1 51.6 0 1 111 126 162 XOR41085.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 333 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32986724 32986724 PRJNA492363_S_NODE_8723_length_321_cov_2.834615_g7902_i0 PRJNA492363 8723 321 2.834615 9.09911415 uncultured Caudovirales phage 2100421 Viruses Viruses 69.3 4.1e-11   NR CAB4138901.1 2100421 g7902 i0 49.4 1.46728971962617 77 38 72 1 316 86 87 162 CAB4138901.1 hypothetical protein UFOVP343_24 [uncultured Caudovirales phage] diamond 471 69.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
33139947 33139947 PRJNA492363_S_NODE_100903_length_201_cov_1.121429_g100082_i0 PRJNA492363 100903 201 1.121429 2.25407229 Erwinia phage phiEaP8 2178928 Viruses Viruses 62 3.44e-9   NR YP_009889574.1 2178928 g100082 i0 50 0.985074626865672 66 32 97 1 5 199 1483 1548 YP_009889574.1 virion RNA polymerase [Erwinia phage phiEaP8] diamond 198 62 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Yonginvirus Yonginvirus EaP8
33174288 33174288 PRJNA492363_S_NODE_22248_length_246_cov_1.037838_g21427_i0 PRJNA492363 22248 246 1.037838 2.55308148 Vibrio phage MZH 2664193 Viruses Viruses 99 1.24e-22   NR QGT52262.1 2664193 g21427 i0 77 2.21951219512195 61 14 74.4 0 244 62 272 332 QGT52262.1 major capsid protein [Vibrio phage MZH0603] diamond 546 99 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage MZH0603

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