metadata: contig_metadata: 13 rows where bioproject = "PRJNA564810", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

13 rows where bioproject = "PRJNA564810", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
1829642	1829642	PRJNA564810_S_NODE_1042_length_400_cov_1.937313_g1020_i0	PRJNA564810	1042	400	1.937313	7.749252	Microcystis aeruginosa	1126	Bacteria	Bacteria	527	5.2199999999999985e-145	NTclustered	gi\|2673719\|emb\|AJ003181.1\|	324056	g1020	i0	94.94	24.21	336	17	84	0	51	386	1	336	Microcystis aeruginosa EAWAG175 partial pcB and pcA genes, strain EAWAG175	blastn	9684	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
5657991	5657991	PRJNA564810_S_NODE_5685_length_242_cov_1.536723_g5663_i0	PRJNA564810	5685	242	1.536723	3.71886966	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	156	1.99e-44	NR	WP_106367299.1	2107693	g5663	i0	97.5	19.8347107438017	80	2	99.2	0	242	3	172	251	WP_106367299.1 recombinase RecA [Chlorogloea sp. CCALA 695]	diamond	4800	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
6932220	6932220	PRJNA564810_S_NODE_586_length_469_cov_10.824257_g564_i0	PRJNA564810	586	469	10.824257	50.76576533	Aliterella chasmolithica	2739056	Bacteria	Bacteria	617	3.58e-172	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g564	i0	91.537	118.714285714286	449	36	96	2	1	448	2412	1965	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55677	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6932226	6932226	PRJNA564810_S_NODE_7006_length_223_cov_1.386076_g6984_i0	PRJNA564810	7006	223	1.386076	3.09094948	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	139	1.48e-28	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g6984	i0	87.603	4.98206278026906	121	13	53	2	90	208	703339	703459	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1111	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
8207119	8207119	PRJNA564810_S_NODE_3307_length_290_cov_1.813333_g3285_i0	PRJNA564810	3307	290	1.813333	5.2586657	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	182	1.58e-53	NR	WP_009634238.1	927677	g3285	i0	97.9	0.993103448275862	96	2	99.3	0	1	288	84	179	WP_009634238.1 preprotein translocase subunit SecY [Synechocystis sp. PCC 7509]	diamond	288	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
11336735	11336735	PRJNA564810_S_NODE_729_length_443_cov_1.100529_g707_i0	PRJNA564810	729	443	1.100529	4.87534347	Nodularia	159191	Bacteria	Bacteria	285	3.88e-72	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g707	i0	83.28	8.40632054176072	311	51	70	1	111	420	1068697	1068387	Nodularia spumigena CCY9414 genome	blastn	3724	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
16436250	16436250	PRJNA564810_S_NODE_1913_length_341_cov_3.550725_g1891_i0	PRJNA564810	1913	341	3.550725	12.10797225	Cyanophyceae	3028117	Bacteria	Bacteria	294	4.85e-75	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g1891	i0	83.232	89.7800586510264	328	47	95	7	9	331	6831650	6831974	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	30615	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
19680648	19680648	PRJNA564810_S_NODE_1696_length_351_cov_2.360140_g1674_i0	PRJNA564810	1696	351	2.36014	8.2840914	Aliterella sp. ETH-LAL4-MM48	3237182	Bacteria	Bacteria	507	5.89e-139	NTclustered	gi\|2774606087\|gb\|PQ057073.1\|	3237182	g1674	i0	97.315	85.5498575498575	298	8	85	0	54	351	1355	1058	Aliterella sp. ETH-LAL4-MM48 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30028	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella sp. ETH-LAL4-MM48
26636056	26636056	PRJNA564810_S_NODE_4061_length_272_cov_0.985507_g4039_i0	PRJNA564810	4061	272	0.985507	2.68057904	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	105	1.32e-25	NR	WP_106367335.1	2107693	g4039	i0	77.9	0.75	68	15	75	0	272	69	200	267	WP_106367335.1 pyridine nucleotide transhydrogenase [Chlorogloea sp. CCALA 695]	diamond	204	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28216065	28216065	PRJNA564810_S_NODE_6326_length_232_cov_2.035928_g6304_i0	PRJNA564810	6326	232	2.035928	4.72335296	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	91.7	7.75e-20	NR	ARV61053.1	1940762	g6304	i0	56.3	4.17672413793103	64	28	82.8	0	17	208	291	354	ARV61053.1 hypothetical protein BZZ01_22695 [Nostocales cyanobacterium HT-58-2]	diamond	969	91.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
28469086	28469086	PRJNA564810_S_NODE_5206_length_250_cov_1.102703_g5184_i0	PRJNA564810	5206	250	1.102703	2.7567575	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	156	5.439999999999999e-43	NR	WP_106369171.1	2107693	g5184	i0	88	0.996	83	10	99.6	0	249	1	21	103	WP_106369171.1 GspE/PulE family protein [Chlorogloea sp. CCALA 695]	diamond	249	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28626990	28626990	PRJNA564810_S_NODE_5687_length_242_cov_1.531073_g5665_i0	PRJNA564810	5687	242	1.531073	3.70519666	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	55.8	5.62e-7	NR	MBW4663526.1	2499659	g5665	i0	50.9	0.681818181818182	55	26	66.9	1	5	166	10	64	MBW4663526.1 hypothetical protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	165	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
31785892	31785892	PRJNA564810_S_NODE_5037_length_253_cov_1.808511_g5015_i0	PRJNA564810	5037	253	1.808511	4.57553283	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	150	1.8799999999999994e-42	NR	WP_106370624.1	2107693	g5015	i0	89.3	0.99604743083004	84	9	99.6	0	1	252	211	294	WP_106370624.1 SDR family oxidoreductase [Chlorogloea sp. CCALA 695]	diamond	252	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695

Advanced export

JSON shape: default, array, newline-delimited

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