RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA474911" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474911 · 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
2998369 2998369 PRJNA474911_P_NODE_8263_length_201_cov_0.914286_g8136_i0 PRJNA474911 8263 201 0.914286 1.83771486 Mycobacterium gordonae 1778 Bacteria Bacteria 136 7.65e-38   NR WP_069434356.1 1778 g8136 i0 100 2 67 0 100 0 1 201 112 178 WP_069434356.1 arylamine N-acetyltransferase family protein [Mycobacterium gordonae] diamond 402 136 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium gordonae
27265985 27265985 PRJNA474911_P_NODE_6463_length_219_cov_0.797468_g6336_i0 PRJNA474911 6463 219 0.797468 1.74645492 Nocardioides daedukensis 634462 Bacteria Bacteria 42 0.00997   NR WP_179503640.1 634462 g6336 i0 42.6 0.73972602739726 54 20 74 2 47 208 31 73 WP_179503640.1 hypothetical protein [Nocardioides daedukensis] diamond 162 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides daedukensis
28308072 28308072 PRJNA474911_P_NODE_7806_length_204_cov_0.895105_g7679_i0 PRJNA474911 7806 204 0.895105 1.8260142 Tsukamurella sp. PLM1 2929795 Bacteria Bacteria 43.1 0.0121   NR BDH59710.1 2929795 g7679 i0 33.3 3.52941176470588 60 38 88.2 1 21 200 86 143 BDH59710.1 hypothetical protein MTP03_46490 [Tsukamurella sp. PLM1] diamond 720 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Tsukamurellaceae Tsukamurella Tsukamurella sp. PLM1
28844555 28844555 PRJNA474911_P_NODE_5148_length_252_cov_0.848168_g5021_i0 PRJNA474911 5148 252 0.848168 2.13738336 Agrococcus sp. Ld7 649148 Bacteria Bacteria 41.6 0.0404   NR WP_405219380.1 649148 g5021 i0 34.4 0.761904761904762 64 42 76.2 0 3 194 28 91 WP_405219380.1 fluoride efflux transporter FluC [Agrococcus sp. Ld7] diamond 192 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Agrococcus Agrococcus sp. Ld7
30107775 30107775 PRJNA474911_P_NODE_2952_length_353_cov_1.534247_g2826_i0 PRJNA474911 2952 353 1.534247 5.41589191 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 62.8 3.22e-9   NR MDO4241565.1 1873462 g2826 i0 35.5 1.02832861189802 121 52 98.6 4 3 350 68 167 MDO4241565.1 adenylate kinase [Microbacteriaceae bacterium] diamond 363 62.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
31466899 31466899 PRJNA474911_P_NODE_7616_length_205_cov_0.888889_g7489_i0 PRJNA474911 7616 205 0.888889 1.82222245 Corynebacterium kroppenstedtii 161879 Bacteria Bacteria 134 9.05e-37   NR WP_303735073.1 161879 g7489 i0 100 0.980487804878049 67 0 98 0 203 3 89 155 WP_303735073.1 ornithine cyclodeaminase [Corynebacterium kroppenstedtii] diamond 201 134 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium kroppenstedtii

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