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

11 rows where analysis = "diamond", bioproject = "PRJNA949785" 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
21664280	21664280	PRJNA949785_P_NODE_18337_length_243_cov_0.905882_g18140_i0	PRJNA949785	18337	243	0.905882	2.20129326	uncultured Coleofasciculus sp.	1267456	Bacteria	Bacteria	117	1.25e-30	NR	CAA9257822.1	1267456	g18140	i0	100	0.740740740740741	60	0	74.1	0	180	1	1	60	CAA9257822.1 ATP-dependent Clp protease proteolytic subunit [uncultured Coleofasciculus sp.]	diamond	180	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	uncultured Coleofasciculus sp.
27625975	27625975	PRJNA949785_P_NODE_16004_length_250_cov_0.870056_g15807_i0	PRJNA949785	16004	250	0.870056	2.17514	Cyanophyceae	3028117	Bacteria	Bacteria	52.8	1.13e-5	NR	WP_190417489.1	3028117	g15807	i0	64.9	1.332	37	13	44.4	0	1	111	303	339	WP_190417489.1 MULTISPECIES: glycosyltransferase family 2 protein [Cyanophyceae]	diamond	333	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
28004937	28004937	PRJNA949785_P_NODE_17145_length_246_cov_0.890173_g16948_i0	PRJNA949785	17145	246	0.890173	2.18982558	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	100	2.57e-22	NR	MEO8890062.1	3081323	g16948	i0	86.8	1.9390243902439	53	7	64.6	0	246	88	694	746	MEO8890062.1 glycoside hydrolase [Coleofasciculaceae cyanobacterium]	diamond	477	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
28232033	28232033	PRJNA949785_P_NODE_16786_length_247_cov_0.885057_g16589_i0	PRJNA949785	16786	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	75.5	1.15e-13	NR	HEY9821992.1	2762020	g16589	i0	82.9	1.48178137651822	41	7	49.8	0	1	123	517	557	HEY9821992.1 transglutaminase domain-containing protein [Candidatus Sericytochromatia bacterium]	diamond	366	75.9	0.994729907773386	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29267443	29267443	PRJNA949785_P_NODE_17169_length_246_cov_0.890173_g16972_i0	PRJNA949785	17169	246	0.890173	2.18982558	Brasilonema octagenarum	417105	Bacteria	Bacteria	85.5	6.23e-20	NR	NMF67470.1	417115	g16972	i0	76.4	0.670731707317073	55	13	67.1	0	212	48	10	64	NMF67470.1 molybdenum-pterin-binding domain-containing protein [Brasilonema octagenarum UFV-OR1]	diamond	165	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema octagenarum
31005031	31005031	PRJNA949785_P_NODE_17314_length_246_cov_0.890173_g17117_i0	PRJNA949785	17314	246	0.890173	2.18982558	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	150	7.859999999999998e-42	NR	WP_009633475.1	927677	g17117	i0	91.4	2.96341463414634	81	7	98.8	0	3	245	148	228	WP_009633475.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Synechocystis sp. PCC 7509]	diamond	729	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
31447604	31447604	PRJNA949785_P_NODE_16596_length_248_cov_0.880000_g16399_i0	PRJNA949785	16596	248	0.88	2.1824	Microcoleus sp. FACHB-1	2692820	Bacteria	Bacteria	121	5.75e-34	NR	MBD2130230.1	2692820	g16399	i0	86.6	2.43145161290323	67	9	81	0	201	1	15	81	MBD2130230.1 hypothetical protein [Microcoleus sp. FACHB-1]	diamond	603	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-1
31833570	31833570	PRJNA949785_P_NODE_18417_length_243_cov_0.858824_g18220_i0	PRJNA949785	18417	243	0.858824	2.08694232	Cyanophyceae	3028117	Bacteria	Bacteria	55.8	1.4e-7	NR	WP_414589245.1	1680591	g18220	i0	43.2	1.8641975308642	81	39	91.4	2	6	227	52	132	WP_414589245.1 hypothetical protein [Scytonema sp. PCC 10023]	diamond	453	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
32206876	32206876	PRJNA949785_P_NODE_19098_length_241_cov_0.916667_g18901_i0	PRJNA949785	19098	241	0.916667	2.20916747	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	55.5	1.55e-7	NR	TAE66774.1	1151	g18901	i0	65.9	2.06639004149378	41	13	49.8	1	123	4	28	68	TAE66774.1 MAG: hypothetical protein EAZ86_19245 [Oscillatoriales cyanobacterium]	diamond	498	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
32206880	32206880	PRJNA949785_P_NODE_4838_length_514_cov_1.755102_g4641_i0	PRJNA949785	4838	514	1.755102	9.02122428	Prochlorococcus marinus	1219	Bacteria	Bacteria	50.1	6.55e-4	NR	WP_257008984.1	1219	g4641	i0	32.3	3.09922178988327	93	63	54.3	0	68	346	31	123	WP_257008984.1 photosystem II biogenesis protein Psp29 [Prochlorococcus marinus]	diamond	1593	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
32680619	32680619	PRJNA949785_P_NODE_18620_length_242_cov_0.911243_g18423_i0	PRJNA949785	18620	242	0.911243	2.20520806	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	140	8.529999999999999e-37	NR	HEY9892514.1	2762020	g18423	i0	96.2	0.979338842975207	79	3	97.9	0	5	241	90	168	HEY9892514.1 potassium-transporting ATPase subunit KdpB [Candidatus Sericytochromatia bacterium]	diamond	237	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium

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