metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_clade = "FCB 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
5237723	5237723	PRJEB73599_P_NODE_4165_length_335_cov_7.339869_g3878_i0	PRJEB73599	4165	335	7.339869	24.58856115	Thermoflexibacter	1938003	Bacteria	Bacteria	105	2.31e-27	NR	WP_091548537.1	1003	g3878	i0	75.4	1.16417910447761	65	16	58.2	0	218	24	1	65	WP_091548537.1 cold-shock protein [Thermoflexibacter ruber]	diamond	390	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Thermoflexibacteraceae	Thermoflexibacter	Thermoflexibacter ruber
27002271	27002271	PRJEB73599_P_NODE_6742_length_227_cov_1.429293_g6455_i0	PRJEB73599	6742	227	1.429293	3.24449511	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	108	2.82e-25	NR	MFN4253882.1	2202734	g6455	i0	56.8	1.94273127753304	74	32	97.8	0	2	223	167	240	MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	441	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
27034104	27034104	PRJEB73599_P_NODE_1062_length_732_cov_2.379801_g881_i0	PRJEB73599	1062	732	2.379801	17.42014332	Bacteroidota bacterium	1898104	Bacteria	Bacteria	114	6.3499999999999995e-25	NR	MES2731615.1	1898104	g881	i0	34.4	1.03688524590164	253	127	92.6	9	732	55	2094	2334	MES2731615.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Bacteroidota bacterium]	diamond	759	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27160269	27160269	PRJEB73599_P_NODE_262_length_1386_cov_4.453206_g196_i0	PRJEB73599	262	1386	4.453206	61.72143516	Spirosoma aerolatum	1211326	Bacteria	Bacteria	67.4	1.19e-8	NR	WP_080054425.1	1211326	g196	i0	37.9	0.222943722943723	103	55	21.4	4	1288	992	25	122	WP_080054425.1 hypothetical protein [Spirosoma aerolatum]	diamond	309	67.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aerolatum
28581780	28581780	PRJEB73599_P_NODE_647_length_932_cov_2.576966_g524_i0	PRJEB73599	647	932	2.576966	24.01732312	Candidatus Palauibacter soopunensis	3056739	Bacteria	Bacteria	196	1.94e-52	NR	WP_310756307.1	3056739	g524	i0	37.2	1.87982832618026	285	177	91.1	1	851	3	593	877	WP_310756307.1 polyketide synthase [Candidatus Palauibacter soopunensis]	diamond	1752	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales	Candidatus Palauibacteraceae	Candidatus Palauibacter	Candidatus Palauibacter soopunensis
28613214	28613214	PRJEB73599_P_NODE_8727_length_176_cov_2.013605_g8440_i0	PRJEB73599	8727	176	2.013605	3.5439448	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	60.5	8.43e-9	NR	MFN4253882.1	2202734	g8440	i0	56.9	0.869318181818182	51	20	86.9	2	174	22	115	163	MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	153	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
30319041	30319041	PRJEB73599_P_NODE_6332_length_240_cov_1.658768_g6045_i0	PRJEB73599	6332	240	1.658768	3.9810432	Flavobacterium sp.	239	Bacteria	Bacteria	78.6	7.4e-17	NR	WP_298150892.1	239	g6045	i0	65.5	0.6875	55	19	68.8	0	235	71	30	84	WP_298150892.1 hypothetical protein [Flavobacterium sp.]	diamond	165	78.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30571021	30571021	PRJEB73599_P_NODE_10053_length_152_cov_2.016260_g9766_i0	PRJEB73599	10053	152	2.01626	3.0647152	Sphingobacteriia bacterium	2035813	Bacteria	Bacteria	41.2	0.0324	NR	NCA72770.1	2035813	g9766	i0	51.9	0.532894736842105	27	13	53.3	0	50	130	135	161	NCA72770.1 hypothetical protein [Sphingobacteriia bacterium]	diamond	81	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium
30571023	30571023	PRJEB73599_P_NODE_3793_length_358_cov_1.911854_g3507_i0	PRJEB73599	3793	358	1.911854	6.84443732	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	155	5.8e-41	NR	MFN4253882.1	2202734	g3507	i0	54.1	1.02234636871508	122	53	99.7	1	1	357	179	300	MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	366	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
30571027	30571027	PRJEB73599_P_NODE_8793_length_175_cov_1.650685_g8506_i0	PRJEB73599	8793	175	1.650685	2.88869875	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	55.5	4.67e-7	NR	MDP2058583.1	1871037	g8506	i0	45	1.02857142857143	60	30	97.7	1	172	2	55	114	MDP2058583.1 HAD-IC family P-type ATPase [Flavobacteriaceae bacterium]	diamond	180	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
30824018	30824018	PRJEB73599_P_NODE_4294_length_329_cov_2.150000_g4007_i0	PRJEB73599	4294	329	2.15	7.0735	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	72	5.6e-12	NR	MEX2235615.1	2099675	g4007	i0	40	3.09118541033435	110	60	99.4	4	329	3	1105	1209	MEX2235615.1 ELWxxDGT repeat protein [Cyclobacteriaceae bacterium]	diamond	1017	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
30950604	30950604	PRJEB73599_P_NODE_8114_length_189_cov_2.581250_g7827_i0	PRJEB73599	8114	189	2.58125	4.8785625	Flavobacterium sp.	239	Bacteria	Bacteria	52.8	6.43e-7	NR	WP_298151086.1	239	g7827	i0	86.7	0.476190476190476	30	4	47.6	0	100	189	1	30	WP_298151086.1 hypothetical protein [Flavobacterium sp.]	diamond	90	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
32461467	32461467	PRJEB73599_P_NODE_899_length_790_cov_2.511170_g735_i0	PRJEB73599	899	790	2.51117	19.838243	Flavobacteriaceae	49546	Bacteria	Bacteria	85.1	6.06e-16	NR	WP_391594995.1	1883156	g735	i0	36.4	1.64050632911392	143	81	53.5	5	606	184	61	195	WP_391594995.1 hypothetical protein [Winogradskyella sp.]	diamond	1296	85.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sp.
32878326	32878326	PRJEB73599_P_NODE_1220_length_680_cov_2.688172_g1029_i0	PRJEB73599	1220	680	2.688172	18.2795696	Robertkochia marina	1227945	Bacteria	Bacteria	110	1.4e-25	NR	WP_224487878.1	1227945	g1029	i0	48.6	0.975	109	54	48.1	1	347	673	62	168	WP_224487878.1 hypothetical protein [Robertkochia marina]	diamond	663	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Robertkochia	Robertkochia marina

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