metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_order	tax_family	tax_species
27381876	27381876	PRJEB66218_P_NODE_65423_length_402_cov_1.469208_g63000_i0	PRJEB66218	65423	402	1.469208	5.90621616	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	152	1.85e-41	NR	MBA2660810.1	2946527	g63000	i0	69.8	0.791044776119403	106	32	79.1	0	320	3	5	110	MBA2660810.1 acetylglutamate kinase [Lujinxingiaceae bacterium]	diamond	318	152	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingiaceae bacterium
27785267	27785267	PRJEB66218_P_NODE_127084_length_265_cov_2.470588_g124655_i0	PRJEB66218	127084	265	2.470588	6.5470582	Pseudomonadota	1224	Bacteria	Bacteria	94	2.7e-22	NR	PIQ46194.1	1973977	g124655	i0	57.1	1.58490566037736	70	30	79.2	0	2	211	70	139	PIQ46194.1 MAG: hypothetical protein COW04_03485 [Deltaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_43_10]	diamond	420	94	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_43_10
28479774	28479774	PRJEB66218_P_NODE_89346_length_329_cov_1.578358_g86919_i0	PRJEB66218	89346	329	1.578358	5.19279782	Bacteria	2	Bacteria	Bacteria	76.3	1.2e-13	NR	OGQ06247.1	1797856	g86919	i0	49.1	2.89969604863222	106	52	96.7	2	12	329	134	237	OGQ06247.1 MAG: hypothetical protein A2712_05160 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	954	76.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
29300645	29300645	PRJEB66218_P_NODE_42169_length_535_cov_1.373418_g39763_i0	PRJEB66218	42169	535	1.373418	7.3477863	Spirochaetota	203691	Bacteria	Bacteria	113	1.79e-26	NR	OGQ06361.1	1797856	g39763	i0	41	4.82803738317757	178	100	98.7	4	534	7	175	349	OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	2583	114	0.991228070175439	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
29395350	29395350	PRJEB66218_P_NODE_123429_length_270_cov_1.775120_g121000_i0	PRJEB66218	123429	270	1.77512	4.792824	Bacteria	2	Bacteria	Bacteria	43.5	0.0267	NR	OGQ06247.1	1797856	g121000	i0	31.9	3.03333333333333	91	55	97.8	2	270	7	208	294	OGQ06247.1 MAG: hypothetical protein A2712_05160 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	819	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
30665908	30665908	PRJEB66218_P_NODE_237093_length_203_cov_0.915493_g234662_i0	PRJEB66218	237093	203	0.915493	1.85845079	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	55.5	1.98e-7	NR	MCZ6749535.1	2024889	g234662	i0	45.3	0.945812807881773	64	33	94.6	1	202	11	63	124	MCZ6749535.1 thermonuclease family protein [SAR324 cluster bacterium]	diamond	192	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			SAR324 cluster bacterium
31297823	31297823	PRJEB66218_P_NODE_108535_length_292_cov_0.991342_g106106_i0	PRJEB66218	108535	292	0.991342	2.89471864	Deltaproteobacteria bacterium DG_8	1703397	Bacteria	Bacteria	62	1.14e-8	NR	KPJ55820.1	1703397	g106106	i0	41.6	0.791095890410959	77	30	79.1	3	62	292	327	388	KPJ55820.1 MAG: hypothetical protein AMJ42_06195, partial [Deltaproteobacteria bacterium DG_8]	diamond	231	62	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium DG_8
32713707	32713707	PRJEB66218_P_NODE_93620_length_319_cov_2.108527_g91192_i0	PRJEB66218	93620	319	2.108527	6.72620113	Bacteria	2	Bacteria	Bacteria	50.1	2.37e-4	NR	OGQ06248.1	1797856	g91192	i0	38.3	1.42006269592476	81	49	75.2	1	251	12	408	488	OGQ06248.1 MAG: hypothetical protein A2712_05165 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	453	50.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
32776587	32776587	PRJEB66218_P_NODE_123720_length_270_cov_1.224880_g121291_i0	PRJEB66218	123720	270	1.22488	3.307176	Bacteria	2	Bacteria	Bacteria	52.4	2.01e-5	NR	OGQ06361.1	1797856	g121291	i0	35.2	2.84444444444444	88	53	93.3	2	16	267	36	123	OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	768	52.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49

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);;