metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
14761992	14761992	PRJNA758087_P_NODE_14352_length_791_cov_12.417827_g13137_i0	PRJNA758087	14352	791	12.417827	98.22501157	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	293	1.72e-94	NR	MFN8092163.1	2793154	g13137	i0	89.2	1.26675094816688	167	18	63.3	0	505	5	1	167	MFN8092163.1 ArsA family ATPase [Vicinamibacteria bacterium]	diamond	1002	293	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
21135682	21135682	PRJNA758087_P_NODE_17797_length_675_cov_5.833887_g16516_i0	PRJNA758087	17797	675	5.833887	39.37873725	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	188	2.54e-51	NR	HZF08511.1	2651171	g16516	i0	84.7	0.493333333333333	111	12	48.4	2	349	23	1	108	HZF08511.1 DUF3604 domain-containing protein [Thermoanaerobaculia bacterium]	diamond	333	188	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22410945	22410945	PRJNA758087_P_NODE_33738_length_354_cov_2.309609_g32418_i0	PRJNA758087	33738	354	2.309609	8.17601586	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	97.4	6.989999999999999e-23	NR	HTQ98429.1	3069120	g32418	i0	63.6	0.559322033898305	66	24	55.9	0	39	236	97	162	HTQ98429.1 DUF6644 family protein [Candidatus Acidiferrum sp.]	diamond	198	97.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
26641403	26641403	PRJNA758087_P_NODE_40841_length_261_cov_2.117021_g39521_i0	PRJNA758087	40841	261	2.117021	5.52542481	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	43.5	0.0212	NR	MEO6590451.1	2283092	g39521	i0	100	0.252873563218391	22	0	25.3	0	231	166	211	232	MEO6590451.1 VIT1/CCC1 transporter family protein [Pyrinomonadaceae bacterium]	diamond	66	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
26957864	26957864	PRJNA758087_P_NODE_19642_length_623_cov_4.289091_g18341_i0	PRJNA758087	19642	623	4.289091	26.72103693	Blastocatellia bacterium	2052146	Bacteria	Bacteria	108	4.12e-27	NR	HKQ79976.1	2052146	g18341	i0	71	0.332263242375602	69	19	33.2	1	621	415	7	74	HKQ79976.1 MbtH family protein [Blastocatellia bacterium]	diamond	207	108	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
27337547	27337547	PRJNA758087_P_NODE_14443_length_788_cov_11.890909_g13227_i0	PRJNA758087	14443	788	11.890909	93.70036292	Terriglobales bacterium	2282142	Bacteria	Bacteria	117	1.06e-25	NR	HMC73736.1	2282142	g13227	i0	55.1	1.47335025380711	98	44	37.3	0	117	410	410	507	HMC73736.1 hypothetical protein [Terriglobales bacterium]	diamond	1161	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27400742	27400742	PRJNA758087_P_NODE_43343_length_243_cov_0.905882_g42023_i0	PRJNA758087	43343	243	0.905882	2.20129326	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	149	1.27e-39	NR	HZZ40784.1	2052142	g42023	i0	93.8	1	81	5	100	0	1	243	244	324	HZZ40784.1 DNA polymerase I [Acidobacteriaceae bacterium]	diamond	243	149	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
28600554	28600554	PRJNA758087_P_NODE_42987_length_245_cov_0.895349_g41667_i0	PRJNA758087	42987	245	0.895349	2.19360505	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	106	1.73e-24	NR	HLX07428.1	2651171	g41667	i0	69.1	2.97551020408163	81	24	98	1	5	244	470	550	HLX07428.1 S8 family serine peptidase [Thermoanaerobaculia bacterium]	diamond	729	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28789735	28789735	PRJNA758087_P_NODE_43507_length_242_cov_0.911243_g42187_i0	PRJNA758087	43507	242	0.911243	2.20520806	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.0106	NR	MCA1636601.1	1978231	g42187	i0	42.9	0.78099173553719	63	29	69.4	1	1	168	602	664	MCA1636601.1 tetratricopeptide repeat protein [Acidobacteriota bacterium]	diamond	189	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29358291	29358291	PRJNA758087_P_NODE_39569_length_278_cov_1.390244_g38249_i0	PRJNA758087	39569	278	1.390244	3.86487832	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	163	1.06e-46	NR	HEX3660992.1	2052142	g38249	i0	82.6	2.96762589928058	92	16	99.3	0	3	278	169	260	HEX3660992.1 SH3 domain-containing protein [Acidobacteriaceae bacterium]	diamond	825	163	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
29484252	29484252	PRJNA758087_P_NODE_40710_length_263_cov_1.526316_g39390_i0	PRJNA758087	40710	263	1.526316	4.01421108	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	153	5.53e-41	NR	HEX7085326.1	2910147	g39390	i0	89.5	0.980988593155893	86	9	98.1	0	4	261	847	932	HEX7085326.1 carboxypeptidase regulatory-like domain-containing protein [Vicinamibacterales bacterium]	diamond	258	153	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
30274396	30274396	PRJNA758087_P_NODE_42052_length_249_cov_0.875000_g40732_i0	PRJNA758087	42052	249	0.875	2.17875	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	172	1.55e-49	NR	HEX6213204.1	2910147	g40732	i0	94	1	83	5	100	0	1	249	94	176	HEX6213204.1 cytochrome c [Vicinamibacterales bacterium]	diamond	249	172	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
30653098	30653098	PRJNA758087_P_NODE_42473_length_247_cov_0.885057_g41153_i0	PRJNA758087	42473	247	0.885057	2.18609079	Acidicapsa ligni	542300	Bacteria	Bacteria	102	2.3699999999999998e-23	NR	WP_263360131.1	542300	g41153	i0	58.1	1.04453441295547	86	31	98.4	1	3	245	203	288	WP_263360131.1 PP2C family protein-serine/threonine phosphatase [Acidicapsa ligni]	diamond	258	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidicapsa	Acidicapsa ligni
30789456	30789456	PRJNA758087_P_NODE_42034_length_249_cov_0.875000_g40714_i0	PRJNA758087	42034	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	142	5.669999999999999e-38	NR	MDQ3421364.1	1978231	g40714	i0	85.4	6.91566265060241	82	12	98.8	0	247	2	61	142	MDQ3421364.1 FAD-dependent thymidylate synthase [Acidobacteriota bacterium]	diamond	1722	142	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32044461	32044461	PRJNA758087_P_NODE_41818_length_250_cov_0.870056_g40498_i0	PRJNA758087	41818	250	0.870056	2.17514	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	152	6.33e-42	NR	HEV3062547.1	2910147	g40498	i0	86.6	0.984	82	11	98.4	0	3	248	265	346	HEV3062547.1 M28 family peptidase [Vicinamibacterales bacterium]	diamond	246	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32676542	32676542	PRJNA758087_P_NODE_10580_length_982_cov_2.753575_g9497_i0	PRJNA758087	10580	982	2.753575	27.0401065	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	382	7.71e-126	NR	HLJ75534.1	2651171	g9497	i0	62	0.989816700610998	324	118	97.5	3	1	957	100	423	HLJ75534.1 efflux RND transporter permease subunit [Thermoanaerobaculia bacterium]	diamond	972	382	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;