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

9 rows where bioproject = "PRJNA743294", 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_species
3750063	3750063	PRJNA743294_P_NODE_41103_length_266_cov_1.000000_g40647_i0	PRJNA743294	41103	266	1	2.66	Bacteria	2	Bacteria	Bacteria	268	2.22e-67	NTclustered	gi\|95115285\|gb\|DQ501327.1\|	34034	g40647	i0	84.906	74.7669172932331	265	40	99	0	2	266	1192	1456	Uncultured delta proteobacterium clone ST11-13 16S ribosomal RNA gene, partial sequence	blastn	19888	268	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16024676	16024676	PRJNA743294_P_NODE_39633_length_270_cov_1.350254_g39177_i0	PRJNA743294	39633	270	1.350254	3.6456858	uncultured delta proteobacterium	34034	Bacteria	Bacteria	248	2.94e-61	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g39177	i0	85.02	674.811111111111	247	34	91	3	26	270	12468	12713	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	182199	248	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
26704197	26704197	PRJNA743294_P_NODE_28281_length_312_cov_1.305439_g27825_i0	PRJNA743294	28281	312	1.305439	4.07296968	Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9	1973968	Bacteria	Bacteria	77.4	1.18e-14	NR	PJB33164.1	1973968	g27825	i0	51.3	2.88461538461538	76	37	73.1	0	37	264	166	241	PJB33164.1 MAG: DUF4197 domain-containing protein [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9]	diamond	900	77.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_65_9
28442405	28442405	PRJNA743294_P_NODE_6166_length_624_cov_2.695100_g5716_i0	PRJNA743294	6166	624	2.6951	16.817424	delta proteobacterium ML8_F1	1775671	Bacteria	Bacteria	123	7.999999999999998e-30	NR	OPL09242.1	1775671	g5716	i0	37	1.59615384615385	165	102	79.3	1	129	623	34	196	OPL09242.1 MAG: threonine aldolase [delta proteobacterium ML8_F1]	diamond	996	123	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	delta proteobacterium ML8_F1
28610204	28610204	PRJNA743294_P_NODE_25147_length_328_cov_3.145098_g24691_i0	PRJNA743294	25147	328	3.145098	10.31592144	Bacteria	2	Bacteria	Bacteria	43.9	0.0399	NR	OIP36672.1	1805126	g24691	i0	37	1.48170731707317	81	43	66.8	3	258	40	414	494	OIP36672.1 MAG: hypothetical protein AUK47_14735 [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	486	43.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG2_30_63_29
29326169	29326169	PRJNA743294_P_NODE_20749_length_357_cov_3.507042_g20293_i0	PRJNA743294	20749	357	3.507042	12.52013994	Deltaproteobacteria bacterium RIFCSPHIGHO2_	2026735	Bacteria	Bacteria	54.3	1.06e-5	NR	OGQ05465.1	1797856	g20293	i0	44.8	0.563025210084034	67	31	51.3	2	296	114	149	215	OGQ05465.1 MAG: molecular chaperone DnaJ [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	201	54.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
30505085	30505085	PRJNA743294_P_NODE_4253_length_735_cov_1.858006_g3845_i0	PRJNA743294	4253	735	1.858006	13.6563441	Bacteria	2	Bacteria	Bacteria	75.9	1.37e-11	NR	OGQ89419.1	1797895	g3845	i0	39.9	1.33061224489796	163	87	63.3	6	8	472	1786	1945	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	978	75.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
31032349	31032349	PRJNA743294_P_NODE_48855_length_250_cov_0.881356_g48399_i0	PRJNA743294	48855	250	0.881356	2.20339	Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_6	2026735	Bacteria	Bacteria	42.7	0.0388	NR	OGQ80239.1	1797894	g48399	i0	35.9	0.768	64	34	74.4	2	224	39	50	108	OGQ80239.1 MAG: protoporphyrinogen oxidase [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19]	diamond	192	42.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
32676210	32676210	PRJNA743294_P_NODE_50220_length_248_cov_2.582857_g49764_i0	PRJNA743294	50220	248	2.582857	6.40548536	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	48.9	2.53e-4	NR	UQZ89024.1	2946587	g49764	i0	51.6	0.375	31	15	37.5	0	68	160	143	173	UQZ89024.1 hypothetical protein C4J81_07355 [Deltaproteobacteria bacterium Smac51]	diamond	93	48.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium Smac51

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