RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA345071" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 8 ✖

bioproject 1

  • PRJNA345071 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
1668126 1668126 PRJNA345071_P_NODE_9942_length_245_cov_0.906977_g9902_i0 PRJNA345071 9942 245 0.906977 2.22209365 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 155 1.3199999999999999e-42   NR WP_009633042.1 927677 g9902 i0 95.1 10.9102040816327 81 4 99.2 0 1 243 215 295 WP_009633042.1 NAD(P)H-quinone oxidoreductase subunit 4 [Synechocystis sp. PCC 7509] diamond 2673 155 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
26617131 26617131 PRJNA345071_P_NODE_8681_length_249_cov_0.886364_g8641_i0 PRJNA345071 8681 249 0.886364 2.20704636 Phormidesmis 1005722 Bacteria Bacteria 114 4.499999999999999e-31   NR WP_219898628.1 268141 g8641 i0 69.4 3.46987951807229 72 22 86.7 0 249 34 4 75 WP_219898628.1 hypothetical protein [Phormidesmis priestleyi] diamond 864 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi
29064400 29064400 PRJNA345071_P_NODE_8968_length_248_cov_0.891429_g8928_i0 PRJNA345071 8968 248 0.891429 2.21074392 Chroococcus sp. FPU1 1974212 Bacteria Bacteria 151 2.8699999999999993e-40   NR WP_206814471.1 1974212 g8928 i0 95.1 0.991935483870968 82 4 99.2 0 248 3 400 481 WP_206814471.1 phosphoenolpyruvate carboxylase [Chroococcus sp. FPU101] diamond 246 151 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Chroococcus Chroococcus sp. FPU101
29397180 29397180 PRJNA345071_P_NODE_3469_length_329_cov_1.519531_g3429_i0 PRJNA345071 3469 329 1.519531 4.99925699 Bacteria 2 Bacteria Bacteria 99.4 9.53e-22   NR MDJ0743806.1 3036636 g3429 i0 43.1 3.97568389057751 109 62 99.4 0 327 1 169 277 MDJ0743806.1 NCS2 family permease [Xenococcaceae cyanobacterium MO_167.B27] diamond 1308 99.8 0.995991983967936 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Xenococcaceae   Xenococcaceae cyanobacterium MO_167.B27
29460023 29460023 PRJNA345071_P_NODE_7470_length_254_cov_1.580110_g7430_i0 PRJNA345071 7470 254 1.58011 4.0134794 root 1 Root_unresolved Root_unresolved 102 1.8399999999999998e-23   NR MEB3327563.1 1131 g7430 i0 70.2 2.97637795275591 84 25 99.2 0 254 3 192 275 MEB3327563.1 hypothetical protein [Synechococcus sp.] diamond 756 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp.
29506202 29506202 PRJNA345071_P_NODE_3350_length_333_cov_1.596154_g3310_i0 PRJNA345071 3350 333 1.596154 5.31519282 Scytonema sp. HK- 1204 Bacteria Bacteria 152 9.13e-41   NR WP_073636499.1 1137095 g3310 i0 66.1 9 112 32 99.1 2 331 2 456 563 WP_073636499.1 thiamine pyrophosphate-binding protein [Scytonema sp. HK-05] diamond 2997 152 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. HK-05
30706575 30706575 PRJNA345071_P_NODE_7614_length_253_cov_0.866667_g7574_i0 PRJNA345071 7614 253 0.866667 2.19266751 candidate division WOR-1 bacterium RIFOXYB2_FULL_42_35 1802580 Bacteria Bacteria 125 2.01e-31   NR OGC23361.1 1802580 g7574 i0 66.7 4.9802371541502 84 28 99.6 0 2 253 93 176 OGC23361.1 MAG: phosphoglycerate dehydrogenase [candidate division WOR-1 bacterium RIFOXYB2_FULL_42_35] diamond 1260 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati           candidate division WOR-1 bacterium RIFOXYB2_FULL_42_35
32809992 32809992 PRJNA345071_P_NODE_6520_length_266_cov_1.647668_g6480_i0 PRJNA345071 6520 266 1.647668 4.38279688 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 107 4.8e-27   NR WP_054468796.1 132607 g6480 i0 58.1 8.72932330827068 86 35 97 1 1 258 6 90 WP_054468796.1 MULTISPECIES: superoxide dismutase [Planktothricoides] diamond 2322 108 0.990740740740741 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Planktothricoides  

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