metadata: contig_metadata: 10 rows where bioproject = "PRJNA1196384" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where bioproject = "PRJNA1196384" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
26882780	26882780	PRJNA1196384_S_NODE_5381_length_177_cov_1.371429_g5317_i0	PRJNA1196384	5381	177	1.371429	2.42742933	Planktothricoides raciborskii	132608	Bacteria	Bacteria	54.7	5.33e-7	NR	WP_190878128.1	132608	g5317	i0	51.7	1.94915254237288	58	27	98.3	1	4	177	37	93	WP_190878128.1 NADPH-dependent F420 reductase [Planktothricoides raciborskii]	diamond	345	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
27388715	27388715	PRJNA1196384_S_NODE_1603_length_309_cov_1.852941_g1539_i0	PRJNA1196384	1603	309	1.852941	5.72558769	Gloeobacterales cyanobacterium ES-bin-313	2812629	Bacteria	Bacteria	60.1	6.21e-8	NR	MBC7882579.1	2812629	g1539	i0	51.8	0.543689320388349	56	27	54.4	0	137	304	105	160	MBC7882579.1 fatty acid desaturase [Gloeobacterales cyanobacterium ES-bin-313]	diamond	168	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales			Gloeobacterales cyanobacterium ES-bin-313
27483276	27483276	PRJNA1196384_S_NODE_5063_length_181_cov_1.479167_g4999_i0	PRJNA1196384	5063	181	1.479167	2.67729227	Thermosynechococcaceae cyanobacterium MS004	2881380	Bacteria	Bacteria	74.3	1.14e-13	NR	MCG9892195.1	2881380	g4999	i0	56.7	2.98342541436464	60	26	99.4	0	181	2	260	319	MCG9892195.1 hypothetical protein [Thermosynechococcaceae cyanobacterium MS004]	diamond	540	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium MS004
27988480	27988480	PRJNA1196384_S_NODE_565_length_498_cov_3.748373_g503_i0	PRJNA1196384	565	498	3.748373	18.66689754	Gloeobacterales cyanobacterium ES-bin-313	2812629	Bacteria	Bacteria	76.6	7.25e-13	NR	MBC7882579.1	2812629	g503	i0	33.6	0.680722891566265	113	73	68.1	1	491	153	336	446	MBC7882579.1 fatty acid desaturase [Gloeobacterales cyanobacterium ES-bin-313]	diamond	339	76.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales			Gloeobacterales cyanobacterium ES-bin-313
28114596	28114596	PRJNA1196384_S_NODE_705_length_452_cov_2.221687_g641_i0	PRJNA1196384	705	452	2.221687	10.04202524	Oscillatoria sp. PCC 1	1159	Bacteria	Bacteria	59.7	3.23e-7	NR	WP_017715544.1	1173028	g641	i0	32.4	0.922566371681416	139	75	83.6	5	59	436	20	152	WP_017715544.1 HNH endonuclease [Oscillatoria sp. PCC 10802]	diamond	417	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
28323025	28323025	PRJNA1196384_S_NODE_1766_length_295_cov_2.259690_g1702_i0	PRJNA1196384	1766	295	2.25969	6.6660855	Cyanophyceae	3028117	Bacteria	Bacteria	85.5	5.57e-17	NR	WP_019499601.1	118173	g1702	i0	42.7	1.9728813559322	96	54	97.6	1	1	288	292	386	WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802]	diamond	582	86.3	0.990730011587486	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
30294028	30294028	PRJNA1196384_S_NODE_3752_length_204_cov_1.628743_g3688_i0	PRJNA1196384	3752	204	1.628743	3.32263572	Thermosynechococcaceae cyanobacterium MS004	2881380	Bacteria	Bacteria	84	5.7e-17	NR	MCG9892195.1	2881380	g3688	i0	55.6	1.85294117647059	63	28	92.6	0	15	203	248	310	MCG9892195.1 hypothetical protein [Thermosynechococcaceae cyanobacterium MS004]	diamond	378	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium MS004
30609432	30609432	PRJNA1196384_S_NODE_3613_length_207_cov_2.541176_g3549_i0	PRJNA1196384	3613	207	2.541176	5.26023432	Pseudanabaena sp. PCC 68	1153	Bacteria	Bacteria	81.6	4.03e-16	NR	WP_019499601.1	118173	g3549	i0	58.2	0.971014492753623	67	28	97.1	0	202	2	214	280	WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802]	diamond	201	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
31020413	31020413	PRJNA1196384_S_NODE_6435_length_165_cov_1.468750_g6371_i0	PRJNA1196384	6435	165	1.46875	2.4234375	Pseudanabaena sp. PCC 68	1153	Bacteria	Bacteria	64.3	3.2e-10	NR	WP_019499601.1	118173	g6371	i0	45.3	2.89090909090909	53	29	96.4	0	165	7	163	215	WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802]	diamond	477	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
31083549	31083549	PRJNA1196384_S_NODE_7395_length_157_cov_1.600000_g7331_i0	PRJNA1196384	7395	157	1.6	2.512	filamentous cyanobacterium CCP3	2107704	Bacteria	Bacteria	59.3	1.65e-8	NR	PSR14385.1	2107704	g7331	i0	48.1	2.94267515923567	52	27	99.4	0	157	2	159	210	PSR14385.1 hypothetical protein C8255_24205 [filamentous cyanobacterium CCP3]	diamond	462	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP3

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