RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1101946" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1101946 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
24437175 24437175 PRJNA1101946_S_NODE_4280_length_324_cov_2.225455_g4181_i0 PRJNA1101946 4280 324 2.225455 7.2104742 Actinomycetospora atypica 1290095 Bacteria Bacteria 189 4.2e-57   NR WP_378036211.1 1290095 g4181 i0 96.3 1 108 4 100 0 324 1 18 125 WP_378036211.1 sigma-70 family RNA polymerase sigma factor [Actinomycetospora atypica] diamond 324 189 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora atypica
26655909 26655909 PRJNA1101946_S_NODE_16821_length_196_cov_6.068027_g16722_i0 PRJNA1101946 16821 196 6.068027 11.89333292 unclassified Micromonospora 2617518 Bacteria Bacteria 42.7 0.0196   NR WP_357387275.1 2617518 g16722 i0 51.2 0.627551020408163 41 14 62.8 1 182 60 495 529 WP_357387275.1 MULTISPECIES: alpha/beta fold hydrolase [unclassified Micromonospora] diamond 123 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora  
27067563 27067563 PRJNA1101946_S_NODE_9682_length_250_cov_73.781095_g9583_i0 PRJNA1101946 9682 250 73.781095 184.4527375 Arthrobacter sp. PAMC25284 2861279 Bacteria Bacteria 43.9 0.0155   NR WP_219886742.1 2861279 g9583 i0 47.1 0.612 51 27 61.2 0 97 249 7 57 WP_219886742.1 TerC family protein [Arthrobacter sp. PAMC25284] diamond 153 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. PAMC25284
27478456 27478456 PRJNA1101946_S_NODE_23083_length_167_cov_6.745763_g22984_i0 PRJNA1101946 23083 167 6.745763 11.26542421 Streptomyces sp. WZ-12 3030210 Bacteria Bacteria 42 0.0245   NR WP_274912841.1 3030210 g22984 i0 45.7 0.826347305389222 46 25 82.6 0 14 151 193 238 WP_274912841.1 hypothetical protein [Streptomyces sp. WZ-12] diamond 138 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. WZ-12
28457387 28457387 PRJNA1101946_S_NODE_16086_length_200_cov_56.582781_g15987_i0 PRJNA1101946 16086 200 56.582781 113.165562 Actinomycetota bacterium 2900548 Bacteria Bacteria 43.5 0.0074400000000000004   NR HWD48181.1 2900548 g15987 i0 41.4 0.87 58 34 87 0 4 177 75 132 HWD48181.1 MSMEG_0567/Sll0786 family nitrogen starvation N-acetyltransferase [Actinomycetota bacterium] diamond 174 43.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28583709 28583709 PRJNA1101946_S_NODE_16807_length_196_cov_7.272109_g16708_i0 PRJNA1101946 16807 196 7.272109 14.25333364 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.5 0.0104   NR WP_352342252.1 3154419 g16708 i0 43.1 0.780612244897959 51 25 71.9 1 161 21 248 298 WP_352342252.1 replication initiator [Streptomyces sp. NPDC002588] diamond 153 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC002588
29057272 29057272 PRJNA1101946_S_NODE_1148_length_464_cov_24.566265_g1051_i0 PRJNA1101946 1148 464 24.566265 113.9874696 Cellulosimicrobium cellulans 1710 Bacteria Bacteria 46.6 0.0149   NR MBE9926933.1 1710 g1051 i0 35.6 0.65301724137931 101 63 64 1 138 434 165 265 MBE9926933.1 hypothetical protein [Cellulosimicrobium cellulans] diamond 303 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Promicromonosporaceae Cellulosimicrobium Cellulosimicrobium cellulans
29174970 29174970 PRJNA1101946_S_NODE_8309_length_265_cov_4.356481_g8210_i0 PRJNA1101946 8309 265 4.356481 11.54467465 root 1 Root_unresolved Root_unresolved 45.8 7.5e-4   NR MES6020828.1 1747 g8210 i0 53.8 3.2377358490566 39 18 44.2 0 126 10 16 54 MES6020828.1 hypothetical protein [Cutibacterium acnes] diamond 858 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
29404501 29404501 PRJNA1101946_S_NODE_15909_length_201_cov_84.717105_g15810_i0 PRJNA1101946 15909 201 84.717105 170.28138105 Actinomycetota bacterium 2900548 Bacteria Bacteria 42 0.04   NR MBS1885599.1 2900548 g15810 i0 36.2 0.865671641791045 58 33 86.6 1 19 192 16 69 MBS1885599.1 alpha/beta fold hydrolase [Actinomycetota bacterium] diamond 174 42 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29530836 29530836 PRJNA1101946_S_NODE_6230_length_291_cov_6.161157_g6131_i0 PRJNA1101946 6230 291 6.161157 17.92896687 Streptomyces camelliae 3004093 Bacteria Bacteria 41.6 0.0357   NR WP_270086712.1 3004093 g6131 i0 38.3 0.618556701030928 60 30 61.9 2 8 187 29 81 WP_270086712.1 hypothetical protein [Streptomyces camelliae] diamond 180 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces camelliae
29972869 29972869 PRJNA1101946_S_NODE_8251_length_266_cov_3.331797_g8152_i0 PRJNA1101946 8251 266 3.331797 8.86258002 Jatrophihabitans sp. 1932789 Bacteria Bacteria 42.7 0.0493   NR HEU5271020.1 1932789 g8152 i0 45.7 0.518796992481203 46 24 51.9 1 144 7 167 211 HEU5271020.1 hypothetical protein [Jatrophihabitans sp.] diamond 138 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae Jatrophihabitans Jatrophihabitans sp.
30320964 30320964 PRJNA1101946_S_NODE_2592_length_369_cov_6.759375_g2493_i0 PRJNA1101946 2592 369 6.759375 24.94209375 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.7 0.0267   NR MDQ6842456.1 2900548 g2493 i0 40.7 0.479674796747967 59 31 48 2 31 207 18 72 MDQ6842456.1 hypothetical protein [Actinomycetota bacterium] diamond 177 42.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31837498 31837498 PRJNA1101946_S_NODE_7077_length_280_cov_2.285714_g6978_i0 PRJNA1101946 7077 280 2.285714 6.3999992 Actinomycetospora atypica 1290095 Bacteria Bacteria 45.4 0.00632   NR WP_378036224.1 1290095 g6978 i0 100 0.675 21 0 22.5 0 217 279 12 32 WP_378036224.1 NAD(P)/FAD-dependent oxidoreductase [Actinomycetospora atypica] diamond 189 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora atypica
32249371 32249371 PRJNA1101946_S_NODE_14398_length_212_cov_3.754601_g14299_i0 PRJNA1101946 14398 212 3.754601 7.95975412 Gaiellales bacterium 2093372 Bacteria Bacteria 42.4 0.0333   NR MDX6592185.1 2093372 g14299 i0 40.3 0.94811320754717 67 32 84.9 3 14 193 18 83 MDX6592185.1 hypothetical protein [Gaiellales bacterium] diamond 201 42.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales     Gaiellales bacterium
32344178 32344178 PRJNA1101946_S_NODE_17599_length_192_cov_2.853147_g17500_i0 PRJNA1101946 17599 192 2.853147 5.47804224 Cutibacterium acnes 1747 Bacteria Bacteria 46.6 8.47e-5   NR MES8736955.1 1747 g17500 i0 77.8 0.421875 27 6 42.2 0 81 1 16 42 MES8736955.1 hypothetical protein [Cutibacterium acnes] diamond 81 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32533967 32533967 PRJNA1101946_S_NODE_1399_length_437_cov_20.113402_g1300_i0 PRJNA1101946 1399 437 20.113402 87.89556674 Micromonospora sp. NPDC 1876 Bacteria Bacteria 45.1 0.0452   NR WP_393291663.1 3364268 g1300 i0 37.3 0.51487414187643 75 47 51.5 0 353 129 1397 1471 WP_393291663.1 DUF7507 domain-containing protein [Micromonospora sp. NPDC049275] diamond 225 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora sp. NPDC049275
32659620 32659620 PRJNA1101946_S_NODE_14320_length_212_cov_53.828221_g14221_i0 PRJNA1101946 14320 212 53.828221 114.11582852 Streptomyces microflavus 1919 Bacteria Bacteria 42.7 0.0248   NR WP_319340637.1 1919 g14221 i0 47.1 0.721698113207547 51 27 72.2 0 27 179 263 313 WP_319340637.1 NAD(P)/FAD-dependent oxidoreductase [Streptomyces microflavus] diamond 153 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces microflavus
32848759 32848759 PRJNA1101946_S_NODE_18720_length_186_cov_3.686131_g18621_i0 PRJNA1101946 18720 186 3.686131 6.85620366 Actinacidiphila epipremni 2053013 Bacteria Bacteria 42.7 0.0175   NR WP_167985359.1 2053013 g18621 i0 45.8 0.951612903225806 59 29 95.2 1 9 185 236 291 WP_167985359.1 helicase HerA domain-containing protein [Actinacidiphila epipremni] diamond 177 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila epipremni

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