metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_order	tax_family	tax_genus	tax_species
10224294	10224294	PRJEB14803_P_NODE_5789_length_572_cov_1.849162_g5367_i0	PRJEB14803	5789	572	1.849162	10.57720664	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	227	5.4e-66	NR	MBF0238808.1	2024889	g5367	i0	56.4	4.93006993006993	188	82	98.6	0	570	7	47	234	MBF0238808.1 glycogen/starch/alpha-glucan phosphorylase [SAR324 cluster bacterium]	diamond	2820	227	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
27152674	27152674	PRJEB14803_P_NODE_11582_length_371_cov_1.633929_g11117_i0	PRJEB14803	11582	371	1.633929	6.06187659	Myxococcota	2818505	Bacteria	Bacteria	60.1	1.01e-7	NR	QDG54948.1	2292766	g11117	i0	32.5	2.88679245283019	123	77	97.8	3	368	6	134	252	QDG54948.1 hypothetical protein FIV42_23140 [Persicimonas caeni]	diamond	1071	60.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
27159233	27159233	PRJEB14803_P_NODE_25802_length_218_cov_1.524590_g25336_i0	PRJEB14803	25802	218	1.52459	3.3236062	Microvenator marinus	2600177	Bacteria	Bacteria	68.6	8.98e-12	NR	QED28169.1	2600177	g25336	i0	53.3	2.51834862385321	60	28	82.6	0	194	15	57	116	QED28169.1 glutathione S-transferase [Microvenator marinus]	diamond	549	68.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
27317730	27317730	PRJEB14803_P_NODE_15883_length_301_cov_2.706767_g15417_i0	PRJEB14803	15883	301	2.706767	8.14736867	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	53.5	3.39e-6	NR	MFU8803011.1	2740543	g15417	i0	43.6	0.548172757475083	55	31	54.8	0	10	174	90	144	MFU8803011.1 ester cyclase [Bradymonadaceae bacterium]	diamond	165	53.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
28896218	28896218	PRJEB14803_P_NODE_21988_length_243_cov_1.408654_g21522_i0	PRJEB14803	21988	243	1.408654	3.42302922	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7	2013757	Bacteria	Bacteria	97.4	1.1e-22	NR	PKN10507.1	2013757	g21522	i0	54.2	5.12345679012346	83	34	100	3	243	1	118	198	PKN10507.1 MAG: hypothetical protein CVU72_00980 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7]	diamond	1245	97.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7
29180733	29180733	PRJEB14803_P_NODE_39709_length_166_cov_1.526718_g39243_i0	PRJEB14803	39709	166	1.526718	2.53435188	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	83.6	3.96e-18	NR	MBF0351217.1	2024889	g39243	i0	76.4	0.993975903614458	55	13	99.4	0	165	1	140	194	MBF0351217.1 riboflavin synthase subunit alpha [SAR324 cluster bacterium]	diamond	165	83.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30216119	30216119	PRJEB14803_P_NODE_18732_length_270_cov_2.408511_g18266_i0	PRJEB14803	18732	270	2.408511	6.5029797	Pseudomonadota	1224	Bacteria	Bacteria	44.7	0.0105	NR	OGP74343.1	1797841	g18266	i0	44.4	2.5	45	22	46.7	1	82	207	176	220	OGP74343.1 MAG: sorbosone dehydrogenase [Deltaproteobacteria bacterium RBG_16_50_11]	diamond	675	44.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_16_50_11
30343208	30343208	PRJEB14803_P_NODE_45892_length_153_cov_1.127119_g45426_i0	PRJEB14803	45892	153	1.127119	1.72449207	Bacteria	2	Bacteria	Bacteria	45.4	0.0012	NR	PKN54365.1	2013741	g45426	i0	45.5	2.56862745098039	44	24	86.3	0	21	152	343	386	PKN54365.1 MAG: hypothetical protein CVU56_26920 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	393	45.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
31012599	31012599	PRJEB14803_P_NODE_7135_length_502_cov_2.066381_g6682_i0	PRJEB14803	7135	502	2.066381	10.37323262	Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9	1797899	Bacteria	Bacteria	60.5	3.12e-7	NR	OGR09887.1	1797899	g6682	i0	69.4	0.394422310756972	36	11	21.5	0	3	110	280	315	OGR09887.1 MAG: hypothetical protein A2341_27220 [Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9]	diamond	198	60.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9
32372831	32372831	PRJEB14803_P_NODE_46439_length_152_cov_1.119658_g45973_i0	PRJEB14803	46439	152	1.119658	1.70188016	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	84.7	1.7e-17	NR	MBF0276672.1	2024889	g45973	i0	74	0.986842105263158	50	13	98.7	0	150	1	66	115	MBF0276672.1 GcvT family protein [SAR324 cluster bacterium]	diamond	150	84.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster 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);;