metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where analysis = "diamond", bioproject = "PRJNA454503" 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
26632977	26632977	PRJNA454503_P_NODE_66941_length_207_cov_1.780822_g66612_i0	PRJNA454503	66941	207	1.780822	3.68630154	Candidatus Synechococcus spongiarum 142	1608213	Bacteria	Bacteria	40.8	0.0324	NR	KKZ15259.1	1608213	g66612	i0	41.2	0.985507246376812	68	22	72.5	2	34	183	17	84	KKZ15259.1 MAG: hypothetical protein TH68_01305 [Candidatus Synechococcus spongiarum 142]	diamond	204	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus spongiarum
26664329	26664329	PRJNA454503_P_NODE_72541_length_206_cov_0.896552_g72212_i0	PRJNA454503	72541	206	0.896552	1.84689712	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	58.2	6.31e-9	NR	MCC6977383.1	2052166	g72212	i0	66.1	0.815533980582524	56	18	80.1	1	166	2	1	56	MCC6977383.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26696185	26696185	PRJNA454503_P_NODE_54821_length_211_cov_0.866667_g54492_i0	PRJNA454503	54821	211	0.866667	1.82866737	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	65.1	2.9e-10	NR	HNB23727.1	2052166	g54492	i0	67.3	0.696682464454976	49	16	69.7	0	62	208	7	55	HNB23727.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium]	diamond	147	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26934126	26934126	PRJNA454503_P_NODE_68062_length_207_cov_0.890411_g67733_i0	PRJNA454503	68062	207	0.890411	1.84315077	Bacillati	1783272	Bacteria	Bacteria	119	5.9400000000000005e-33	NR	MBW4459677.1	1602008	g67733	i0	76.8	5	69	16	100	0	1	207	14	82	MBW4459677.1 nuclear transport factor 2 family protein [Nodosilinea sp. WJT8-NPBG4]	diamond	1035	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. WJT8-NPBG4
27834163	27834163	PRJNA454503_P_NODE_63244_length_208_cov_2.353741_g62915_i0	PRJNA454503	63244	208	2.353741	4.89578128	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	136	2.24e-35	NR	PZM77956.1	2052166	g62915	i0	97.1	0.995192307692308	69	2	99.5	0	207	1	4000	4068	PZM77956.1 MAG: hypothetical protein DKT66_27160 [Candidatus Melainabacteria bacterium]	diamond	207	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27865692	27865692	PRJNA454503_P_NODE_50305_length_215_cov_1.688312_g49976_i0	PRJNA454503	50305	215	1.688312	3.6298708	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	142	1.4e-38	NR	HEY9771584.1	3081323	g49976	i0	97.2	0.990697674418605	71	2	99.1	0	213	1	227	297	HEY9771584.1 sodium/proline symporter [Coleofasciculaceae cyanobacterium]	diamond	213	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
28623793	28623793	PRJNA454503_P_NODE_47107_length_218_cov_2.923567_g46778_i0	PRJNA454503	47107	218	2.923567	6.37337606	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	143	5.299999999999999e-38	NR	PZM81424.1	2052166	g46778	i0	95.8	0.990825688073395	72	3	99.1	0	216	1	195	266	PZM81424.1 MAG: hypothetical protein DKT66_19630 [Candidatus Melainabacteria bacterium]	diamond	216	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29223693	29223693	PRJNA454503_P_NODE_63249_length_208_cov_2.340136_g62920_i0	PRJNA454503	63249	208	2.340136	4.86748288	Synechococcus sp. R60.3	2967123	Bacteria	Bacteria	70.1	6.71e-14	NR	MFS8799176.1	2967123	g62920	i0	67.3	0.706730769230769	49	16	70.7	0	55	201	27	75	MFS8799176.1 hypothetical protein [Synechococcus sp. R60.3]	diamond	147	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. R60.3
31972719	31972719	PRJNA454503_P_NODE_32678_length_236_cov_1.291429_g32349_i0	PRJNA454503	32678	236	1.291429	3.04777244	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	140	1.23e-37	NR	PZM82883.1	2052166	g32349	i0	92.3	0.991525423728814	78	6	99.2	0	235	2	255	332	PZM82883.1 MAG: hypothetical protein DKT66_12915 [Candidatus Melainabacteria bacterium]	diamond	234	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32067553	32067553	PRJNA454503_P_NODE_39078_length_228_cov_1.329341_g38749_i0	PRJNA454503	39078	228	1.329341	3.03089748	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	78.2	9.7e-15	NR	MBC7999982.1	2052166	g38749	i0	85.7	1.13157894736842	42	6	55.3	0	102	227	438	479	MBC7999982.1 PAS domain S-box protein [Candidatus Melainabacteria bacterium]	diamond	258	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32067558	32067558	PRJNA454503_P_NODE_85798_length_202_cov_0.921986_g85469_i0	PRJNA454503	85798	202	0.921986	1.86241172	Candidatus Gastranaerophilales bacterium HUM_9	1916320	Bacteria	Bacteria	124	1.47e-31	NR	DAA96876.1	1916320	g85469	i0	89.6	0.995049504950495	67	7	99.5	0	2	202	103	169	DAA96876.1 MAG TPA: hypothetical protein CPT80_03445 [Candidatus Gastranaerophilales bacterium HUM_9]	diamond	201	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_9

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