RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA902848" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA902848 · 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
27087551 27087551 PRJNA902848_P_NODE_16382_length_248_cov_0.891429_g16332_i0 PRJNA902848 16382 248 0.891429 2.21074392 Microbacterium phage Triscuit 2126721 Viruses Viruses 136 5.209999999999998e-35   NR AVR56943.1 2126721 g16332 i0 77.1 1.00403225806452 83 18 99.2 1 246 1 654 736 AVR56943.1 DNA polymerase I [Microbacterium phage Triscuit] diamond 249 136 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Triscuit
27877108 27877108 PRJNA902848_P_NODE_6365_length_340_cov_1.749064_g6315_i0 PRJNA902848 6365 340 1.749064 5.9468176 Zebrafish influenza B-like virus RQ01 Viruses Viruses 145 2.8e-38   NR AVM87624.1 RQ01 g6315 i0 64.6 0.997058823529412 113 40 99.7 0 339 1 452 564 AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] diamond 339 145 1 Viruses   Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Zebrafish influenza B-like virus
28066543 28066543 PRJNA902848_P_NODE_14705_length_251_cov_0.876404_g14655_i0 PRJNA902848 14705 251 0.876404 2.19977404 uncultured Caudovirales phage 2100421 Viruses Viruses 75.5 1.24e-13   NR CAB4124507.1 2100421 g14655 i0 52.4 0.9800796812749 82 39 98 0 251 6 389 470 CAB4124507.1 hypothetical protein UFOVP62_7 [uncultured Caudovirales phage] diamond 246 75.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30118930 30118930 PRJNA902848_P_NODE_19052_length_244_cov_0.912281_g19002_i0 PRJNA902848 19052 244 0.912281 2.22596564 uncultured Caudovirales phage 2100421 Viruses Viruses 73.2 7.32e-13   NR CAB4123841.1 2100421 g19002 i0 76.2 0.774590163934426 63 15 77.5 0 2 190 688 750 CAB4123841.1 hypothetical protein UFOVP48_93 [uncultured Caudovirales phage] diamond 189 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30150417 30150417 PRJNA902848_P_NODE_18872_length_244_cov_0.912281_g18822_i0 PRJNA902848 18872 244 0.912281 2.22596564 Stenotrophomonas phage vB_SM_ytsc_ply2 3432383 Viruses Viruses 65.1 5.1e-10   NR YP_010719966.1 2894587 g18822 i0 34.3 0.823770491803279 67 44 82.4 0 240 40 610 676 YP_010719966.1 DNA primase/helicase [Stenotrophomonas phage vB_SM_ytsc_ply2008005c] diamond 201 65.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Shangdongvirus Shangdongvirus ply2008005c
32174134 32174134 PRJNA902848_P_NODE_10158_length_283_cov_1.185714_g10108_i0 PRJNA902848 10158 283 1.185714 3.35557062 uncultured Caudovirales phage 2100421 Viruses Viruses 84.7 2.28e-17   NR CAB4204268.1 2100421 g10108 i0 47.4 1.00706713780919 95 43 94.3 2 282 16 145 238 CAB4204268.1 hypothetical protein UFOVP1389_41 [uncultured Caudovirales phage] diamond 285 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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