metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA664479" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA664479" 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
1905253	1905253	PRJNA664479_S_NODE_1222_length_429_cov_2.005263_g1146_i0	PRJNA664479	1222	429	2.005263	8.60257827	Empedobacter stercoris	1628248	Bacteria	Bacteria	776	0	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g1146	i0	99.301	355.594405594406	429	3	100	0	1	429	1406515	1406943	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	152550	776	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
4457078	4457078	PRJNA664479_S_NODE_6904_length_212_cov_1.061350_g6828_i0	PRJNA664479	6904	212	1.06135	2.250062	Flavobacterium alkalisoli	2602769	Bacteria	Bacteria	60.2	1.11e-4	NTclustered	gi\|1724793953\|gb\|CP042831.1\|	2602769	g6828	i0	91.304	0.216981132075472	46	1	22	3	86	131	1713469	1713511	Flavobacterium alkalisoli strain XS-5 chromosome, complete genome	blastn	46	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium alkalisoli
4990553	4990553	PRJNA664479_S_NODE_17064_length_163_cov_1.342105_g16988_i0	PRJNA664479	17064	163	1.342105	2.18763115	Flavobacterium	237	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2306666110\|emb\|OX336425.1\|	1114861	g16988	i0	100	450.901840490798	163	0	100	0	1	163	24392	24554	Flavobacterium collinsii strain TRV642 genome assembly, chromosome: TRV642	blastn	73497	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii
8282388	8282388	PRJNA664479_S_NODE_9107_length_193_cov_6.097222_g9031_i0	PRJNA664479	9107	193	6.097222	11.76763846	Apibacter raozihei	2500547	Bacteria	Bacteria	302	1.5e-77	NTclustered	gi\|1554515621\|gb\|CP034930.1\|	2500547	g9031	i0	94.819	470.761658031088	193	10	100	0	1	193	781316	781124	Apibacter raozihei strain HY041 chromosome, complete genome	blastn	90857	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Apibacter	Apibacter raozihei
9557643	9557643	PRJNA664479_S_NODE_16548_length_164_cov_0.886957_g16472_i0	PRJNA664479	16548	164	0.886957	1.45460948	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g16472	i0	96.951	9.61585365853658	164	5	100	0	1	164	2560096	2559933	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	1577	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
12108482	12108482	PRJNA664479_S_NODE_15690_length_165_cov_0.879310_g15614_i0	PRJNA664479	15690	165	0.87931	1.4508615	Epilithonimonas zeae	1416779	Bacteria	Bacteria	161	2.2e-35	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g15614	i0	84.242	1.95151515151515	165	26	100	0	1	165	3540019	3539855	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	322	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
12108483	12108483	PRJNA664479_S_NODE_15790_length_165_cov_0.879310_g15714_i0	PRJNA664479	15790	165	0.87931	1.4508615	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	287	3.47e-73	NTclustered	gi\|1958230772\|gb\|CP068083.1\|	258	g15714	i0	98.171	4.9030303030303	164	3	99	0	1	164	1857885	1857722	Sphingobacterium spiritivorum strain FDAARGOS_1145 chromosome, complete genome	blastn	809	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
13916230	13916230	PRJNA664479_S_NODE_2931_length_294_cov_1.355102_g2855_i0	PRJNA664479	2931	294	1.355102	3.98399988	Flavobacteriales	200644	Bacteria	Bacteria	534	2.2199999999999998e-147	NTclustered	gi\|1896493618\|gb\|MT921741.1\|	247	g2855	i0	99.32	111.979591836735	294	2	100	0	1	294	468	761	Empedobacter brevis strain DPBS068 16S ribosomal RNA gene, partial sequence	blastn	32922	538	0.992565055762082	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
14658116	14658116	PRJNA664479_S_NODE_17992_length_162_cov_0.902655_g17916_i0	PRJNA664479	17992	162	0.902655	1.4623011	Epilithonimonas zeae	1416779	Bacteria	Bacteria	202	1.26e-47	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g17916	i0	89.024	3.84567901234568	164	16	100	1	1	162	3379468	3379305	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	623	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
17207203	17207203	PRJNA664479_S_NODE_15774_length_165_cov_0.879310_g15698_i0	PRJNA664479	15774	165	0.87931	1.4508615	Chryseobacterium sp. CY350	2997336	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|2430443073\|gb\|CP116034.1\|	2997336	g15698	i0	84.173	1.56969696969697	139	19	84	3	28	165	3954901	3955037	Chryseobacterium sp. CY350 chromosome, complete genome	blastn	259	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. CY350
17207211	17207211	PRJNA664479_S_NODE_3154_length_285_cov_1.394068_g3078_i0	PRJNA664479	3154	285	1.394068	3.9730938	Empedobacter falsenii	343874	Bacteria	Bacteria	390	4.909999999999998e-104	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g3078	i0	95.142	330.347368421053	247	12	87	0	3	249	522419	522173	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	94149	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
18481564	18481564	PRJNA664479_S_NODE_5775_length_225_cov_2.562500_g5699_i0	PRJNA664479	5775	225	2.5625	5.765625	Empedobacter stercoris	1628248	Bacteria	Bacteria	394	2.89e-105	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g5699	i0	98.222	679.902222222222	225	4	100	0	1	225	85301	85525	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	152978	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
19013852	19013852	PRJNA664479_S_NODE_7935_length_202_cov_2.026144_g7859_i0	PRJNA664479	7935	202	2.026144	4.09281088	Weeksellaceae	2762318	Bacteria	Bacteria	335	1.5599999999999993e-87	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g7859	i0	97	230.311881188119	200	4	98	2	5	202	522034	522233	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	46523	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
21031694	21031694	PRJNA664479_S_NODE_18897_length_161_cov_0.910714_g18821_i0	PRJNA664479	18897	161	0.910714	1.46624954	Prevotella melaninogenica	28132	Bacteria	Bacteria	222	9.63e-54	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g18821	i0	91.824	27.0186335403727	159	13	100	0	3	161	1641183	1641025	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	4350	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
22839686	22839686	PRJNA664479_S_NODE_17918_length_162_cov_0.902655_g17842_i0	PRJNA664479	17918	162	0.902655	1.4623011	Sphingobacterium	28453	Bacteria	Bacteria	244	2.07e-60	NTclustered	gi\|2831337980\|gb\|CP171136.1\|	1768011	g17842	i0	93.827	2.91975308641975	162	10	100	0	1	162	1396904	1396743	Sphingobacterium cellulitidis strain WGS1282 chromosome, complete genome	blastn	473	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium cellulitidis
24855402	24855402	PRJNA664479_S_NODE_15800_length_165_cov_0.879310_g15724_i0	PRJNA664479	15800	165	0.87931	1.4508615	Winogradskyella sediminis	1382466	Bacteria	Bacteria	108	2.9e-19	NTclustered	gi\|1085942643\|emb\|LT629774.1\|	1382466	g15724	i0	80.272	0.890909090909091	147	25	88	3	2	146	741407	741551	Winogradskyella sediminis strain RHA_55 genome assembly, chromosome: I	blastn	147	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella sediminis

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