metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA690234" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA690234" 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
670378	670378	PRJNA690234_P_NODE_31181_length_243_cov_0.917647_g30814_i0	PRJNA690234	31181	243	0.917647	2.22988221	Cloacibacterium caeni	2004710	Bacteria	Bacteria	424	4.03e-114	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g30814	i0	98.34	3.95473251028807	241	4	99	0	1	241	1703420	1703660	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	961	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
5773764	5773764	PRJNA690234_P_NODE_24605_length_255_cov_1.686813_g24238_i0	PRJNA690234	24605	255	1.686813	4.30137315	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	366	7.28e-97	NTclustered	gi\|1640052653\|emb\|LR590484.1\|	259	g24238	i0	92.549	463.003921568627	255	19	100	0	1	255	1037431	1037685	Sphingobacterium thalpophilum strain NCTC11429 genome assembly, chromosome: 1	blastn	118066	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
6282857	6282857	PRJNA690234_P_NODE_20765_length_278_cov_2.439024_g20398_i0	PRJNA690234	20765	278	2.439024	6.78048672	Dysgonomonadaceae	2005520	Bacteria	Bacteria	431	2.81e-116	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g20398	i0	94.604	290.172661870504	278	15	100	0	1	278	1012783	1012506	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	80668	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
7048785	7048785	PRJNA690234_P_NODE_24546_length_255_cov_2.434066_g24179_i0	PRJNA690234	24546	255	2.434066	6.2068683	Dysgonomonadaceae bacterium zrk40	2811465	Bacteria	Bacteria	239	1.66e-58	NTclustered	gi\|1992198317\|gb\|CP070276.1\|	2811465	g24179	i0	87.264	323.576470588235	212	24	99	3	1	210	4980	5190	Dysgonomonadaceae bacterium zrk40 chromosome, complete genome	blastn	82512	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonomonadaceae bacterium zrk40
14698941	14698941	PRJNA690234_P_NODE_16412_length_314_cov_1.278008_g16045_i0	PRJNA690234	16412	314	1.278008	4.01294512	Hymenobacter sp. 21/4	369951	Bacteria	Bacteria	496	1.1299999999999999e-135	NTclustered	gi\|87042293\|gb\|DQ365992.1\|	369951	g16045	i0	95.223	99.8025477707006	314	13	99	2	1	313	273	585	Hymenobacter sp. 21/4 16S ribosomal RNA gene, partial sequence	blastn	31338	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 21/4
19797133	19797133	PRJNA690234_P_NODE_24696_length_254_cov_5.243094_g24329_i0	PRJNA690234	24696	254	5.243094	13.31745876	Cloacibacterium caeni	2004710	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g24329	i0	99.606	126.263779527559	254	1	100	0	1	254	1875941	1875688	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	32071	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
21072565	21072565	PRJNA690234_P_NODE_22117_length_270_cov_1.187817_g21750_i0	PRJNA690234	22117	270	1.187817	3.2071059	Mucilaginibacter robiniae	2728022	Bacteria	Bacteria	62.1	4.11e-5	NTclustered	gi\|1835012336\|gb\|CP051682.1\|	2728022	g21750	i0	92.857	0.155555555555556	42	3	16	0	51	92	3141518	3141559	Mucilaginibacter robiniae strain F39-2 chromosome, complete genome	blastn	42	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter robiniae
21072714	21072714	PRJNA690234_P_NODE_28077_length_248_cov_0.891429_g27710_i0	PRJNA690234	28077	248	0.891429	2.21074392	Cloacibacterium caeni	2004710	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g27710	i0	98.79	18.8709677419355	248	3	100	0	1	248	1190719	1190472	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4680	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24896449	24896449	PRJNA690234_P_NODE_25060_length_253_cov_0.866667_g24693_i0	PRJNA690234	25060	253	0.866667	2.19266751	Cloacibacterium normanense	237258	Bacteria	Bacteria	418	1.9599999999999994e-112	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g24693	i0	96.443	4.93280632411067	253	9	100	0	1	253	890718	890970	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1248	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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