metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Minisyncoccota"

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_phylum	tax_species
28276345	28276345	PRJNA488043_P_NODE_8286_length_402_cov_1.914209_g6086_i0	PRJNA488043	8286	402	1.914209	7.69512018	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	128	4.98e-32	NR	MBP9771433.1	2053589	g6086	i0	67.7	0.694029850746269	93	29	68.7	1	121	396	303	395	MBP9771433.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	279	128	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28876338	28876338	PRJNA488043_P_NODE_7148_length_457_cov_2.390187_g5018_i0	PRJNA488043	7148	457	2.390187	10.92315459	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	82.4	3.82e-15	NR	MEX2053136.1	2053589	g5018	i0	52.8	1.15536105032823	89	24	58.4	1	5	271	171	241	MEX2053136.1 DUF2586 family protein [Candidatus Paceibacterota bacterium]	diamond	528	82.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29696929	29696929	PRJNA488043_P_NODE_7770_length_427_cov_2.060302_g5592_i0	PRJNA488043	7770	427	2.060302	8.79748954	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	181	6.57e-53	NR	MFA5715571.1	2053589	g5592	i0	64	0.955503512880562	136	48	94.8	1	416	12	1	136	MFA5715571.1 RNA-guided endonuclease TnpB family protein [Candidatus Paceibacterota bacterium]	diamond	408	181	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30202494	30202494	PRJNA488043_P_NODE_3752_length_736_cov_2.002829_g2094_i0	PRJNA488043	3752	736	2.002829	14.74082144	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	52.8	3.38e-5	NR	MBP6949126.1	2053589	g2094	i0	58.3	0.391304347826087	36	14	14.7	1	473	580	49	83	MBP6949126.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	288	52.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30644863	30644863	PRJNA488043_P_NODE_19573_length_176_cov_2.142857_g17331_i0	PRJNA488043	19573	176	2.142857	3.77142832	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	47.8	2.35e-5	NR	MFA5431976.1	2053589	g17331	i0	51.1	0.801136363636364	47	20	76.7	2	174	40	23	68	MFA5431976.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	141	47.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31846275	31846275	PRJNA488043_P_NODE_8537_length_392_cov_2.845730_g6329_i0	PRJNA488043	8537	392	2.84573	11.1552616	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.2	1.26e-8	NR	MEX2053136.1	2053589	g6329	i0	50	0.581632653061224	76	20	58.2	1	388	161	171	228	MEX2053136.1 DUF2586 family protein [Candidatus Paceibacterota bacterium]	diamond	228	63.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota 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);;