RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753112 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27400673 27400673 PRJNA753112_P_NODE_19083_length_311_cov_1.638655_g18741_i0 PRJNA753112 19083 311 1.638655 5.09621705 Pseudomonas phage phiK7A1 2759194 Viruses Viruses 46.2 5.69e-4   NR QNR53890.1 2759194 g18741 i0 66.7 0.578778135048232 30 10 28.9 0 92 3 2 31 QNR53890.1 hypothetical protein phiK7A1_102 [Pseudomonas phage phiK7A1] diamond 180 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Torinovirus Torinovirus K7A1
27874137 27874137 PRJNA753112_P_NODE_21925_length_290_cov_2.129032_g21583_i0 PRJNA753112 21925 290 2.129032 6.1741928 Caudoviricetes sp. 2832643 Viruses Viruses 159 5.96e-43   NR XOR28482.1 2832643 g21583 i0 92.6 0.982758620689655 95 7 98.3 0 285 1 722 816 XOR28482.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 285 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29610382 29610382 PRJNA753112_P_NODE_25030_length_272_cov_1.884422_g24688_i0 PRJNA753112 25030 272 1.884422 5.12562784 Flyfo siphovirus Tbat1_6 2907287 Viruses Viruses 79.7 1.39e-16   NR YP_010685015.1 2907287 g24688 i0 67.3 1.76470588235294 52 17 57.4 0 234 79 95 146 YP_010685015.1 hypothetical protein PRB80_gp12 [Flyfo siphovirus Tbat1_6] diamond 480 79.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Flyfo siphovirus Tbat1_6
31664621 31664621 PRJNA753112_P_NODE_22917_length_284_cov_2.218009_g22575_i0 PRJNA753112 22917 284 2.218009 6.29914556 Pseudomonas phage D3 2932880 Viruses Viruses 112 1.86e-28   NR NP_061578.1 2932880 g22575 i0 87.5 5.36619718309859 64 8 67.6 0 282 91 150 213 NP_061578.1 NinG/ Rap DNA junction specific endonuclease [Pseudomonas phage D3] diamond 1524 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Detrevirus Detrevirus D3

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