metadata: contig_metadata: 20 rows where bioproject = "PRJNA1192965" and tax

20 rows where bioproject = "PRJNA1192965" and tax_phylum = "Bacteroidota"

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
4147406	4147406	PRJNA1192965_P_NODE_144_length_891_cov_2.152812_g131_i0	PRJNA1192965	144	891	2.152812	19.18155492	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	394	6.969999999999998e-128	NR	MCA6491779.1	1869212	g131	i0	67.8	0.962962962962963	286	83	96.3	2	1	858	2	278	MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium]	diamond	858	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
9248435	9248435	PRJNA1192965_P_NODE_4488_length_244_cov_1.801170_g4469_i0	PRJNA1192965	4488	244	1.80117	4.3948548	Tannerella sp. oral taxon BU	2382127	Bacteria	Bacteria	171	2.92e-47	NR	ETK10705.1	1411021	g4469	i0	100	0.983606557377049	80	0	98.4	0	242	3	480	559	ETK10705.1 methylase, partial [Tannerella sp. oral taxon BU063 isolate Cell 6/7/9]	diamond	240	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
13074096	13074096	PRJNA1192965_P_NODE_2051_length_298_cov_1.026667_g2032_i0	PRJNA1192965	2051	298	1.026667	3.05946766	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	383	8.65e-102	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g2032	i0	92.565	113.355704697987	269	16	90	4	32	298	2977762	2978028	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	33780	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
15623296	15623296	PRJNA1192965_P_NODE_3833_length_248_cov_0.880000_g3814_i0	PRJNA1192965	3833	248	0.88	2.1824	Runella sp. SP2	2268026	Bacteria	Bacteria	401	1.9299999999999994e-107	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g3814	i0	95.951	181.862903225806	247	10	99	0	2	248	5734442	5734688	Runella sp. SP2 chromosome, complete genome	blastn	45102	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
17620151	17620151	PRJNA1192965_P_NODE_2334_length_285_cov_0.830189_g2315_i0	PRJNA1192965	2334	285	0.830189	2.36603865	Flavobacterium	237	Bacteria	Bacteria	383	8.22e-102	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g2315	i0	96.537	271.280701754386	231	8	81	0	1	231	718533	718303	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	77315	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
21997248	21997248	PRJNA1192965_P_NODE_78_length_1082_cov_2.207136_g69_i0	PRJNA1192965	78	1082	2.207136	23.88121152	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	512	7.019999999999999e-173	NR	MCA6491779.1	1869212	g69	i0	67.4	0.995378927911275	359	116	99.5	1	1079	3	329	686	MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium]	diamond	1077	512	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
26755658	26755658	PRJNA1192965_P_NODE_4361_length_245_cov_0.895349_g4342_i0	PRJNA1192965	4361	245	0.895349	2.19360505	Bacteroidota bacterium	1898104	Bacteria	Bacteria	82.8	3.06e-16	NR	MEM0997395.1	1898104	g4342	i0	50.6	3.97959183673469	81	40	99.2	0	245	3	806	886	MEM0997395.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium]	diamond	975	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27293594	27293594	PRJNA1192965_P_NODE_3223_length_252_cov_1.463687_g3204_i0	PRJNA1192965	3223	252	1.463687	3.68849124	Bacteroidota bacterium	1898104	Bacteria	Bacteria	97.4	2.51e-21	NR	MBK9448845.1	1898104	g3204	i0	57	1.88095238095238	79	34	94	0	10	246	678	756	MBK9448845.1 gliding motility-associated C-terminal domain-containing protein [Bacteroidota bacterium]	diamond	474	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27420285	27420285	PRJNA1192965_P_NODE_943_length_399_cov_0.944785_g924_i0	PRJNA1192965	943	399	0.944785	3.76969215	Dysgonamonadaceae bacterium	2065189	Bacteria	Bacteria	55.1	8.81e-6	NR	MDD4727728.1	2065189	g924	i0	31.1	0.992481203007519	132	80	98.5	3	3	395	172	293	MDD4727728.1 DNA polymerase IV [Dysgonamonadaceae bacterium]	diamond	396	55.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonamonadaceae bacterium
27546330	27546330	PRJNA1192965_P_NODE_724_length_444_cov_1.037736_g705_i0	PRJNA1192965	724	444	1.037736	4.60754784	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	52.4	1.41e-4	NR	MDX1478598.1	2202734	g705	i0	38.4	0.668918918918919	99	58	66.9	1	299	3	997	1092	MDX1478598.1 hypothetical protein [Saprospiraceae bacterium]	diamond	297	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
28082981	28082981	PRJNA1192965_P_NODE_1465_length_337_cov_2.780303_g1446_i0	PRJNA1192965	1465	337	2.780303	9.36962111	Mesoflavibacter sp. CH_XMU14	1930902	Bacteria	Bacteria	88.2	5.54e-19	NR	WP_336065625.1	3107766	g1446	i0	53.7	1.45994065281899	82	37	72.1	1	247	5	43	124	WP_336065625.1 glycoside hydrolase family 19 protein [Mesoflavibacter sp. CH_XMU1404-2]	diamond	492	88.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Mesoflavibacter	Mesoflavibacter sp. CH_XMU1404-2
28082983	28082983	PRJNA1192965_P_NODE_3265_length_251_cov_1.297753_g3246_i0	PRJNA1192965	3265	251	1.297753	3.25736003	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	50.4	8.13e-5	NR	NNE25220.1	2202734	g3246	i0	37.3	1.69721115537849	83	52	99.2	0	250	2	619	701	NNE25220.1 DUF11 domain-containing protein [Saprospiraceae bacterium]	diamond	426	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
28525273	28525273	PRJNA1192965_P_NODE_2547_length_276_cov_1.517241_g2528_i0	PRJNA1192965	2547	276	1.517241	4.18758516	Bacteroidia bacterium	2044936	Bacteria	Bacteria	46.2	0.00325	NR	MFK7972564.1	2044936	g2528	i0	32.1	0.847826086956522	78	42	84.8	2	245	12	330	396	MFK7972564.1 MORN repeat-containing protein [Bacteroidia bacterium]	diamond	234	46.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
28620015	28620015	PRJNA1192965_P_NODE_1187_length_366_cov_1.982935_g1168_i0	PRJNA1192965	1187	366	1.982935	7.2575421	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	127	4.48e-31	NR	MCA6491779.1	1869212	g1168	i0	52.6	0.934426229508197	114	52	93.4	2	1	342	718	829	MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium]	diamond	342	127	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28808953	28808953	PRJNA1192965_P_NODE_4688_length_243_cov_1.782353_g4669_i0	PRJNA1192965	4688	243	1.782353	4.33111779	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	77.8	1.63e-14	NR	MFK7772512.1	2202734	g4669	i0	50.9	2.12345679012346	57	27	69.1	1	172	5	48	104	MFK7772512.1 hypothetical protein [Saprospiraceae bacterium]	diamond	516	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
28828138	28828138	PRJNA1192965_P_NODE_2608_length_273_cov_2.310000_g2589_i0	PRJNA1192965	2608	273	2.31	6.3063	Pseudomonadati	3379134	Bacteria	Bacteria	67.4	2.46e-11	NR	WP_092133343.1	283786	g2589	i0	45	1.8021978021978	80	44	87.9	0	271	32	88	167	WP_092133343.1 glycoside hydrolase family 19 protein [Bizionia paragorgiae]	diamond	492	67.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Bizionia	Bizionia paragorgiae
28967295	28967295	PRJNA1192965_P_NODE_2408_length_281_cov_7.177885_g2389_i0	PRJNA1192965	2408	281	7.177885	20.16985685	Bacteroidota bacterium	1898104	Bacteria	Bacteria	110	8.39e-29	NR	MFM1913008.1	1898104	g2389	i0	61.9	1.84697508896797	84	32	89.7	0	279	28	7	90	MFM1913008.1 hypothetical protein [Bacteroidota bacterium]	diamond	519	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30262186	30262186	PRJNA1192965_P_NODE_4532_length_244_cov_0.900585_g4513_i0	PRJNA1192965	4532	244	0.900585	2.1974274	Gelidibacter salicanalis	291193	Bacteria	Bacteria	74.7	2.15e-13	NR	WP_146893812.1	291193	g4513	i0	48.1	2.02868852459016	81	38	98.4	2	243	4	1466	1543	WP_146893812.1 gliding motility-associated C-terminal domain-containing protein [Gelidibacter salicanalis]	diamond	495	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Gelidibacter	Gelidibacter salicanalis
30640933	30640933	PRJNA1192965_P_NODE_2333_length_285_cov_1.037736_g2314_i0	PRJNA1192965	2333	285	1.037736	2.9575476	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	103	2.5699999999999998e-23	NR	MFN4253882.1	2202734	g2314	i0	57.6	0.968421052631579	92	35	96.8	3	3	278	241	328	MFN4253882.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium]	diamond	276	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
31431158	31431158	PRJNA1192965_P_NODE_4036_length_247_cov_0.885057_g4017_i0	PRJNA1192965	4036	247	0.885057	2.18609079	Bacteroidetes bacterium SB0662_bin_6	2604895	Bacteria	Bacteria	95.9	7.54e-21	NR	MYE04204.1	2604895	g4017	i0	54.3	2.95141700404858	81	35	98.4	1	3	245	329	407	MYE04204.1 glutamine synthetase type III [Bacteroidetes bacterium SB0662_bin_6]	diamond	729	95.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium SB0662_bin_6

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