RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA560029 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
23496480 23496480 PRJNA560029_S_NODE_31679_length_252_cov_2.268156_g31455_i0 PRJNA560029 31679 252 2.268156 5.71575312 Actinomycetospora lemnae 3019891 Bacteria Bacteria 77.8 1.6e-14   NR WP_274203450.1 3019891 g31455 i0 84.6 0.94047619047619 39 6 46.4 0 227 111 5 43 WP_274203450.1 sarcosine oxidase subunit beta family protein [Actinomycetospora lemnae] diamond 237 77.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora lemnae
28531866 28531866 PRJNA560029_S_NODE_6927_length_401_cov_4.807927_g6703_i0 PRJNA560029 6927 401 4.807927 19.27978727 Microlunatus sp. 39595 Bacteria Bacteria 50.1 5.22e-4   NR HET9649394.1 39595 g6703 i0 32.6 0.965087281795511 129 75 87.5 4 372 22 204 332 HET9649394.1 ABC transporter permease [Microlunatus sp.] diamond 387 50.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus sp.
29226580 29226580 PRJNA560029_S_NODE_20569_length_300_cov_1.788546_g20345_i0 PRJNA560029 20569 300 1.788546 5.365638 Brachybacterium 43668 Bacteria Bacteria 202 2.42e-62   NR WP_193866173.1 43668 g20345 i0 98 0.99 99 2 99 0 298 2 239 337 WP_193866173.1 MULTISPECIES: HAD-IIA family hydrolase [Brachybacterium] diamond 297 202 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium  
30141749 30141749 PRJNA560029_S_NODE_9312_length_373_cov_5.050000_g9088_i0 PRJNA560029 9312 373 5.05 18.8365 Scrofimicrobium appendicitidis 3079930 Bacteria Bacteria 63.2 7.2e-10   NR XBW08714.1 3079930 g9088 i0 32 0.780160857908847 97 65 77.2 1 312 25 11 107 XBW08714.1 GNAT family N-acetyltransferase [Scrofimicrobium appendicitidis] diamond 291 63.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Scrofimicrobium Scrofimicrobium appendicitidis
30805696 30805696 PRJNA560029_S_NODE_23994_length_284_cov_1.872038_g23770_i0 PRJNA560029 23994 284 1.872038 5.31658792 Atopobiaceae bacterium 2485926 Bacteria Bacteria 48.9 4.02e-4   NR MCH3968418.1 2485926 g23770 i0 31 0.887323943661972 84 58 88.7 0 280 29 77 160 MCH3968418.1 L,D-transpeptidase/peptidoglycan binding protein [Atopobiaceae bacterium] diamond 252 48.9 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Atopobiaceae   Atopobiaceae bacterium
31754071 31754071 PRJNA560029_S_NODE_14837_length_331_cov_7.550388_g14613_i0 PRJNA560029 14837 331 7.550388 24.99178428 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 56.6 1.42e-6   NR HEY4611321.1 2497619 g14613 i0 39.4 0.942598187311178 104 58 92.4 3 17 322 669 769 HEY4611321.1 HAD-IC family P-type ATPase [Ilumatobacteraceae bacterium] diamond 312 56.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
31926227 31926227 PRJNA560029_S_NODE_3697_length_476_cov_6.856079_g3474_i0 PRJNA560029 3697 476 6.856079 32.63493604 Bacteria 2 Bacteria Bacteria 82.4 6.75e-15   NR WP_307234788.1 137267 g3474 i0 46.4 3.51050420168067 84 38 52.9 1 3 254 793 869 WP_307234788.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Catenuloplanes indicus] diamond 1671 83.2 0.990384615384615 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Catenuloplanes Catenuloplanes indicus

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