metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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
1435681	1435681	PRJNA1020854_S_NODE_23482_length_221_cov_2733.921875_g20718_i0	PRJNA1020854	23482	221	2733.921875	6041.96734375	Edaphobacter paludis	3035702	Bacteria	Bacteria	122	1.47e-23	NTclustered	gi\|2737763816\|gb\|CP121194.1\|	3035702	g20718	i0	80.247	196.660633484163	162	32	73	0	6	167	1808460	1808621	Edaphobacter paludis strain DSM 109919 chromosome, complete genome	blastn	43462	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter paludis
2711189	2711189	PRJNA1020854_S_NODE_20883_length_239_cov_87.409524_g18119_i0	PRJNA1020854	20883	239	87.409524	208.90876236	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	344	3.16e-90	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g18119	i0	92.827	102.970711297071	237	17	99	0	2	238	6633857	6633621	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	24610	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
3553834	3553834	PRJNA1020854_S_NODE_27503_length_199_cov_33.658824_g24739_i0	PRJNA1020854	27503	199	33.658824	66.98105976	Tunturiibacter	3154218	Bacteria	Bacteria	316	5.55e-82	NTclustered	gi\|2304905231\|gb\|CP073696.1\|	2051959	g24739	i0	97.814	241.336683417085	183	4	92	0	5	187	3200303	3200121	Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome	blastn	48026	316	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter lichenicola
6539078	6539078	PRJNA1020854_S_NODE_22366_length_228_cov_2760.547739_g19602_i0	PRJNA1020854	22366	228	2760.547739	6294.04884492	Granulicella tundricola	940615	Bacteria	Bacteria	305	1.41e-78	NTclustered	gi\|321161386\|gb\|CP002480.1\|	1198114	g19602	i0	97.753	190.995614035088	178	3	78	1	52	228	1081595	1081772	Granulicella tundricola MP5ACTX9, complete genome	blastn	43547	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
11206694	11206694	PRJNA1020854_S_NODE_40129_length_157_cov_3.117188_g37365_i0	PRJNA1020854	40129	157	3.117188	4.89398516	Bacteria	2	Bacteria	Bacteria	224	2.5899999999999994e-54	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g37365	i0	92.5	138.050955414013	160	6	100	6	1	157	3938	4094	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	21674	224	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15464097	15464097	PRJNA1020854_S_NODE_7833_length_524_cov_2065.438384_g5190_i0	PRJNA1020854	7833	524	2065.438384	10822.89713216	Granulicella mallensis	940614	Bacteria	Bacteria	697	0	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g5190	i0	96.875	164.698473282443	416	13	79	0	55	470	3185579	3185994	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	86302	697	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
23113239	23113239	PRJNA1020854_S_NODE_26899_length_202_cov_4.572254_g24135_i0	PRJNA1020854	26899	202	4.572254	9.23595308	Holophagaceae bacterium	2052165	Bacteria	Bacteria	364	1.99e-96	NTclustered	gi\|2689136629\|emb\|OZ019758.1\|	2052165	g24135	i0	99.02	167.732673267327	204	0	100	1	1	202	26968	26765	MAG: Holophagaceae bacterium isolate ZE-13nov19-LR-8 genome assembly, chromosome: 1	blastn	33882	364	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae		Holophagaceae 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);;