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

7 rows where analysis = "diamond", bioproject = "PRJNA274362" 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
27010662	27010662	PRJNA274362_S_NODE_23882_length_192_cov_0.993007_g23762_i0	PRJNA274362	23882	192	0.993007	1.90657344	Mesonia maritima	1793873	Bacteria	Bacteria	51.6	8.5e-6	NR	WP_309727053.1	1793873	g23762	i0	40.7	1.703125	54	25	84.4	1	163	2	90	136	WP_309727053.1 metallophosphatase domain-containing protein [Mesonia maritima]	diamond	327	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Mesonia	Mesonia maritima
27074034	27074034	PRJNA274362_S_NODE_3922_length_419_cov_1.986486_g3802_i0	PRJNA274362	3922	419	1.986486	8.32337634	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	152	1.9e-42	NR	NBO61270.1	2044941	g3802	i0	63.3	3.90930787589499	139	43	94.5	4	2	397	184	321	NBO61270.1 hypothetical protein [Flavobacteriia bacterium]	diamond	1638	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
27958467	27958467	PRJNA274362_S_NODE_10085_length_274_cov_1.533333_g9965_i0	PRJNA274362	10085	274	1.533333	4.20133242	Alistipes shahii	328814	Bacteria	Bacteria	41.6	0.0214	NR	WP_302785946.1	328814	g9965	i0	47.7	0.481751824817518	44	22	47.1	1	7	135	16	59	WP_302785946.1 hypothetical protein, partial [Alistipes shahii]	diamond	132	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes shahii
28305772	28305772	PRJNA274362_S_NODE_33446_length_167_cov_0.881356_g33326_i0	PRJNA274362	33446	167	0.881356	1.47186452	Ferruginibacter sp.	1940288	Bacteria	Bacteria	87.8	7.76e-19	NR	HMT95829.1	1940288	g33326	i0	75.5	9.64670658682635	53	13	95.2	0	165	7	270	322	HMT95829.1 isocitrate dehydrogenase (NADP(+)) [Ferruginibacter sp.]	diamond	1611	87.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
28653141	28653141	PRJNA274362_S_NODE_13927_length_239_cov_1.731579_g13807_i0	PRJNA274362	13927	239	1.731579	4.13847381	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	46.6	0.00153	NR	HCL29403.1	2053570	g13807	i0	47.5	0.765690376569038	61	31	76.6	1	200	18	195	254	HCL29403.1 hypothetical protein [Candidatus Latescibacterota bacterium]	diamond	183	46.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
29821088	29821088	PRJNA274362_S_NODE_32111_length_169_cov_0.866667_g31991_i0	PRJNA274362	32111	169	0.866667	1.46466723	Pedobacter cryophilus	2571271	Bacteria	Bacteria	82	4.4e-17	NR	WP_136824426.1	2571271	g31991	i0	62.5	4.97041420118343	56	21	99.4	0	1	168	155	210	WP_136824426.1 SDR family oxidoreductase [Pedobacter cryophilus]	diamond	840	82	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter cryophilus
32192227	32192227	PRJNA274362_S_NODE_33638_length_167_cov_0.881356_g33518_i0	PRJNA274362	33638	167	0.881356	1.47186452	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.5	0.00644	NR	MBI4539274.1	2026742	g33518	i0	44.4	0.970059880239521	54	25	88	2	150	4	62	115	MBI4539274.1 adenylate kinase [Gemmatimonadota bacterium]	diamond	162	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;