metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA576995" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA576995" and tax_clade = "PVC group"

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
9489265	9489265	PRJNA576995_P_NODE_43568_length_236_cov_2.742331_g42976_i0	PRJNA576995	43568	236	2.742331	6.47190116	Bacteria	2	Bacteria	Bacteria	125	3.7e-31	NR	MEW6156070.1	2026799	g42976	i0	73.1	4.95762711864407	78	21	99.2	0	236	3	892	969	MEW6156070.1 LamG domain-containing protein [Verrucomicrobiota bacterium]	diamond	1170	126	0.992063492063492	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
22237759	22237759	PRJNA576995_P_NODE_27878_length_289_cov_1.351852_g27286_i0	PRJNA576995	27878	289	1.351852	3.90685228	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	144	4.4e-39	NR	MBC7782499.1	2026778	g27286	i0	74	1.99307958477509	96	25	99.7	0	1	288	227	322	MBC7782499.1 glycosyltransferase family 4 protein [Phycisphaerae bacterium]	diamond	576	144	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27616797	27616797	PRJNA576995_P_NODE_42424_length_242_cov_0.911243_g41832_i0	PRJNA576995	42424	242	0.911243	2.20520806	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	48.1	4.57e-4	NR	MBC8105615.1	2026778	g41832	i0	42.3	0.880165289256198	71	40	86.8	1	226	17	197	267	MBC8105615.1 hypothetical protein [Phycisphaerae bacterium]	diamond	213	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28027244	28027244	PRJNA576995_P_NODE_38845_length_247_cov_0.885057_g38253_i0	PRJNA576995	38845	247	0.885057	2.18609079	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	141	6.8399999999999995e-37	NR	MDX1970569.1	2026779	g38253	i0	81.7	0.995951417004049	82	15	99.6	0	1	246	322	403	MDX1970569.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetaceae bacterium]	diamond	246	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28451326	28451326	PRJNA576995_P_NODE_5826_length_668_cov_0.983193_g5254_i0	PRJNA576995	5826	668	0.983193	6.56772924	Bacteria	2	Bacteria	Bacteria	101	1.28e-20	NR	MCE2811946.1	2026779	g5254	i0	37.7	3.23802395209581	175	99	74.1	4	552	58	163	337	MCE2811946.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	2163	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29384930	29384930	PRJNA576995_P_NODE_30649_length_275_cov_0.881188_g30057_i0	PRJNA576995	30649	275	0.881188	2.423267	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.1	0.0387	NR	HUO07241.1	2026778	g30057	i0	52.5	0.436363636363636	40	17	43.6	2	251	132	297	334	HUO07241.1 radical SAM family heme chaperone HemW [Phycisphaerae bacterium]	diamond	120	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30047809	30047809	PRJNA576995_P_NODE_42191_length_242_cov_0.911243_g41599_i0	PRJNA576995	42191	242	0.911243	2.20520806	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.6	4.32e-7	NR	MBS0187422.1	2026780	g41599	i0	48.1	1.00413223140496	81	36	95.5	3	238	8	41	119	MBS0187422.1 choice-of-anchor A family protein [Planctomycetota bacterium]	diamond	243	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30174331	30174331	PRJNA576995_P_NODE_41072_length_244_cov_0.900585_g40480_i0	PRJNA576995	41072	244	0.900585	2.1974274	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	42.7	0.0204	NR	MEN6367618.1	2691551	g40480	i0	34	0.614754098360656	50	29	56.6	1	16	153	100	149	MEN6367618.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	150	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
30314816	30314816	PRJNA576995_P_NODE_40372_length_245_cov_0.895349_g39780_i0	PRJNA576995	40372	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	74.3	1.51e-14	NR	MBL9159718.1	2026801	g39780	i0	50	3.28163265306122	70	35	85.7	0	240	31	68	137	MBL9159718.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	804	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30490389	30490389	PRJNA576995_P_NODE_35153_length_251_cov_0.865169_g34561_i0	PRJNA576995	35153	251	0.865169	2.17157419	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.9	0.016	NR	MBP7747433.1	2026778	g34561	i0	39.2	0.609561752988048	51	31	61	0	205	53	154	204	MBP7747433.1 hypothetical protein [Phycisphaerae bacterium]	diamond	153	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30616579	30616579	PRJNA576995_P_NODE_19033_length_345_cov_1.029412_g18441_i0	PRJNA576995	19033	345	1.029412	3.5514714	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	0.00178	NR	MBS0658504.1	2026799	g18441	i0	57.9	0.330434782608696	38	13	30.4	2	265	161	6	43	MBS0658504.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	114	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30616587	30616587	PRJNA576995_P_NODE_24113_length_311_cov_0.970588_g23521_i0	PRJNA576995	24113	311	0.970588	3.01852868	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.5	7.28e-10	NR	MEK7411798.1	2026780	g23521	i0	50.9	0.530546623794212	55	27	53.1	0	300	136	302	356	MEK7411798.1 hypothetical protein [Planctomycetota bacterium]	diamond	165	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30932728	30932728	PRJNA576995_P_NODE_34034_length_254_cov_2.066298_g33442_i0	PRJNA576995	34034	254	2.066298	5.24839692	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	74.3	3.140000000000001e-13	NR	MBX3364978.1	2026777	g33442	i0	51.3	2.82283464566929	78	23	92.1	2	16	249	312	374	MBX3364978.1 FAD-dependent oxidoreductase [Phycisphaeraceae bacterium]	diamond	717	74.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31059354	31059354	PRJNA576995_P_NODE_23235_length_316_cov_1.218107_g22643_i0	PRJNA576995	23235	316	1.218107	3.84921812	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0478	NR	MBS0619893.1	2026799	g22643	i0	28.9	0.920886075949367	97	57	92.1	3	295	5	464	548	MBS0619893.1 aconitate hydratase [Verrucomicrobiota bacterium]	diamond	291	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31248610	31248610	PRJNA576995_P_NODE_32575_length_264_cov_1.104712_g31983_i0	PRJNA576995	32575	264	1.104712	2.91643968	Chlamydiota bacterium	2081524	Bacteria	Bacteria	57.4	2.84e-7	NR	NGX54963.1	2081524	g31983	i0	49	0.579545454545455	51	26	58	0	111	263	16	66	NGX54963.1 hypothetical protein [Chlamydiota bacterium]	diamond	153	57.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31438334	31438334	PRJNA576995_P_NODE_3056_length_928_cov_1.540351_g2616_i0	PRJNA576995	3056	928	1.540351	14.29445728	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	55.1	9.18e-5	NR	MDD8043828.1	2026799	g2616	i0	39.2	0.239224137931034	74	41	22.6	1	909	700	168	241	MDD8043828.1 glutamine amidotransferase [Verrucomicrobiota bacterium]	diamond	222	55.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31976086	31976086	PRJNA576995_P_NODE_28098_length_288_cov_1.372093_g27506_i0	PRJNA576995	28098	288	1.372093	3.95162784	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	114	4.7e-27	NR	HMN42288.1	2052180	g27506	i0	60.2	0.96875	93	36	95.8	1	7	282	1361	1453	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	279	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32514370	32514370	PRJNA576995_P_NODE_39759_length_246_cov_0.872832_g39167_i0	PRJNA576995	39759	246	0.872832	2.14716672	Planctomycetia bacterium	2052181	Bacteria	Bacteria	45.1	0.00579	NR	MBL8799175.1	2052181	g39167	i0	32.4	1.60975609756098	71	42	79.3	1	206	12	340	410	MBL8799175.1 adenylate/guanylate cyclase domain-containing protein [Planctomycetia bacterium]	diamond	396	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
32653457	32653457	PRJNA576995_P_NODE_26460_length_297_cov_1.031250_g25868_i0	PRJNA576995	26460	297	1.03125	3.0628125	Planctomycetia	203683	Bacteria	Bacteria	48.1	2.38e-4	NR	MEZ6142109.1	1914240	g25868	i0	58.1	3.64646464646465	31	13	31.3	0	94	2	2	32	MEZ6142109.1 TspO/MBR family protein [Zavarzinella sp.]	diamond	1083	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella sp.

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