metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA737474" 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
25569636	25569636	PRJNA737474b_S_NODE_42033_length_251_cov_2.550562_g40994_i0	PRJNA737474	42033	251	2.550562	6.40191062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g40994	i0	91	145.294820717131	200	10	77	7	45	237	1690481	1690283	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	36469	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25630021	25630021	PRJNA737474g_S_NODE_150985_length_296_cov_1.044843_g149691_i0	PRJNA737474	150985	296	1.044843	3.09273528	Chloracidobacterium	458032	Bacteria	Bacteria	104	7.48e-18	NTclustered	gi\|2033635510\|gb\|CP072632.1\|	458033	g149691	i0	88.372	18.8783783783784	86	10	29	0	31	116	664159	664244	Chloracidobacterium thermophilum strain B chromosome 1, complete sequence	blastn	5588	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
25705364	25705364	PRJNA737474b_S_NODE_36882_length_267_cov_3.118557_g35843_i0	PRJNA737474	36882	267	3.118557	8.32654719	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	222	1.76e-53	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g35843	i0	85.514	12.0262172284644	214	29	79	2	6	217	3298246	3298459	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	3211	222	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
25713545	25713545	PRJNA737474f_S_NODE_148642_length_267_cov_1.721649_g147964_i0	PRJNA737474	148642	267	1.721649	4.59680283	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	215	2.94e-51	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g147964	i0	81.712	66.9176029962547	257	47	96	0	1	257	2268804	2269060	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	17867	215	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
25993552	25993552	PRJNA737474g_S_NODE_248580_length_264_cov_1.246073_g247286_i0	PRJNA737474	248580	264	1.246073	3.28963272	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	134	8.370000000000001e-27	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g247286	i0	87.5	17.0833333333333	120	10	44	4	132	248	4986897	4986780	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	4510	134	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
26127734	26127734	PRJNA737474g_S_NODE_154621_length_294_cov_1.886878_g153327_i0	PRJNA737474	154621	294	1.886878	5.54742132	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	348	3.11e-91	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g153327	i0	91.935	0.843537414965986	248	20	84	0	8	255	912243	911996	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	248	348	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
26173116	26173116	PRJNA737474e_S_NODE_30157_length_249_cov_0.875000_g29275_i0	PRJNA737474	30157	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2490891634\|dbj\|AP027080.1\|	2927979	g29275	i0	100	0.253012048192771	30	0	12	0	148	177	1981572	1981601	Mesoterricola silvestris W79 DNA, complete genome	blastn	63	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola silvestris
26254065	26254065	PRJNA737474d_S_NODE_30542_length_276_cov_3.660099_g29948_i0	PRJNA737474	30542	276	3.660099	10.10187324	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	172	1.87e-38	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g29948	i0	79.675	41.9673913043478	246	44	88	4	1	243	1538887	1539129	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	11583	172	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
26257149	26257149	PRJNA737474f_S_NODE_109566_length_286_cov_1.065728_g108888_i0	PRJNA737474	109566	286	1.065728	3.04798208	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	200	8.919999999999998e-47	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g108888	i0	80.292	59.8951048951049	274	46	94	7	17	286	4572776	4573045	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	17130	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
26393493	26393493	PRJNA737474f_S_NODE_130063_length_275_cov_1.955446_g129385_i0	PRJNA737474	130063	275	1.955446	5.3774765	Edaphobacter sp. 4G125	2763071	Bacteria	Bacteria	195	3.97e-45	NTclustered	gi\|1895667655\|gb\|CP060393.1\|	2763071	g129385	i0	80.309	70.1636363636364	259	49	94	2	16	273	1682857	1682600	Edaphobacter sp. 4G125 chromosome, complete genome	blastn	19295	195	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter sp. 4G125
26524349	26524349	PRJNA737474c_S_NODE_29288_length_240_cov_3.491018_g28457_i0	PRJNA737474	29288	240	3.491018	8.3784432	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	257	4.26e-64	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g28457	i0	90.5	185.066666666667	200	11	81	7	35	228	1690286	1690483	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	44416	257	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
26531006	26531006	PRJNA737474f_S_NODE_205896_length_250_cov_1.231638_g205218_i0	PRJNA737474	205896	250	1.231638	3.079095	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|2621704939\|emb\|OY762226.1\|	2910147	g205218	i0	80.365	47.4	219	35	86	7	1	215	2538114	2537900	MAG: Vicinamibacterales bacterium isolate 0d5134ca-f8ab-4963-ab29-a032ed897002 genome assembly, chromosome: 1	blastn	11850	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26531597	26531597	PRJNA737474f_S_NODE_25536_length_417_cov_1.965116_g24859_i0	PRJNA737474	25536	417	1.965116	8.19453372	Terriglobia bacterium	2081523	Bacteria	Bacteria	387	9.679999999999999e-103	NTclustered	gi\|2874253792\|emb\|OY969776.1\|	2081523	g24859	i0	83.911	11.705035971223	404	65	97	0	14	417	951272	950869	MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1	blastn	4881	387	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia 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);;