metadata: contig_metadata: 16 rows where bioproject = "PRJNA982106", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA982106", tax_kingdom = "Pseudomonadati" and tax_phylum = "Gemmatimonadota"

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
16266897	16266897	PRJNA982106_P_NODE_30753_length_242_cov_0.911243_g30513_i0	PRJNA982106	30753	242	0.911243	2.20520806	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	213	9.45e-51	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g30513	i0	83.475	6.7603305785124	236	31	97	5	8	242	238195	237967	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	1636	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19122477	19122477	PRJNA982106_P_NODE_30735_length_242_cov_0.911243_g30495_i0	PRJNA982106	30735	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	81.3	3.8e-16	NR	HKW48038.1	2026741	g30495	i0	83	3.49586776859504	47	8	58.3	0	141	1	1	47	HKW48038.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	846	81.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27095503	27095503	PRJNA982106_P_NODE_29842_length_243_cov_0.905882_g29602_i0	PRJNA982106	29842	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	158	7.83e-44	NR	HEX7977213.1	2026741	g29602	i0	98.8	2	81	1	100	0	1	243	222	302	HEX7977213.1 M56 family metallopeptidase [Gemmatimonadaceae bacterium]	diamond	486	158	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27443503	27443503	PRJNA982106_P_NODE_21063_length_251_cov_0.865169_g20823_i0	PRJNA982106	21063	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	98.6	3.4000000000000003e-22	NR	OYV64923.1	1970514	g20823	i0	56.6	7.80478087649402	83	36	99.2	0	249	1	192	274	OYV64923.1 MAG: hypothetical protein B7Z72_12705, partial [Gemmatimonadetes bacterium 21-71-4]	diamond	1959	99.4	0.991951710261569	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium 21-71-4
28637195	28637195	PRJNA982106_P_NODE_21967_length_250_cov_0.870056_g21727_i0	PRJNA982106	21967	250	0.870056	2.17514	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	147	2.97e-41	NR	HKC41269.1	2448054	g21727	i0	84	0.972	81	13	97.2	0	2	244	117	197	HKC41269.1 S1/P1 nuclease [Gemmatimonadales bacterium]	diamond	243	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29079133	29079133	PRJNA982106_P_NODE_24088_length_248_cov_0.880000_g23848_i0	PRJNA982106	24088	248	0.88	2.1824	Longimicrobium sp.	2029185	Bacteria	Bacteria	132	9.23e-37	NR	HLM66679.1	2029185	g23848	i0	74.4	0.991935483870968	82	21	99.2	0	1	246	9	90	HLM66679.1 hypothetical protein [Longimicrobium sp.]	diamond	246	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29521020	29521020	PRJNA982106_P_NODE_30430_length_243_cov_0.905882_g30190_i0	PRJNA982106	30430	243	0.905882	2.20129326	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	137	3.69e-39	NR	MDP9200977.1	2026742	g30190	i0	87.1	0.864197530864197	70	9	86.4	0	241	32	92	161	MDP9200977.1 D-hexose-6-phosphate mutarotase [Gemmatimonadota bacterium]	diamond	210	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29678575	29678575	PRJNA982106_P_NODE_25550_length_247_cov_0.885057_g25310_i0	PRJNA982106	25550	247	0.885057	2.18609079	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	150	1.71e-41	NR	HMH86450.1	2026741	g25310	i0	91.4	3.93522267206478	81	7	98.4	0	3	245	108	188	HMH86450.1 bifunctional UDP-3-O-[3-hydroxymyristoyl] N-acetylglucosamine deacetylase/3-hydroxyacyl-ACP dehydratase [Gemmatimonadaceae bacterium]	diamond	972	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30279464	30279464	PRJNA982106_P_NODE_33092_length_228_cov_2.651613_g32852_i0	PRJNA982106	33092	228	2.651613	6.04567764	Longimicrobium sp.	2029185	Bacteria	Bacteria	139	6.59e-39	NR	WP_329686386.1	2029185	g32852	i0	89.2	2.92105263157895	74	8	97.4	0	6	227	1	74	WP_329686386.1 prolipoprotein diacylglyceryl transferase [Longimicrobium sp.]	diamond	666	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30285491	30285491	PRJNA982106_P_NODE_27412_length_245_cov_0.895349_g27172_i0	PRJNA982106	27412	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	90.1	6.72e-19	NR	HMI49452.1	2026741	g27172	i0	69.1	16.8612244897959	81	25	99.2	0	245	3	221	301	HMI49452.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	4131	90.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30342799	30342799	PRJNA982106_P_NODE_22712_length_249_cov_0.875000_g22472_i0	PRJNA982106	22712	249	0.875	2.17875	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	90.1	2.55e-20	NR	HZE09488.1	2026741	g22472	i0	58.8	0.819277108433735	68	28	81.9	0	2	205	124	191	HZE09488.1 S24 family peptidase [Gemmatimonadaceae bacterium]	diamond	204	90.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30626464	30626464	PRJNA982106_P_NODE_23653_length_249_cov_0.875000_g23413_i0	PRJNA982106	23653	249	0.875	2.17875	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	118	1.87e-30	NR	MEO7084700.1	2026741	g23413	i0	74.4	3.93975903614458	82	21	98.8	0	248	3	60	141	MEO7084700.1 tRNA pseudouridine(55) synthase TruB [Gemmatimonadaceae bacterium]	diamond	981	118	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30689725	30689725	PRJNA982106_P_NODE_24653_length_248_cov_0.880000_g24413_i0	PRJNA982106	24653	248	0.88	2.1824	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	117	1.18e-30	NR	HZA94415.1	2448054	g24413	i0	83.8	0.82258064516129	68	11	82.3	0	1	204	14	81	HZA94415.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	204	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30753048	30753048	PRJNA982106_P_NODE_30854_length_242_cov_0.911243_g30614_i0	PRJNA982106	30854	242	0.911243	2.20520806	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	140	5.41e-38	NR	HEY4131929.1	2026741	g30614	i0	88.8	5.9504132231405	80	9	99.2	0	2	241	306	385	HEY4131929.1 efflux RND transporter periplasmic adaptor subunit [Gemmatimonadaceae bacterium]	diamond	1440	140	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31194957	31194957	PRJNA982106_P_NODE_30075_length_243_cov_0.905882_g29835_i0	PRJNA982106	30075	243	0.905882	2.20129326	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	126	1.4e-32	NR	HEV8455187.1	2448054	g29835	i0	96.6	0.728395061728395	59	2	72.8	0	67	243	1	59	HEV8455187.1 amidohydrolase family protein [Gemmatimonadales bacterium]	diamond	177	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32213729	32213729	PRJNA982106_P_NODE_32598_length_241_cov_0.916667_g32358_i0	PRJNA982106	32598	241	0.916667	2.20916747	FCB group	1783270	Bacteria	Bacteria	106	3.36e-25	NR	HTJ21870.1	2026741	g32358	i0	94.5	6.84647302904564	55	3	68.5	0	165	1	1	55	HTJ21870.1 DNA repair exonuclease [Gemmatimonadaceae bacterium]	diamond	1650	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium

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