RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA720429" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA720429 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
1193570 1193570 PRJNA720429_P_NODE_3761_length_248_cov_0.880000_g3704_i0 PRJNA720429 3761 248 0.88 2.1824 Janibacter massiliensis 2058291 Bacteria Bacteria 176 2.84e-54   NR WP_106818472.1 2058291 g3704 i0 100 0.991935483870968 82 0 99.2 0 2 247 57 138 WP_106818472.1 phosphoribulokinase [Janibacter massiliensis] diamond 246 176 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Janibacter Janibacter massiliensis
10914045 10914045 PRJNA720429_P_NODE_5049_length_241_cov_0.916667_g4992_i0 PRJNA720429 5049 241 0.916667 2.20916747 Brevibacterium ammoniilyticum 1046555 Bacteria Bacteria 157 1.9e-44   NR WP_342039112.1 1046555 g4992 i0 100 0.995850622406639 80 0 99.6 0 241 2 303 382 WP_342039112.1 FAD/NAD(P)-binding oxidoreductase [Brevibacterium ammoniilyticum] diamond 240 157 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium ammoniilyticum
14739018 14739018 PRJNA720429_P_NODE_3512_length_250_cov_0.870056_g3455_i0 PRJNA720429 3512 250 0.870056 2.17514 Pseudoclavibacter sp. 1915061 Bacteria Bacteria 157 3.03e-44   NR HHW50759.1 1915061 g3455 i0 97.6 0.996 83 2 99.6 0 250 2 102 184 HHW50759.1 PLP-dependent aminotransferase family protein [Pseudoclavibacter sp.] diamond 249 157 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Pseudoclavibacter Pseudoclavibacter sp.
16012542 16012542 PRJNA720429_P_NODE_4613_length_244_cov_0.900585_g4556_i0 PRJNA720429 4613 244 0.900585 2.1974274 Lawsonella 1847725 Bacteria Bacteria 157 1.1799999999999999e-43   NR WP_290598351.1 1847725 g4556 i0 100 0.983606557377049 80 0 98.4 0 3 242 301 380 WP_290598351.1 MULTISPECIES: NADH-quinone oxidoreductase subunit M [Lawsonella] diamond 240 157 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
18561836 18561836 PRJNA720429_P_NODE_4175_length_246_cov_0.890173_g4118_i0 PRJNA720429 4175 246 0.890173 2.18982558 Lawsonella sp. 2041415 Bacteria Bacteria 154 6.6899999999999985e-43   NR WP_290595769.1 2041415 g4118 i0 100 0.98780487804878 81 0 98.8 0 3 245 194 274 WP_290595769.1 preprotein translocase subunit SecY [Lawsonella sp.] diamond 243 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella sp.
19836921 19836921 PRJNA720429_P_NODE_4156_length_246_cov_0.890173_g4099_i0 PRJNA720429 4156 246 0.890173 2.18982558 Thermoleophilia bacterium 2026888 Bacteria Bacteria 113 7.66e-29   NR MBY0395625.1 2026888 g4099 i0 81 0.768292682926829 63 12 76.8 0 244 56 139 201 MBY0395625.1 hypothetical protein [Thermoleophilia bacterium] diamond 189 113 1 Bacteria   Bacillati Actinomycetota Thermoleophilia       Thermoleophilia bacterium
27209892 27209892 PRJNA720429_P_NODE_3142_length_252_cov_2.039106_g3085_i0 PRJNA720429 3142 252 2.039106 5.13854712 Microbacterium sp. NPDC016588 3364185 Bacteria Bacteria 148 2.34e-41   NR MFF8188021.1 3364185 g3085 i0 100 0.988095238095238 83 0 98.8 0 3 251 257 339 MFF8188021.1 daptide biosynthesis RiPP recognition protein [Microbacterium sp. NPDC016588] diamond 249 148 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. NPDC016588
27431559 27431559 PRJNA720429_P_NODE_2543_length_275_cov_1.336634_g2486_i0 PRJNA720429 2543 275 1.336634 3.6757435 Galactobacter valiniphilus 2676122 Bacteria Bacteria 94 5.53e-20   NR WP_407645689.1 2676122 g2486 i0 53.3 1.96363636363636 90 38 93.8 1 6 263 1266 1355 WP_407645689.1 DEAD/DEAH box helicase [Galactobacter valiniphilus] diamond 540 94 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Galactobacter Galactobacter valiniphilus
27810360 27810360 PRJNA720429_P_NODE_2464_length_278_cov_1.443902_g2407_i0 PRJNA720429 2464 278 1.443902 4.01404756 Janibacter endophyticus 2806261 Bacteria Bacteria 175 6.5199999999999996e-52   NR WP_204142335.1 2806261 g2407 i0 98.9 0.992805755395683 92 1 99.3 0 276 1 127 218 WP_204142335.1 NAD(P)H-binding protein [Janibacter endophyticus] diamond 276 175 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Janibacter Janibacter endophyticus
29389022 29389022 PRJNA720429_P_NODE_3889_length_248_cov_0.880000_g3832_i0 PRJNA720429 3889 248 0.88 2.1824 uncultured Microbacterium sp. 191216 Bacteria Bacteria 63.5 1.83e-9   NR WP_296195279.1 191216 g3832 i0 97.1 0.423387096774194 35 1 42.3 0 107 3 464 498 WP_296195279.1 Stk1 family PASTA domain-containing Ser/Thr kinase [uncultured Microbacterium sp.] diamond 105 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium uncultured Microbacterium sp.
29483375 29483375 PRJNA720429_P_NODE_3630_length_249_cov_0.875000_g3573_i0 PRJNA720429 3630 249 0.875 2.17875 Pseudarthrobacter sp. NPDC 1934409 Bacteria Bacteria 139 1.78e-38   NR WP_387552850.1 3346448 g3573 i0 79.5 1 83 17 100 0 1 249 183 265 WP_387552850.1 sugar phosphate isomerase/epimerase family protein [Pseudarthrobacter sp. NPDC058329] diamond 249 139 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter sp. NPDC058329
29904692 29904692 PRJNA720429_P_NODE_3511_length_250_cov_0.870056_g3454_i0 PRJNA720429 3511 250 0.870056 2.17514 Microbacterium 33882 Bacteria Bacteria 77 2.74e-14   NR WP_292891659.1 51671 g3454 i0 91.1 1.068 45 4 54 0 114 248 248 292 WP_292891659.1 tyrosine-type recombinase/integrase [Microbacterium sp.] diamond 267 77 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp.
30747213 30747213 PRJNA720429_P_NODE_5134_length_241_cov_0.916667_g5077_i0 PRJNA720429 5134 241 0.916667 2.20916747 uncultured Microbacterium sp. 191216 Bacteria Bacteria 132 7.58e-34   NR WP_298012668.1 191216 g5077 i0 95.8 0.896265560165975 72 3 89.6 0 3 218 386 457 WP_298012668.1 aconitate hydratase AcnA [uncultured Microbacterium sp.] diamond 216 132 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium uncultured Microbacterium sp.
30778792 30778792 PRJNA720429_P_NODE_4334_length_245_cov_0.895349_g4277_i0 PRJNA720429 4334 245 0.895349 2.19360505 Rubrobacteraceae bacterium 2740537 Bacteria Bacteria 62 3.22e-9   NR MBA2712418.1 2740537 g4277 i0 68.9 0.551020408163265 45 14 55.1 0 9 143 200 244 MBA2712418.1 CpsD/CapB family tyrosine-protein kinase [Rubrobacteraceae bacterium] diamond 135 62 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae   Rubrobacteraceae bacterium
31885241 31885241 PRJNA720429_P_NODE_4037_length_247_cov_0.885057_g3980_i0 PRJNA720429 4037 247 0.885057 2.18609079 Lawsonella clevelandensis 1528099 Bacteria Bacteria 166 1.7499999999999999e-46   NR WP_304161553.1 1528099 g3980 i0 100 0.995951417004049 82 0 99.6 0 246 1 194 275 WP_304161553.1 hypothetical protein [Lawsonella clevelandensis] diamond 246 166 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
32201790 32201790 PRJNA720429_P_NODE_4938_length_242_cov_0.911243_g4881_i0 PRJNA720429 4938 242 0.911243 2.20520806 uncultured Microbacterium sp. 191216 Bacteria Bacteria 158 2.71e-45   NR WP_296198005.1 191216 g4881 i0 98.7 0.979338842975207 79 1 97.9 0 5 241 260 338 WP_296198005.1 sensor histidine kinase [uncultured Microbacterium sp.] diamond 237 158 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium uncultured Microbacterium sp.

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