metadata: contig_metadata: 28 rows where bioproject = "PRJNA1262902" and tax

28 rows where 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
2914234	2914234	PRJNA1262902_P_NODE_143_length_981_cov_2.647577_g116_i0	PRJNA1262902	143	981	2.647577	25.97273037	Hymenobacter volaticus	2932254	Bacteria	Bacteria	1701	0	NTclustered	gi\|2221934578\|gb\|CP095067.1\|	2932254	g116	i0	97.965	285.439347604485	983	17	100	3	1	981	64477	63496	Hymenobacter volaticus strain 5420 S-77 plasmid unnamed6, complete sequence	blastn	280016	1701	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter volaticus
2914276	2914276	PRJNA1262902_P_NODE_7943_length_250_cov_0.870056_g7901_i0	PRJNA1262902	7943	250	0.870056	2.17514	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	448	2.4699999999999996e-121	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g7901	i0	98.81	1.008	252	1	100	1	1	250	370122	370373	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	252	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
2914286	2914286	PRJNA1262902_P_NODE_8863_length_248_cov_0.880000_g8821_i0	PRJNA1262902	8863	248	0.88	2.1824	Chryseobacterium indologenes	253	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g8821	i0	100	10.9879032258065	248	0	100	0	1	248	4724376	4724129	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	2725	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
6741342	6741342	PRJNA1262902_P_NODE_7606_length_251_cov_0.865169_g7564_i0	PRJNA1262902	7606	251	0.865169	2.17157419	Chryseobacterium sp. CY350	2997336	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|2430443073\|gb\|CP116034.1\|	2997336	g7564	i0	85.83	15.4980079681275	247	35	98	0	5	251	598711	598465	Chryseobacterium sp. CY350 chromosome, complete genome	blastn	3890	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. CY350
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
15666413	15666413	PRJNA1262902_P_NODE_1613_length_376_cov_6.372937_g1571_i0	PRJNA1262902	1613	376	6.372937	23.96224312	Flavobacterium fluviale	2249356	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g1571	i0	100	0.0771276595744681	29	0	8	0	343	371	115149	115121	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
20765078	20765078	PRJNA1262902_P_NODE_2017_length_352_cov_1.347670_g1975_i0	PRJNA1262902	2017	352	1.34767	4.7437984	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	444	4.699999999999998e-120	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g1975	i0	90.719	222.068181818182	334	29	94	2	8	339	1076929	1076596	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	78168	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
22040192	22040192	PRJNA1262902_P_NODE_2518_length_332_cov_2.675676_g2476_i0	PRJNA1262902	2518	332	2.675676	8.88324432	Hymenobacter tibetensis	497967	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|2218432809\|gb\|CP094673.1\|	497967	g2476	i0	99.699	267.551204819277	332	1	100	0	1	332	59235	59566	Hymenobacter tibetensis strain KACC 21982 plasmid unnamed4, complete sequence	blastn	88827	608	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter tibetensis
23315679	23315679	PRJNA1262902_P_NODE_1919_length_357_cov_2.309859_g1877_i0	PRJNA1262902	1919	357	2.309859	8.24619663	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	545	1.27e-150	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g1877	i0	94.15	10.8487394957983	359	19	100	1	1	357	3149230	3149588	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	3873	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
23315740	23315740	PRJNA1262902_P_NODE_9719_length_246_cov_0.890173_g9677_i0	PRJNA1262902	9719	246	0.890173	2.18982558	uncultured Flavobacteriaceae bacterium	165436	Bacteria	Bacteria	255	1.58e-63	NTclustered	gi\|921059534\|gb\|KP887319.1\|	165436	g9677	i0	90.452	125.40243902439	199	11	78	8	42	233	1811	1614	Uncultured Flavobacteriaceae bacterium clone 201_DPL 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30849	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		uncultured Flavobacteriaceae bacterium
24005988	24005988	PRJNA1262902_P_NODE_5999_length_265_cov_2.328125_g5957_i0	PRJNA1262902	5999	265	2.328125	6.16953125	Fluviicola	332102	Bacteria	Bacteria	333	7.719999999999999e-87	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g5957	i0	93.363	213.139622641509	226	14	85	1	17	242	1431	1207	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	56482	335	0.994029850746269	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
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);;