metadata: contig_metadata: 19 rows where bioproject = "PRJNA1263632" and tax

19 rows where bioproject = "PRJNA1263632" 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
1054091	1054091	PRJNA1263632_P_NODE_881_length_629_cov_0.827338_g864_i0	PRJNA1263632	881	629	0.827338	5.20395602	Chryseobacterium	59732	Bacteria	Bacteria	928	0	NTclustered	gi\|399572481\|gb\|JQ918535.1\|	152509	g864	i0	93.974	98.0524642289348	614	35	97	2	17	629	723	111	Uncultured Bacteroidetes bacterium clone Cd5d857 16S ribosomal RNA gene, partial sequence	blastn	61675	933	0.994640943193998	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
3604485	3604485	PRJNA1263632_P_NODE_643_length_718_cov_2.111628_g626_i0	PRJNA1263632	643	718	2.111628	15.16148904	Flavobacterium	237	Bacteria	Bacteria	1101	0	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g626	i0	94.908	339.300835654596	707	30	98	5	1	703	1333787	1334491	Flavobacterium sp. N1719 chromosome, complete genome	blastn	243618	1101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
6156769	6156769	PRJNA1263632_P_NODE_4045_length_309_cov_1.406780_g4027_i0	PRJNA1263632	4045	309	1.40678	4.3469502	Chryseobacterium	59732	Bacteria	Bacteria	544	3.9e-150	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g4027	i0	98.382	454.229773462783	309	5	100	0	1	309	2944291	2943983	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	140357	549	0.990892531876138	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
11257318	11257318	PRJNA1263632_P_NODE_3289_length_339_cov_1.308271_g3271_i0	PRJNA1263632	3289	339	1.308271	4.43503869	Flavobacterium	237	Bacteria	Bacteria	556	5.56e-154	NTclustered	gi\|2223843353\|gb\|CP090145.1\|	2024526	g3271	i0	96.188	680.802359882006	341	11	100	2	1	339	700950	701290	Flavobacterium sediminilitoris strain YSM-43 chromosome, complete genome	blastn	230792	556	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminilitoris
16941032	16941032	PRJNA1263632_P_NODE_6614_length_250_cov_0.870056_g6596_i0	PRJNA1263632	6614	250	0.870056	2.17514	Flagellimonas ruestringensis	111501	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|343953259\|gb\|CP002999.1\|	886377	g6596	i0	100	0.112	28	0	11	0	220	247	3598249	3598222	Muricauda ruestringensis DSM 13258, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flagellimonas	Flagellimonas ruestringensis
16941080	16941080	PRJNA1263632_P_NODE_8374_length_241_cov_0.916667_g8356_i0	PRJNA1263632	8374	241	0.916667	2.20916747	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g8356	i0	97.925	139.54356846473	241	5	100	0	1	241	55587	55347	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	33630	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
26789195	26789195	PRJNA1263632_P_NODE_4201_length_303_cov_1.939130_g4183_i0	PRJNA1263632	4201	303	1.93913	5.8755639	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	160	1.9599999999999999e-47	NR	MFM7853512.1	2026740	g4183	i0	82	0.99009900990099	100	18	99	0	2	301	5	104	MFM7853512.1 14-3-3 family protein [Flammeovirgaceae bacterium]	diamond	300	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
27769108	27769108	PRJNA1263632_P_NODE_7764_length_244_cov_0.900585_g7746_i0	PRJNA1263632	7764	244	0.900585	2.1974274	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	48.1	4.27e-4	NR	HLP46911.1	2447898	g7746	i0	55.3	1.36475409836066	38	17	46.7	0	244	131	74	111	HLP46911.1 hypothetical protein [Candidatus Kapaibacterium sp.]	diamond	333	48.1	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
27895055	27895055	PRJNA1263632_P_NODE_7565_length_245_cov_0.895349_g7547_i0	PRJNA1263632	7565	245	0.895349	2.19360505	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	50.8	5.23e-5	NR	HEX5112210.1	2202734	g7547	i0	47.4	0.991836734693878	38	20	46.5	0	118	5	179	216	HEX5112210.1 FAD-binding protein [Saprospiraceae bacterium]	diamond	243	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
28007866	28007866	PRJNA1263632_P_NODE_7105_length_247_cov_1.747126_g7087_i0	PRJNA1263632	7105	247	1.747126	4.31540122	Bacteroidota	976	Bacteria	Bacteria	103	8.36e-24	NR	WP_091871867.1	641691	g7087	i0	97.9	29.1497975708502	48	1	58.3	0	246	103	460	507	WP_091871867.1 aldehyde dehydrogenase family protein [Pricia antarctica]	diamond	7200	104	0.990384615384615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pricia	Pricia antarctica
28747651	28747651	PRJNA1263632_P_NODE_6507_length_251_cov_0.865169_g6489_i0	PRJNA1263632	6507	251	0.865169	2.17157419	Portibacter marinus	2898660	Bacteria	Bacteria	72	2e-12	NR	WP_235299793.1	2898660	g6489	i0	48.6	1.86454183266932	74	37	87.3	1	248	30	503	576	WP_235299793.1 SdrD B-like domain-containing protein, partial [Portibacter marinus]	diamond	468	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Portibacter	Portibacter marinus
29536983	29536983	PRJNA1263632_P_NODE_5990_length_259_cov_1.279570_g5972_i0	PRJNA1263632	5990	259	1.27957	3.3140863	Bacteroidales bacterium	2030927	Bacteria	Bacteria	63.9	1.49e-9	NR	MBD5207074.1	2030927	g5972	i0	65.4	3.1042471042471	52	18	60.2	0	257	102	463	514	MBD5207074.1 AAA family ATPase [Bacteroidales bacterium]	diamond	804	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29757888	29757888	PRJNA1263632_P_NODE_6211_length_254_cov_1.414365_g6193_i0	PRJNA1263632	6211	254	1.414365	3.5924871	Flavobacterium restrictum	2594428	Bacteria	Bacteria	126	2.66e-34	NR	WP_144255016.1	2594428	g6193	i0	74.1	0.956692913385827	81	21	95.7	0	7	249	81	161	WP_144255016.1 NAD(P)-dependent oxidoreductase [Flavobacterium restrictum]	diamond	243	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium restrictum
29757890	29757890	PRJNA1263632_P_NODE_7051_length_248_cov_0.880000_g7033_i0	PRJNA1263632	7051	248	0.88	2.1824	Prevotella sp.	59823	Bacteria	Bacteria	99	1.39e-24	NR	MBQ4148026.1	59823	g7033	i0	51.9	0.955645161290323	79	38	95.6	0	247	11	42	120	MBQ4148026.1 hypothetical protein [Prevotella sp.]	diamond	237	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
29757891	29757891	PRJNA1263632_P_NODE_7851_length_244_cov_0.900585_g7833_i0	PRJNA1263632	7851	244	0.900585	2.1974274	Bacteroidota bacterium	1898104	Bacteria	Bacteria	47.8	6.57e-4	NR	NTW31445.1	1898104	g7833	i0	34.2	0.971311475409836	79	49	93.4	1	16	243	512	590	NTW31445.1 hypothetical protein [Bacteroidota bacterium]	diamond	237	47.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30674101	30674101	PRJNA1263632_P_NODE_3253_length_341_cov_1.115672_g3235_i0	PRJNA1263632	3253	341	1.115672	3.80444152	Bacteroidota bacterium	1898104	Bacteria	Bacteria	124	1.63e-30	NR	MFM1913009.1	1898104	g3235	i0	48.6	0.976539589442815	111	57	97.7	0	3	335	107	217	MFM1913009.1 hypothetical protein [Bacteroidota bacterium]	diamond	333	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31021802	31021802	PRJNA1263632_P_NODE_815_length_658_cov_13.856410_g798_i0	PRJNA1263632	815	658	13.85641	91.1751778	Chryseobacterium sp. JUb7	2940599	Bacteria	Bacteria	107	1e-23	NR	WP_259113384.1	2940599	g798	i0	41.6	0.734042553191489	161	78	72	5	529	56	171	318	WP_259113384.1 hypothetical protein [Chryseobacterium sp. JUb7]	diamond	483	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. JUb7
31337757	31337757	PRJNA1263632_P_NODE_6676_length_250_cov_0.870056_g6658_i0	PRJNA1263632	6676	250	0.870056	2.17514	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	43.1	0.0283	NR	MBI5856777.1	2044944	g6658	i0	36.7	0.72	60	30	67.2	2	177	10	262	317	MBI5856777.1 stage II sporulation protein M [Sphingobacteriales bacterium]	diamond	180	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32886321	32886321	PRJNA1263632_P_NODE_6820_length_249_cov_0.875000_g6802_i0	PRJNA1263632	6820	249	0.875	2.17875	Formosa agariphila	320324	Bacteria	Bacteria	56.6	5.26e-7	NR	WP_038530764.1	320324	g6802	i0	40	1.89156626506024	80	44	96.4	2	3	242	1250	1325	WP_038530764.1 T9SS C-terminal target domain-containing protein [Formosa agariphila]	diamond	471	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Formosa	Formosa agariphila

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