metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Rhodothermota"

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_genus	tax_species
26622117	26622117	PRJEB64798_P_NODE_163961_length_181_cov_8.537879_g162195_i0	PRJEB64798	163961	181	8.537879	15.45356099	Rhodothermales bacterium	2306054	Bacteria	Bacteria	66.6	6.2e-11	NR	MFT5516759.1	2306054	g162195	i0	50.9	1.85635359116022	55	27	91.2	0	8	172	60	114	MFT5516759.1 hypothetical protein [Rhodothermales bacterium]	diamond	336	66.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27508051	27508051	PRJEB64798_P_NODE_55883_length_261_cov_3.731132_g54118_i0	PRJEB64798	55883	261	3.731132	9.73825452	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52	1.76e-5	NR	MDX1529966.1	2306054	g54118	i0	51	2.54022988505747	49	23	56.3	1	202	56	99	146	MDX1529966.1 T9SS type A sorting domain-containing protein [Rhodothermales bacterium]	diamond	663	52	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28328689	28328689	PRJEB64798_P_NODE_83086_length_213_cov_7.554878_g81320_i0	PRJEB64798	83086	213	7.554878	16.09189014	Rhodothermia bacterium	2497633	Bacteria	Bacteria	45.4	0.00267	NR	MBN8588274.1	2497633	g81320	i0	52.6	0.535211267605634	38	18	53.5	0	95	208	39	76	MBN8588274.1 hypothetical protein [Rhodothermia bacterium]	diamond	114	45.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
28543042	28543042	PRJEB64798_P_NODE_97567_length_212_cov_3.625767_g95801_i0	PRJEB64798	97567	212	3.625767	7.68662604	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	3.14e-7	NR	MCA1803179.1	2026787	g95801	i0	75.9	3.41037735849057	29	7	41	0	8	94	225	253	MCA1803179.1 primosomal protein N' [Rhodothermaceae bacterium]	diamond	723	56.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
28833867	28833867	PRJEB64798_P_NODE_238448_length_155_cov_15.433962_g236682_i0	PRJEB64798	238448	155	15.433962	23.9226411	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52.8	3.22e-6	NR	HMB93905.1	2306054	g236682	i0	47.9	0.929032258064516	48	25	92.9	0	148	5	13	60	HMB93905.1 3-phosphoglycerate dehydrogenase family protein [Rhodothermales bacterium]	diamond	144	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29213046	29213046	PRJEB64798_P_NODE_57449_length_257_cov_5.269231_g55684_i0	PRJEB64798	57449	257	5.2692310000000004	13.54192367	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	68.2	5e-11	NR	WP_412061153.1	3391614	g55684	i0	61.5	0.607003891050584	52	20	60.7	0	163	8	96	147	WP_412061153.1 CHRD domain-containing protein [Rubrivirga sp. IMCC45206]	diamond	156	68.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
29244446	29244446	PRJEB64798_P_NODE_47429_length_285_cov_4.033898_g45664_i0	PRJEB64798	47429	285	4.033898	11.4966093	Rhodothermia bacterium	2497633	Bacteria	Bacteria	53.5	6.92e-6	NR	MBN8587674.1	2497633	g45664	i0	42.9	0.663157894736842	63	36	66.3	0	191	3	47	109	MBN8587674.1 YARHG domain-containing protein [Rhodothermia bacterium]	diamond	189	53.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
30191572	30191572	PRJEB64798_P_NODE_142872_length_192_cov_2.454545_g141106_i0	PRJEB64798	142872	192	2.454545	4.7127264	Rhodothermales bacterium	2306054	Bacteria	Bacteria	41.6	0.0489	NR	MEZ4701686.1	2306054	g141106	i0	46.3	0.640625	41	21	62.5	1	121	2	26	66	MEZ4701686.1 choice-of-anchor D domain-containing protein [Rhodothermales bacterium]	diamond	123	41.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30191615	30191615	PRJEB64798_P_NODE_177232_length_175_cov_9.476190_g175466_i0	PRJEB64798	177232	175	9.47619	16.5833325	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	82	2.15e-16	NR	HEX9952616.1	2838334	g175466	i0	55.2	1.98857142857143	58	26	99.4	0	1	174	462	519	HEX9952616.1 peptidase S9 [Rubricoccaceae bacterium]	diamond	348	82	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30507754	30507754	PRJEB64798_P_NODE_213333_length_164_cov_0.904348_g211567_i0	PRJEB64798	213333	164	0.904348	1.48313072	Rhodothermales bacterium	2306054	Bacteria	Bacteria	91.7	4.71e-20	NR	MFT5129571.1	2306054	g211567	i0	95.3	0.786585365853659	43	2	78.7	0	36	164	82	124	MFT5129571.1 putative aminopeptidase FrvX [Rhodothermales bacterium]	diamond	129	91.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;