metadata: contig_metadata: 14 rows where bioproject = "PRJNA615351", tax_clade = "delta/epsilon subdivisions" and tax

14 rows where bioproject = "PRJNA615351", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

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
1149912	1149912	PRJNA615351_P_NODE_107781_length_287_cov_7.170635_g93682_i0	PRJNA615351	107781	287	7.170635	20.57972245	Bacteria	2	Bacteria	Bacteria	473	4.78e-129	NTclustered	gi\|146429400\|gb\|EF220216.1\|	34034	g93682	i0	97.143	96.9163763066202	280	8	98	0	8	287	11	290	Uncultured delta proteobacterium clone FB-1_C04 16S ribosomal RNA gene, partial sequence	blastn	27815	473	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
15178365	15178365	PRJNA615351_P_NODE_170872_length_164_cov_2.480620_g156772_i0	PRJNA615351	170872	164	2.48062	4.0682168	Thermodesulfobacteriota	200940	Bacteria	Bacteria	152	1.31e-32	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g156772	i0	84.177	355.042682926829	158	23	96	2	4	160	702308	702464	Microvenator marinus strain V1718 chromosome, complete genome	blastn	58227	152	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
22272784	22272784	PRJNA615351_P_NODE_158118_length_179_cov_1.500000_g144018_i0	PRJNA615351	158118	179	1.5	2.685	uncultured delta proteobacterium	34034	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g144018	i0	100	0.156424581005587	28	0	16	0	36	63	7440398	7440371	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
27333584	27333584	PRJNA615351_P_NODE_93963_length_345_cov_3.103226_g79877_i0	PRJNA615351	93963	345	3.103226	10.7061297	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	59.7	9.87e-8	NR	MDP6204496.1	2024889	g79877	i0	36.2	0.817391304347826	94	40	69.6	4	269	30	2	89	MDP6204496.1 amidohydrolase family protein [SAR324 cluster bacterium]	diamond	282	59.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
27365165	27365165	PRJNA615351_P_NODE_145843_length_196_cov_1.956522_g131743_i0	PRJNA615351	145843	196	1.956522	3.83478312	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	110	3.75e-26	NR	MBF0236369.1	2024889	g131743	i0	84.6	6.94897959183673	65	8	99.5	1	1	195	274	336	MBF0236369.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [SAR324 cluster bacterium]	diamond	1362	110	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
27554054	27554054	PRJNA615351_P_NODE_141964_length_203_cov_1.190476_g127864_i0	PRJNA615351	141964	203	1.190476	2.41666628	Deltaproteobacteria bacterium RBG_13_58_19	1797832	Bacteria	Bacteria	47.4	5.18e-4	NR	OGP75284.1	1797832	g127864	i0	38.2	0.812807881773399	55	34	81.3	0	199	35	795	849	OGP75284.1 MAG: hypothetical protein A2Y80_04575 [Deltaproteobacteria bacterium RBG_13_58_19]	diamond	165	47.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_13_58_19
27788388	27788388	PRJNA615351_P_NODE_156844_length_181_cov_1.089041_g142744_i0	PRJNA615351	156844	181	1.089041	1.97116421	Bacteria	2	Bacteria	Bacteria	44.3	0.0047	NR	MDP7630861.1	2024889	g142744	i0	38.3	2.98342541436464	60	34	99.4	2	2	181	267	323	MDP7630861.1 hypothetical protein [SAR324 cluster bacterium]	diamond	540	44.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
29480098	29480098	PRJNA615351_P_NODE_39690_length_906_cov_4.862227_g29454_i0	PRJNA615351	39690	906	4.862227	44.05177662	Deltaproteobacteria bacterium GWA2_45_12	1797805	Bacteria	Bacteria	66.6	3.67e-9	NR	OGP07419.1	1797805	g29454	i0	27.2	0.596026490066225	180	123	57.6	4	61	582	2	179	OGP07419.1 MAG: hypothetical protein A2048_05880 [Deltaproteobacteria bacterium GWA2_45_12]	diamond	540	66.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_45_12
29525002	29525002	PRJNA615351_P_NODE_9310_length_2101_cov_4.461762_g6662_i0	PRJNA615351	9310	2101	4.461762	93.74161962	Myxococcota	2818505	Bacteria	Bacteria	54.3	0.00246	NR	QDG52427.1	2292766	g6662	i0	34.5	0.364112327463113	119	66	17	1	671	1027	58	164	QDG52427.1 tetratricopeptide repeat protein [Persicimonas caeni]	diamond	765	54.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
30851590	30851590	PRJNA615351_P_NODE_35754_length_989_cov_5.911950_g9898_i1	PRJNA615351	35754	989	5.91195	58.4691855	Bacteria	2	Bacteria	Bacteria	180	2.84e-49	NR	MBA2664539.1	2946527	g9898	i1	36	2.80889787664307	311	192	94.3	5	55	987	39	342	MBA2664539.1 DegT/DnrJ/EryC1/StrS aminotransferase family protein [Lujinxingiaceae bacterium]	diamond	2778	180	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
31154408	31154408	PRJNA615351_P_NODE_67915_length_520_cov_1.552577_g54123_i0	PRJNA615351	67915	520	1.552577	8.0734004	uncultured delta proteobacterium HF	34034	Bacteria	Bacteria	46.2	0.00687	NR	ADI19205.1	710829	g54123	i0	64.3	0.484615384615385	28	10	16.2	0	86	3	59	86	ADI19205.1 hypothetical protein [uncultured delta proteobacterium HF0130_20J24]	diamond	252	46.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0130_20J24
31376135	31376135	PRJNA615351_P_NODE_31416_length_1094_cov_5.372049_g15080_i1	PRJNA615351	31416	1094	5.372049	58.77021606	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	58.5	1.76e-5	NR	OGQ04977.1	1797856	g15080	i1	35.6	0.474405850091408	90	57	24.4	1	939	673	55	144	OGQ04977.1 MAG: hypothetical protein A2712_04800 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	519	58.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
32211544	32211544	PRJNA615351_P_NODE_90238_length_364_cov_3.331307_g76159_i0	PRJNA615351	90238	364	3.331307	12.12595748	Bacteria	2	Bacteria	Bacteria	61.6	3.44e-8	NR	OQB76601.1	1852867	g76159	i0	39.4	3.82417582417582	94	45	77.5	2	358	77	411	492	OQB76601.1 MAG: hypothetical protein BWX92_01664 [Deltaproteobacteria bacterium ADurb.Bin135]	diamond	1392	61.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin135
32262033	32262033	PRJNA615351_P_NODE_13738_length_1771_cov_5.821429_g9898_i0	PRJNA615351	13738	1771	5.821429	103.09750759	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	194	4.22e-52	NR	MBA2664539.1	2946527	g9898	i0	34.3	0.611518915866742	361	226	60.5	7	1717	647	39	392	MBA2664539.1 DegT/DnrJ/EryC1/StrS aminotransferase family protein [Lujinxingiaceae bacterium]	diamond	1083	194	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae 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);;