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

12 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
2518925	2518925	PRJNA893346_P_NODE_5782_length_672_cov_1.337229_g5318_i0	PRJNA893346	5782	672	1.337229	8.98617888	Chryseobacterium	59732	Bacteria	Bacteria	1192	0	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g5318	i0	98.661	538.407738095238	672	9	100	0	1	672	2943512	2944183	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	361810	1197	0.995822890559733	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
3418665	3418665	PRJNA893346_P_NODE_16243_length_385_cov_0.993590_g15755_i0	PRJNA893346	16243	385	0.99359	3.8253215	Mariniflexile sp. TRM1-10	2027857	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1463734540\|gb\|CP022985.1\|	2027857	g15755	i0	100	0.150649350649351	29	0	8	0	128	156	3742560	3742532	Mariniflexile sp. TRM1-10 chromosome, complete genome	blastn	58	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Mariniflexile	Mariniflexile sp. TRM1-10
4696873	4696873	PRJNA893346_P_NODE_36484_length_246_cov_0.890173_g35994_i0	PRJNA893346	36484	246	0.890173	2.18982558	Kaistella haifensis	421525	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g35994	i0	99.187	2.9390243902439	246	2	100	0	1	246	99	344	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	723	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
8896156	8896156	PRJNA893346_P_NODE_30447_length_269_cov_1.117347_g29957_i0	PRJNA893346	30447	269	1.117347	3.00566343	Hymenobacter	89966	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g29957	i0	100	0.20817843866171	28	0	10	0	63	90	3163244	3163217	Hymenobacter sp. APR13, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
9796172	9796172	PRJNA893346_P_NODE_29568_length_274_cov_1.532338_g29078_i0	PRJNA893346	29568	274	1.532338	4.19860612	Candidatus Marifrigoribacter sp. Uisw_064	3230970	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2908907730\|gb\|CP159833.1\|	3230970	g29078	i0	100	0.105839416058394	29	0	11	0	20	48	1734172	1734200	Flavobacteriaceae bacterium Uisw_064 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Candidatus Marifrigoribacter	Candidatus Marifrigoribacter sp. Uisw_064
11447039	11447039	PRJNA893346_P_NODE_38349_length_243_cov_0.905882_g37859_i0	PRJNA893346	38349	243	0.905882	2.20129326	Dyadobacter	120831	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|470484375\|ref\|NR_076644.1\|	94254	g37859	i0	97.942	265.283950617284	243	5	100	0	1	243	1036	1278	Dyadobacter fermentans strain NS114 23S ribosomal RNA gene, complete sequence	blastn	64464	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fermentans
13997139	13997139	PRJNA893346_P_NODE_16251_length_385_cov_0.987179_g15763_i0	PRJNA893346	16251	385	0.987179	3.80063915	Capnocytophaga	1016	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1242569895\|gb\|CP022388.1\|	28188	g15763	i0	94.286	0.545454545454545	35	1	9	1	249	283	1711083	1711116	Capnocytophaga canimorsus strain H5594 chromosome, complete genome	blastn	210	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
21645462	21645462	PRJNA893346_P_NODE_39397_length_241_cov_2.648810_g38907_i0	PRJNA893346	39397	241	2.64881	6.3836321	Emticicia	312278	Bacteria	Bacteria	346	8.89e-91	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g38907	i0	92.531	43.0912863070539	241	18	100	0	1	241	1457	1217	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	10385	348	0.994252873563218	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
22544895	22544895	PRJNA893346_P_NODE_20898_length_337_cov_1.454545_g20409_i0	PRJNA893346	20898	337	1.454545	4.90181665	Algibacter luteus	1178825	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2524564344\|gb\|CP128313.1\|	1178825	g20409	i0	88.889	0.13353115727003	45	2	13	3	181	225	1721456	1721415	Algibacter luteus strain HNIBRBA226 chromosome, complete genome	blastn	45	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter luteus
22544947	22544947	PRJNA893346_P_NODE_22758_length_321_cov_2.241935_g22268_i0	PRJNA893346	22758	321	2.241935	7.19661135	Flavobacterium nitratireducens	992289	Bacteria	Bacteria	582	8.639999999999997e-162	NTclustered	gi\|2482055250\|gb\|CP121111.1\|	992289	g22268	i0	99.377	546.06230529595	321	2	100	0	1	321	40479	40159	Flavobacterium nitratireducens strain JCM 17678 chromosome, complete genome	blastn	175286	582	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nitratireducens
22545299	22545299	PRJNA893346_P_NODE_37818_length_244_cov_0.900585_g37328_i0	PRJNA893346	37818	244	0.900585	2.1974274	Chryseobacterium indologenes	253	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1267040975\|gb\|CP023968.1\|	253	g37328	i0	100	10	244	0	100	0	1	244	3359615	3359858	Chryseobacterium indologenes strain FDAARGOS_379 chromosome, complete genome	blastn	2440	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
23820593	23820593	PRJNA893346_P_NODE_35279_length_248_cov_0.880000_g34789_i0	PRJNA893346	35279	248	0.88	2.1824	Cloacibacterium normanense	237258	Bacteria	Bacteria	287	5.649999999999999e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g34789	i0	88.285	5.51612903225806	239	28	96	0	8	246	2359447	2359209	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1368	287	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);;