RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA728642" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA728642 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
3264102 3264102 PRJNA728642_P_NODE_15823_length_251_cov_0.865169_g15552_i0 PRJNA728642 15823 251 0.865169 2.17157419 Brachybacterium sp. 1891286 Bacteria Bacteria 172 3.77e-49   NR WP_330882423.1 1891286 g15552 i0 100 0.99203187250996006 83 0 99.2 0 249 1 234 316 WP_330882423.1 LCP family protein [Brachybacterium sp.] diamond 249 172 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium sp.
3746720 3746720 PRJNA728642_P_NODE_17563_length_246_cov_0.890173_g17292_i0 PRJNA728642 17563 246 0.890173 2.18982558 Pseudonocardia parietis 570936 Bacteria Bacteria 142 2.44e-40   NR WP_210025691.1 570936 g17292 i0 92.6 0.98780487804878 81 6 98.8 0 244 2 124 204 WP_210025691.1 response regulator [Pseudonocardia parietis] diamond 243 142 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia parietis
8847915 8847915 PRJNA728642_P_NODE_12947_length_280_cov_1.294686_g12676_i0 PRJNA728642 12947 280 1.294686 3.6251208 Patulibacter minatonensis 298163 Bacteria Bacteria 166 1.04e-50   NR WP_026911720.1 298163 g12676 i0 95.7 0.985714285714286 92 4 98.6 0 3 278 34 125 WP_026911720.1 transcription elongation factor GreA [Patulibacter minatonensis] diamond 276 166 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Patulibacteraceae Patulibacter Patulibacter minatonensis
26735357 26735357 PRJNA728642_P_NODE_19521_length_241_cov_0.916667_g19250_i0 PRJNA728642 19521 241 0.916667 2.20916747 Pseudonocardia ammonioxydans 260086 Bacteria Bacteria 89.4 5.99e-20   NR WP_093350930.1 260086 g19250 i0 95.9 0.609958506224066 49 2 61 0 147 1 1 49 WP_093350930.1 TetR/AcrR family transcriptional regulator [Pseudonocardia ammonioxydans] diamond 147 89.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia ammonioxydans
26777895 26777895 PRJNA728642_P_NODE_15821_length_251_cov_0.865169_g15550_i0 PRJNA728642 15821 251 0.865169 2.17157419 Actinomycetes 1760 Bacteria Bacteria 152 7.84e-41   NR WP_045248425.1 33882 g15550 i0 91.6 3.9681274900398402 83 7 99.2 0 250 2 765 847 WP_045248425.1 MULTISPECIES: hypothetical protein [Microbacterium] diamond 996 152 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium  
27094187 27094187 PRJNA728642_P_NODE_18442_length_244_cov_0.900585_g18171_i0 PRJNA728642 18442 244 0.900585 2.1974274 Microbacterium 33882 Bacteria Bacteria 130 1.2699999999999998e-35   NR MCB8043752.1 82380 g18171 i0 87.7 2.98770491803279 81 10 99.6 0 1 243 115 195 MCB8043752.1 hypothetical protein [Microbacterium oxydans] diamond 729 130 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oxydans
27968278 27968278 PRJNA728642_P_NODE_19165_length_242_cov_0.911243_g18894_i0 PRJNA728642 19165 242 0.911243 2.20520806 Kocuria palustris 71999 Bacteria Bacteria 168 1.7199999999999998e-47   NR WP_259872130.1 71999 g18894 i0 98.8 0.991735537190083 80 1 99.2 0 240 1 335 414 WP_259872130.1 heparinase II/III family protein [Kocuria palustris] diamond 240 168 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria palustris
28230933 28230933 PRJNA728642_P_NODE_18446_length_244_cov_0.900585_g18175_i0 PRJNA728642 18446 244 0.900585 2.1974274 Actinomycetes 1760 Bacteria Bacteria 76.3 6.02e-14   NR GAA4068096.1 36807 g18175 i0 56.8 7.86885245901639 81 31 94.7 1 238 8 1 81 GAA4068096.1 hypothetical protein GCM10023065_21060 [Microbacterium laevaniformans] diamond 1920 76.6 0.996083550913838 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium laevaniformans
28704920 28704920 PRJNA728642_P_NODE_19687_length_241_cov_0.916667_g19416_i0 PRJNA728642 19687 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 70.5 1.12e-13   NR WP_078093226.1 1812480 g19416 i0 52.8 1.80497925311203 72 32 89.6 2 1 216 24 93 WP_078093226.1 hypothetical protein [Streptomyces sp. fd1-xmd] diamond 435 71.2 0.990168539325843 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. fd1-xmd
28726090 28726090 PRJNA728642_P_NODE_16627_length_249_cov_0.875000_g16356_i0 PRJNA728642 16627 249 0.875 2.17875 Pseudonocardia nantongensis 1181885 Bacteria Bacteria 172 3.61e-53   NR WP_410949530.1 1181885 g16356 i0 100 1 83 0 100 0 249 1 8 90 WP_410949530.1 pyridoxamine 5'-phosphate oxidase family protein [Pseudonocardia nantongensis] diamond 249 172 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia nantongensis
28978801 28978801 PRJNA728642_P_NODE_18168_length_245_cov_0.895349_g17897_i0 PRJNA728642 18168 245 0.895349 2.19360505 Schaalia sp. Marseille-Q2122 2736604 Bacteria Bacteria 150 3.16e-41   NR WP_175953492.1 2736604 g17897 i0 98.8 0.991836734693878 81 1 99.2 0 3 245 252 332 WP_175953492.1 alanine/glycine:cation symporter family protein [Schaalia sp. Marseille-Q2122] diamond 243 150 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Schaalia Schaalia sp. Marseille-Q2122
29231432 29231432 PRJNA728642_P_NODE_18449_length_244_cov_0.900585_g18178_i0 PRJNA728642 18449 244 0.900585 2.1974274 Lawsonella 1847725 Bacteria Bacteria 49.7 1.01e-5   NR WP_290598729.1 1847725 g18178 i0 90.9 0.811475409836066 66 6 81.1 0 243 46 8 73 WP_290598729.1 MULTISPECIES: hypothetical protein [Lawsonella] diamond 198 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
29578343 29578343 PRJNA728642_P_NODE_17610_length_246_cov_0.890173_g17339_i0 PRJNA728642 17610 246 0.890173 2.18982558 Beutenbergiaceae bacterium 3012325 Bacteria Bacteria 112 1.07e-27   NR HLR58413.1 3012325 g17339 i0 69.5 1 82 25 100 0 246 1 48 129 HLR58413.1 hypothetical protein [Beutenbergiaceae bacterium] diamond 246 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Beutenbergiaceae   Beutenbergiaceae bacterium
29578344 29578344 PRJNA728642_P_NODE_19290_length_242_cov_0.911243_g19019_i0 PRJNA728642 19290 242 0.911243 2.20520806 Cutibacterium acnes 1747 Bacteria Bacteria 58.2 3.47e-8   NR MES6357805.1 1747 g19019 i0 89.3 1.04132231404959 28 3 34.7 0 242 159 62 89 MES6357805.1 J domain-containing protein [Cutibacterium acnes] diamond 252 58.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
29672991 29672991 PRJNA728642_P_NODE_16370_length_250_cov_0.870056_g16099_i0 PRJNA728642 16370 250 0.870056 2.17514 Microbacterium testaceum 2033 Bacteria Bacteria 71.6 1.42e-12   NR WP_228164564.1 2033 g16099 i0 92.3 0.468 39 3 46.8 0 186 70 158 196 WP_228164564.1 hypothetical protein [Microbacterium testaceum] diamond 117 71.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium testaceum
30210039 30210039 PRJNA728642_P_NODE_18112_length_245_cov_0.895349_g17841_i0 PRJNA728642 18112 245 0.895349 2.19360505 Corynebacterium riegelii 156976 Bacteria Bacteria 174 3.23e-49   NR WP_284858601.1 156976 g17841 i0 100 0.991836734693878 81 0 99.2 0 243 1 250 330 WP_284858601.1 heparinase II/III domain-containing protein [Corynebacterium riegelii] diamond 243 174 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium riegelii
31157802 31157802 PRJNA728642_P_NODE_17795_length_246_cov_0.890173_g17524_i0 PRJNA728642 17795 246 0.890173 2.18982558 Nocardioides aequoreus 397278 Bacteria Bacteria 170 2.09e-50   NR WP_084597287.1 397278 g17524 i0 100 0.98780487804878 81 0 98.8 0 245 3 219 299 WP_084597287.1 sulfotransferase family protein [Nocardioides aequoreus] diamond 243 170 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides aequoreus
32202059 32202059 PRJNA728642_P_NODE_19318_length_242_cov_0.911243_g19047_i0 PRJNA728642 19318 242 0.911243 2.20520806 Actinomycetospora termitidis 3053470 Bacteria Bacteria 134 1.92e-36   NR WP_286057048.1 3053470 g19047 i0 95.8 0.892561983471074 72 3 89.3 0 25 240 1 72 WP_286057048.1 hypothetical protein [Actinomycetospora termitidis] diamond 216 134 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora termitidis
32370693 32370693 PRJNA728642_P_NODE_17639_length_246_cov_0.890173_g17368_i0 PRJNA728642 17639 246 0.890173 2.18982558 Streptomyces 1883 Bacteria Bacteria 103 1.4599999999999999e-24   NR WP_170811934.1 1883 g17368 i0 58.2 3.85365853658537 79 33 96.3 0 4 240 25 103 WP_170811934.1 MULTISPECIES: hypothetical protein [Streptomyces] diamond 948 103 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
32644300 32644300 PRJNA728642_P_NODE_13200_length_277_cov_1.504902_g12929_i0 PRJNA728642 13200 277 1.504902 4.16857854 Brachybacterium 43668 Bacteria Bacteria 140 2.0999999999999999e-38   NR WP_148639698.1 43668 g12929 i0 80.4 0.996389891696751 92 17 98.6 1 4 276 80 171 WP_148639698.1 MULTISPECIES: hypothetical protein [Brachybacterium] diamond 276 140 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium  
32833488 32833488 PRJNA728642_P_NODE_19600_length_241_cov_0.916667_g19329_i0 PRJNA728642 19600 241 0.916667 2.20916747 Neomicrococcus lactis 732241 Bacteria Bacteria 138 8.82e-36   NR WP_183642678.1 732241 g19329 i0 93.8 0.995850622406639 80 5 99.6 0 2 241 611 690 WP_183642678.1 3'-5' exonuclease [Neomicrococcus lactis] diamond 240 138 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Neomicrococcus Neomicrococcus lactis

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