metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1167252" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1167252" and tax_phylum = "Calditrichota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16891780	16891780	PRJNA1167252_P_NODE_28854_length_243_cov_0.917647_g28581_i0	PRJNA1167252	28854	243	0.917647	2.22988221	Caldithrix abyssi	187145	Bacteria	Bacteria	163	1.05e-46	NR	HHJ53042.1	187145	g28581	i0	91.3	0.987654320987654	80	7	98.8	0	242	3	104	183	HHJ53042.1 asparagine synthetase B [Caldithrix abyssi]	diamond	240	163	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
29345843	29345843	PRJNA1167252_P_NODE_24749_length_250_cov_0.881356_g24476_i0	PRJNA1167252	24749	250	0.881356	2.20339	Calditrichaceae bacterium	2614252	Bacteria	Bacteria	113	2.73e-28	NR	MEJ2053373.1	2614252	g24476	i0	67.5	1.944	80	26	96	0	9	248	14	93	MEJ2053373.1 calcium/sodium antiporter [Calditrichaceae bacterium]	diamond	486	113	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae		Calditrichaceae bacterium
29440165	29440165	PRJNA1167252_P_NODE_28310_length_244_cov_0.912281_g28037_i0	PRJNA1167252	28310	244	0.912281	2.22596564	Caldithrix abyssi	187145	Bacteria	Bacteria	101	4.019999999999999e-23	NR	WP_006927786.1	187145	g28037	i0	64.9	1.89344262295082	77	24	94.7	1	3	233	32	105	WP_006927786.1 hypothetical protein [Caldithrix abyssi]	diamond	462	101	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
29977287	29977287	PRJNA1167252_P_NODE_24651_length_250_cov_0.881356_g24378_i0	PRJNA1167252	24651	250	0.881356	2.20339	Calditrichota bacterium	2212469	Bacteria	Bacteria	42.7	0.0193	NR	RPI03390.1	2212469	g24378	i0	41.8	0.66	55	30	66	1	23	187	2	54	RPI03390.1 MAG: helix-hairpin-helix domain-containing protein [Calditrichota bacterium]	diamond	165	42.7	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30470648	30470648	PRJNA1167252_P_NODE_26913_length_246_cov_0.901734_g26640_i0	PRJNA1167252	26913	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	121	9.459999999999999e-34	NR	MCB0277388.1	2212469	g26640	i0	71.6	2.9390243902439	81	23	98.8	0	243	1	14	94	MCB0277388.1 VOC family protein [Calditrichota bacterium]	diamond	723	121	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30925408	30925408	PRJNA1167252_P_NODE_28134_length_244_cov_0.912281_g27861_i0	PRJNA1167252	28134	244	0.912281	2.22596564	Calditrichia bacterium	2268178	Bacteria	Bacteria	139	3.0899999999999997e-37	NR	MCK5077018.1	2268178	g27861	i0	83.8	0.983606557377049	80	13	98.4	0	240	1	226	305	MCK5077018.1 electron transport complex subunit RsxC [Calditrichia bacterium]	diamond	240	139	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
32221852	32221852	PRJNA1167252_P_NODE_24538_length_250_cov_0.881356_g24265_i0	PRJNA1167252	24538	250	0.881356	2.20339	Calditrichia bacterium	2268178	Bacteria	Bacteria	77	2.67e-14	NR	MCK5077991.1	2268178	g24265	i0	62.5	0.672	56	21	67.2	0	2	169	199	254	MCK5077991.1 tetratricopeptide repeat protein [Calditrichia bacterium]	diamond	168	77	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
32758776	32758776	PRJNA1167252_P_NODE_27520_length_245_cov_0.906977_g27247_i0	PRJNA1167252	27520	245	0.906977	2.22209365	Calditrichota bacterium	2212469	Bacteria	Bacteria	147	3.91e-40	NR	NOZ56145.1	2212469	g27247	i0	91.4	0.991836734693878	81	7	99.2	0	245	3	272	352	NOZ56145.1 cytochrome ubiquinol oxidase subunit I [Calditrichota bacterium]	diamond	243	147	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota 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);;