metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax_kingdom = "Pseudomonadati"

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
4437306	4437306	PRJNA638724_P_NODE_4924_length_286_cov_1.314554_g4838_i0	PRJNA638724	4924	286	1.314554	3.75962444	Acinetobacter bereziniae	106648	Bacteria	Bacteria	160	1.9099999999999998e-47	NR	WP_333515275.1	106648	g4838	i0	91.2	0.954545454545455	91	8	95.5	0	274	2	11	101	WP_333515275.1 AAA family ATPase [Acinetobacter bereziniae]	diamond	273	160	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter bereziniae
27302380	27302380	PRJNA638724_P_NODE_7083_length_246_cov_0.890173_g6997_i0	PRJNA638724	7083	246	0.890173	2.18982558	Aquabacterium sp. G14	3130164	Bacteria	Bacteria	130	9.329999999999998e-37	NR	WP_339582258.1	3130164	g6997	i0	100	0.75609756097561	62	0	75.6	0	186	1	1	62	WP_339582258.1 AtaL-like protein [Aquabacterium sp. G14]	diamond	186	130	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. G14
28817575	28817575	PRJNA638724_P_NODE_2328_length_392_cov_2.253918_g2242_i0	PRJNA638724	2328	392	2.253918	8.83535856	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	46.2	0.0104	NR	RLB60749.1	2026735	g2242	i0	48.9	0.344387755102041	45	23	34.4	0	368	234	175	219	RLB60749.1 MAG: hypothetical protein DRI90_12965, partial [Deltaproteobacteria bacterium]	diamond	135	46.2	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29480649	29480649	PRJNA638724_P_NODE_7150_length_245_cov_0.895349_g7064_i0	PRJNA638724	7150	245	0.895349	2.19360505	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	44.7	0.008	NR	MCF7852967.1	2698248	g7064	i0	67.9	0.342857142857143	28	9	34.3	0	231	148	124	151	MCF7852967.1 ankyrin repeat domain-containing protein [Simkaniaceae bacterium]	diamond	84	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
29670029	29670029	PRJNA638724_P_NODE_6970_length_247_cov_0.885057_g6884_i0	PRJNA638724	6970	247	0.885057	2.18609079	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	158	3.88e-44	NR	WP_166550406.1	2683263	g6884	i0	97.5	0.97165991902834	80	2	97.2	0	242	3	200	279	WP_166550406.1 SusD/RagB family nutrient-binding outer membrane lipoprotein [Cellulophaga sp. BC115SP]	diamond	240	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
31756144	31756144	PRJNA638724_P_NODE_6877_length_248_cov_0.880000_g6791_i0	PRJNA638724	6877	248	0.88	2.1824	Prevotella sp. oral taxon 317	652721	Bacteria	Bacteria	156	6.76e-44	NR	WP_009229796.1	652721	g6791	i0	96.2	0.955645161290323	79	3	95.6	0	238	2	177	255	WP_009229796.1 imidazolonepropionase [Prevotella sp. oral taxon 317]	diamond	237	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 317
32230947	32230947	PRJNA638724_P_NODE_6878_length_248_cov_0.880000_g6792_i0	PRJNA638724	6878	248	0.88	2.1824	Bradyrhizobium sp. LHD-71	3072141	Bacteria	Bacteria	47.4	8.96e-4	NR	WP_308966524.1	3072141	g6792	i0	86.2	0.701612903225806	29	3	33.9	1	85	2	1	29	WP_308966524.1 serine hydrolase domain-containing protein [Bradyrhizobium sp. LHD-71]	diamond	174	47.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. LHD-71

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