metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA753112" 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
14757993	14757993	PRJNA753112_P_NODE_29612_length_251_cov_0.876404_g29270_i0	PRJNA753112	29612	251	0.876404	2.19977404	Tepidisphaera sp.	2017440	Bacteria	Bacteria	167	1.96e-48	NR	MBI1190304.1	2017440	g29270	i0	96.4	0.99203187250996006	83	3	99.2	0	2	250	290	372	MBI1190304.1 DUF444 family protein [Tepidisphaera sp.]	diamond	249	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
22879240	22879240	PRJNA753112_P_NODE_28898_length_253_cov_0.866667_g28556_i0	PRJNA753112	28898	253	0.866667	2.19266751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	108	2.11e-25	NR	MFA6044200.1	2052180	g28556	i0	67.1	1.00790513833992	85	25	98.4	2	251	3	16	99	MFA6044200.1 zinc-dependent metalloprotease [Phycisphaerales bacterium]	diamond	255	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
24955708	24955708	PRJNA753112_P_NODE_32300_length_245_cov_0.906977_g31958_i0	PRJNA753112	32300	245	0.906977	2.22209365	Tepidisphaera sp.	2017440	Bacteria	Bacteria	166	3.5199999999999995e-46	NR	MBI1189397.1	2017440	g31958	i0	97.5	0.991836734693878	81	2	99.2	0	243	1	289	369	MBI1189397.1 hypothetical protein [Tepidisphaera sp.]	diamond	243	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
26609482	26609482	PRJNA753112_P_NODE_5681_length_572_cov_3.687375_g5342_i0	PRJNA753112	5681	572	3.687375	21.091785	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.1	4.28e-5	NR	NLE59076.1	2026780	g5342	i0	47.4	0.508741258741259	97	35	49.3	3	269	550	499	582	NLE59076.1 calcium-binding protein [Planctomycetota bacterium]	diamond	291	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26926334	26926334	PRJNA753112_P_NODE_22322_length_288_cov_1.427907_g21980_i0	PRJNA753112	22322	288	1.427907	4.11237216	Tepidisphaera sp.	2017440	Bacteria	Bacteria	160	4.69e-47	NR	MBI1191057.1	2017440	g21980	i0	89.4	0.979166666666667	94	10	97.9	0	288	7	37	130	MBI1191057.1 sigma-70 family RNA polymerase sigma factor [Tepidisphaera sp.]	diamond	282	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
27779569	27779569	PRJNA753112_P_NODE_19184_length_310_cov_1.974684_g18842_i0	PRJNA753112	19184	310	1.974684	6.1215204	Tepidisphaera sp.	2017440	Bacteria	Bacteria	105	2.9e-25	NR	MBI1191532.1	2017440	g18842	i0	67.4	0.832258064516129	86	28	83.2	0	52	309	14	99	MBI1191532.1 PEP-CTERM sorting domain-containing protein [Tepidisphaera sp.]	diamond	258	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
28063532	28063532	PRJNA753112_P_NODE_27825_length_257_cov_2.353261_g27483_i0	PRJNA753112	27825	257	2.353261	6.04788077	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	47	0.00125	NR	WP_267672914.1	2995170	g27483	i0	45.3	1.21400778210117	53	28	61.9	1	98	256	35	86	WP_267672914.1 FAD:protein FMN transferase [Luteolibacter sp. SL250]	diamond	312	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
28537422	28537422	PRJNA753112_P_NODE_14267_length_360_cov_1.087108_g13925_i0	PRJNA753112	14267	360	1.087108	3.9135888	Tepidisphaera sp.	2017440	Bacteria	Bacteria	177	2.46e-53	NR	MBI1191011.1	2017440	g13925	i0	88.4	0.933333333333333	112	12	92.5	1	348	16	15	126	MBI1191011.1 OmpA family protein [Tepidisphaera sp.]	diamond	336	177	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
28821081	28821081	PRJNA753112_P_NODE_30288_length_249_cov_1.761364_g29946_i0	PRJNA753112	30288	249	1.761364	4.38579636	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	123	6.879999999999998e-32	NR	MFA6044316.1	2052180	g29946	i0	71.4	1.01204819277108	84	22	98.8	1	247	2	173	256	MFA6044316.1 type II secretion system protein [Phycisphaerales bacterium]	diamond	252	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29958056	29958056	PRJNA753112_P_NODE_24731_length_274_cov_1.552239_g24389_i0	PRJNA753112	24731	274	1.552239	4.25313486	Tepidisphaera sp.	2017440	Bacteria	Bacteria	53.1	8.18e-6	NR	MBI1191533.1	2017440	g24389	i0	96.9	0.35036496350365	32	1	35	0	176	271	1	32	MBI1191533.1 hypothetical protein [Tepidisphaera sp.]	diamond	96	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
30052749	30052749	PRJNA753112_P_NODE_15771_length_342_cov_1.159851_g15429_i0	PRJNA753112	15771	342	1.159851	3.96669042	Tepidisphaera sp.	2017440	Bacteria	Bacteria	191	3.8899999999999994e-57	NR	MBI1189954.1	2017440	g15429	i0	78.1	1	114	24	99.1	1	340	2	246	359	MBI1189954.1 hypothetical protein [Tepidisphaera sp.]	diamond	342	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
30179141	30179141	PRJNA753112_P_NODE_1932_length_993_cov_2.582609_g1679_i0	PRJNA753112	1932	993	2.582609	25.64530737	Tepidisphaera sp.	2017440	Bacteria	Bacteria	503	1.8399999999999995e-177	NR	MBI1189720.1	2017440	g1679	i0	88.1	0.88821752265861	294	35	88.8	0	928	47	1	294	MBI1189720.1 PEP-CTERM sorting domain-containing protein [Tepidisphaera sp.]	diamond	882	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
30811164	30811164	PRJNA753112_P_NODE_16374_length_335_cov_2.312977_g16032_i0	PRJNA753112	16374	335	2.312977	7.74847295	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	179	1.14e-53	NR	MFA6046562.1	2052180	g16032	i0	75.7	0.994029850746269	111	23	99.4	3	335	3	63	169	MFA6046562.1 type II secretion system protein [Phycisphaerales bacterium]	diamond	333	179	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31348596	31348596	PRJNA753112_P_NODE_8936_length_455_cov_1.583770_g8594_i0	PRJNA753112	8936	455	1.58377	7.2061535	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	53.1	7.26e-5	NR	MDF1852461.1	2026801	g8594	i0	48.1	0.342857142857143	52	25	34.3	1	19	174	1	50	MDF1852461.1 adenylate/guanylate cyclase domain-containing protein [Verrucomicrobiales bacterium]	diamond	156	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32708105	32708105	PRJNA753112_P_NODE_18480_length_316_cov_1.045267_g18138_i0	PRJNA753112	18480	316	1.045267	3.30304372	Tepidisphaera sp.	2017440	Bacteria	Bacteria	170	3.17e-50	NR	MBI1190784.1	2017440	g18138	i0	86.5	0.987341772151899	104	14	98.7	0	314	3	176	279	MBI1190784.1 hypothetical protein [Tepidisphaera sp.]	diamond	312	170	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
32771007	32771007	PRJNA753112_P_NODE_28780_length_253_cov_0.866667_g28438_i0	PRJNA753112	28780	253	0.866667	2.19266751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	144	9.31e-41	NR	MFA6046017.1	2052180	g28438	i0	83.3	0.99604743083004	84	13	98.4	1	249	1	6	89	MFA6046017.1 hypothetical protein [Phycisphaerales bacterium]	diamond	252	144	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;