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

12 rows where bioproject = "PRJNA414036" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
418803	418803	PRJNA414036_P_NODE_6261_length_493_cov_101.954148_g1827_i3	PRJNA414036	6261	493	101.954148	502.63394964	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	237	1.24e-57	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g1827	i3	76.494	102.789046653144	502	79	98	32	11	492	3515341	3515823	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	50675	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
10622627	10622627	PRJNA414036_P_NODE_3749_length_557_cov_4.289272_g3038_i0	PRJNA414036	3749	557	4.289272	23.89124504	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	3.03e-59	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g3038	i0	98.54	49.4775583482944	137	2	25	0	333	469	24	160	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	27559	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13172402	13172402	PRJNA414036_P_NODE_18751_length_347_cov_6.509615_g17029_i0	PRJNA414036	18751	347	6.509615	22.58836405	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	150	1.1299999999999998e-31	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g17029	i0	93.137	59	102	7	29	0	158	259	59	160	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	20473	150	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13172565	13172565	PRJNA414036_P_NODE_71991_length_178_cov_9.678322_g70252_i0	PRJNA414036	71991	178	9.678322	17.22741316	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	6.44e-61	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g70252	i0	94.375	205.494382022472	160	9	90	0	11	170	4841836	4841677	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	36578	246	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20820334	20820334	PRJNA414036_P_NODE_15157_length_379_cov_14.645349_g13474_i0	PRJNA414036	15157	379	14.645349	55.50587271	Holophagaceae bacterium	2052165	Bacteria	Bacteria	84.2	1.28e-11	NTclustered	gi\|2689136629\|emb\|OZ019758.1\|	2052165	g13474	i0	91.803	0.287598944591029	61	4	16	1	307	366	28410	28470	MAG: Holophagaceae bacterium isolate ZE-13nov19-LR-8 genome assembly, chromosome: 1	blastn	109	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae		Holophagaceae bacterium
20820432	20820432	PRJNA414036_P_NODE_39977_length_233_cov_1.151515_g38238_i0	PRJNA414036	39977	233	1.151515	2.68302995	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2874253693\|emb\|OY969419.1\|	194844	g38238	i0	94.737	0.163090128755365	38	2	16	0	40	77	5968015	5968052	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1	blastn	38	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
22095082	22095082	PRJNA414036_P_NODE_15158_length_379_cov_14.081395_g13475_i0	PRJNA414036	15158	379	14.081395	53.36848705	Holophagaceae bacterium	2052165	Bacteria	Bacteria	84.2	1.28e-11	NTclustered	gi\|2689136629\|emb\|OZ019758.1\|	2052165	g13475	i0	91.803	0.287598944591029	61	4	16	1	307	366	28410	28470	MAG: Holophagaceae bacterium isolate ZE-13nov19-LR-8 genome assembly, chromosome: 1	blastn	109	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae		Holophagaceae bacterium
24645035	24645035	PRJNA414036_P_NODE_12220_length_409_cov_5.122995_g10618_i0	PRJNA414036	12220	409	5.122995	20.95304955	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	2.1700000000000007e-59	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g10618	i0	98.54	65.5330073349633	137	2	33	0	89	225	160	24	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	26803	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
28623161	28623161	PRJNA414036_P_NODE_46327_length_231_cov_2.954082_g44588_i0	PRJNA414036	46327	231	2.954082	6.82392942	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.046	NR	MDQ6786359.1	1978231	g44588	i0	95.5	0.285714285714286	22	1	28.6	0	10	75	104	125	MDQ6786359.1 TonB-dependent receptor [Acidobacteriota bacterium]	diamond	66	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31356299	31356299	PRJNA414036_P_NODE_47156_length_231_cov_2.770408_g45417_i0	PRJNA414036	47156	231	2.770408	6.39964248	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	2.67e-4	NR	WP_125485429.1	570835	g45417	i0	95	1.5974025974026	20	1	26	0	9	68	36	55	WP_125485429.1 YdeI/OmpD-associated family protein [Edaphobacter aggregans]	diamond	369	48.5	0.991752577319588	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter aggregans
31672384	31672384	PRJNA414036_P_NODE_87237_length_152_cov_5.290598_g85498_i0	PRJNA414036	87237	152	5.290598	8.04170896	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	1.3e-4	NR	ADI18656.1	710731	g85498	i0	64.7	2.78289473684211	34	12	67.1	0	106	5	31	64	ADI18656.1 hypothetical protein [uncultured Acidobacteria bacterium HF4000_26D02]	diamond	423	45.8	0.991266375545852	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteria bacterium HF4000_26D02
31877047	31877047	PRJNA414036_P_NODE_51837_length_231_cov_1.897959_g50098_i0	PRJNA414036	51837	231	1.897959	4.38428529	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	45.1	0.0049	NR	MFN0100876.1	2212468	g50098	i0	68.2	0.558441558441558	22	7	28.6	0	222	157	407	428	MFN0100876.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	129	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;