metadata: contig_metadata: 21 rows where bioproject = "PRJNA1012699" and tax

21 rows where bioproject = "PRJNA1012699" 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
158022	158022	PRJNA1012699_P_NODE_3521_length_246_cov_0.895954_g3489_i0	PRJNA1012699	3521	246	0.895954	2.20404684	Prevotella histicola	470565	Bacteria	Bacteria	448	2.4299999999999995e-121	NTclustered	gi\|2913587115\|gb\|CP181052.1\|	470565	g3489	i0	99.592	1.99186991869919	245	1	99	0	1	245	839597	839841	Prevotella histicola strain T05-04 chromosome 1, complete sequence	blastn	490	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella histicola
1432860	1432860	PRJNA1012699_P_NODE_3922_length_242_cov_2.745562_g3890_i0	PRJNA1012699	3922	242	2.745562	6.64426004	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g3890	i0	85.714	138.388429752066	245	25	99	10	2	242	3519	3281	Dyadobacter pollutisoli strain U1 chromosome	blastn	33490	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
2708362	2708362	PRJNA1012699_P_NODE_3303_length_247_cov_1.741379_g3271_i0	PRJNA1012699	3303	247	1.741379	4.30120613	Prevotella bivia	28125	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g3271	i0	99.194	362.473684210526	248	0	99	1	1	246	279673	279426	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	89531	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
3984577	3984577	PRJNA1012699_P_NODE_444_length_511_cov_3.230594_g412_i0	PRJNA1012699	444	511	3.230594	16.50833534	Prevotella bivia	28125	Bacteria	Bacteria	939	0	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g412	i0	99.804	215.207436399217	511	1	100	0	1	511	278421	277911	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	109971	939	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
4830450	4830450	PRJNA1012699_P_NODE_644_length_436_cov_3.225895_g612_i0	PRJNA1012699	644	436	3.225895	14.0649022	root	1	Root_unresolved	Root_unresolved	730	0	NTclustered	gi\|2515258864\|gb\|CP126676.1\|	28125	g612	i0	97.005	102.532110091743	434	13	99	0	2	435	786297	786730	Prevotella bivia strain PLW0727 chromosome 1, complete sequence	blastn	44704	736	0.991847826086957	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
6536239	6536239	PRJNA1012699_P_NODE_4106_length_232_cov_2.930818_g4074_i0	PRJNA1012699	4106	232	2.930818	6.79949776	Prevotella bivia	28125	Bacteria	Bacteria	425	1.0599999999999999e-114	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g4074	i0	100	220.150862068966	230	0	99	0	2	231	276848	277077	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	51075	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
7380076	7380076	PRJNA1012699_P_NODE_866_length_388_cov_1.041270_g834_i0	PRJNA1012699	866	388	1.04127	4.0401276	Prevotella	838	Bacteria	Bacteria	652	0	NTclustered	gi\|2028867418\|gb\|CP072361.1\|	28132	g834	i0	97.15	264.025773195876	386	11	99	0	1	386	225247	225632	Prevotella melaninogenica strain F0054 chromosome 1, complete sequence	blastn	102442	658	0.990881458966565	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
9085599	9085599	PRJNA1012699_P_NODE_3108_length_249_cov_0.886364_g3076_i0	PRJNA1012699	3108	249	0.886364	2.20704636	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1893901222\|gb\|CP059189.1\|	1653831	g3076	i0	92.308	0.156626506024096	39	2	16	1	131	169	568466	568503	Blattabacterium cuenoti strain PHYLLODsp chromosome	blastn	39	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
12481271	12481271	PRJNA1012699_P_NODE_4110_length_232_cov_2.232704_g4078_i0	PRJNA1012699	4110	232	2.232704	5.17987328	Chryseobacterium	59732	Bacteria	Bacteria	420	4.94e-113	NTclustered	gi\|124303178\|gb\|EF208922.1\|	422310	g4078	i0	99.565	104.094827586207	230	1	99	0	2	231	139	368	Chryseobacterium sp. 'TS IW 15' 16S ribosomal RNA gene, partial sequence	blastn	24150	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 'TS IW 15'
12911599	12911599	PRJNA1012699_P_NODE_1231_length_336_cov_1.182510_g1199_i0	PRJNA1012699	1231	336	1.18251	3.9732336	Candidatus Ornithobacterium hominis	2497989	Bacteria	Bacteria	377	4.6e-100	NTclustered	gi\|2502739559\|emb\|OX579588.1\|	2497989	g1199	i0	87.537	210.464285714286	337	28	99	10	1	335	646911	647235	Candidatus Ornithobacterium hominis strain MSHR-COH1 genome assembly, chromosome: 1	blastn	70716	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Candidatus Ornithobacterium hominis
12911610	12911610	PRJNA1012699_P_NODE_1711_length_294_cov_3.067873_g1679_i0	PRJNA1012699	1711	294	3.067873	9.01954662	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	281	3.2000000000000007e-71	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1679	i0	85.714	2.7891156462585	273	32	91	7	25	293	422278	422009	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	820	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12911613	12911613	PRJNA1012699_P_NODE_1951_length_282_cov_1.842105_g1919_i0	PRJNA1012699	1951	282	1.842105	5.1947361	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	114	2.6e-29	NR	MDP2061423.1	1871037	g1919	i0	65.6	2.03191489361702	96	30	98.9	1	280	2	97	192	MDP2061423.1 30S ribosomal protein S8e [Flavobacteriaceae bacterium]	diamond	573	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
12911618	12911618	PRJNA1012699_P_NODE_231_length_680_cov_4.454695_g203_i0	PRJNA1012699	231	680	4.454695	30.291926	Prevotella bivia	28125	Bacteria	Bacteria	1256	0	NTclustered	gi\|2884265423\|dbj\|AP038912.1\|	28125	g203	i0	100	255.525	680	0	100	0	1	680	412812	413491	Prevotella bivia GTC18476 DNA, chromosome 2, complete sequence	blastn	173757	1256	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
16734970	16734970	PRJNA1012699_P_NODE_2454_length_259_cov_1.672043_g2422_i0	PRJNA1012699	2454	259	1.672043	4.33059137	Bacteroidales bacterium	2030927	Bacteria	Bacteria	315	2.72e-81	NTclustered	gi\|2621785016\|emb\|OY781474.1\|	2030927	g2422	i0	89.02	449.953667953668	255	27	99	1	2	256	1949233	1949486	MAG: Bacteroidales bacterium isolate d554a065-6b18-4027-98a3-e240c86e67dd genome assembly, chromosome: 1	blastn	116538	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
18009840	18009840	PRJNA1012699_P_NODE_1695_length_295_cov_1.306306_g1663_i0	PRJNA1012699	1695	295	1.306306	3.8536027	Prevotella bivia	28125	Bacteria	Bacteria	538	1.7199999999999995e-148	NTclustered	gi\|2679198013\|dbj\|AP029376.1\|	28125	g1663	i0	99.66	224.461016949153	294	1	99	0	1	294	1019796	1020089	Prevotella bivia TOH-2715 DNA, chromosome 2, complete sequence	blastn	66216	538	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
20559170	20559170	PRJNA1012699_P_NODE_1617_length_300_cov_1.229075_g1585_i0	PRJNA1012699	1617	300	1.229075	3.687225	Ornithobacterium rhinotracheale	28251	Bacteria	Bacteria	462	1.09e-125	NTclustered	gi\|1560269301\|gb\|CP035107.1\|	28251	g1585	i0	94.631	315.646666666667	298	16	99	0	2	299	363704	364001	Ornithobacterium rhinotracheale strain FARPER-174b chromosome, complete genome	blastn	94694	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Ornithobacterium rhinotracheale
20559226	20559226	PRJNA1012699_P_NODE_4077_length_236_cov_2.380368_g4045_i0	PRJNA1012699	4077	236	2.380368	5.61766848	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	385	1.84e-102	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g4045	i0	96.17	238.483050847458	235	9	99	0	1	235	55244	55010	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	56282	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
21834876	21834876	PRJNA1012699_P_NODE_4158_length_228_cov_2.006452_g4126_i0	PRJNA1012699	4158	228	2.006452	4.57471056	Phnomibacter ginsenosidimutans	2676868	Bacteria	Bacteria	294	3.0600000000000003e-75	NTclustered	gi\|1783227364\|gb\|CP046566.1\|	2676868	g4126	i0	91.943	75.8508771929825	211	15	92	2	13	222	922474	922265	Phnomibacter ginsenosidimutans strain SB-02 chromosome, complete genome	blastn	17294	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Phnomibacter	Phnomibacter ginsenosidimutans
25228674	25228674	PRJNA1012699_P_NODE_2580_length_254_cov_2.430939_g2548_i0	PRJNA1012699	2580	254	2.430939	6.17458506	root	1	Root_unresolved	Root_unresolved	464	2.4999999999999994e-126	NTclustered	gi\|2868812398\|dbj\|LC855767.1\|	50419	g2548	i0	99.606	100	254	1	100	0	1	254	637	384	Flectobacillus sp. FWB18 gene for 16S ribosomal RNA, partial sequence	blastn	25400	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
30666752	30666752	PRJNA1012699_P_NODE_3373_length_247_cov_0.896552_g3341_i0	PRJNA1012699	3373	247	0.896552	2.21448344	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	54.3	3.17e-6	NR	MDZ7778902.1	2026742	g3341	i0	57.5	3.32793522267206	40	17	48.6	0	245	126	514	553	MDZ7778902.1 ankyrin repeat domain-containing protein [Gemmatimonadota bacterium]	diamond	822	54.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31773149	31773149	PRJNA1012699_P_NODE_457_length_507_cov_1.260369_g425_i0	PRJNA1012699	457	507	1.260369	6.39007083	Chitinophaga pollutisoli	3133966	Bacteria	Bacteria	48.1	0.00695	NR	WP_341836319.1	3133966	g425	i0	32.7	0.869822485207101	147	91	86.4	4	27	464	1625	1764	WP_341836319.1 PKD domain-containing protein [Chitinophaga pollutisoli]	diamond	441	48.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga pollutisoli

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