metadata: contig_metadata: 8 rows where bioproject = "PRJNA454503" and tax

8 rows where bioproject = "PRJNA454503" 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
442557	442557	PRJNA454503_P_NODE_50561_length_215_cov_1.441558_g50232_i0	PRJNA454503	50561	215	1.441558	3.0993497	Longimicrobium sp.	2029185	Bacteria	Bacteria	128	2.27e-32	NR	HEX8673179.1	2029185	g50232	i0	87.3	0.990697674418605	71	9	99.1	0	1	213	125	195	HEX8673179.1 hypothetical protein [Longimicrobium sp.]	diamond	213	128	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
8095666	8095666	PRJNA454503_P_NODE_49647_length_216_cov_1.432258_g49318_i0	PRJNA454503	49647	216	1.432258	3.09367728	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	91.7	1.56e-19	NR	HEY9506457.1	2448054	g49318	i0	58.3	5	72	30	100	0	216	1	39	110	HEY9506457.1 proton-conducting transporter membrane subunit [Gemmatimonadales bacterium]	diamond	1080	91.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
9370597	9370597	PRJNA454503_P_NODE_69928_length_206_cov_1.793103_g69599_i0	PRJNA454503	69928	206	1.793103	3.69379218	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	137	4.83e-28	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g69599	i0	83.916	2.44174757281553	143	23	69	0	60	202	2293467	2293325	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	503	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
17020249	17020249	PRJNA454503_P_NODE_80414_length_203_cov_1.767606_g80085_i0	PRJNA454503	80414	203	1.767606	3.58824018	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	291	3.44e-74	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g80085	i0	94.709	15.2463054187192	189	6	92	4	1	186	3043406	3043219	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	3095	291	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24668314	24668314	PRJNA454503_P_NODE_20800_length_265_cov_0.965686_g20471_i0	PRJNA454503	20800	265	0.965686	2.5590679	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	370	5.89e-98	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g20471	i0	92.664	230.581132075472	259	15	97	4	1	257	1904489	1904745	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	61104	370	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
28023780	28023780	PRJNA454503_P_NODE_71945_length_206_cov_0.896552_g71616_i0	PRJNA454503	71945	206	0.896552	1.84689712	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	57.8	1.14e-7	NR	HSE45865.1	2448054	g71616	i0	43.8	2.79611650485437	64	34	93.2	1	204	13	48	109	HSE45865.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	576	57.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29776357	29776357	PRJNA454503_P_NODE_20331_length_267_cov_1.262136_g20002_i0	PRJNA454503	20331	267	1.262136	3.36990312	Bacteria	2	Bacteria	Bacteria	53.5	7.86e-6	NR	MFQ5678369.1	2026742	g20002	i0	46	4.10112359550562	63	28	66.3	3	2	178	745	805	MFQ5678369.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadota bacterium]	diamond	1095	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32099258	32099258	PRJNA454503_P_NODE_84398_length_202_cov_0.921986_g84069_i0	PRJNA454503	84398	202	0.921986	1.86241172	Longimicrobium sp.	2029185	Bacteria	Bacteria	124	5.29e-31	NR	HEV7588876.1	2029185	g84069	i0	88.7	0.920792079207921	62	7	92.1	0	202	17	430	491	HEV7588876.1 lantibiotic dehydratase [Longimicrobium sp.]	diamond	186	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium 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);;