metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA752278" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
726645	726645	PRJNA752278_P_NODE_100201_length_243_cov_0.905882_g99998_i0	PRJNA752278	100201	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g99998	i0	84.264	0.810699588477366	197	31	81	0	40	236	2144014	2144210	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	197	193	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
728095	728095	PRJNA752278_P_NODE_76401_length_252_cov_1.446927_g76198_i0	PRJNA752278	76401	252	1.446927	3.64625604	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1037405666\|gb\|CP011806.1\|	1660251	g76198	i0	100	0.111111111111111	28	0	11	0	9	36	4310920	4310947	Acidobacteria bacterium Mor1 chromosome	blastn	28	52.8	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium Mor1
4556231	4556231	PRJNA752278_P_NODE_56944_length_270_cov_2.796954_g56741_i0	PRJNA752278	56944	270	2.796954	7.5517758	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	305	1.72e-78	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g56741	i0	87.085	61.0666666666667	271	33	100	2	1	270	6442850	6442581	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	16488	305	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
5029324	5029324	PRJNA752278_P_NODE_52364_length_275_cov_1.386139_g52161_i0	PRJNA752278	52364	275	1.386139	3.81188225	Holophagaceae	574976	Bacteria	Bacteria	76.8	1.5e-9	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g52161	i0	91.071	4.45818181818182	56	5	20	0	178	233	3505	3560	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	1226	76.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
5830352	5830352	PRJNA752278_P_NODE_104405_length_241_cov_0.916667_g104202_i0	PRJNA752278	104405	241	0.916667	2.20916747	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	158	4.47e-34	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g104202	i0	80.189	16.7178423236515	212	41	88	1	1	212	1242604	1242814	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	4029	158	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
16029624	16029624	PRJNA752278_P_NODE_16333_length_382_cov_0.877023_g16130_i0	PRJNA752278	16333	382	0.877023	3.35022786	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	496	1.3999999999999998e-135	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g16130	i0	90.155	28.6989528795812	386	30	100	8	1	382	417	36	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	10963	496	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18579567	18579567	PRJNA752278_P_NODE_58855_length_269_cov_1.234694_g58652_i0	PRJNA752278	58855	269	1.234694	3.32132686	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	431	2.71e-116	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g58652	i0	95.556	199.646840148699	270	11	100	1	1	269	3300991	3300722	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	53705	431	1	Bacteria		Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18580078	18580078	PRJNA752278_P_NODE_84755_length_248_cov_1.885714_g84552_i0	PRJNA752278	84755	248	1.885714	4.67657072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	222	1.62e-53	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g84552	i0	84.444	1.98790322580645	225	35	91	0	23	247	3288278	3288502	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	493	222	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22405432	22405432	PRJNA752278_P_NODE_71798_length_256_cov_2.262295_g71595_i0	PRJNA752278	71798	256	2.262295	5.7914752	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	235	2.15e-57	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g71595	i0	83.268	98.87890625	257	41	100	2	1	256	4802546	4802801	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	25313	235	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22405834	22405834	PRJNA752278_P_NODE_93718_length_245_cov_0.895349_g93515_i0	PRJNA752278	93718	245	0.895349	2.19360505	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	165	2.72e-36	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g93515	i0	82.54	4.3265306122449	189	31	77	2	12	199	699354	699541	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	1060	165	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24953205	24953205	PRJNA752278_P_NODE_101680_length_242_cov_0.911243_g101477_i0	PRJNA752278	101680	242	0.911243	2.20520806	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g101477	i0	100	0.115702479338843	28	0	12	0	97	124	1608349	1608322	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;