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

5 rows where bioproject = "PRJNA492406", 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
13206552	13206552	PRJNA492406_P_NODE_771_length_1366_cov_19.472544_g604_i0	PRJNA492406	771	1366	19.472544	265.99495104	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1491	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g604	i0	86.473	195.650805270864	1375	167	100	15	1	1366	14033	12669	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	267259	1491	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
29649786	29649786	PRJNA492406_P_NODE_27370_length_250_cov_0.870056_g27071_i0	PRJNA492406	27370	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	66.2	2.14e-10	NR	OGQ89419.1	1797895	g27071	i0	44.9	1.656	69	37	82.8	1	215	9	1184	1251	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	414	66.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30550273	30550273	PRJNA492406_P_NODE_6733_length_465_cov_1.020408_g6434_i0	PRJNA492406	6733	465	1.020408	4.7448972	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	45.4	0.0218	NR	MDX2469210.1	2024889	g6434	i0	28.4	0.658064516129032	102	66	61.3	2	381	97	67	168	MDX2469210.1 hypothetical protein [SAR324 cluster bacterium]	diamond	306	45.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
30739918	30739918	PRJNA492406_P_NODE_25974_length_253_cov_2.683333_g25675_i0	PRJNA492406	25974	253	2.683333	6.78883249	Microvenator marinus	2600177	Bacteria	Bacteria	55.5	1.33e-6	NR	WP_146962556.1	2600177	g25675	i0	56.3	0.569169960474308	48	19	56.9	1	45	188	356	401	WP_146962556.1 hypothetical protein [Microvenator marinus]	diamond	144	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
30739922	30739922	PRJNA492406_P_NODE_29414_length_246_cov_0.890173_g29115_i0	PRJNA492406	29414	246	0.890173	2.18982558	Olavius algarvensis Delta 1 endosymbiont	334747	Bacteria	Bacteria	45.8	0.00307	NR	CAB1083184.1	334747	g29115	i0	44.6	0.682926829268293	56	29	68.3	2	5	172	290	343	CAB1083184.1 hypothetical protein D1AOALGA4SA_10763 [Olavius algarvensis Delta 1 endosymbiont]	diamond	168	45.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Olavius algarvensis Delta 1 endosymbiont

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