RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA1186363" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1186363 · 15 ✖
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
11245291 11245291 PRJNA1186363_P_NODE_39509_length_251_cov_0.876404_g38621_i0 PRJNA1186363 39509 251 0.876404 2.19977404 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 157 5.52e-45   NR WP_106369292.1 2107693 g38621 i0 86.7 0.99203187250996006 83 11 99.2 0 249 1 136 218 WP_106369292.1 beta-ketoacyl-ACP synthase III [Chlorogloea sp. CCALA 695] diamond 249 157 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
21443903 21443903 PRJNA1186363_P_NODE_10837_length_626_cov_79.216998_g9956_i0 PRJNA1186363 10837 626 79.216998 495.89840748 root 1 Root_unresolved Root_unresolved 67.6 2.22e-6   NTclustered gi|1373819911|dbj|AP018318.1| 196308 g9956 i0 93.333 5.73642172523962 45 3 7 0 377 421 5803672 5803716 Nostoc sp. HK-01 DNA, complete genome blastn 3591 67.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. HK-01
27767516 27767516 PRJNA1186363_P_NODE_7024_length_800_cov_1.141678_g6234_i0 PRJNA1186363 7024 800 1.141678 9.133424 Myxosarcina sp. GI1 1541065 Bacteria Bacteria 96.7 1.3e-19   NR WP_052055755.1 1541065 g6234 i0 34.8 0.77625 207 105 75.8 7 16 621 18 199 WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1] diamond 621 96.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Myxosarcina Myxosarcina sp. GI1
28020054 28020054 PRJNA1186363_P_NODE_5565_length_903_cov_1.897590_g4582_i1 PRJNA1186363 5565 903 1.89759 17.1352377 Myxosarcina sp. GI1 1541065 Bacteria Bacteria 158 1.2399999999999997e-42   NR WP_052055755.1 1541065 g4582 i1 35.6 0.933554817275748 281 156 92.4 8 46 879 18 276 WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1] diamond 843 158 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Myxosarcina Myxosarcina sp. GI1
28020055 28020055 PRJNA1186363_P_NODE_5985_length_870_cov_3.276035_g5265_i0 PRJNA1186363 5985 870 3.276035 28.5015045 Leptolyngbyaceae cyanobacterium CSU_1_4 2720411 Bacteria Bacteria 161 4.01e-44   NR NJR39198.1 2720411 g5265 i0 36.1 2.76206896551724 252 138 85.2 7 775 35 34 267 NJR39198.1 Spherulation-specific family 4 [Leptolyngbyaceae cyanobacterium CSU_1_4] diamond 2403 161 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium CSU_1_4
28272253 28272253 PRJNA1186363_P_NODE_28386_length_331_cov_0.906977_g27498_i0 PRJNA1186363 28386 331 0.906977 3.00209387 [Phormidium ambiguum] IAM M-71 454136 Bacteria Bacteria 45.8 0.00828   NR WP_218616874.1 454136 g27498 i0 30 0.725075528700906 80 53 71.6 2 60 296 283 360 WP_218616874.1 dynamin family protein [[Phormidium ambiguum] IAM M-71] diamond 240 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Floridanema [Phormidium ambiguum] IAM M-71
28714582 28714582 PRJNA1186363_P_NODE_42067_length_246_cov_0.895954_g41179_i0 PRJNA1186363 42067 246 0.895954 2.20404684 unclassified Nostoc 2593658 Bacteria Bacteria 87 4.29e-18   NR WP_190696167.1 2593658 g41179 i0 55.3 0.926829268292683 76 31 89 1 221 3 14 89 WP_190696167.1 MULTISPECIES: isopenicillin N synthase family dioxygenase [unclassified Nostoc] diamond 228 87 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc  
30376180 30376180 PRJNA1186363_P_NODE_38872_length_252_cov_0.871508_g37984_i0 PRJNA1186363 38872 252 0.871508 2.19620016 root 1 Root_unresolved Root_unresolved 80.5 1.08e-15   NR WP_348230987.1 1481672 g37984 i0 55.1 5.60714285714286 78 32 92.9 2 3 236 225 299 WP_348230987.1 DUF6929 family protein [Trichocoleus desertorum] diamond 1413 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Trichocoleusaceae Trichocoleus Trichocoleus desertorum
30546228 30546228 PRJNA1186363_P_NODE_30173_length_315_cov_1.289256_g29285_i0 PRJNA1186363 30173 315 1.289256 4.0611564 Symplocastrum torsivum 1552229 Bacteria Bacteria 48.5 7.46e-4   NR MBW4548882.1 450513 g29285 i0 34.6 2.23809523809524 78 48 74.3 1 280 47 6 80 MBW4548882.1 low temperature requirement protein A [Symplocastrum torsivum CPER-KK1] diamond 705 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Symplocastrum Symplocastrum torsivum
30830547 30830547 PRJNA1186363_P_NODE_38734_length_252_cov_1.307263_g37846_i0 PRJNA1186363 38734 252 1.307263 3.29430276 Prochlorococcus sp. ALOHA_A2.0_51 2919293 Bacteria Bacteria 85.5 3.68e-17   NR MCH2566828.1 2919293 g37846 i0 56.2 4.53571428571429 73 32 86.9 0 250 32 617 689 MCH2566828.1 reverse transcriptase family protein [Prochlorococcus sp. ALOHA_A2.0_51] diamond 1143 85.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp. ALOHA_A2.0_51
30830580 30830580 PRJNA1186363_P_NODE_9614_length_672_cov_2.098497_g8745_i0 PRJNA1186363 9614 672 2.098497 14.10189984 Desmonostoc muscorum 1179 Bacteria Bacteria 217 2.04e-64   NR MBX9253278.1 2756293 g8745 i0 50.2 1.96428571428571 221 108 98.7 1 6 668 1 219 MBX9253278.1 indoleacetamide hydrolase [Desmonostoc muscorum CCALA 125] diamond 1320 217 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Desmonostoc Desmonostoc muscorum
30849619 30849619 PRJNA1186363_P_NODE_14194_length_530_cov_2.849015_g13310_i0 PRJNA1186363 14194 530 2.849015 15.0997795 root 1 Root_unresolved Root_unresolved 163 1.0199999999999999e-47   NR MFH7242584.1 1157 g13310 i0 47.6 1.89622641509434 166 86 94 1 530 33 6 170 MFH7242584.1 hypothetical protein [Spirulina sp.] diamond 1005 163 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae Spirulina Spirulina sp.
30925648 30925648 PRJNA1186363_P_NODE_5254_length_925_cov_2.153756_g4582_i0 PRJNA1186363 5254 925 2.153756 19.922243 Myxosarcina sp. GI1 1541065 Bacteria Bacteria 159 7.679999999999999e-43   NR WP_052055755.1 1541065 g4582 i0 35.9 0.911351351351351 281 155 90.2 8 858 25 18 276 WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1] diamond 843 159 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Myxosarcina Myxosarcina sp. GI1
31304571 31304571 PRJNA1186363_P_NODE_28795_length_327_cov_1.228346_g27907_i0 PRJNA1186363 28795 327 1.228346 4.01669142 Nostocaceae cyanobacterium 2723028 Bacteria Bacteria 75.5 3.22e-13   NR HLP88410.1 2723028 g27907 i0 37.9 0.944954128440367 103 61 94.5 2 18 326 728 827 HLP88410.1 hypothetical protein [Nostocaceae cyanobacterium] diamond 309 75.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae   Nostocaceae cyanobacterium
31431117 31431117 PRJNA1186363_P_NODE_4476_length_994_cov_1.926167_g3865_i0 PRJNA1186363 4476 994 1.926167 19.14609998 Prochlorococcus sp. ALOHA_A2.0_51 2919293 Bacteria Bacteria 97.1 4.51e-18   NR MCH2566828.1 2919293 g3865 i0 54.8 0.570422535211268 84 38 25.4 0 320 571 606 689 MCH2566828.1 reverse transcriptase family protein [Prochlorococcus sp. ALOHA_A2.0_51] diamond 567 97.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus sp. ALOHA_A2.0_51

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