metadata: contig_metadata: 8 rows where bioproject = "PRJNA529241", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA529241", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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_species
5604578	5604578	PRJNA529241_P_NODE_419345_length_168_cov_3.183206_g417023_i0	PRJNA529241	419345	168	3.183206	5.34778608	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	124	2.9499999999999994e-24	NTclustered	gi\|1850839647\|gb\|CP053446.1\|	2026749	g417023	i0	89.796	0.583333333333333	98	8	58	1	4	101	1398653	1398558	Ignavibacteriae bacterium isolate IGN2 chromosome	blastn	98	124	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
27235487	27235487	PRJNA529241_P_NODE_243563_length_173_cov_4.588235_g241241_i0	PRJNA529241	243563	173	4.588235	7.93764655	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	42.7	0.0148	NR	NLH60938.1	2049428	g241241	i0	76	0.867052023121387	25	6	43.4	0	172	98	420	444	NLH60938.1 PAS domain S-box protein [Ignavibacteriales bacterium]	diamond	150	42.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
27314081	27314081	PRJNA529241_P_NODE_502303_length_151_cov_4.833333_g499981_i0	PRJNA529241	502303	151	4.833333	7.29833283	Pseudomonadati	3379134	Bacteria	Bacteria	53.1	2.25e-6	NR	MBI3258330.1	2026749	g499981	i0	71.8	3.87417218543046	39	6	67.5	1	102	1	1	39	MBI3258330.1 argininosuccinate synthase [Ignavibacteriota bacterium]	diamond	585	53.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
27456931	27456931	PRJNA529241_P_NODE_483743_length_151_cov_6.473684_g481421_i0	PRJNA529241	483743	151	6.473684	9.77526284	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	61.2	8.41e-11	NR	MCC7158550.1	2053306	g481421	i0	75.6	0.894039735099338	45	10	87.4	1	19	150	5	49	MCC7158550.1 hypothetical protein [Ignavibacteria bacterium]	diamond	135	61.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27598339	27598339	PRJNA529241_P_NODE_75564_length_245_cov_1.312500_g73242_i0	PRJNA529241	75564	245	1.3125	3.215625	Bacteria	2	Bacteria	Bacteria	52	1.28e-5	NR	MCJ7552844.1	2651163	g73242	i0	43.5	1.62857142857143	69	36	83.3	2	5	208	135	201	MCJ7552844.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	399	52	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
28245905	28245905	PRJNA529241_P_NODE_84846_length_233_cov_4.515306_g82524_i0	PRJNA529241	84846	233	4.515306	10.520662980000001	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	53.9	8.08e-7	NR	MCX6151218.1	2049428	g82524	i0	76.5	0.875536480686695	34	8	43.8	0	131	232	1	34	MCX6151218.1 SRPBCC family protein [Ignavibacteriales bacterium]	diamond	204	53.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
28277372	28277372	PRJNA529241_P_NODE_102426_length_216_cov_1.089385_g100104_i0	PRJNA529241	102426	216	1.089385	2.3530716	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	65.1	2.23e-10	NR	MDR0926599.1	2053306	g100104	i0	41.4	4.65277777777778	70	41	97.2	0	214	5	115	184	MDR0926599.1 helix-turn-helix domain-containing protein [Ignavibacteria bacterium]	diamond	1005	65.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32290807	32290807	PRJNA529241_P_NODE_10339_length_844_cov_15.022305_g8769_i0	PRJNA529241	10339	844	15.022305	126.7882542	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	78.2	6.3e-13	NR	GJQ43864.1	2651163	g8769	i0	68.5	0.191943127962085	54	17	19.2	0	729	568	29	82	GJQ43864.1 MAG: hypothetical protein JETCAE03_33620 [Ignavibacteriaceae bacterium]	diamond	162	78.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae 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);;