metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1199893" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1199893" 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
6704578	6704578	PRJNA1199893_P_NODE_2106_length_659_cov_21.923208_g2033_i0	PRJNA1199893	2106	659	21.923208	144.47394072	Vibrio vulnificus	672	Bacteria	Bacteria	72.4	8.06e-13	NR	WP_224642647.1	672	g2033	i0	54.4	0.359635811836115	79	31	33.7	3	395	174	5	83	WP_224642647.1 hypothetical protein, partial [Vibrio vulnificus]	diamond	237	72.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio vulnificus
27135357	27135357	PRJNA1199893_P_NODE_14222_length_251_cov_0.865169_g14147_i0	PRJNA1199893	14222	251	0.865169	2.17157419	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.7	0.0404	NR	RPI26303.1	1978231	g14147	i0	40	0.717131474103586	60	30	69.3	2	31	204	96	151	RPI26303.1 MAG: GGDEF domain-containing protein [Acidobacteriota bacterium]	diamond	180	42.7	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28525478	28525478	PRJNA1199893_P_NODE_8727_length_323_cov_1.232000_g8652_i0	PRJNA1199893	8727	323	1.232	3.97936	Mariprofundaceae bacterium	2306050	Bacteria	Bacteria	97.1	2.64e-21	NR	HKI62304.1	2306050	g8652	i0	65.6	0.56656346749226	61	21	56.7	0	321	139	303	363	HKI62304.1 hypothetical protein [Mariprofundaceae bacterium]	diamond	183	97.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Candidatius Mariprofundia	Mariprofundales	Mariprofundaceae		Mariprofundaceae bacterium
29807039	29807039	PRJNA1199893_P_NODE_11171_length_286_cov_2.032864_g11096_i0	PRJNA1199893	11171	286	2.032864	5.81399104	Enterobacteriaceae	543	Bacteria	Bacteria	157	3.12e-46	NR	WP_317869804.1	573	g11096	i0	88.8	1.87762237762238	89	9	93.4	1	19	285	1	88	WP_317869804.1 Kunitz family serine protease inhibitor, partial [Klebsiella pneumoniae]	diamond	537	157	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
30040968	30040968	PRJNA1199893_P_NODE_15231_length_248_cov_0.880000_g15156_i0	PRJNA1199893	15231	248	0.88	2.1824	Arenibacter lacus	2608629	Bacteria	Bacteria	41.6	0.0478	NR	WP_150452469.1	2608629	g15156	i0	33.9	0.67741935483871	56	36	66.5	1	239	75	47	102	WP_150452469.1 VOC family protein [Arenibacter lacus]	diamond	168	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Arenibacter	Arenibacter lacus

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