metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA1262902" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA1262902" 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
9291731	9291731	PRJNA1262902_P_NODE_9508_length_247_cov_0.885057_g9466_i0	PRJNA1262902	9508	247	0.885057	2.18609079	Flavisolibacter	398041	Bacteria	Bacteria	143	1.0499999999999998e-37	NR	WP_066403513.1	1492898	g9466	i0	90.1	4.91902834008097	81	8	98.4	0	3	245	95	175	WP_066403513.1 KUP/HAK/KT family potassium transporter [Flavisolibacter tropicus]	diamond	1215	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
26693973	26693973	PRJNA1262902_P_NODE_8321_length_249_cov_0.875000_g8279_i0	PRJNA1262902	8321	249	0.875	2.17875	Flavobacterium caeni	490189	Bacteria	Bacteria	75.5	1.17e-13	NR	WP_091145536.1	490189	g8279	i0	64.3	1.34939759036145	56	19	67.5	1	2	169	744	798	WP_091145536.1 glycoside hydrolase family 31 protein [Flavobacterium caeni]	diamond	336	75.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium caeni
26884198	26884198	PRJNA1262902_P_NODE_3861_length_297_cov_1.241071_g3819_i0	PRJNA1262902	3861	297	1.241071	3.68598087	Aequorivita marina	3073654	Bacteria	Bacteria	115	2.61e-29	NR	WP_310993605.1	3073654	g3819	i0	70.9	0.797979797979798	79	23	79.8	0	295	59	190	268	WP_310993605.1 glycosyltransferase [Aequorivita marina]	diamond	237	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita marina
27912761	27912761	PRJNA1262902_P_NODE_10265_length_245_cov_0.895349_g10223_i0	PRJNA1262902	10265	245	0.895349	2.19360505	Spirosoma	107	Bacteria	Bacteria	119	2.36e-29	NR	WP_077131231.1	1178516	g10223	i0	70	2.9265306122449	80	20	98	1	6	245	175	250	WP_077131231.1 hypothetical protein [Spirosoma montaniterrae]	diamond	717	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
28210716	28210716	PRJNA1262902_P_NODE_8786_length_248_cov_0.880000_g8744_i0	PRJNA1262902	8786	248	0.88	2.1824	Chitinophagales bacterium	2448779	Bacteria	Bacteria	117	2.94e-28	NR	MBX7108124.1	2448779	g8744	i0	70.7	0.991935483870968	82	24	99.2	0	246	1	31	112	MBX7108124.1 TonB-dependent receptor [Chitinophagales bacterium]	diamond	246	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
29473567	29473567	PRJNA1262902_P_NODE_11870_length_242_cov_0.911243_g11828_i0	PRJNA1262902	11870	242	0.911243	2.20520806	Flavobacterium longum	1299340	Bacteria	Bacteria	140	2.18e-36	NR	WP_415582023.1	1299340	g11828	i0	78.8	1.98347107438017	80	17	99.2	0	2	241	464	543	WP_415582023.1 CotH kinase family protein [Flavobacterium longum]	diamond	480	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium longum
29473569	29473569	PRJNA1262902_P_NODE_12310_length_241_cov_0.916667_g12268_i0	PRJNA1262902	12310	241	0.916667	2.20916747	Rhodocytophaga rosea	2704465	Bacteria	Bacteria	51.6	1.59e-5	NR	WP_162447467.1	2704465	g12268	i0	68.4	0.946058091286307	38	12	47.3	0	188	75	172	209	WP_162447467.1 IS5 family transposase [Rhodocytophaga rosea]	diamond	228	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Rhodocytophagaceae	Rhodocytophaga	Rhodocytophaga rosea
30263773	30263773	PRJNA1262902_P_NODE_2392_length_336_cov_1.756654_g2350_i0	PRJNA1262902	2392	336	1.756654	5.90235744	Bacteroidota bacterium	1898104	Bacteria	Bacteria	122	5.329999999999999e-31	NR	MCW3078505.1	1898104	g2350	i0	59.6	1.94642857142857	109	44	97.3	0	330	4	50	158	MCW3078505.1 hypothetical protein [Bacteroidota bacterium]	diamond	654	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30484698	30484698	PRJNA1262902_P_NODE_7873_length_250_cov_0.870056_g7831_i0	PRJNA1262902	7873	250	0.870056	2.17514	Chitinophagales bacterium	2448779	Bacteria	Bacteria	114	8.0399999999999995e-28	NR	MCC6570102.1	2448779	g7831	i0	67.9	1.896	81	25	96	1	242	3	11	91	MCC6570102.1 glycosyltransferase family 39 protein [Chitinophagales bacterium]	diamond	474	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
30610894	30610894	PRJNA1262902_P_NODE_11553_length_242_cov_1.621302_g11511_i0	PRJNA1262902	11553	242	1.621302	3.92355084	Flavobacterium sp.	239	Bacteria	Bacteria	136	2.43e-36	NR	HEX8563154.1	239	g11511	i0	79.5	5.92561983471074	78	16	96.7	0	242	9	328	405	HEX8563154.1 nucleotide sugar dehydrogenase [Flavobacterium sp.]	diamond	1434	136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
31021786	31021786	PRJNA1262902_P_NODE_10115_length_245_cov_0.895349_g10073_i0	PRJNA1262902	10115	245	0.895349	2.19360505	Rhodocytophaga rosea	2704465	Bacteria	Bacteria	119	6.02e-29	NR	WP_162445491.1	2704465	g10073	i0	69.1	0.991836734693878	81	25	99.2	0	2	244	924	1004	WP_162445491.1 PQQ-dependent sugar dehydrogenase [Rhodocytophaga rosea]	diamond	243	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Rhodocytophagaceae	Rhodocytophaga	Rhodocytophaga rosea
31071318	31071318	PRJNA1262902_P_NODE_8195_length_249_cov_1.670455_g8153_i0	PRJNA1262902	8195	249	1.670455	4.15943295	Pedobacter	84567	Bacteria	Bacteria	57.8	8.79e-8	NR	HEX8607729.1	1411316	g8153	i0	60.5	1.03614457831325	43	17	51.8	0	247	119	165	207	HEX8607729.1 HAD family phosphatase [Pedobacter sp.]	diamond	258	57.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp.
31274550	31274550	PRJNA1262902_P_NODE_11175_length_243_cov_0.905882_g11133_i0	PRJNA1262902	11175	243	0.905882	2.20129326	Hymenobacteraceae bacterium	2065362	Bacteria	Bacteria	147	2.75e-41	NR	MBC7446845.1	2065362	g11133	i0	88.8	0.987654320987654	80	9	98.8	0	2	241	232	311	MBC7446845.1 aspartate-semialdehyde dehydrogenase [Hymenobacteraceae bacterium]	diamond	240	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae		Hymenobacteraceae bacterium
31938682	31938682	PRJNA1262902_P_NODE_11837_length_242_cov_0.911243_g11795_i0	PRJNA1262902	11837	242	0.911243	2.20520806	Ferruginibacter sp.	1940288	Bacteria	Bacteria	112	2.66e-28	NR	MBX2887264.1	1940288	g11795	i0	65	1.98347107438017	80	28	99.2	0	242	3	73	152	MBX2887264.1 polysaccharide biosynthesis/export family protein [Ferruginibacter sp.]	diamond	480	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
32065337	32065337	PRJNA1262902_P_NODE_9538_length_246_cov_2.040462_g9496_i0	PRJNA1262902	9538	246	2.040462	5.01953652	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	107	2.06e-27	NR	MBK9731950.1	1869212	g9496	i0	85.7	1.53658536585366	63	9	76.8	0	242	54	116	178	MBK9731950.1 sigma-70 family RNA polymerase sigma factor [Chitinophagaceae bacterium]	diamond	378	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32097007	32097007	PRJNA1262902_P_NODE_7938_length_250_cov_0.870056_g7896_i0	PRJNA1262902	7938	250	0.870056	2.17514	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	52.4	1.47e-5	NR	HOU67150.1	2748031	g7896	i0	58	0.6	50	21	60	0	153	4	12	61	HOU67150.1 DUF6353 family protein [Paludibacteraceae bacterium]	diamond	150	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
32255630	32255630	PRJNA1262902_P_NODE_9458_length_247_cov_0.885057_g9416_i0	PRJNA1262902	9458	247	0.885057	2.18609079	Flavobacterium sp.	239	Bacteria	Bacteria	123	1.97e-30	NR	MBF6608679.1	239	g9416	i0	89.2	1.57894736842105	65	7	78.9	0	2	196	691	755	MBF6608679.1 aconitate hydratase [Flavobacterium sp.]	diamond	390	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
32666006	32666006	PRJNA1262902_P_NODE_1860_length_360_cov_1.404181_g1818_i0	PRJNA1262902	1860	360	1.404181	5.0550516	Flavobacterium sp.	239	Bacteria	Bacteria	239	1.4299999999999999e-74	NR	MBP9792626.1	239	g1818	i0	96.6	0.991666666666667	119	4	99.2	0	359	3	52	170	MBP9792626.1 recombinase family protein [Flavobacterium sp.]	diamond	357	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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