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

9 rows where analysis = "blastn", bioproject = "PRJNA596867" 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
1843574	1843574	PRJNA596867_P_NODE_10762_length_257_cov_2.081522_g10687_i0	PRJNA596867	10762	257	2.081522	5.34951154	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	448	2.5499999999999995e-121	NTclustered	gi\|27530731\|dbj\|AB074612.1\|	152509	g10687	i0	98.054	103.964980544747	257	5	100	0	1	257	20	276	Uncultured Bacteroidetes bacterium gene for 16S rRNA, partial cds, clone:APe4_73	blastn	26719	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
4395602	4395602	PRJNA596867_P_NODE_14004_length_244_cov_0.900585_g13929_i0	PRJNA596867	14004	244	0.900585	2.1974274	Dysgonomonadaceae bacterium zrk40	2811465	Bacteria	Bacteria	265	2.6e-66	NTclustered	gi\|1992198317\|gb\|CP070276.1\|	2811465	g13929	i0	86.364	7.94262295081967	242	33	99	0	1	242	3008828	3008587	Dysgonomonadaceae bacterium zrk40 chromosome, complete genome	blastn	1938	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonomonadaceae bacterium zrk40
8221217	8221217	PRJNA596867_P_NODE_267_length_1152_cov_3.372567_g230_i0	PRJNA596867	267	1152	3.372567	38.85197184	Bacteroidales bacterium	2030927	Bacteria	Bacteria	1535	0	NTclustered	gi\|2621785016\|emb\|OY781474.1\|	2030927	g230	i0	90.784	506.53125	1161	89	100	16	1	1152	2632180	2633331	MAG: Bacteroidales bacterium isolate d554a065-6b18-4027-98a3-e240c86e67dd genome assembly, chromosome: 1	blastn	583524	1535	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
8793217	8793217	PRJNA596867_P_NODE_14207_length_243_cov_1.811765_g14132_i0	PRJNA596867	14207	243	1.811765	4.40258895	Chitinophagaceae	563835	Bacteria	Bacteria	219	2.0399999999999998e-52	NTclustered	gi\|2678854710\|gb\|CP144143.1\|	2962693	g14132	i0	83.065	178.950617283951	248	34	100	8	1	243	1745	1501	Mycovorax composti strain C216 chromosome, complete genome	blastn	43485	219	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Mycovorax	Mycovorax composti
9496438	9496438	PRJNA596867_P_NODE_3968_length_383_cov_1.032258_g3893_i0	PRJNA596867	3968	383	1.032258	3.95354814	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	453	8.570000000000001e-123	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g3893	i0	88.114	274.007832898172	387	39	100	7	1	383	54926	55309	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	104945	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
12619491	12619491	PRJNA596867_P_NODE_9830_length_268_cov_2.030769_g9755_i0	PRJNA596867	9830	268	2.030769	5.44246092	Cloacibacterium	501783	Bacteria	Bacteria	339	1.6799999999999998e-88	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g9755	i0	90.588	24.3731343283582	255	24	95	0	1	255	215060	214806	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	6532	340	0.997058823529412	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
19694395	19694395	PRJNA596867_P_NODE_11736_length_250_cov_0.870056_g11661_i0	PRJNA596867	11736	250	0.870056	2.17514	Cloacibacterium caeni	2004710	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g11661	i0	95.6	4.072	250	11	100	0	1	250	2055504	2055255	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	1018	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
23520402	23520402	PRJNA596867_P_NODE_14079_length_244_cov_0.900585_g14004_i0	PRJNA596867	14079	244	0.900585	2.1974274	Cloacibacterium caeni	2004710	Bacteria	Bacteria	392	1.14e-104	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g14004	i0	95.868	3.72131147540984	242	10	99	0	1	242	231735	231494	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	908	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
23520433	23520433	PRJNA596867_P_NODE_5139_length_346_cov_2.230769_g5064_i0	PRJNA596867	5139	346	2.230769	7.71846074	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	558	1.58e-154	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g5064	i0	95.93	278.627167630058	344	14	99	0	3	346	2978464	2978121	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	96405	558	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17

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