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

10 rows where analysis = "diamond", bioproject = "PRJNA1199893" and tax_superkingdom = "Bacteria"

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
26692665	26692665	PRJNA1199893_P_NODE_14321_length_251_cov_0.865169_g14246_i0	PRJNA1199893	14321	251	0.865169	2.17157419	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	47	3.91e-4	NR	HSS71954.1	2838783	g14246	i0	100	10.4462151394422	23	0	27.5	0	2	70	109	131	HSS71954.1 30S ribosomal protein S9 [Gaiellaceae bacterium]	diamond	2622	47	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
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
27609743	27609743	PRJNA1199893_P_NODE_16464_length_244_cov_0.900585_g16389_i0	PRJNA1199893	16464	244	0.900585	2.1974274	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22	2013750	Bacteria	Bacteria	44.7	0.00763	NR	PKN16874.1	2013750	g16389	i0	32.8	0.786885245901639	64	20	78.7	1	3	194	406	446	PKN16874.1 MAG: hypothetical protein CVU65_18765 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22]	diamond	192	44.7	1	Bacteria	delta/epsilon subdivisions			Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22
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
30388953	30388953	PRJNA1199893_P_NODE_15713_length_246_cov_1.086705_g15638_i0	PRJNA1199893	15713	246	1.086705	2.6732943	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	47	1.65e-4	NR	WP_252130143.1	1590	g15638	i0	87.5	1.75609756097561	24	3	29.3	0	3	74	66	89	WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	432	47	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
30957430	30957430	PRJNA1199893_P_NODE_12014_length_276_cov_1.423645_g11939_i0	PRJNA1199893	12014	276	1.423645	3.9292602	Streptococcus pyogenes	1314	Bacteria	Bacteria	49.7	1.72e-4	NR	WP_317582632.1	1314	g11939	i0	54.4	0.619565217391304	57	24	59.8	2	74	238	27	83	WP_317582632.1 hypothetical protein, partial [Streptococcus pyogenes]	diamond	171	49.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pyogenes
32664595	32664595	PRJNA1199893_P_NODE_15020_length_248_cov_1.262857_g14945_i0	PRJNA1199893	15020	248	1.262857	3.13188536	bacterium	1869227	Bacteria	Bacteria	42.7	0.038	NR	GIR20681.1	1869227	g14945	i0	43.1	0.701612903225806	58	30	70.2	2	246	73	40	94	GIR20681.1 MAG: hypothetical protein CM15mP35_09420 [bacterium]	diamond	174	42.7	1	Bacteria								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);;