RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1215774 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
2882540 2882540 PRJNA1215774_P_NODE_81083_length_243_cov_0.905882_g80763_i0 PRJNA1215774 81083 243 0.905882 2.20129326 Williamsia serinedens 391736 Bacteria Bacteria 141 1.17e-37   NR WP_253654417.1 391736 g80763 i0 90.1 1 81 8 100 0 243 1 259 339 WP_253654417.1 acetyl-CoA carboxylase carboxyltransferase subunit alpha/beta [Williamsia serinedens] diamond 243 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia serinedens
4157890 4157890 PRJNA1215774_P_NODE_30044_length_386_cov_1.476038_g29724_i0 PRJNA1215774 30044 386 1.476038 5.69750668 Microbacterium plantarum 1816425 Bacteria Bacteria 142 3.61e-40   NR WP_323986238.1 1816425 g29724 i0 56.8 1.0259067357513 132 50 97.9 3 386 9 16 146 WP_323986238.1 hypothetical protein [Microbacterium plantarum] diamond 396 142 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium plantarum
9259541 9259541 PRJNA1215774_P_NODE_79608_length_244_cov_0.900585_g79288_i0 PRJNA1215774 79608 244 0.900585 2.1974274 Pseudoclavibacter sp. 1915061 Bacteria Bacteria 159 9.67e-44   NR HHW50434.1 1915061 g79288 i0 98.8 0.995901639344262 81 1 99.6 0 243 1 137 217 HHW50434.1 2-isopropylmalate synthase [Pseudoclavibacter sp.] diamond 243 159 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Pseudoclavibacter Pseudoclavibacter sp.
14360391 14360391 PRJNA1215774_P_NODE_66772_length_254_cov_2.071823_g66452_i0 PRJNA1215774 66772 254 2.071823 5.26243042 Microbacterium sp. ASV81 3041921 Bacteria Bacteria 162 1.0999999999999999e-47   NR WP_308488834.1 3041921 g66452 i0 88.1 0.992125984251969 84 10 99.2 0 254 3 34 117 WP_308488834.1 sulfurtransferase [Microbacterium sp. ASV81] diamond 252 162 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium capsulatum
26755973 26755973 PRJNA1215774_P_NODE_75341_length_247_cov_0.885057_g75021_i0 PRJNA1215774 75341 247 0.885057 2.18609079 Mycobacterium sp. 1785 Bacteria Bacteria 162 2.44e-46   NR MCE9515289.1 1785 g75021 i0 95.1 0.995951417004049 82 4 99.6 0 2 247 83 164 MCE9515289.1 cytochrome P450 [Mycobacterium sp.] diamond 246 162 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
26996404 26996404 PRJNA1215774_P_NODE_69542_length_250_cov_1.983051_g69222_i0 PRJNA1215774 69542 250 1.983051 4.9576275 Actinomycetes 1760 Bacteria Bacteria 116 4.059999999999999e-31   NR WP_290863882.1 2024425 g69222 i0 74.7 5.604 79 19 93.6 1 17 250 2 80 WP_290863882.1 VOC family protein [Hamadaea sp.] diamond 1401 116 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Hamadaea Hamadaea sp.
27009288 27009288 PRJNA1215774_P_NODE_62242_length_265_cov_1.718750_g61922_i0 PRJNA1215774 62242 265 1.71875 4.5546875 Baekduia sp. 2600305 Bacteria Bacteria 45.8 0.00367   NR HEY6758934.1 2600305 g61922 i0 48.3 0.679245283018868 60 29 66.8 2 44 220 123 181 HEY6758934.1 DMT family transporter [Baekduia sp.] diamond 180 45.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Baekduiaceae Baekduia Baekduia sp.
27072650 27072650 PRJNA1215774_P_NODE_30462_length_383_cov_1.790323_g30142_i0 PRJNA1215774 30462 383 1.790323 6.85693709 Arthrobacter sp. ZGTC412 2058900 Bacteria Bacteria 218 1.33e-65   NR WP_104045095.1 2058900 g30142 i0 84.9 1.98172323759791 126 19 98.7 0 383 6 64 189 WP_104045095.1 HAL/PAL/TAL family ammonia-lyase [Arthrobacter sp. ZGTC412] diamond 759 218 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. ZGTC412
27104122 27104122 PRJNA1215774_P_NODE_53122_length_289_cov_1.305556_g52802_i0 PRJNA1215774 53122 289 1.305556 3.77305684 Microbacterium sp. NPDC 51671 Bacteria Bacteria 76.3 2.94e-15   NR WP_363520183.1 3154768 g52802 i0 56.5 0.716262975778547 69 30 71.6 0 289 83 65 133 WP_363520183.1 hypothetical protein [Microbacterium sp. NPDC079176] diamond 207 76.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. NPDC079176
27357325 27357325 PRJNA1215774_P_NODE_84963_length_241_cov_0.916667_g84643_i0 PRJNA1215774 84963 241 0.916667 2.20916747 Actinotalea soli 2819234 Bacteria Bacteria 116 3.52e-28   NR WP_208055820.1 2819234 g84643 i0 68.8 0.995850622406639 80 25 99.6 0 2 241 589 668 WP_208055820.1 DUF4185 domain-containing protein [Actinotalea soli] diamond 240 116 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Actinotalea Actinotalea soli
27483489 27483489 PRJNA1215774_P_NODE_58363_length_275_cov_1.460396_g58043_i0 PRJNA1215774 58363 275 1.460396 4.016089 Gordonia sp. 852 1834101 Bacteria Bacteria 113 7.83e-28   NR WP_064904521.1 1834101 g58043 i0 100 0.676363636363636 62 0 67.6 0 188 3 287 348 WP_064904521.1 DUF6542 domain-containing protein [Gordonia sp. 852002-51296_SCH5728562-b] diamond 186 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia sp. 852002-51296_SCH5728562-b
27628795 27628795 PRJNA1215774_P_NODE_69244_length_251_cov_0.865169_g68924_i0 PRJNA1215774 69244 251 0.865169 2.17157419 Rhodococcus 1827 Bacteria Bacteria 161 1e-45   NR WP_317804219.1 3082225 g68924 i0 97.6 1.9840637450199201 83 2 99.2 0 251 3 215 297 WP_317804219.1 hypothetical protein [Rhodococcus sp. IEGM 1330] diamond 498 161 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. IEGM 1330
28114844 28114844 PRJNA1215774_P_NODE_50905_length_295_cov_1.932432_g50585_i0 PRJNA1215774 50905 295 1.932432 5.7006744 Streptomyces atratus 1893 Bacteria Bacteria 42 0.033   NR GGT61744.1 1893 g50585 i0 54.8 0.427118644067797 42 18 41.7 1 198 76 21 62 GGT61744.1 hypothetical protein GCM10010207_71750 [Streptomyces atratus] diamond 126 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces atratus
28133922 28133922 PRJNA1215774_P_NODE_84025_length_241_cov_0.916667_g83705_i0 PRJNA1215774 84025 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 158 9.919999999999999e-48   NR WP_316316563.1 28447 g83705 i0 98.8 4.9792531120332 80 1 99.6 0 1 240 17 96 WP_316316563.1 hypothetical protein, partial [Clavibacter michiganensis] diamond 1200 158 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Clavibacter Clavibacter michiganensis
28272637 28272637 PRJNA1215774_P_NODE_45366_length_313_cov_1.283333_g45046_i0 PRJNA1215774 45366 313 1.283333 4.01683229 Microbacterium jejuense 1263637 Bacteria Bacteria 55.5 8.96e-7   NR GAA5202339.1 1263637 g45046 i0 42 0.661341853035144 69 31 65.2 2 108 311 77 137 GAA5202339.1 hypothetical protein GCM10025773_25290 [Microbacterium jejuense] diamond 207 55.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium jejuense
28620312 28620312 PRJNA1215774_P_NODE_75407_length_247_cov_0.885057_g75087_i0 PRJNA1215774 75407 247 0.885057 2.18609079 Mycolicibacterium iranicum 912594 Bacteria Bacteria 99.8 3.14e-22   NR WP_165762858.1 912594 g75087 i0 100 0.595141700404858 49 0 59.5 0 99 245 1 49 WP_165762858.1 AMP-binding protein [Mycolicibacterium iranicum] diamond 147 99.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium iranicum
28777883 28777883 PRJNA1215774_P_NODE_78607_length_245_cov_0.895349_g78287_i0 PRJNA1215774 78607 245 0.895349 2.19360505 Ilumatobacter sp. 1967498 Bacteria Bacteria 91.7 2.34e-19   NR TVR27944.1 1967498 g78287 i0 61.3 0.979591836734694 80 31 98 0 245 6 519 598 TVR27944.1 MAG: hypothetical protein EA389_01510, partial [Ilumatobacter sp.] diamond 240 91.7 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
28967626 28967626 PRJNA1215774_P_NODE_84668_length_241_cov_0.916667_g84348_i0 PRJNA1215774 84668 241 0.916667 2.20916747 Pseudarthrobacter oxydans 1671 Bacteria Bacteria 62 8.99e-10   NR WP_364410732.1 1671 g84348 i0 76.5 1.46887966804979 34 8 42.3 0 2 103 77 110 WP_364410732.1 hypothetical protein [Pseudarthrobacter oxydans] diamond 354 62 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter oxydans
29030825 29030825 PRJNA1215774_P_NODE_83388_length_242_cov_0.834320_g83068_i0 PRJNA1215774 83388 242 0.83432 2.0190544 unclassified Nocardiopsis 2649073 Bacteria Bacteria 43.1 0.0263   NR WP_406981360.1 2649073 g83068 i0 43.3 0.830578512396694 67 33 83.1 1 205 5 176 237 WP_406981360.1 MULTISPECIES: FAD-binding oxidoreductase [unclassified Nocardiopsis] diamond 201 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Nocardiopsis  
29238956 29238956 PRJNA1215774_P_NODE_83589_length_241_cov_1.815476_g83269_i0 PRJNA1215774 83589 241 1.815476 4.37529716 Bacteria 2 Bacteria Bacteria 77.4 4.53e-16   NR MCB0997881.1 2201156 g83269 i0 89.4 1.7551867219917 47 5 58.5 0 240 100 80 126 MCB0997881.1 preQ(1) synthase [Acidimicrobiales bacterium] diamond 423 77.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29314795 29314795 PRJNA1215774_P_NODE_69449_length_251_cov_0.837079_g69129_i0 PRJNA1215774 69449 251 0.837079 2.10106829 uncultured Acidimicrobiales bacterium 310071 Bacteria Bacteria 43.1 0.00473   NR CAA9259618.1 310071 g69129 i0 60 0.358565737051793 30 12 35.9 0 16 105 15 44 CAA9259618.1 MAG: hypothetical protein AVDCRST_MAG20-2631 [uncultured Acidimicrobiales bacterium] diamond 90 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     uncultured Acidimicrobiales bacterium
29756694 29756694 PRJNA1215774_P_NODE_82831_length_242_cov_0.911243_g82511_i0 PRJNA1215774 82831 242 0.911243 2.20520806 Microbacterium oleivorans 273677 Bacteria Bacteria 152 8.84e-44   NR WP_366213612.1 273677 g82511 i0 100 0.991735537190083 80 0 99.2 0 2 241 36 115 WP_366213612.1 hypothetical protein [Microbacterium oleivorans] diamond 240 152 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium oleivorans
29870341 29870341 PRJNA1215774_P_NODE_43011_length_321_cov_1.822581_g42691_i0 PRJNA1215774 43011 321 1.822581 5.85048501 Bacteria 2 Bacteria Bacteria 99.4 1.25e-21   NR WP_415648861.1 1892856 g42691 i0 46.8 3.02803738317757 109 55 99.1 1 2 319 610 718 WP_415648861.1 cytochrome P450/oxidoreductase [Stackebrandtia soli] diamond 972 100 0.994 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Stackebrandtia Stackebrandtia soli
30135529 30135529 PRJNA1215774_P_NODE_24392_length_433_cov_1.063889_g24072_i0 PRJNA1215774 24392 433 1.063889 4.60663937 Pseudonocardiales bacterium 2201155 Bacteria Bacteria 45.8 0.00679   NR MDT7575649.1 2201155 g24072 i0 34.6 0.720554272517321 104 57 67.2 3 385 95 9 108 MDT7575649.1 hypothetical protein [Pseudonocardiales bacterium] diamond 312 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales     Pseudonocardiales bacterium
30167320 30167320 PRJNA1215774_P_NODE_84072_length_241_cov_0.916667_g83752_i0 PRJNA1215774 84072 241 0.916667 2.20916747 Mobiluncus curtisii 2051 Bacteria Bacteria 119 2.5899999999999997e-31   NR NMW89542.1 2051 g83752 i0 100 2.35269709543568 63 0 78.4 0 2 190 174 236 NMW89542.1 toll/interleukin-1 receptor domain-containing protein [Mobiluncus curtisii] diamond 567 119 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Mobiluncus Mobiluncus curtisii
30230631 30230631 PRJNA1215774_P_NODE_70992_length_249_cov_2.386364_g70672_i0 PRJNA1215774 70992 249 2.386364 5.94204636 Microbacterium rhizosphaerae 1678237 Bacteria Bacteria 60.8 1.05e-8   NR WP_320942784.1 1678237 g70672 i0 86.1 0.433734939759036 36 5 43.4 0 122 15 1 36 WP_320942784.1 NAD(P)-dependent oxidoreductase [Microbacterium rhizosphaerae] diamond 108 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium rhizosphaerae
30894329 30894329 PRJNA1215774_P_NODE_53354_length_288_cov_1.432558_g53034_i0 PRJNA1215774 53354 288 1.432558 4.12576704 Microbacterium sp. 1P 51671 Bacteria Bacteria 156 3.4699999999999992e-43   NR WP_413354039.1 3132289 g53034 i0 83.3 1 96 16 100 0 1 288 309 404 WP_413354039.1 phage portal protein [Microbacterium sp. 1P06AB] diamond 288 156 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. 1P06AB
30957543 30957543 PRJNA1215774_P_NODE_7434_length_807_cov_1.358311_g7146_i0 PRJNA1215774 7434 807 1.358311 10.96156977 Microbacterium sp. 1P 51671 Bacteria Bacteria 192 3.0299999999999997e-56   NR WP_413354014.1 3132289 g7146 i0 58.8 0.594795539033457 160 64 58.7 1 295 768 1 160 WP_413354014.1 hypothetical protein [Microbacterium sp. 1P06AB] diamond 480 192 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. 1P06AB
31874284 31874284 PRJNA1215774_P_NODE_72837_length_248_cov_1.405714_g72517_i0 PRJNA1215774 72837 248 1.405714 3.48617072 Gordonia 2053 Bacteria Bacteria 114 5.02e-28   NR WP_251723330.1 2053 g72517 i0 76 0.907258064516129 75 11 89.5 2 247 26 8 76 WP_251723330.1 MULTISPECIES: glycosyltransferase family 4 protein [Gordonia] diamond 225 114 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia  
32475715 32475715 PRJNA1215774_P_NODE_31839_length_375_cov_1.009934_g31519_i0 PRJNA1215774 31839 375 1.009934 3.7872525 unclassified Microbacterium 2609290 Bacteria Bacteria 75.5 4.82e-14   NR WP_363391746.1 2609290 g31519 i0 48.9 0.704 88 44 69.6 1 262 2 66 153 WP_363391746.1 MULTISPECIES: hypothetical protein [unclassified Microbacterium] diamond 264 75.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium  
32601945 32601945 PRJNA1215774_P_NODE_70960_length_249_cov_2.630682_g70640_i0 PRJNA1215774 70960 249 2.630682 6.55039818 Streptomyces sp. HF1 1931 Bacteria Bacteria 43.1 0.0286   NR WP_159701868.1 2692233 g70640 i0 47.6 0.759036144578313 63 25 67.5 3 80 247 205 266 WP_159701868.1 glycosyltransferase family 39 protein [Streptomyces sp. HF10] diamond 189 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. HF10

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