RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA596867" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA596867 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
3691875 3691875 PRJNA596867_P_NODE_5083_length_347_cov_1.930657_g5008_i0 PRJNA596867 5083 347 1.930657 6.69937979 Pseudomonas phage Rollin 3079657 Viruses Viruses 82 6.37e-18   NR WNV50608.1 3079657 g5008 i0 79.6 0.423631123919308 49 10 42.4 0 346 200 24 72 WNV50608.1 hypothetical protein [Pseudomonas phage Rollin] diamond 147 82 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Rollin
26699772 26699772 PRJNA596867_P_NODE_15281_length_241_cov_0.916667_g15206_i0 PRJNA596867 15281 241 0.916667 2.20916747 Pseudomonas phage D6 3025445 Viruses Viruses 58.5 9.99e-8   NR WDS62261.1 3025445 g15206 i0 34.2 1.96680497925311 79 49 98.3 1 5 241 677 752 WDS62261.1 virion structural protein [Pseudomonas phage D6] diamond 474 58.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage D6
28387988 28387988 PRJNA596867_P_NODE_13226_length_246_cov_0.890173_g13151_i0 PRJNA596867 13226 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 59.3 5.56e-8   NR YP_007675804.1 754046 g13151 i0 39.3 2.96341463414634 84 46 97.6 4 5 244 346 428 YP_007675804.1 hypothetical protein SUFG_00016 [Sulfitobacter phage phiCB2047-B] diamond 729 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Raunefjordenvirus Raunefjordenvirus CB2047B
30585176 30585176 PRJNA596867_P_NODE_8173_length_289_cov_1.101852_g8098_i0 PRJNA596867 8173 289 1.101852 3.18435228 Pectobacterium phage DU_PP_III 2041490 Viruses Viruses 112 2.54e-27   NR ATS93712.1 2041490 g8098 i0 62.2 2.55363321799308 82 31 85.1 0 247 2 3 84 ATS93712.1 hypothetical protein P9AB12kb_p003 [Pectobacterium phage DU_PP_III] diamond 738 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Astrithrvirus Pectobacterium phage DU_PP_III
31754885 31754885 PRJNA596867_P_NODE_8657_length_283_cov_1.190476_g8582_i0 PRJNA596867 8657 283 1.190476 3.36904708 Caudoviricetes sp. 2832643 Viruses Viruses 51.6 4.48e-5   NR XOR59884.1 2832643 g8582 i0 34.8 1.886925795053 89 54 94.3 1 275 9 363 447 XOR59884.1 MAG: major capsid protein [Caudoviricetes sp.] diamond 534 51.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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