metadata: contig_metadata: 7 rows where bioproject = "PRJNA741997", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA741997", tax_clade = "Bacteria candidate phyla" 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
12200949	12200949	PRJNA741997_P_NODE_58990_length_280_cov_1.458937_g57870_i0	PRJNA741997	58990	280	1.458937	4.0850236	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	177	2.76e-51	NR	MFA6050529.1	2053589	g57870	i0	89.1	0.985714285714286	92	10	98.6	0	278	3	138	229	MFA6050529.1 glycine--tRNA ligase [Candidatus Paceibacterota bacterium]	diamond	276	177	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27178790	27178790	PRJNA741997_P_NODE_72262_length_251_cov_0.865169_g71142_i0	PRJNA741997	72262	251	0.865169	2.17157419	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79	7.41e-15	NR	MDR3570672.1	2053589	g71142	i0	48	0.896414342629482	75	30	89.6	1	17	241	604	669	MDR3570672.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	225	79	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28600134	28600134	PRJNA741997_P_NODE_47007_length_316_cov_1.041152_g45887_i0	PRJNA741997	47007	316	1.041152	3.29004032	Candidatus Pacebacteria bacterium CG1	1974770	Bacteria	Bacteria	52	4.58e-5	NR	PIR60552.1	1974770	g45887	i0	37.1	1.57594936708861	89	47	78.8	4	15	263	170	255	PIR60552.1 MAG: helicase [Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_54]	diamond	498	52	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Candidatus Pacebacteria bacterium CG10_big_fil_rev_8_21_14_0_10_44_54
30715965	30715965	PRJNA741997_P_NODE_75814_length_249_cov_0.875000_g74694_i0	PRJNA741997	75814	249	0.875	2.17875	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	127	9.129999999999999e-32	NR	HLP77618.1	2053589	g74694	i0	70.7	2.96385542168675	82	24	98.8	0	247	2	161	242	HLP77618.1 lamin tail domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	738	127	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32107262	32107262	PRJNA741997_P_NODE_56238_length_286_cov_1.446009_g55118_i0	PRJNA741997	56238	286	1.446009	4.13558574	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	43.9	0.0244	NR	HUT96427.1	2053589	g55118	i0	38.2	0.797202797202797	76	40	75.5	4	283	68	105	177	HUT96427.1 restriction endonuclease subunit S [Candidatus Paceibacterota bacterium]	diamond	228	43.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32329146	32329146	PRJNA741997_P_NODE_62499_length_272_cov_1.542714_g61379_i0	PRJNA741997	62499	272	1.542714	4.19618208	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	119	1.11e-32	NR	MDR3570670.1	2053589	g61379	i0	73.1	0.860294117647059	78	19	83.8	1	28	255	5	82	MDR3570670.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	234	119	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32518909	32518909	PRJNA741997_P_NODE_47259_length_315_cov_1.161157_g46139_i0	PRJNA741997	47259	315	1.161157	3.65764455	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	57	9.04e-8	NR	MDR3582048.1	2053589	g46139	i0	43.8	1.47619047619048	73	40	68.6	1	216	1	47	119	MDR3582048.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	465	57	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);;