RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA796753 · 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
26673683 26673683 PRJNA796753_P_NODE_45341_length_247_cov_0.885057_g45029_i0 PRJNA796753 45341 247 0.885057 2.18609079 uncultured Caudovirales phage 2100421 Viruses Viruses 55.5 7.64e-7   NR CAB4129990.1 2100421 g45029 i0 35.9 0.947368421052632 78 39 89.9 4 2 223 45 115 CAB4129990.1 COG2129 Predicted phosphoesterases, related to the Icc protein [uncultured Caudovirales phage] diamond 234 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
26990347 26990347 PRJNA796753_P_NODE_51682_length_243_cov_0.905882_g51370_i0 PRJNA796753 51682 243 0.905882 2.20129326 Ralstonia phage Firinga 2759725 Viruses Viruses 143 3.0599999999999995e-42   NR YP_010078559.1 2759725 g51370 i0 91.3 0.987654320987654 80 7 98.8 0 242 3 6 85 YP_010078559.1 hypothetical protein KMC49_gp20 [Ralstonia phage Firinga] diamond 240 143 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Firingavirus Firingavirus firinga
27094583 27094583 PRJNA796753_P_NODE_53062_length_242_cov_0.911243_g52750_i0 PRJNA796753 53062 242 0.911243 2.20520806 Marchewkavirus 3425052 Viruses Viruses 45.1 0.00561   NR USN14186.1 2948600 g52750 i0 100 0.545454545454545 22 0 27.3 0 1 66 623 644 USN14186.1 helicase [Brevundimonas phage vB_BpoS-Kabachok] diamond 132 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Jeanschmidtviridae Marchewkavirus Marchewkavirus kabachok
29485149 29485149 PRJNA796753_P_NODE_41190_length_250_cov_0.870056_g40878_i0 PRJNA796753 41190 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 142 3.5099999999999995e-37   NR XOS41798.1 2832643 g40878 i0 77.1 0.996 83 19 99.6 0 2 250 571 653 XOS41798.1 MAG: hypothetical protein MSP0993_67 [Caudoviricetes sp.] diamond 249 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30116925 30116925 PRJNA796753_P_NODE_35892_length_260_cov_1.903743_g35580_i0 PRJNA796753 35892 260 1.903743 4.9497318 Methylophilales phage MEP4 3003801 Viruses Viruses 48.1 3.7e-4   NR WBF78151.1 3003801 g35580 i0 32.1 0.9 78 51 87.7 1 255 28 126 203 WBF78151.1 hypothetical protein MEP402_gp31 [Methylophilales phage MEP402] diamond 234 48.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Zobellviridae   Methylophilales phage MEP402
30812101 30812101 PRJNA796753_P_NODE_39594_length_251_cov_0.865169_g39282_i0 PRJNA796753 39594 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 64.3 4.29e-10   NR UOF77712.1 2832643 g39282 i0 39.5 0.968127490039841 81 46 96.8 1 249 7 142 219 UOF77712.1 hypothetical protein [Caudoviricetes sp.] diamond 243 64.3 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);;