metadata: contig_metadata: 12 rows where bioproject = "PRJNA1148190" and tax

12 rows where bioproject = "PRJNA1148190" and tax_clade = "SAR202 cluster"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18146167	18146167	PRJNA1148190_P_NODE_35155_length_1130_cov_2.686850_g25060_i0	PRJNA1148190	35155	1130	2.68685	30.361405	Candidatus Lucifugimonas marina	3038979	Bacteria	Bacteria	78.7	1.9e-9	NTclustered	gi\|2476246254\|gb\|CP046146.1\|	3038979	g25060	i0	92.593	0.849557522123894	54	4	5	0	140	193	627111	627058	Candidatus Lucifugimonas marina strain JH545 chromosome, complete genome	blastn	960	78.7	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia	Candidatus Lucifugimonadales	Candidatus Lucifugimonadaceae	Candidatus Lucifugimonas	Candidatus Lucifugimonas marina
26628674	26628674	PRJNA1148190_P_NODE_92341_length_560_cov_1.517454_g81200_i0	PRJNA1148190	92341	560	1.517454	8.4977424	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	187	1.4599999999999997e-52	NR	MBM3940445.1	2030829	g81200	i0	47.9	1.02857142857143	192	94	99.6	1	560	3	149	340	MBM3940445.1 terminase large subunit [SAR202 cluster bacterium]	diamond	576	187	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
27482110	27482110	PRJNA1148190_P_NODE_489083_length_269_cov_1.127551_g477910_i0	PRJNA1148190	489083	269	1.127551	3.03311219	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	45.1	0.00425	NR	MDP6422530.1	2030829	g477910	i0	40	0.557620817843866	50	30	55.8	0	155	6	115	164	MDP6422530.1 hypothetical protein [SAR202 cluster bacterium]	diamond	150	45.1	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
28397511	28397511	PRJNA1148190_P_NODE_369706_length_293_cov_1.972727_g358533_i0	PRJNA1148190	369706	293	1.972727	5.78009011	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	45.8	0.0016	NR	MQF98043.1	2030829	g358533	i0	27.4	0.972696245733788	95	57	85	3	26	274	33	127	MQF98043.1 hypothetical protein [SAR202 cluster bacterium]	diamond	285	45.8	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
29093077	29093077	PRJNA1148190_P_NODE_84968_length_589_cov_1.447674_g73836_i0	PRJNA1148190	84968	589	1.447674	8.52679986	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	105	1.93e-23	NR	MQF98475.1	2030829	g73836	i0	34.7	0.896434634974533	176	101	85.6	4	22	525	128	297	MQF98475.1 PD-(D/E)XK nuclease family protein [SAR202 cluster bacterium]	diamond	528	105	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
30102148	30102148	PRJNA1148190_P_NODE_16212_length_2201_cov_2.654605_g9161_i0	PRJNA1148190	16212	2201	2.654605	58.42785605	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	219	2.9499999999999998e-62	NR	MBM3947106.1	2030829	g9161	i0	64.2	0.396637891867333	151	52	20.4	2	459	10	2	151	MBM3947106.1 DNA adenine methylase [SAR202 cluster bacterium]	diamond	873	219	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
30133461	30133461	PRJNA1148190_P_NODE_112132_length_501_cov_1.079439_g100970_i0	PRJNA1148190	112132	501	1.079439	5.40798939	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	137	1.07e-35	NR	MQG00207.1	2030829	g100970	i0	44.9	1	167	86	99.4	2	500	3	136	297	MQG00207.1 alpha-hydroxy-acid oxidizing protein [SAR202 cluster bacterium]	diamond	501	137	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
30576065	30576065	PRJNA1148190_P_NODE_2013_length_10120_cov_7.416244_g593_i1	PRJNA1148190	2013	10120	7.416244	750.5238928	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	291	1.44e-78	NR	MQG59539.1	2030829	g593	i1	27.9	0.496541501976285	773	492	21.9	20	2774	555	44	784	MQG59539.1 hypothetical protein [SAR202 cluster bacterium]	diamond	5025	291	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
30956069	30956069	PRJNA1148190_P_NODE_440314_length_278_cov_1.502439_g429141_i0	PRJNA1148190	440314	278	1.502439	4.17678042	SAR202 cluster bacterium AD-804-J14_MRT_500m	2587836	Bacteria	Bacteria	109	1.54e-25	NR	MQF69590.1	2587836	g429141	i0	54.3	1.98561151079137	92	42	99.3	0	277	2	352	443	MQF69590.1 hypothetical protein [SAR202 cluster bacterium AD-804-J14_MRT_500m]	diamond	552	109	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium AD-804-J14_MRT_500m
31987673	31987673	PRJNA1148190_P_NODE_34258_length_1155_cov_2.164510_g24233_i0	PRJNA1148190	34258	1155	2.16451	25.0000905	Bacillati	1783272	Bacteria	Bacteria	248	2.14e-71	NR	MQG59539.1	2030829	g24233	i0	38.2	3.02337662337662	390	215	99.2	10	6	1151	185	556	MQG59539.1 hypothetical protein [SAR202 cluster bacterium]	diamond	3492	248	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
32473994	32473994	PRJNA1148190_P_NODE_30559_length_1269_cov_2.514214_g20886_i0	PRJNA1148190	30559	1269	2.514214	31.90537566	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	77	4.76e-11	NR	MQF98153.1	2030829	g20886	i0	32.8	0.453900709219858	192	102	42.1	7	1230	697	391	569	MQF98153.1 hypothetical protein [SAR202 cluster bacterium]	diamond	576	77	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
32569112	32569112	PRJNA1148190_P_NODE_376059_length_291_cov_1.788991_g364886_i0	PRJNA1148190	376059	291	1.788991	5.20596381	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	77.8	3.5e-15	NR	MDP6403082.1	2030829	g364886	i0	62.7	0.690721649484536	67	22	66	2	98	289	138	204	MDP6403082.1 hypothetical protein [SAR202 cluster bacterium]	diamond	201	77.8	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 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);;