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

17 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Lentisphaerota"

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_species
20529225	20529225	PRJEB64798_P_NODE_228637_length_159_cov_4.500000_g226871_i0	PRJEB64798	228637	159	4.5	7.155	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	73.6	1.58e-13	NR	MCM8539423.1	2461380	g226871	i0	70	2.83018867924528	50	15	94.3	0	6	155	483	532	MCM8539423.1 DNA mismatch repair protein MutS [Lentisphaeraceae bacterium]	diamond	450	73.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaeraceae bacterium
27128114	27128114	PRJEB64798_P_NODE_167482_length_180_cov_1.877863_g165716_i0	PRJEB64798	167482	180	1.877863	3.3801534	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	94	6.4e-21	NR	MBQ9336655.1	2053569	g165716	i0	61.4	0.95	57	22	95	0	174	4	131	187	MBQ9336655.1 pyridoxal phosphate-dependent aminotransferase [Lentisphaeria bacterium]	diamond	171	94	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
27128198	27128198	PRJEB64798_P_NODE_23782_length_405_cov_4.224719_g22037_i0	PRJEB64798	23782	405	4.224719	17.11011195	Victivallaceae bacterium	2793042	Bacteria	Bacteria	58.5	6.78e-7	NR	MCQ2352893.1	2793042	g22037	i0	74.4	1.53333333333333	39	10	28.9	0	395	279	252	290	MCQ2352893.1 hypothetical protein [Victivallaceae bacterium]	diamond	621	58.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
27184735	27184735	PRJEB64798_P_NODE_234822_length_157_cov_2.944444_g233056_i0	PRJEB64798	234822	157	2.944444	4.62277708	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	7.07e-7	NR	MFA5205396.1	2053569	g233056	i0	68.6	1.29936305732484	35	11	66.9	0	8	112	377	411	MFA5205396.1 RHS repeat-associated core domain-containing protein [Lentisphaeria bacterium]	diamond	204	54.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
28069131	28069131	PRJEB64798_P_NODE_114365_length_209_cov_4.112500_g112599_i0	PRJEB64798	114365	209	4.1125	8.595125	Pseudomonadati	3379134	Bacteria	Bacteria	47.8	9.55e-5	NR	MBM4144520.1	1932692	g112599	i0	84	1.79425837320574	25	4	35.9	0	187	113	63	87	MBM4144520.1 four helix bundle protein [Lentisphaerota bacterium]	diamond	375	48.1	0.993762993762994	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
28100607	28100607	PRJEB64798_P_NODE_192905_length_169_cov_4.125000_g191139_i0	PRJEB64798	192905	169	4.125	6.97125	PVC group	1783257	Bacteria	Bacteria	100	8.22e-23	NR	NLE66141.1	1932692	g191139	i0	74.5	6.81656804733728	55	14	97.6	0	5	169	354	408	NLE66141.1 phosphoenolpyruvate carboxykinase (GTP) [Lentisphaerota bacterium]	diamond	1152	100	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
28581345	28581345	PRJEB64798_P_NODE_160047_length_183_cov_5.970149_g158281_i0	PRJEB64798	160047	183	5.970149	10.92537267	Victivallales bacterium	2212475	Bacteria	Bacteria	65.5	1.63e-10	NR	MBP5670755.1	2212475	g158281	i0	49.2	1.0327868852459	63	28	96.7	1	177	1	493	555	MBP5670755.1 protein kinase [Victivallales bacterium]	diamond	189	65.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
28581542	28581542	PRJEB64798_P_NODE_91267_length_212_cov_6.012270_g89501_i0	PRJEB64798	91267	212	6.01227	12.7460124	Lentisphaerae bacterium GWF2_5	1932692	Bacteria	Bacteria	59.7	1.25e-8	NR	OGV57117.1	1798574	g89501	i0	81.8	2.50471698113208	33	6	46.7	0	99	1	21	53	OGV57117.1 MAG: lysophospholipase [Lentisphaerae bacterium GWF2_50_93]	diamond	531	59.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium GWF2_50_93
28960373	28960373	PRJEB64798_P_NODE_169148_length_179_cov_3.153846_g167382_i0	PRJEB64798	169148	179	3.153846	5.64538434	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	68.6	5.19e-12	NR	MDP7398976.1	2053569	g167382	i0	56.9	0.854748603351955	51	21	85.5	1	179	27	158	207	MDP7398976.1 tyrosinase family protein [Lentisphaeria bacterium]	diamond	153	68.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
29212855	29212855	PRJEB64798_P_NODE_128549_length_199_cov_2.973333_g126783_i0	PRJEB64798	128549	199	2.973333	5.91693267	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	96.7	3.73e-23	NR	MFA5204569.1	2053569	g126783	i0	72.6	1.89949748743719	62	17	93.5	0	193	8	128	189	MFA5204569.1 hypothetical protein [Lentisphaeria bacterium]	diamond	378	96.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
30002213	30002213	PRJEB64798_P_NODE_113131_length_209_cov_10.968750_g111365_i0	PRJEB64798	113131	209	10.96875	22.9246875	Lentisphaerae bacterium ADurb.Bin242	1852900	Bacteria	Bacteria	43.9	0.00309	NR	OQA76217.1	1852900	g111365	i0	59.4	0.45933014354067	32	13	45.9	0	207	112	39	70	OQA76217.1 MAG: hypothetical protein BWY31_04653 [Lentisphaerae bacterium ADurb.Bin242]	diamond	96	43.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium ADurb.Bin242
30918567	30918567	PRJEB64798_P_NODE_171134_length_178_cov_4.170543_g169368_i0	PRJEB64798	171134	178	4.170543	7.42356654	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	47.4	3.03e-4	NR	MCE9616667.1	1932692	g169368	i0	51.1	0.792134831460674	47	23	79.2	0	146	6	156	202	MCE9616667.1 VPDSG-CTERM sorting domain-containing protein [Lentisphaerota bacterium]	diamond	141	47.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
31613908	31613908	PRJEB64798_P_NODE_143256_length_192_cov_1.237762_g141490_i0	PRJEB64798	143256	192	1.237762	2.37650304	Victivallaceae bacterium	2793042	Bacteria	Bacteria	107	1.78e-26	NR	MDD2480461.1	2793042	g141490	i0	73.3	0.9375	60	16	93.8	0	12	191	12	71	MDD2480461.1 DNA methyltransferase [Victivallaceae bacterium]	diamond	180	107	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
32303402	32303402	PRJEB64798_P_NODE_84159_length_213_cov_5.079268_g82393_i0	PRJEB64798	84159	213	5.079268	10.81884084	PVC group	1783257	Bacteria	Bacteria	113	2.3400000000000003e-27	NR	OQA84140.1	1852900	g82393	i0	81.2	43.7464788732394	69	12	97.2	1	211	5	323	390	OQA84140.1 MAG: Hydroxylamine reductase [Lentisphaerae bacterium ADurb.Bin242]	diamond	9318	113	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium ADurb.Bin242
32436837	32436837	PRJEB64798_P_NODE_185419_length_172_cov_3.455285_g183653_i0	PRJEB64798	185419	172	3.455285	5.9430902	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	54.7	8.46e-7	NR	MBR7131607.1	2053569	g183653	i0	54.3	2.54651162790698	46	21	80.2	0	11	148	223	268	MBR7131607.1 GTPase ObgE [Lentisphaeria bacterium]	diamond	438	54.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
32619191	32619191	PRJEB64798_P_NODE_186880_length_171_cov_9.950820_g185114_i0	PRJEB64798	186880	171	9.95082	17.0159022	Pseudomonadati	3379134	Bacteria	Bacteria	52	7.49e-6	NR	NLB70032.1	1932692	g185114	i0	55.1	5.05263157894737	49	20	82.5	1	163	23	215	263	NLB70032.1 replicative DNA helicase [Lentisphaerota bacterium]	diamond	864	52	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
32751960	32751960	PRJEB64798_P_NODE_114600_length_209_cov_3.418750_g112834_i0	PRJEB64798	114600	209	3.41875	7.1451875	Victivallaceae bacterium	2793042	Bacteria	Bacteria	55.1	8.52e-7	NR	MDD5698409.1	2793042	g112834	i0	69.7	1.89473684210526	33	10	47.4	0	111	209	63	95	MDD5698409.1 glucose-1-phosphate cytidylyltransferase [Victivallaceae bacterium]	diamond	396	55.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae 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);;