metadata: contig_metadata: 18 rows where bioproject = "PRJNA393181" and tax

18 rows where bioproject = "PRJNA393181" 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
1685346	1685346	PRJNA393181_S_NODE_29182_length_209_cov_1.412791_g29076_i0	PRJNA393181	29182	209	1.412791	2.95273319	Hymenobacter monticola	1705399	Bacteria	Bacteria	58.4	3.94e-4	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g29076	i0	100	0.425837320574163	31	0	15	0	163	193	4524766	4524796	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	89	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
1685736	1685736	PRJNA393181_S_NODE_45662_length_155_cov_1.313559_g45556_i0	PRJNA393181	45662	155	1.313559	2.03601645	Flavitalea sp.	1909289	Bacteria	Bacteria	69.7	9.75e-14	NR	HRE52273.1	1909289	g45556	i0	60.4	0.929032258064516	48	19	92.9	0	2	145	15	62	HRE52273.1 superinfection immunity protein [Flavitalea sp.]	diamond	144	69.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavitalea	Flavitalea sp.
8063378	8063378	PRJNA393181_S_NODE_13807_length_324_cov_3.271777_g13701_i0	PRJNA393181	13807	324	3.271777	10.60055748	Bacteroidales bacterium	2030927	Bacteria	Bacteria	102	1.58e-25	NR	NJO54033.1	2030927	g13701	i0	73.5	1.25925925925926	68	18	63	0	6	209	54	121	NJO54033.1 septal ring lytic transglycosylase RlpA family protein [Bacteroidales bacterium]	diamond	408	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
10006580	10006580	PRJNA393181_S_NODE_29948_length_205_cov_2.053571_g29842_i0	PRJNA393181	29948	205	2.053571	4.20982055	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g29842	i0	100	1.68292682926829	29	0	14	0	45	73	790932	790960	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	345	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
13831811	13831811	PRJNA393181_S_NODE_16151_length_298_cov_2.053640_g16045_i0	PRJNA393181	16151	298	2.05364	6.1198472	Cloacibacterium	501783	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g16045	i0	100	498.58389261745	298	0	100	0	1	298	130494	130197	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	148578	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15712819	15712819	PRJNA393181_S_NODE_15593_length_304_cov_2.029963_g15487_i0	PRJNA393181	15593	304	2.029963	6.17108752	Hymenobacter monticola	1705399	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g15487	i0	94.444	0.674342105263158	36	2	12	0	131	166	2899871	2899906	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	205	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
15713573	15713573	PRJNA393181_S_NODE_44993_length_156_cov_2.268908_g44887_i0	PRJNA393181	44993	156	2.268908	3.53949648	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	244	1.9799999999999998e-60	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g44887	i0	94.872	282.596153846154	156	8	100	0	1	156	586473	586628	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	44085	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
18262241	18262241	PRJNA393181_S_NODE_34375_length_187_cov_2.033333_g34269_i0	PRJNA393181	34375	187	2.033333	3.80233271	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g34269	i0	100	248.625668449198	187	0	100	0	1	187	339013	338827	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	46493	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
28639770	28639770	PRJNA393181_S_NODE_4127_length_550_cov_2.499025_g4026_i0	PRJNA393181	4127	550	2.499025	13.7446375	Pseudomonadati	3379134	Bacteria	Bacteria	133	8.44e-36	NR	WP_321564215.1	1173583	g4026	i0	42.9	2.81454545454545	170	53	68.7	1	173	550	7	176	WP_321564215.1 GNAT family N-acetyltransferase [Mucilaginibacter sabulilitoris]	diamond	1548	134	0.992537313432836	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sabulilitoris
28749038	28749038	PRJNA393181_S_NODE_18307_length_277_cov_2.991667_g18201_i0	PRJNA393181	18307	277	2.991667	8.28691759	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	80.9	2.74e-16	NR	MBK9275535.1	2021391	g18201	i0	56.9	0.703971119133574	65	28	70.4	0	195	1	119	183	MBK9275535.1 hypothetical protein [Flavobacteriales bacterium]	diamond	195	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
28923575	28923575	PRJNA393181_S_NODE_31088_length_200_cov_1.975460_g30982_i0	PRJNA393181	31088	200	1.97546	3.95092	Mucilaginibacter	423349	Bacteria	Bacteria	46.2	0.0013	NR	WP_273630708.1	1176721	g30982	i0	60	1.515	35	14	52.5	0	1	105	1802	1836	WP_273630708.1 MBG domain-containing protein [Mucilaginibacter jinjuensis]	diamond	303	46.6	0.991416309012876	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter jinjuensis
29822355	29822355	PRJNA393181_S_NODE_26591_length_221_cov_1.842391_g26485_i0	PRJNA393181	26591	221	1.842391	4.07168411	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0191	NR	MBK8686221.1	1898104	g26485	i0	42	0.678733031674208	50	28	66.5	1	190	44	132	181	MBK8686221.1 glutamate racemase [Bacteroidota bacterium]	diamond	150	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30486099	30486099	PRJNA393181_S_NODE_38353_length_174_cov_1.678832_g38247_i0	PRJNA393181	38353	174	1.678832	2.92116768	Bacteroidota bacterium	1898104	Bacteria	Bacteria	56.2	2.62e-7	NR	MBS1499391.1	1898104	g38247	i0	65.8	3.22413793103448	38	13	65.5	0	58	171	1	38	MBS1499391.1 glycosyltransferase [Bacteroidota bacterium]	diamond	561	56.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30692329	30692329	PRJNA393181_S_NODE_35753_length_182_cov_2.820690_g35647_i0	PRJNA393181	35753	182	2.82069	5.1336558	Pseudomonadati	3379134	Bacteria	Bacteria	68.6	1.28e-11	NR	MBO9659554.1	1869212	g35647	i0	67.2	2.96703296703297	61	17	97.3	2	5	181	193	252	MBO9659554.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	540	68.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30801897	30801897	PRJNA393181_S_NODE_10974_length_364_cov_3.348624_g10868_i0	PRJNA393181	10974	364	3.348624	12.18899136	Bacteroidota bacterium	1898104	Bacteria	Bacteria	80.9	4.61e-16	NR	MEM1042165.1	1898104	g10868	i0	59.7	0.552197802197802	67	27	55.2	0	162	362	5	71	MEM1042165.1 transposase [Bacteroidota bacterium]	diamond	201	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31735473	31735473	PRJNA393181_S_NODE_10457_length_373_cov_2.991071_g10351_i0	PRJNA393181	10457	373	2.991071	11.15669483	FCB group	1783270	Bacteria	Bacteria	192	3.61e-58	NR	MCO6478012.1	1940289	g10351	i0	70.2	3.98927613941019	124	37	99.7	0	373	2	66	189	MCO6478012.1 AAA family ATPase [Phaeodactylibacter sp.]	diamond	1488	192	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Phaeodactylibacter	Phaeodactylibacter sp.
32604530	32604530	PRJNA393181_S_NODE_7940_length_423_cov_3.189119_g7834_i0	PRJNA393181	7940	423	3.189119	13.48997337	Bacteroidota bacterium	1898104	Bacteria	Bacteria	127	5.779999999999999e-32	NR	MEO1255790.1	1898104	g7834	i0	42	1.01418439716312	143	74	95.7	3	415	11	251	392	MEO1255790.1 hypothetical protein [Bacteroidota bacterium]	diamond	429	127	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32715730	32715730	PRJNA393181_S_NODE_7560_length_433_cov_2.368687_g7454_i0	PRJNA393181	7560	433	2.368687	10.25641471	Bacteroidota	976	Bacteria	Bacteria	139	4.1699999999999996e-39	NR	WP_171656744.1	49546	g7454	i0	43	7.89145496535797	142	76	94.9	1	417	7	2	143	WP_171656744.1 MULTISPECIES: SMI1/KNR4 family protein [Flavobacteriaceae]	diamond	3417	140	0.992857142857143	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae

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