metadata: contig_metadata: 26 rows where bioproject = "PRJNA675331" and tax

26 rows where bioproject = "PRJNA675331" 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
647727	647727	PRJNA675331_P_NODE_8701_length_333_cov_1.380769_g8529_i0	PRJNA675331	8701	333	1.380769	4.59796077	Chitinophaga oryzae	2725414	Bacteria	Bacteria	65.8	4.03e-6	NTclustered	gi\|1832568489\|gb\|CP051205.1\|	2725414	g8529	i0	90	0.396396396396396	50	5	15	0	71	120	4997444	4997493	Chitinophaga oryzae strain 1310 chromosome, complete genome	blastn	132	65.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga oryzae
1923865	1923865	PRJNA675331_P_NODE_18662_length_250_cov_0.870056_g18490_i0	PRJNA675331	18662	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	89.7	2.28e-21	NR	MBL7722999.1	1869212	g18490	i0	97.7	2.64	44	1	52.8	0	236	105	1	44	MBL7722999.1 dihydropteroate synthase [Chitinophagaceae bacterium]	diamond	660	89.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
3198593	3198593	PRJNA675331_P_NODE_10263_length_311_cov_46.273109_g10091_i0	PRJNA675331	10263	311	46.273109	143.90936899	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	435	2.47e-117	NTclustered	gi\|698039167\|gb\|KM650332.1\|	152509	g10091	i0	93.836	137.064308681672	292	13	92	1	13	299	779	488	Uncultured Bacteroidetes bacterium clone Pa166_083 16S ribosomal RNA gene, partial sequence	blastn	42627	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
3720214	3720214	PRJNA675331_P_NODE_2203_length_618_cov_2.511927_g2037_i0	PRJNA675331	2203	618	2.511927	15.52370886	Candidatus Parvibacillus	2981995	Bacteria	Bacteria	425	3.1299999999999998e-114	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g2037	i0	79.556	305.587378640777	631	101	99	23	4	617	3060194	3059575	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	188853	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
3720224	3720224	PRJNA675331_P_NODE_5303_length_415_cov_2.026316_g5131_i0	PRJNA675331	5303	415	2.026316	8.4092114	Bacteria	2	Bacteria	Bacteria	756	0	NTclustered	gi\|388541852\|gb\|JQ937370.1\|	512288	g5131	i0	99.518	100.698795180723	415	2	100	0	1	415	439	25	Uncultured Cryomorphaceae bacterium isolate DGGE gel band a-KIN 16S ribosomal RNA gene, partial sequence	blastn	41790	756	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Cryomorphaceae		uncultured Cryomorphaceae bacterium
4475695	4475695	PRJNA675331_P_NODE_11144_length_301_cov_5.333333_g10972_i0	PRJNA675331	11144	301	5.333333	16.05333233	uncultured Flavobacteriia bacterium	212695	Bacteria	Bacteria	457	5.08e-124	NTclustered	gi\|335390855\|gb\|JF947919.1\|	212695	g10972	i0	98.467	96.7940199335548	261	1	86	2	30	289	394	136	Uncultured Flavobacteria bacterium clone Pa18e10 16S ribosomal RNA gene, partial sequence	blastn	29135	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				uncultured Flavobacteriia bacterium
4996844	4996844	PRJNA675331_P_NODE_10364_length_310_cov_1.552743_g10192_i0	PRJNA675331	10364	310	1.552743	4.8135033	Bacteroidota	976	Bacteria	Bacteria	457	5.25e-124	NTclustered	gi\|2621702112\|emb\|OY760143.1\|	2748031	g10192	i0	93.226	320.970967741936	310	21	100	0	1	310	1474447	1474756	MAG: Paludibacteraceae bacterium isolate 01c8064d-6cbe-49cb-b462-9ef0373b1e27 genome assembly, chromosome: 1	blastn	99501	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
7026407	7026407	PRJNA675331_P_NODE_20946_length_246_cov_0.890173_g20774_i0	PRJNA675331	20946	246	0.890173	2.18982558	Bacteroidota	976	Bacteria	Bacteria	139	4.51e-37	NR	MEI7736649.1	1940288	g20774	i0	78.8	6.85365853658537	80	17	97.6	0	240	1	192	271	MEI7736649.1 citrate (Si)-synthase, eukaryotic [Ferruginibacter sp.]	diamond	1686	140	0.992857142857143	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
11372086	11372086	PRJNA675331_P_NODE_3529_length_499_cov_1.183099_g3358_i0	PRJNA675331	3529	499	1.183099	5.90366401	Haliscomenobacter	2349	Bacteria	Bacteria	588	3.009999999999999e-163	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g3358	i0	88.73	438.108216432866	488	46	97	9	6	489	366	848	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	218616	588	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
19020265	19020265	PRJNA675331_P_NODE_22155_length_244_cov_0.900585_g21983_i0	PRJNA675331	22155	244	0.900585	2.1974274	Fluviicola	332102	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g21983	i0	96.68	280.622950819672	241	8	99	0	1	241	1216	1456	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	68472	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
19774566	19774566	PRJNA675331_P_NODE_12236_length_290_cov_1.414747_g12064_i0	PRJNA675331	12236	290	1.414747	4.1027663	Bacteroidales bacterium	2030927	Bacteria	Bacteria	315	3.1e-81	NTclustered	gi\|2621704310\|emb\|OY760906.1\|	2030927	g12064	i0	86.254	344.113793103448	291	39	100	1	1	290	28275	27985	MAG: Bacteroidales bacterium isolate 68ad28d8-9785-4e35-8572-44786b46fd48 genome assembly, chromosome: 1	blastn	99793	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27050395	27050395	PRJNA675331_P_NODE_922_length_930_cov_1.768961_g790_i0	PRJNA675331	922	930	1.768961	16.4513373	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	143	1.32e-36	NR	MBL0135014.1	1869212	g790	i0	40.1	3.60322580645161	282	145	85.8	11	42	839	36	309	MBL0135014.1 fasciclin domain-containing protein [Chitinophagaceae bacterium]	diamond	3351	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27378454	27378454	PRJNA675331_P_NODE_18303_length_251_cov_0.865169_g18131_i0	PRJNA675331	18303	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	126	3.969999999999999e-34	NR	MBL7730473.1	1869212	g18131	i0	94.2	4.12350597609562	69	4	82.5	0	207	1	1	69	MBL7730473.1 response regulator transcription factor [Chitinophagaceae bacterium]	diamond	1035	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27567554	27567554	PRJNA675331_P_NODE_1684_length_702_cov_2.055644_g1523_i0	PRJNA675331	1684	702	2.055644	14.43062088	Pseudomonadati	3379134	Bacteria	Bacteria	125	4.11e-29	NR	MDZ7717225.1	2053516	g1523	i0	41.8	2.67094017094017	184	92	75.6	5	172	702	73	248	MDZ7717225.1 fasciclin domain-containing protein [Balneolaceae bacterium]	diamond	1875	125	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27682504	27682504	PRJNA675331_P_NODE_23884_length_241_cov_0.916667_g23712_i0	PRJNA675331	23884	241	0.916667	2.20916747	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	47.8	6.52e-4	NR	MFN6380301.1	2021391	g23712	i0	41.3	0.933609958506224	75	42	90.9	2	1	219	1938	2012	MFN6380301.1 T9SS type A sorting domain-containing protein [Flavobacteriales bacterium]	diamond	225	47.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
28451900	28451900	PRJNA675331_P_NODE_23346_length_242_cov_0.911243_g23174_i0	PRJNA675331	23346	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	55.8	8.99e-7	NR	WP_031453842.1	554283	g23174	i0	44.2	2.83884297520661	77	39	90.5	1	220	2	129	205	WP_031453842.1 Ig-like domain-containing protein [Flavobacterium chungangense]	diamond	687	55.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium chungangense
28629578	28629578	PRJNA675331_P_NODE_12307_length_289_cov_2.796296_g12135_i0	PRJNA675331	12307	289	2.796296	8.08129544	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	61.6	9.04e-9	NR	MDB4835335.1	2099675	g12135	i0	35.9	1.86851211072664	92	55	92.4	2	23	289	152	242	MDB4835335.1 carbonic anhydrase family protein [Cyclobacteriaceae bacterium]	diamond	540	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
28957156	28957156	PRJNA675331_P_NODE_11948_length_293_cov_1.050000_g11776_i0	PRJNA675331	11948	293	1.05	3.0765	Bacteria	2	Bacteria	Bacteria	45.1	0.0106	NR	MCB0538595.1	1898104	g11776	i0	31.7	2.20136518771331	82	53	81.9	2	250	11	741	821	MCB0538595.1 hypothetical protein [Bacteroidota bacterium]	diamond	645	45.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29071599	29071599	PRJNA675331_P_NODE_24048_length_241_cov_0.916667_g23876_i0	PRJNA675331	24048	241	0.916667	2.20916747	Polaribacter aquimarinus	2100726	Bacteria	Bacteria	42.7	0.037	NR	WP_235869097.1	2100726	g23876	i0	28.6	0.871369294605809	70	48	87.1	1	240	31	484	551	WP_235869097.1 tetratricopeptide repeat protein [Polaribacter aquimarinus]	diamond	210	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter aquimarinus
29619559	29619559	PRJNA675331_P_NODE_24150_length_241_cov_0.916667_g23978_i0	PRJNA675331	24150	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	90.5	4.77e-19	NR	MCF8289086.1	1869212	g23978	i0	55.3	3.78423236514523	76	33	94.6	1	231	4	33	107	MCF8289086.1 family 10 glycosylhydrolase [Chitinophagaceae bacterium]	diamond	912	90.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30429856	30429856	PRJNA675331_P_NODE_22873_length_243_cov_0.905882_g22701_i0	PRJNA675331	22873	243	0.905882	2.20129326	Bacteroidota bacterium	1898104	Bacteria	Bacteria	167	1.74e-49	NR	MCA6437638.1	1898104	g22701	i0	91.3	1.97530864197531	80	7	98.8	0	241	2	16	95	MCA6437638.1 acetyl-CoA carboxylase carboxyltransferase subunit beta [Bacteroidota bacterium]	diamond	480	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30682010	30682010	PRJNA675331_P_NODE_4653_length_441_cov_1.695652_g4481_i0	PRJNA675331	4653	441	1.695652	7.47782532	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	73.9	4.23e-12	NR	MCH2213589.1	2021391	g4481	i0	49	0.707482993197279	104	40	67.3	6	429	133	96	191	MCH2213589.1 HYR domain-containing protein [Flavobacteriales bacterium]	diamond	312	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
31061635	31061635	PRJNA675331_P_NODE_1295_length_791_cov_2.079387_g1143_i0	PRJNA675331	1295	791	2.079387	16.44795117	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	60.1	3.34e-6	NR	MBM3956824.1	2026742	g1143	i0	28.9	1.61567635903919	211	120	78.5	9	142	762	49	233	MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium]	diamond	1278	60.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31294386	31294386	PRJNA675331_P_NODE_13135_length_282_cov_1.105263_g12963_i0	PRJNA675331	13135	282	1.105263	3.11684166	Bacteroidota	976	Bacteria	Bacteria	101	1.1e-22	NR	MBT3443244.1	1871037	g12963	i0	65.9	7.9468085106383	82	25	84	2	34	270	3	84	MBT3443244.1 aspartate--tRNA ligase [Flavobacteriaceae bacterium]	diamond	2241	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
32231906	32231906	PRJNA675331_P_NODE_17138_length_257_cov_0.994565_g16966_i0	PRJNA675331	17138	257	0.994565	2.5560320500000002	Gelidibacter sp. F2691	2926852	Bacteria	Bacteria	53.5	7.22e-6	NR	MCK0124720.1	2926852	g16966	i0	42.4	0.992217898832685	85	46	98.1	3	253	2	1427	1509	MCK0124720.1 gliding motility-associated C-terminal domain-containing protein [Gelidibacter sp. F2691]	diamond	255	53.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Gelidibacter	Gelidibacter sp. F2691
32673909	32673909	PRJNA675331_P_NODE_3240_length_519_cov_1.381166_g3070_i0	PRJNA675331	3240	519	1.381166	7.16825154	Candidatus Zixiibacteriota bacterium	2053527	Bacteria	Bacteria	47.4	0.012	NR	MCH9031196.1	2053527	g3070	i0	29.9	0.774566473988439	134	73	74.6	7	49	435	226	343	MCH9031196.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Zixiibacteriota bacterium]	diamond	402	47.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota					Candidatus Zixiibacteriota bacterium

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