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

11 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Binatota"

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_phylum	tax_class	tax_species
3952536	3952536	PRJEB64798_P_NODE_106524_length_211_cov_4.432099_g104758_i0	PRJEB64798	106524	211	4.432099	9.35172889	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	143	1.07e-29	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g104758	i0	93.684	131.886255924171	95	6	45	0	18	112	5535691	5535785	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	27828	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
5231828	5231828	PRJEB64798_P_NODE_60825_length_249_cov_54.340000_g59060_i0	PRJEB64798	60825	249	54.34	135.3066	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g59060	i0	93.562	157.068273092369	233	12	93	3	3	233	3739320	3739551	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	39110	344	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
6505176	6505176	PRJEB64798_P_NODE_138166_length_194_cov_5.917241_g136400_i0	PRJEB64798	138166	194	5.917241	11.47944754	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	145	2.69e-30	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g136400	i0	81.053	218.721649484536	190	28	96	7	1	186	2263404	2263219	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	42432	145	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
16703088	16703088	PRJEB64798_P_NODE_10594_length_614_cov_10.938053_g9079_i0	PRJEB64798	10594	614	10.938053	67.15964542	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	259	3.34e-64	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g9079	i0	75.812	83.1938110749186	554	110	88	17	1	540	2070541	2069998	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	51081	259	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
16703206	16703206	PRJEB64798_P_NODE_113894_length_209_cov_5.781250_g112128_i0	PRJEB64798	113894	209	5.78125	12.0828125	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	115	2.3e-21	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g112128	i0	89.13	18.3205741626794	92	10	44	0	115	206	2711633	2711542	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	3829	115	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
16703805	16703805	PRJEB64798_P_NODE_151054_length_188_cov_1.971223_g149288_i0	PRJEB64798	151054	188	1.971223	3.70589924	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	134	5.59e-27	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g149288	i0	80.22	5.37234042553191	182	32	96	4	5	184	1446120	1445941	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	1010	134	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
19252335	19252335	PRJEB64798_P_NODE_130116_length_198_cov_4.744966_g128350_i0	PRJEB64798	130116	198	4.744966	9.39503268	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	143	9.9e-30	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g128350	i0	84.354	17.1969696969697	147	22	74	1	1	146	3394669	3394523	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	3405	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
20120305	20120305	PRJEB64798_P_NODE_81716_length_213_cov_22.073171_g79950_i0	PRJEB64798	81716	213	22.073171	47.01585423	Bacteria	2	Bacteria	Bacteria	252	1.72e-62	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g79950	i0	88.517	262.023474178404	209	22	98	2	3	210	3738947	3739154	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	55811	252	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
21395061	21395061	PRJEB64798_P_NODE_15857_length_500_cov_14.321508_g14164_i0	PRJEB64798	15857	500	14.321508	71.60754	Bacteria	2	Bacteria	Bacteria	468	4.09e-127	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g14164	i0	88.191	120.396	398	40	79	6	4	397	2238880	2239274	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	60198	468	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
23081084	23081084	PRJEB64798_P_NODE_53539_length_267_cov_5.825688_g51774_i0	PRJEB64798	53539	267	5.825688	15.55458696	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	226	1.36e-54	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g51774	i0	84.848	252.906367041199	231	28	85	7	35	262	594436	594210	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	67526	226	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
24354833	24354833	PRJEB64798_P_NODE_46580_length_287_cov_30.529412_g44815_i0	PRJEB64798	46580	287	30.529412	87.61941244	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	429	1.05e-115	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g44815	i0	94.014	189.689895470383	284	16	99	1	1	283	3738964	3738681	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	54441	429	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia 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);;