metadata: contig_metadata: 6 rows where bioproject = "PRJDB3785", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJDB3785", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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
9019	9019	PRJDB3785_S_NODE_9801_length_242_cov_1.067358_g9648_i0	PRJDB3785	9801	242	1.067358	2.58300636	Pseudomonadati	3379134	Bacteria	Bacteria	94	2.5e-20	NR	OIP95211.1	1817892	g9648	i0	53.2	2.7396694214876	79	36	97.9	1	5	241	141	218	OIP95211.1 MAG: hypothetical protein AUK40_06245 [Candidatus Wirthbacteria bacterium CG2_30_54_11]	diamond	663	94	1	Bacteria	Bacteria candidate phyla	Candidatus Wirthbacteria	Candidatus Wirthbacteria bacterium CG2_30_54_11
11486713	11486713	PRJDB3785_S_NODE_18630_length_183_cov_1.268657_g18477_i0	PRJDB3785	18630	183	1.268657	2.32164231	Bacteria	2	Bacteria	Bacteria	102	1.3299999999999995e-23	NR	MBU0646133.1	2052139	g18477	i0	80.3	14	61	12	100	0	1	183	374	434	MBU0646133.1 F0F1 ATP synthase subunit beta [Patescibacteria group bacterium]	diamond	2562	103	0.990291262135922	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
27380328	27380328	PRJDB3785_S_NODE_3663_length_400_cov_7.039886_g3510_i0	PRJDB3785	3663	400	7.039886	28.159544	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	54.7	7.52e-7	NR	RTL06915.1	2030827	g3510	i0	63.9	0.27	36	13	27	0	108	1	36	71	RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium]	diamond	108	54.7	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
28327194	28327194	PRJDB3785_S_NODE_17806_length_187_cov_0.934783_g17653_i0	PRJDB3785	17806	187	0.934783	1.74804421	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	51.6	1.34e-5	NR	MFA6016923.1	2052139	g17653	i0	46.8	1.70053475935829	47	25	75.4	0	44	184	363	409	MFA6016923.1 cation-translocating P-type ATPase [Patescibacteria group bacterium]	diamond	318	51.6	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
31644121	31644121	PRJDB3785_S_NODE_25177_length_164_cov_0.886957_g25024_i0	PRJDB3785	25177	164	0.886957	1.45460948	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	43.9	0.00503	NR	HBS47857.1	2030827	g25024	i0	50	0.878048780487805	48	21	82.3	1	7	141	531	578	HBS47857.1 hypothetical protein [Candidatus Dependentiae bacterium]	diamond	144	43.9	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota bacterium
32719264	32719264	PRJDB3785_S_NODE_3060_length_444_cov_2.521519_g2908_i0	PRJDB3785	3060	444	2.521519	11.19554436	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	57	2.06e-6	NR	RTL06913.1	2030827	g2908	i0	38.5	0.527027027027027	78	48	52.7	0	207	440	27	104	RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium]	diamond	234	57	1	Bacteria	Bacteria candidate phyla		Candidatus Babelota 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);;