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

12 rows where analysis = "diamond", bioproject = "PRJNA797475" 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
26895912	26895912	PRJNA797475_P_NODE_14301_length_287_cov_1.607477_g14202_i0	PRJNA797475	14301	287	1.607477	4.61345899	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	189	4.3e-58	NR	MBK8224185.1	2711154	g14202	i0	98.9	0.993031358885017	95	1	99.3	0	286	2	60	154	MBK8224185.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	285	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
26990361	26990361	PRJNA797475_P_NODE_2242_length_650_cov_1.906412_g2145_i0	PRJNA797475	2242	650	1.906412	12.391678	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	49.7	0.00288	NR	MBI3591571.1	2052166	g2145	i0	43.9	0.304615384615385	66	26	27.7	3	410	231	195	255	MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	198	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27085580	27085580	PRJNA797475_P_NODE_5262_length_438_cov_1.265753_g5164_i0	PRJNA797475	5262	438	1.265753	5.54399814	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	170	2.49e-49	NR	MBX9722485.1	2364082	g5164	i0	55.5	1	146	64	99.3	1	436	2	81	226	MBX9722485.1 pirin family protein [Candidatus Obscuribacterales bacterium]	diamond	438	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27116895	27116895	PRJNA797475_P_NODE_26542_length_245_cov_0.895349_g26443_i0	PRJNA797475	26542	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	155	4.64e-45	NR	HIN65143.1	2364082	g26443	i0	98.8	0.991836734693878	81	1	99.2	0	2	244	129	209	HIN65143.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27717711	27717711	PRJNA797475_P_NODE_16224_length_277_cov_1.509804_g16125_i0	PRJNA797475	16224	277	1.509804	4.18215708	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.7	0.0125	NR	MEB3260244.1	2847862	g16125	i0	36.8	0.823104693140794	76	44	80.1	2	55	276	2404	2477	MEB3260244.1 amino acid adenylation domain-containing protein [Cyanobacteriota bacterium]	diamond	228	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29138383	29138383	PRJNA797475_P_NODE_23809_length_248_cov_1.760000_g23710_i0	PRJNA797475	23809	248	1.76	4.3648	Pseudanabaena cinerea	2661616	Bacteria	Bacteria	50.4	4.65e-6	NR	WP_199302249.1	2661616	g23710	i0	36.5	0.762096774193548	63	40	76.2	0	246	58	6	68	WP_199302249.1 tetratricopeptide repeat protein [Pseudanabaena cinerea]	diamond	189	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena cinerea
29485180	29485180	PRJNA797475_P_NODE_25910_length_246_cov_0.890173_g25811_i0	PRJNA797475	25910	246	0.890173	2.18982558	Coleofasciculus sp. LEGE	3100458	Bacteria	Bacteria	116	1.18e-28	NR	WP_193933289.1	2777969	g25811	i0	68.2	2.08536585365854	85	23	98.8	1	2	244	196	280	WP_193933289.1 MFS transporter, partial [Coleofasciculus sp. LEGE 07092]	diamond	513	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. LEGE 07092
29611420	29611420	PRJNA797475_P_NODE_25210_length_247_cov_0.885057_g25111_i0	PRJNA797475	25210	247	0.885057	2.18609079	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	147	3.909999999999999e-41	NR	WP_250125609.1	155894	g25111	i0	95.1	9.95951417004049	82	4	99.6	0	2	247	55	136	WP_250125609.1 aspartate carbamoyltransferase catalytic subunit [Chroococcidiopsis sp. CCMEE 29]	diamond	2460	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
31476121	31476121	PRJNA797475_P_NODE_21596_length_251_cov_0.865169_g21497_i0	PRJNA797475	21596	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.17e-8	NR	MBX9950823.1	2364082	g21497	i0	87.5	0.764940239043825	32	4	38.2	0	9	104	212	243	MBX9950823.1 HAD family phosphatase [Candidatus Obscuribacterales bacterium]	diamond	192	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31485309	31485309	PRJNA797475_P_NODE_30996_length_228_cov_4.232258_g30897_i0	PRJNA797475	30996	228	4.232258	9.64954824	Bacteria	2	Bacteria	Bacteria	63.2	1.93e-9	NR	WP_124971646.1	1122	g30897	i0	50.9	1.89473684210526	57	28	75	0	56	226	16	72	WP_124971646.1 aminomethyl-transferring glycine dehydrogenase [Aphanothece sacrum]	diamond	432	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sacrum
31887132	31887132	PRJNA797475_P_NODE_29377_length_242_cov_0.911243_g29278_i0	PRJNA797475	29377	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.8	8.76e-20	NR	MBX9685384.1	2364082	g29278	i0	62	0.979338842975207	79	30	97.9	0	1	237	397	475	MBX9685384.1 AAA family ATPase [Candidatus Obscuribacterales bacterium]	diamond	237	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32709067	32709067	PRJNA797475_P_NODE_29960_length_241_cov_0.916667_g29861_i0	PRJNA797475	29960	241	0.916667	2.20916747	Acaryochloris sp. IP29b_bin.148	2969218	Bacteria	Bacteria	125	3.7099999999999997e-34	NR	WP_299411010.1	2969218	g29861	i0	73.4	0.983402489626556	79	21	98.3	0	3	239	83	161	WP_299411010.1 RICIN domain-containing protein [Acaryochloris sp. IP29b_bin.148]	diamond	237	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. IP29b_bin.148

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