metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Planctomycetota"

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
27539168	27539168	PRJEB49404_P_NODE_579984_length_163_cov_1.919355_g566183_i0	PRJEB49404	579984	163	1.919355	3.12854865	Planctomycetales bacterium	2053591	Bacteria	Bacteria	42.7	0.0128	NR	HBI42287.1	2053591	g566183	i0	40	0.736196319018405	40	24	73.6	0	159	40	197	236	HBI42287.1 hypothetical protein [Planctomycetales bacterium]	diamond	120	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
28012869	28012869	PRJEB49404_P_NODE_390965_length_217_cov_2.567416_g377164_i0	PRJEB49404	390965	217	2.567416	5.57129272	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.0074400000000000004	NR	MEN9554679.1	2026780	g377164	i0	48.8	0.566820276497696	41	20	55.3	1	87	206	403	443	MEN9554679.1 hypothetical protein [Planctomycetota bacterium]	diamond	123	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28296727	28296727	PRJEB49404_P_NODE_370946_length_226_cov_1.550802_g357145_i0	PRJEB49404	370946	226	1.550802	3.50481252	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	58.9	5.05e-8	NR	HVP12053.1	2026778	g357145	i0	62.8	0.570796460176991	43	16	57.1	0	131	3	101	143	HVP12053.1 tyrosine-type recombinase/integrase [Phycisphaerae bacterium]	diamond	129	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28612625	28612625	PRJEB49404_P_NODE_257027_length_295_cov_0.867188_g243226_i0	PRJEB49404	257027	295	0.867188	2.5582046	Crateriforma	2714592	Bacteria	Bacteria	44.3	0.0194	NR	WP_146413112.1	2714592	g243226	i0	31.3	0.650847457627119	64	43	65.1	1	198	7	60	122	WP_146413112.1 MULTISPECIES: DUF58 domain-containing protein [Crateriforma]	diamond	192	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma
28833588	28833588	PRJEB49404_P_NODE_465028_length_192_cov_0.980392_g451227_i0	PRJEB49404	465028	192	0.980392	1.88235264	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0371	NR	MSR63606.1	2026780	g451227	i0	43.2	0.6875	44	21	62.5	1	168	49	334	377	MSR63606.1 hypothetical protein [Planctomycetota bacterium]	diamond	132	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29654164	29654164	PRJEB49404_P_NODE_553070_length_169_cov_1.261538_g539269_i0	PRJEB49404	553070	169	1.261538	2.13199922	Planctomycetota bacterium	2026780	Bacteria	Bacteria	59.3	1.96e-8	NR	MBI3818226.1	2026780	g539269	i0	59.3	0.958579881656805	54	20	94.1	2	11	169	61	113	MBI3818226.1 hypothetical protein [Planctomycetota bacterium]	diamond	162	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30254972	30254972	PRJEB49404_P_NODE_245872_length_304_cov_1.811321_g232071_i0	PRJEB49404	245872	304	1.811321	5.50641584	Caulifigura sp.	2795792	Bacteria	Bacteria	45.4	0.00273	NR	HVJ66931.1	2795792	g232071	i0	65.5	0.572368421052632	29	10	28.6	0	133	47	1	29	HVJ66931.1 ribonuclease E inhibitor RraB [Caulifigura sp.]	diamond	174	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura sp.
30539021	30539021	PRJEB49404_P_NODE_493733_length_183_cov_2.520833_g479932_i0	PRJEB49404	493733	183	2.520833	4.61312439	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	2.12e-4	NR	MEO1129876.1	2026780	g479932	i0	52.6	2.54098360655738	38	18	62.3	0	69	182	14	51	MEO1129876.1 response regulator [Planctomycetota bacterium]	diamond	465	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31480830	31480830	PRJEB49404_P_NODE_332196_length_245_cov_1.684466_g318395_i0	PRJEB49404	332196	245	1.684466	4.1269417	Bacteria	2	Bacteria	Bacteria	117	7.7699999999999995e-31	NR	HZZ76997.1	2052164	g318395	i0	74.1	1.98367346938776	81	21	99.2	0	243	1	39	119	HZZ76997.1 response regulator transcription factor [Gemmataceae bacterium]	diamond	486	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31708611	31708611	PRJEB49404_P_NODE_207657_length_343_cov_1.615132_g193858_i0	PRJEB49404	207657	343	1.615132	5.53990276	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.4	7.54e-21	NR	HLX60309.1	2026780	g193858	i0	57.7	0.848396501457726	97	38	84.8	2	50	340	382	475	HLX60309.1 DUF3560 domain-containing protein [Planctomycetota bacterium]	diamond	291	97.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31708619	31708619	PRJEB49404_P_NODE_417817_length_207_cov_1.732143_g404016_i0	PRJEB49404	417817	207	1.732143	3.58553601	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	69.7	4.15e-12	NR	HEV8604292.1	2876886	g404016	i0	87.9	0.478260869565217	33	4	47.8	0	100	2	1	33	HEV8604292.1 polyphosphate kinase 2 family protein [Tepidisphaeraceae bacterium]	diamond	99	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31834965	31834965	PRJEB49404_P_NODE_440157_length_199_cov_2.200000_g426356_i0	PRJEB49404	440157	199	2.2	4.378	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.5	1.18e-8	NR	RLT20878.1	2026780	g426356	i0	48.1	1.58291457286432	54	28	81.4	0	4	165	635	688	RLT20878.1 MAG: TonB-dependent receptor [Planctomycetota bacterium]	diamond	315	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;