RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB43370 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
2610155 2610155 PRJEB43370_P_NODE_7003_length_173_cov_1.677419_g6960_i0 PRJEB43370 7003 173 1.677419 2.90193487 Bacteria 2 Bacteria Bacteria 91.3 1.16e-19   NR WP_345627168.1 556531 g6960 i0 69.1 13.3872832369942 55 17 95.4 0 165 1 495 549 WP_345627168.1 aminomethyl-transferring glycine dehydrogenase [Rugosimonospora acidiphila] diamond 2316 91.7 0.995637949836423 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Rugosimonospora Rugosimonospora acidiphila
3886274 3886274 PRJEB43370_P_NODE_10184_length_163_cov_0.912281_g10141_i0 PRJEB43370 10184 163 0.912281 1.48701803 Bacteria 2 Bacteria Bacteria 53.5 1.29e-6   NR NCZ55714.1 2080302 g10141 i0 50.9 4.95092024539877 53 24 97.5 1 162 4 27 77 NCZ55714.1 M18 family aminopeptidase [Acidimicrobiia bacterium] diamond 807 53.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
27001615 27001615 PRJEB43370_P_NODE_7522_length_169_cov_0.866667_g7479_i0 PRJEB43370 7522 169 0.866667 1.46466723 Actinomycetota bacterium 2900548 Bacteria Bacteria 44.7 0.0029   NR NIA30818.1 2900548 g7479 i0 45.3 1.66863905325444 53 28 92.3 1 5 160 32 84 NIA30818.1 T9SS type A sorting domain-containing protein [Actinomycetota bacterium] diamond 282 44.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27412979 27412979 PRJEB43370_P_NODE_8923_length_166_cov_0.888889_g8880_i0 PRJEB43370 8923 166 0.888889 1.47555574 unclassified Gordonia (in: high G+C Gram-positive bacteria) 2657482 Bacteria Bacteria 74.3 9.62e-14   NR WP_290720141.1 2657482 g8880 i0 58.2 4.96987951807229 55 23 99.4 0 2 166 475 529 WP_290720141.1 MULTISPECIES: ABC transporter ATP-binding protein [unclassified Gordonia (in: high G+C Gram-positive bacteria)] diamond 825 74.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia  
27665501 27665501 PRJEB43370_P_NODE_10784_length_162_cov_0.920354_g10741_i0 PRJEB43370 10784 162 0.920354 1.49097348 Arachnia rubra 1547448 Bacteria Bacteria 47 4.09e-4   NR WP_212326732.1 1547448 g10741 i0 52.8 6.16666666666667 36 17 66.7 0 162 55 402 437 WP_212326732.1 aminopeptidase N [Arachnia rubra] diamond 999 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Arachnia Arachnia rubra
28423264 28423264 PRJEB43370_P_NODE_10306_length_163_cov_0.912281_g10263_i0 PRJEB43370 10306 163 0.912281 1.48701803 Nonomuraea sp. 1883105 Bacteria Bacteria 41.2 0.044   NR HEX4812196.1 1883105 g10263 i0 59.4 0.588957055214724 32 13 58.9 0 142 47 9 40 HEX4812196.1 class F sortase [Nonomuraea sp.] diamond 96 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp.
28423266 28423266 PRJEB43370_P_NODE_2146_length_296_cov_1.263158_g2103_i0 PRJEB43370 2146 296 1.263158 3.73894768 Catenulispora pinisilvae 2705253 Bacteria Bacteria 60.5 4.18e-8   NR WP_194924196.1 2705253 g2103 i0 35.7 2.32094594594595 115 50 99.3 5 2 295 622 729 WP_194924196.1 VWD domain-containing protein [Catenulispora pinisilvae] diamond 687 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora pinisilvae
28833526 28833526 PRJEB43370_P_NODE_2528_length_272_cov_1.713004_g2485_i0 PRJEB43370 2528 272 1.713004 4.65937088 Streptomyces turgidiscabies 85558 Bacteria Bacteria 42.7 0.04   NR WP_344307674.1 85558 g2485 i0 35.5 0.838235294117647 76 40 73.9 2 267 67 55 130 WP_344307674.1 IS5 family transposase, partial [Streptomyces turgidiscabies] diamond 228 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces turgidiscabies
29117927 29117927 PRJEB43370_P_NODE_6749_length_177_cov_1.210938_g6706_i0 PRJEB43370 6749 177 1.210938 2.14336026 Actinomycetes bacterium 1883427 Bacteria Bacteria 55.1 6.95e-7   NR MFM7125210.1 1883427 g6706 i0 54.2 2.86440677966102 59 25 100 2 177 1 150 206 MFM7125210.1 RCC1 domain-containing protein [Actinomycetes bacterium] diamond 507 55.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
29268734 29268734 PRJEB43370_P_NODE_6569_length_179_cov_1.353846_g6526_i0 PRJEB43370 6569 179 1.353846 2.42338434 Bacteria 2 Bacteria Bacteria 80.5 7.32e-16   NR WP_307326838.1 3041785 g6526 i0 62.7 7.91061452513966 59 22 98.9 0 179 3 392 450 WP_307326838.1 NAD-dependent succinate-semialdehyde dehydrogenase [Microbacterium sp. SORGH_AS_1204] diamond 1416 80.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. SORGH_AS_1204
29338851 29338851 PRJEB43370_P_NODE_8769_length_166_cov_0.888889_g8726_i0 PRJEB43370 8769 166 0.888889 1.47555574 Catenulispora sp. 1962977 Bacteria Bacteria 41.6 0.0343   NR NUP48143.1 1962977 g8726 i0 51.2 0.740963855421687 41 19 74.1 1 25 147 268 307 NUP48143.1 MFS transporter [Catenulispora sp.] diamond 123 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora sp.
29528273 29528273 PRJEB43370_P_NODE_4650_length_208_cov_1.465409_g4607_i0 PRJEB43370 4650 208 1.465409 3.04805072 actinobacterium acAcidi 1504320 Bacteria Bacteria 45.1 0.00371   NR KGA05777.1 1504320 g4607 i0 82.6 0.663461538461538 23 4 33.2 0 2 70 500 522 KGA05777.1 MAG: hypothetical protein GM46_10800, partial [actinobacterium acAcidi] diamond 138 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes       actinobacterium acAcidi
29812218 29812218 PRJEB43370_P_NODE_9751_length_164_cov_0.904348_g9708_i0 PRJEB43370 9751 164 0.904348 1.48313072 Actinomycetota bacterium 2900548 Bacteria Bacteria 64.7 2.26e-10   NR MEM9711264.1 2900548 g9708 i0 46.9 4.60975609756098 49 26 89.6 0 157 11 350 398 MEM9711264.1 class I adenylate-forming enzyme family protein [Actinomycetota bacterium] diamond 756 64.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31138968 31138968 PRJEB43370_P_NODE_10995_length_162_cov_0.920354_g10952_i0 PRJEB43370 10995 162 0.920354 1.49097348 Paractinoplanes atraurantiacus 1036182 Bacteria Bacteria 58.9 2.46e-8   NR WP_245923682.1 1036182 g10952 i0 50 2 54 26 98.1 1 4 162 179 232 WP_245923682.1 serine/threonine-protein kinase [Paractinoplanes atraurantiacus] diamond 324 58.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Paractinoplanes Paractinoplanes atraurantiacus
31170660 31170660 PRJEB43370_P_NODE_10555_length_162_cov_1.840708_g10512_i0 PRJEB43370 10555 162 1.840708 2.98194696 Amycolatopsis speibonae 1450224 Bacteria Bacteria 40.4 0.0199   NR WP_378247620.1 1450224 g10512 i0 42.2 1.62962962962963 45 25 81.5 1 29 160 32 76 WP_378247620.1 acyl carrier protein [Amycolatopsis speibonae] diamond 264 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis speibonae
31195442 31195442 PRJEB43370_P_NODE_1215_length_395_cov_2.924855_g1172_i0 PRJEB43370 1215 395 2.924855 11.55317725 PVC group 1783257 Bacteria Bacteria 57 1.93e-6   NR WP_106238110.1 1144618 g1172 i0 47.5 2.0886075949367102 59 28 44.8 1 215 391 5 60 WP_106238110.1 F0F1 ATP synthase subunit beta [Allonocardiopsis opalescens] diamond 825 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales   Allonocardiopsis Allonocardiopsis opalescens
31265788 31265788 PRJEB43370_P_NODE_6295_length_183_cov_1.164179_g6252_i0 PRJEB43370 6295 183 1.164179 2.13044757 Actinomadura sediminis 1038904 Bacteria Bacteria 41.6 0.0346   NR WP_378296409.1 1038904 g6252 i0 45.2 0.688524590163934 42 23 68.9 0 6 131 139 180 WP_378296409.1 hypothetical protein [Actinomadura sediminis] diamond 126 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura sediminis
31607029 31607029 PRJEB43370_P_NODE_9516_length_165_cov_0.896552_g9473_i0 PRJEB43370 9516 165 0.896552 1.4793108 Actinomycetes 1760 Bacteria Bacteria 103 5.3699999999999995e-25   NR MBW8711991.1 1785 g9473 i0 81.8 12 55 10 100 0 1 165 218 272 MBW8711991.1 alpha/beta fold hydrolase [Mycobacterium sp.] diamond 1980 103 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
31740041 31740041 PRJEB43370_P_NODE_7797_length_168_cov_1.924370_g7754_i0 PRJEB43370 7797 168 1.92437 3.2329416 Prescottella equi 43767 Bacteria Bacteria 41.6 0.0349   NR MBM4602470.1 43767 g7754 i0 51.3 0.696428571428571 39 19 69.6 0 46 162 225 263 MBM4602470.1 hypothetical protein [Prescottella equi] diamond 117 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Prescottella Prescottella equi
31961581 31961581 PRJEB43370_P_NODE_9658_length_164_cov_1.808696_g9615_i0 PRJEB43370 9658 164 1.808696 2.96626144 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 80.9 9.01e-18   NR HEY7070843.1 2201156 g9615 i0 84.4 5.90853658536585 45 7 82.3 0 145 11 87 131 HEY7070843.1 adenosylhomocysteinase [Acidimicrobiales bacterium] diamond 969 80.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium

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