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

11 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
449880	449880	PRJNA488043_P_NODE_13181_length_257_cov_4.640351_g10939_i0	PRJNA488043	13181	257	4.640351	11.92570207	Bryobacterales bacterium	2026791	Bacteria	Bacteria	207	4.71e-49	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g10939	i0	84.834	56.9377431906615	211	27	81	5	1	208	2774632	2774424	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	14633	207	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
1724760	1724760	PRJNA488043_S_NODE_582_length_243_cov_17.392523_g571_i0	PRJNA488043	582	243	17.392523	42.26383089	Thermotomaculum hydrothermale	981385	Bacteria	Bacteria	154	5.84e-33	NTclustered	gi\|1941646770\|dbj\|AP017470.1\|	981385	g571	i0	90.678	249.201646090535	118	8	48	3	13	128	1258460	1258576	Thermotomaculum hydrothermale DNA, complete genome, strain: AC55	blastn	60556	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Thermotomaculales	Thermotomaculaceae	Thermotomaculum	Thermotomaculum hydrothermale
3649179	3649179	PRJNA488043_S_NODE_183_length_389_cov_19.513889_g172_i0	PRJNA488043	183	389	19.513889	75.90902821	Bacteria	2	Bacteria	Bacteria	296	1.56e-75	NTclustered	gi\|2621704223\|emb\|OY761614.1\|	188475	g172	i0	81.316	276.825192802057	380	58	96	12	1	372	644041	643667	MAG: uncultured Holophaga sp. isolate c3c763bb-72ba-4188-aae9-c4b83244ba6d genome assembly, chromosome: 1	blastn	107685	296	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
4276924	4276924	PRJNA488043_P_NODE_18104_length_190_cov_18.049689_g15862_i0	PRJNA488043	18104	190	18.049689	34.2944091	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	189	1.19e-43	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g15862	i0	96.491	154.731578947368	114	4	60	0	74	187	4652404	4652517	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	29399	189	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4277091	4277091	PRJNA488043_S_NODE_604_length_240_cov_9.672986_g593_i0	PRJNA488043	604	240	9.672986	23.2151664	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	270	5.47e-68	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g593	i0	87.029	45.7458333333333	239	31	99	0	1	239	314	76	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	10979	270	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6201031	6201031	PRJNA488043_P_NODE_16645_length_206_cov_3.169492_g14403_i0	PRJNA488043	16645	206	3.169492	6.52915352	Bacteria	2	Bacteria	Bacteria	198	2.19e-46	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g14403	i0	92.199	1.3495145631068	141	10	68	1	1	141	4677234	4677095	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	278	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8103142	8103142	PRJNA488043_S_NODE_1227_length_174_cov_6.648276_g1216_i0	PRJNA488043	1227	174	6.648276	11.56800024	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	257	2.89e-64	NTclustered	gi\|2874254139\|emb\|OY970224.1\|	171953	g1216	i0	93.605	226.068965517241	172	11	99	0	1	172	1715527	1715356	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1	blastn	39336	257	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8103145	8103145	PRJNA488043_S_NODE_1487_length_159_cov_8.469231_g1476_i0	PRJNA488043	1487	159	8.469231	13.46607729	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	75	2.81e-9	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g1476	i0	87.879	21.1698113207547	66	5	40	3	1	64	3682028	3682092	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	3366	75	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
15752576	15752576	PRJNA488043_P_NODE_21593_length_157_cov_5.445312_g19351_i0	PRJNA488043	21593	157	5.445312	8.54913984	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	152	1.24e-32	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g19351	i0	89.256	275.573248407643	121	13	77	0	37	157	283872	283752	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	43265	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
17027239	17027239	PRJNA488043_P_NODE_5494_length_558_cov_104.514178_g3526_i0	PRJNA488043	5494	558	104.514178	583.18911324	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	350	1.7400000000000002e-91	NTclustered	gi\|2621701942\|emb\|OY761158.1\|	2651171	g3526	i0	78.393	823.544802867384	560	106	99	15	1	550	3583695	3583141	MAG: Thermoanaerobaculia bacterium isolate 1b26a83f-5f0d-4c2c-8de2-47f95369405e genome assembly, chromosome: 1	blastn	459538	350	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
20851675	20851675	PRJNA488043_S_NODE_597_length_241_cov_12.216981_g586_i0	PRJNA488043	597	241	12.216981	29.44292421	Paludibaculum fermentans	1473598	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g586	i0	97.095	1	241	7	100	0	1	241	2772798	2772558	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	241	407	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans

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