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

16 rows where analysis = "blastn", bioproject = "PRJNA1103784" 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
212120	212120	PRJNA1103784_P_NODE_1081_length_480_cov_2.980344_g1026_i0	PRJNA1103784	1081	480	2.980344	14.3056512	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	793	0	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g1026	i0	96.473	310.75	482	14	100	3	1	480	272173	272653	Hymenobacter sp. DG01 chromosome, complete genome	blastn	149160	793	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
1486810	1486810	PRJNA1103784_P_NODE_3902_length_285_cov_1.216981_g3847_i0	PRJNA1103784	3902	285	1.216981	3.46839585	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	440	4.8099999999999984e-119	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g3847	i0	94.7	2.99298245614035	283	15	99	0	3	285	151285	151567	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	853	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
1486836	1486836	PRJNA1103784_P_NODE_5142_length_260_cov_1.518717_g5087_i0	PRJNA1103784	5142	260	1.518717	3.9486642	Tannerella serpentiformis	712710	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g5087	i0	100	557.438461538462	260	0	100	0	1	260	559224	558965	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	144934	481	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
2295622	2295622	PRJNA1103784_P_NODE_4502_length_272_cov_1.316583_g4447_i0	PRJNA1103784	4502	272	1.316583	3.58110576	Hymenobacter	89966	Bacteria	Bacteria	84.2	8.85e-12	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g4447	i0	96.078	0.375	51	2	19	0	222	272	1940374	1940324	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	102	84.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
4848198	4848198	PRJNA1103784_P_NODE_1304_length_444_cov_5.180593_g1249_i0	PRJNA1103784	1304	444	5.180593	23.00183292	Hymenobacter	89966	Bacteria	Bacteria	778	0	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g1249	i0	98.21	369.628378378378	447	5	100	1	1	444	1301143	1300697	Hymenobacter sp. APR13, complete genome	blastn	164115	782	0.994884910485934	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
10415494	10415494	PRJNA1103784_P_NODE_1609_length_407_cov_3.044910_g1554_i0	PRJNA1103784	1609	407	3.04491	12.3927837	Dyadobacter chenwenxiniae	2906456	Bacteria	Bacteria	741	0	NTclustered	gi\|2221365986\|gb\|CP094997.1\|	2906456	g1554	i0	99.509	249.095823095823	407	2	100	0	1	407	5574214	5573808	Dyadobacter chenwenxiniae strain LJ419 chromosome, complete genome	blastn	101382	741	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenwenxiniae
10415609	10415609	PRJNA1103784_P_NODE_789_length_553_cov_2.700000_g735_i0	PRJNA1103784	789	553	2.7	14.931	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	795	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g735	i0	92.78	477.077757685353	554	33	99	4	2	553	216985	217533	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	263824	795	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
11223580	11223580	PRJNA1103784_P_NODE_4489_length_272_cov_1.487437_g4434_i0	PRJNA1103784	4489	272	1.487437	4.04582864	Chitinophagaceae	563835	Bacteria	Bacteria	363	1.02e-95	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g4434	i0	92.885	202.577205882353	253	12	93	4	21	272	1187003	1187250	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	55101	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
11690821	11690821	PRJNA1103784_P_NODE_4230_length_277_cov_2.681373_g4175_i0	PRJNA1103784	4230	277	2.681373	7.42740321	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	366	8.01e-97	NTclustered	gi\|2179090906\|gb\|CP090557.1\|	2907205	g4175	i0	90.614	276.357400722022	277	24	100	2	1	277	418160	418434	Tellurirhabdus bombi strain IE-0392 chromosome, complete genome	blastn	76551	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
16789325	16789325	PRJNA1103784_P_NODE_7314_length_243_cov_0.905882_g7259_i0	PRJNA1103784	7314	243	0.905882	2.20129326	Chitinophagaceae bacterium DXS	3051226	Bacteria	Bacteria	65.8	2.81e-6	NTclustered	gi\|2524614756\|gb\|CP128386.1\|	3051226	g7259	i0	93.333	9.16872427983539	45	1	19	2	1	43	2228757	2228801	Chitinophagaceae bacterium DXS chromosome	blastn	2228	65.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium DXS
18063883	18063883	PRJNA1103784_P_NODE_7735_length_241_cov_0.916667_g7680_i0	PRJNA1103784	7735	241	0.916667	2.20916747	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	307	4.1900000000000005e-79	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g7680	i0	89.627	157.145228215768	241	25	100	0	1	241	4831694	4831934	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	37872	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
19337937	19337937	PRJNA1103784_P_NODE_4376_length_275_cov_1.069307_g4321_i0	PRJNA1103784	4376	275	1.069307	2.94059425	Dyadobacter chenwenxiniae	2906456	Bacteria	Bacteria	442	1.2799999999999994e-119	NTclustered	gi\|2221365986\|gb\|CP094997.1\|	2906456	g4321	i0	95.636	501.032727272727	275	12	100	0	1	275	5504574	5504300	Dyadobacter chenwenxiniae strain LJ419 chromosome, complete genome	blastn	137784	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenwenxiniae
19337961	19337961	PRJNA1103784_P_NODE_5676_length_251_cov_0.865169_g5621_i0	PRJNA1103784	5676	251	0.865169	2.17157419	Flavobacterium kingsejongi	1678728	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|1384925755\|gb\|CP020919.1\|	1678728	g5621	i0	97.211	433.884462151394	251	7	100	0	1	251	1295177	1295427	Flavobacterium kingsejongi strain WV39 chromosome, complete genome	blastn	108905	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium kingsejongi
21422194	21422194	PRJNA1103784_P_NODE_5157_length_260_cov_1.240642_g5102_i0	PRJNA1103784	5157	260	1.240642	3.2256692	Chryseobacterium	59732	Bacteria	Bacteria	464	2.57e-126	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g5102	i0	98.846	444.973076923077	260	3	100	0	1	260	2943889	2943630	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	115693	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
23164428	23164428	PRJNA1103784_P_NODE_1659_length_402_cov_1.720365_g1604_i0	PRJNA1103784	1659	402	1.720365	6.9158673	Pseudocnuella soli	2502779	Bacteria	Bacteria	710	0	NTclustered	gi\|1590719784\|gb\|CP037755.1\|	2502779	g1604	i0	98.515	310.89552238806	404	3	100	2	1	402	1186217	1186619	Pseudocnuella soli strain 17J28-1 chromosome, complete genome	blastn	124980	710	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudocnuella	Pseudocnuella soli
23972461	23972461	PRJNA1103784_P_NODE_3839_length_286_cov_1.896714_g3784_i0	PRJNA1103784	3839	286	1.896714	5.42460204	Aquirufa	2676247	Bacteria	Bacteria	285	2.39e-72	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g3784	i0	86.312	229.923076923077	263	35	92	1	3	264	359260	358998	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	65758	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae

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