RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 6 ✖

bioproject 1

  • PRJEB14175 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_phylum 0

tax_kingdom 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
26184131 26184131 PRJEB14175_P_NODE_156598_length_269_cov_1.509615_g154331_i0 PRJEB14175 156598 269 1.509615 4.06086435 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 2013741 Bacteria Bacteria 107 9.23e-25   NR PKN58215.1 2013741 g154331 i0 64.9 0.858736059479554 77 27 85.9 0 252 22 160 236 PKN58215.1 MAG: hypothetical protein CVU56_06990 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 231 107 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32943318 32943318 PRJEB14175_P_NODE_198546_length_229_cov_3.238095_g196279_i0 PRJEB14175 198546 229 3.238095 7.41523755 Deltaproteobacteria bacterium RIFCSPHIGHO2_ 2026735 Bacteria Bacteria 42.4 0.0434   NR OGQ13670.1 1797858 g196279 i0 39.7 0.890829694323144 68 28 72.1 4 207 43 359 426 OGQ13670.1 MAG: primosomal protein N' [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11] diamond 204 42.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11
32943724 32943724 PRJEB14175_P_NODE_248698_length_204_cov_0.895105_g246430_i0 PRJEB14175 248698 204 0.895105 1.8260142 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2 2013747 Bacteria Bacteria 51.2 2.28e-5   NR PKN50111.1 2013748 g246430 i0 44.8 0.852941176470588 58 32 85.3 0 203 30 1423 1480 PKN50111.1 MAG: hypothetical protein CVU63_00240, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20] diamond 174 51.2 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
32990924 32990924 PRJEB14175_P_NODE_109635_length_338_cov_5.129964_g107369_i0 PRJEB14175 109635 338 5.129964 17.33927832 Bacteria 2 Bacteria Bacteria 114 4.31e-27   NR OIP35879.1 1805125 g107369 i0 62.4 1.50887573964497 85 32 75.4 0 337 83 410 494 OIP35879.1 MAG: hypothetical protein AUK23_00065 [Deltaproteobacteria bacterium CG2_30_43_15] diamond 510 114 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG2_30_43_15
33076106 33076106 PRJEB14175_P_NODE_171837_length_252_cov_14.565445_g169570_i0 PRJEB14175 171837 252 14.565445 36.7049214 Bacteria 2 Bacteria Bacteria 108 3.87e-28   NR PKN28472.1 2013749 g169570 i0 60.5 12.6666666666667 76 30 90.5 0 23 250 41 116 PKN28472.1 MAG: cupin domain-containing protein [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21] diamond 3192 109 0.990825688073395 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21
33093386 33093386 PRJEB14175_P_NODE_215854_length_216_cov_4.129032_g213587_i0 PRJEB14175 215854 216 4.129032 8.91870912 delta/epsilon subdivisions 68525 Bacteria Bacteria 65.9 1.8e-10   NR PJB35173.1 1973966 g213587 i0 50.7 5.625 67 28 93.1 1 14 214 239 300 PJB35173.1 MAG: group II intron reverse transcriptase/maturase [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_51_14] diamond 1215 66.2 0.995468277945619 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_51_14

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