RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA414036" 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 · 5 ✖

bioproject 1

  • PRJNA414036 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26790813 26790813 PRJNA414036_P_NODE_59221_length_219_cov_11.706522_g57482_i0 PRJNA414036 59221 219 11.706522 25.63728318 uncultured delta proteobacterium HF 34034 Bacteria Bacteria 49.3 3.07e-5   NR ADI18196.1 710833 g57482 i0 53.5 0.589041095890411 43 20 58.9 0 197 69 74 116 ADI18196.1 hypothetical protein [uncultured delta proteobacterium HF0200_39N20] diamond 129 49.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0200_39N20
27549390 27549390 PRJNA414036_P_NODE_40004_length_232_cov_108.979695_g38265_i0 PRJNA414036 40004 232 108.979695 252.8328924 uncultured delta proteobacterium HF 34034 Bacteria Bacteria 47 1.49e-4   NR ADI18200.1 710833 g38265 i0 58.1 0.556034482758621 43 18 55.6 0 130 2 9 51 ADI18200.1 hypothetical protein [uncultured delta proteobacterium HF0200_39N20] diamond 129 47 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0200_39N20
29712776 29712776 PRJNA414036_P_NODE_64330_length_200_cov_3.915152_g62591_i0 PRJNA414036 64330 200 3.915152 7.830304 Bacteria 2 Bacteria Bacteria 47.8 1.94e-4   NR ADI17622.1 710828 g62591 i0 44.9 2.07 69 32 94.5 1 2 190 90 158 ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] diamond 414 47.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0130_19C20
31451171 31451171 PRJNA414036_P_NODE_3456_length_566_cov_9.512241_g2796_i0 PRJNA414036 3456 566 9.512241 53.83928406 Pseudomonadota 1224 Bacteria Bacteria 46.6 0.0119   NR ADI17622.1 710828 g2796 i0 66.7 1.21378091872792 33 11 17.5 0 329 231 90 122 ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] diamond 687 46.6 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0130_19C20
32352066 32352066 PRJNA414036_P_NODE_2299_length_618_cov_9.205832_g1830_i0 PRJNA414036 2299 618 9.205832 56.89204176 uncultured delta proteobacterium HF 34034 Bacteria Bacteria 43.9 0.0218   NR ADI17207.1 710824 g1830 i0 45.7 0.223300970873786 46 25 22.3 0 568 431 23 68 ADI17207.1 hypothetical protein [uncultured delta proteobacterium HF0070_10I02] diamond 138 43.9 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0070_10I02

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