RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1134759" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 7 ✖

bioproject 1

  • PRJNA1134759 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26817371 26817371 PRJNA1134759_P_NODE_56501_length_242_cov_0.923077_g56325_i0 PRJNA1134759 56501 242 0.923077 2.23384634 Caudoviricetes sp. 2832643 Viruses Viruses 92.4 9.06e-22   NR XOR99885.1 2832643 g56325 i0 62.5 1.98347107438017 80 21 99.2 1 3 242 44 114 XOR99885.1 MAG: conserved phage structural protein [Caudoviricetes sp.] diamond 480 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28428462 28428462 PRJNA1134759_P_NODE_48346_length_253_cov_2.177778_g48170_i0 PRJNA1134759 48346 253 2.177778 5.50977834 Erwinia phage vB_EamM_Kwan 1883374 Viruses Viruses 94 4.04e-20   NR YP_009278885.1 1883374 g48170 i0 52.4 0.99604743083004 84 40 99.6 0 253 2 204 287 YP_009278885.1 tail sheath [Erwinia phage vB_EamM_Kwan] diamond 252 94 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Wellingtonvirus wellington
28933623 28933623 PRJNA1134759_P_NODE_4568_length_697_cov_2.844551_g4413_i0 PRJNA1134759 4568 697 2.844551 19.82652047 Erwinia phage vB_EamM_ChrisDB 1883371 Viruses Viruses 174 3.83e-48   NR YP_009292758.1 1883371 g4413 i0 50 2.47489239598278 192 93 81.8 2 574 5 1 191 YP_009292758.1 internal head protein [Erwinia phage vB_EamM_ChrisDB] diamond 1725 174 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Machinavirus Erwinia phage vB_EamM_ChrisDB
30007347 30007347 PRJNA1134759_P_NODE_29271_length_309_cov_2.830508_g29095_i0 PRJNA1134759 29271 309 2.830508 8.74626972 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 2.69e-8   NR XOS23766.1 2832643 g29095 i0 31.4 1.92233009708738 102 70 99 0 3 308 93 194 XOS23766.1 MAG: hypothetical protein MSP0020_13 [Caudoviricetes sp.] diamond 594 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30575622 30575622 PRJNA1134759_P_NODE_49773_length_251_cov_1.432584_g49597_i0 PRJNA1134759 49773 251 1.432584 3.59578584 Erwinia phage pEa_SNUABM_11 2859245 Viruses Viruses 111 2.29e-26   NR QXO09710.1 2859245 g49597 i0 64.6 1.91235059760956 79 28 94.4 0 246 10 46 124 QXO09710.1 hypothetical protein pEaSNUABM11_00286 [Erwinia phage pEa_SNUABM_11] diamond 480 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Erwinia phage pEa_SNUABM_11
31050129 31050129 PRJNA1134759_P_NODE_54315_length_245_cov_0.906977_g54139_i0 PRJNA1134759 54315 245 0.906977 2.22209365 Microbacterium phage LeeroyJenkins 2593338 Viruses Viruses 61.6 2.96e-9   NR QDK01467.1 2593338 g54139 i0 57.4 1.2734693877551 47 20 57.6 0 168 28 6 52 QDK01467.1 acetyltransferase [Microbacterium phage LeeroyJenkins] diamond 312 61.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage LeeroyJenkins
32410011 32410011 PRJNA1134759_P_NODE_6339_length_603_cov_2.928302_g6170_i0 PRJNA1134759 6339 603 2.928302 17.65766106 Erwinia phage pEa_SNUABM_11 2859245 Viruses Viruses 108 8.02e-24   NR QXO09483.1 2859245 g6170 i0 42.3 0.706467661691542 142 78 69.2 3 421 5 3 143 QXO09483.1 hypothetical protein pEaSNUABM11_00059 [Erwinia phage pEa_SNUABM_11] diamond 426 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Erwinia phage pEa_SNUABM_11

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