metadata: contig_metadata: 15 rows where bioproject = "PRJNA1011833" and tax

15 rows where bioproject = "PRJNA1011833" 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
2276774	2276774	PRJNA1011833_S_NODE_54762_length_156_cov_0.964602_g54342_i0	PRJNA1011833	54762	156	0.964602	1.50477912	Sphingobacterium	28453	Bacteria	Bacteria	283	4.1899999999999994e-72	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g54342	i0	99.359	228.711538461538	156	1	100	0	1	156	2537389	2537544	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	35679	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
4829585	4829585	PRJNA1011833_S_NODE_16124_length_301_cov_2.093023_g15704_i0	PRJNA1011833	16124	301	2.093023	6.29999923	Bacteroidales bacterium	2030927	Bacteria	Bacteria	111	1.6300000000000002e-27	NR	NLV37679.1	2030927	g15704	i0	58	0.877076411960133	88	37	87.7	0	3	266	166	253	NLV37679.1 glucosamine-6-phosphate deaminase [Bacteroidales bacterium]	diamond	264	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
9082828	9082828	PRJNA1011833_S_NODE_15848_length_303_cov_6.984615_g15428_i0	PRJNA1011833	15848	303	6.984615	21.16338345	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g15428	i0	100	0.099009900990099	30	0	10	0	271	300	1161409	1161438	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
11633947	11633947	PRJNA1011833_S_NODE_21910_length_256_cov_22.586854_g21490_i0	PRJNA1011833	21910	256	22.586854	57.82234624	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	62.1	3.87e-5	NTclustered	gi\|2717309477\|emb\|OZ032149.1\|	336810	g21490	i0	97.222	0.140625	36	1	14	0	72	107	226088	226053	Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1	blastn	36	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
12480408	12480408	PRJNA1011833_S_NODE_28590_length_221_cov_1.859551_g28170_i0	PRJNA1011833	28590	221	1.859551	4.10960771	Weeksellaceae	2762318	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g28170	i0	100	455.787330316742	221	0	100	0	1	221	229159	228939	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	100729	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
17579457	17579457	PRJNA1011833_S_NODE_37294_length_191_cov_1.297297_g36874_i0	PRJNA1011833	37294	191	1.297297	2.47783727	Sphingobacterium	28453	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g36874	i0	99.476	457.738219895288	191	1	100	0	1	191	1767388	1767578	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	87428	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
20556561	20556561	PRJNA1011833_S_NODE_30477_length_213_cov_1.976471_g30057_i0	PRJNA1011833	30477	213	1.976471	4.20988323	Thermoflavifilum sp.	1968839	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1919310413\|gb\|CP063141.1\|	1968839	g30057	i0	97.059	0.15962441314554	34	0	15	1	123	155	302638	302605	Thermoflavifilum sp. isolate Bu77 chromosome	blastn	34	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Thermoflavifilum	Thermoflavifilum sp.
26591213	26591213	PRJNA1011833_S_NODE_33981_length_201_cov_1.177215_g33561_i0	PRJNA1011833	33981	201	1.177215	2.36620215	Flavipsychrobacter sp.	2307286	Bacteria	Bacteria	42.4	0.0287	NR	MCW3123626.1	2307286	g33561	i0	42.2	0.671641791044776	45	26	67.2	0	145	11	190	234	MCW3123626.1 O-antigen ligase protein [Flavipsychrobacter sp.]	diamond	135	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavipsychrobacter	Flavipsychrobacter sp.
27635099	27635099	PRJNA1011833_S_NODE_16644_length_296_cov_4.750988_g16224_i0	PRJNA1011833	16644	296	4.750988	14.06292448	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	100	1.2800000000000001e-22	NR	MDC0637698.1	1871037	g16224	i0	49.5	2.83783783783784	95	48	96.3	0	296	12	293	387	MDC0637698.1 proline dehydrogenase family protein [Flavobacteriaceae bacterium]	diamond	840	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
28140416	28140416	PRJNA1011833_S_NODE_38085_length_189_cov_0.986301_g37665_i0	PRJNA1011833	38085	189	0.986301	1.86410889	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	42	0.0306	NR	NBX38946.1	2044941	g37665	i0	50	0.857142857142857	54	25	84.1	2	3	161	172	224	NBX38946.1 lycopene cyclase domain-containing protein [Flavobacteriia bacterium]	diamond	162	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
29465863	29465863	PRJNA1011833_S_NODE_10130_length_368_cov_8.286154_g9712_i0	PRJNA1011833	10130	368	8.286154	30.49304672	Roseivirga sp.	1964215	Bacteria	Bacteria	51.6	1.1e-4	NR	MFT6053375.1	1964215	g9712	i0	48	2.58423913043478	50	25	40.8	1	13	162	373	421	MFT6053375.1 putative AlkP superfamily pyrophosphatase or phosphodiesterase [Roseivirga sp.]	diamond	951	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Roseivirgaceae	Roseivirga	Roseivirga sp.
30224173	30224173	PRJNA1011833_S_NODE_37712_length_190_cov_1.061224_g37292_i0	PRJNA1011833	37712	190	1.061224	2.0163256	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0139	NR	KAA3622062.1	1898104	g37292	i0	41	0.615789473684211	39	23	61.6	0	5	121	734	772	KAA3622062.1 MAG: hypothetical protein DWQ02_26710 [Bacteroidota bacterium]	diamond	117	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30627236	30627236	PRJNA1011833_S_NODE_20673_length_265_cov_1.824324_g20253_i0	PRJNA1011833	20673	265	1.824324	4.8344586	Pseudomonadati	3379134	Bacteria	Bacteria	121	1.2399999999999998e-29	NR	MBL7850048.1	2099675	g20253	i0	66.3	4.77735849056604	80	27	90.6	0	241	2	857	936	MBL7850048.1 aminomethyl-transferring glycine dehydrogenase [Cyclobacteriaceae bacterium]	diamond	1266	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
31804579	31804579	PRJNA1011833_S_NODE_1937_length_639_cov_52.954698_g1598_i0	PRJNA1011833	1937	639	52.954698	338.38052022	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	94.7	1.7400000000000003e-21	NR	MFO8183585.1	2528271	g1598	i0	57.7	1.15023474178404	78	33	36.6	0	588	355	2	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	735	94.7	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
32839697	32839697	PRJNA1011833_S_NODE_49560_length_164_cov_1.975207_g49140_i0	PRJNA1011833	49560	164	1.975207	3.23933948	Bacteria	2	Bacteria	Bacteria	86.7	3.82e-18	NR	WP_014224542.1	28112	g49140	i0	69.8	20.359756097561	53	16	97	0	159	1	84	136	WP_014224542.1 adenosylhomocysteinase [Tannerella forsythia]	diamond	3339	86.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella forsythia

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