metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA738523" 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
1197727	1197727	PRJNA738523_P_NODE_9441_length_260_cov_1.647059_g9370_i0	PRJNA738523	9441	260	1.647059	4.2823534	Elizabethkingia	308865	Bacteria	Bacteria	436	5.600000000000001e-118	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g9370	i0	96.923	85.4038461538462	260	8	100	0	1	260	313881	314140	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	22205	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
2473139	2473139	PRJNA738523_P_NODE_7542_length_278_cov_2.321951_g7471_i0	PRJNA738523	7542	278	2.321951	6.45502378	Chitinophagaceae	563835	Bacteria	Bacteria	505	1.63e-138	NTclustered	gi\|1033838715\|gb\|CP015772.1\|	1176587	g7471	i0	100	282.420863309353	273	0	98	0	6	278	996187	995915	Niabella ginsenosidivorans strain BS26 chromosome, complete genome	blastn	78513	508	0.99409448818897606	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella ginsenosidivorans
4548001	4548001	PRJNA738523_P_NODE_10904_length_251_cov_0.865169_g10833_i0	PRJNA738523	10904	251	0.865169	2.17157419	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	390	4.239999999999999e-104	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g10833	i0	94.841	201.067729083665	252	9	99	4	1	249	4833359	4833109	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	50468	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
4548021	4548021	PRJNA738523_P_NODE_13924_length_245_cov_0.895349_g13853_i0	PRJNA738523	13924	245	0.895349	2.19360505	Barnesiella sp. An22	1965590	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2729058714\|emb\|OZ007014.1\|	1965590	g13853	i0	99.592	7.69387755102041	245	1	100	0	1	245	991843	992087	MAG: Barnesiella sp. An22 isolate 6737_HOM_CTRL_s26.ctg000031c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	1885	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Barnesiella	Barnesiella sp. An22
6301795	6301795	PRJNA738523_P_NODE_9265_length_262_cov_1.449735_g9194_i0	PRJNA738523	9265	262	1.449735	3.7983057	Chryseobacterium	59732	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g9194	i0	100	474.519083969466	262	0	100	0	1	262	1758167	1757906	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	124324	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
8372847	8372847	PRJNA738523_P_NODE_5487_length_308_cov_1.310638_g5416_i0	PRJNA738523	5487	308	1.310638	4.03676504	Lewinella sp. LCG006	3231911	Bacteria	Bacteria	440	5.249999999999999e-119	NTclustered	gi\|2773055173\|gb\|CP160680.1\|	3231911	g5416	i0	92.532	385.902597402597	308	22	100	1	1	308	2513176	2513482	Lewinella sp. LCG006 chromosome, complete genome	blastn	118858	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp. LCG006
13473349	13473349	PRJNA738523_P_NODE_12251_length_248_cov_0.880000_g12180_i0	PRJNA738523	12251	248	0.88	2.1824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g12180	i0	84.711	185.254032258065	242	19	93	14	1	230	1593644	1593879	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	45943	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13473360	13473360	PRJNA738523_P_NODE_13431_length_246_cov_0.890173_g13360_i0	PRJNA738523	13431	246	0.890173	2.18982558	Chryseobacterium sp. C-71	2893882	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|2153927454\|gb\|CP087131.1\|	2893882	g13360	i0	95.951	3.35772357723577	247	9	100	1	1	246	3587744	3587498	Chryseobacterium sp. C-71 chromosome, complete genome	blastn	826	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. C-71
13473377	13473377	PRJNA738523_P_NODE_16171_length_241_cov_0.916667_g16100_i0	PRJNA738523	16171	241	0.916667	2.20916747	Dyadobacter sp. 32	538966	Bacteria	Bacteria	377	3.1500000000000003e-100	NTclustered	gi\|1768674615\|emb\|LR735258.1\|	538966	g16100	i0	95.726	275.203319502075	234	10	97	0	1	234	3566479	3566246	Dyadobacter sp. 32 isolate Dyadobacter sp. 32 sample 2 genome assembly, chromosome: 1	blastn	66324	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 32
13951660	13951660	PRJNA738523_P_NODE_12911_length_247_cov_0.885057_g12840_i0	PRJNA738523	12911	247	0.885057	2.18609079	Elizabethkingia	308865	Bacteria	Bacteria	420	5.31e-113	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g12840	i0	97.551	11.7206477732794	245	6	99	0	3	247	597595	597839	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	2895	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
13951674	13951674	PRJNA738523_P_NODE_2791_length_396_cov_1.160991_g2720_i0	PRJNA738523	2791	396	1.160991	4.59752436	Chryseobacterium	59732	Bacteria	Bacteria	721	0	NTclustered	gi\|408044617\|gb\|JX515610.1\|	253	g2720	i0	99.495	171.131313131313	396	2	100	0	1	396	7	402	Chryseobacterium indologenes strain D4 16S ribosomal RNA gene, partial sequence	blastn	67768	726	0.993112947658402	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
22396980	22396980	PRJNA738523_P_NODE_14658_length_244_cov_0.900585_g14587_i0	PRJNA738523	14658	244	0.900585	2.1974274	Tannerella serpentiformis	712710	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g14587	i0	98.361	2	244	4	100	0	1	244	813696	813939	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	488	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis

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