metadata: contig_metadata: 5 rows where bioproject = "PRJNA725806", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA725806", 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
23664750	23664750	PRJNA725806_P_NODE_123439_length_182_cov_4.041379_g123137_i0	PRJNA725806	123439	182	4.041379	7.35530978	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2556928988\|gb\|CP129490.1\|	2614255	g123137	i0	100	0.153846153846154	28	0	15	0	106	133	1877060	1877033	MAG: Melioribacteraceae bacterium isolate cMAG.6 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
27621086	27621086	PRJNA725806_P_NODE_41584_length_262_cov_4.640000_g41287_i0	PRJNA725806	41584	262	4.64	12.1568	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	42.7	0.0464	NR	HPN37386.1	2614255	g41287	i0	34.4	0.698473282442748	61	37	69.8	2	54	236	488	545	HPN37386.1 hypothetical protein [Melioribacteraceae bacterium]	diamond	183	42.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
27841812	27841812	PRJNA725806_P_NODE_12224_length_357_cov_11.203125_g11936_i0	PRJNA725806	12224	357	11.203125	39.99515625	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	77.8	3.25e-14	NR	HEY6435395.1	2651163	g11936	i0	53.7	0.563025210084034	67	31	56.3	0	346	146	244	310	HEY6435395.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	201	77.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
31063586	31063586	PRJNA725806_P_NODE_59435_length_235_cov_9.570707_g59137_i0	PRJNA725806	59435	235	9.570707	22.49116145	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	45.8	0.00271	NR	MEE9431736.1	2614255	g59137	i0	39	0.753191489361702	59	32	70.2	1	201	37	156	214	MEE9431736.1 metallophosphoesterase [Melioribacteraceae bacterium]	diamond	177	45.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
32012146	32012146	PRJNA725806_P_NODE_6678_length_413_cov_3.462766_g6394_i0	PRJNA725806	6678	413	3.462766	14.30122358	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	166	7.97e-48	NR	HEY6435395.1	2651163	g6394	i0	62.6	0.893462469733656	123	46	89.3	0	394	26	83	205	HEY6435395.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	369	166	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);;