metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA641707" 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
1156479	1156479	PRJNA641707_P_NODE_161161_length_211_cov_19.092593_g158498_i0	PRJNA641707	161161	211	19.092593	40.28537123	Bacteria	2	Bacteria	Bacteria	289	1.2999999999999999e-73	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g158498	i0	91.787	93.8909952606635	207	17	98	0	5	211	2238065	2238271	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	19811	289	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
10820116	10820116	PRJNA641707_P_NODE_321289_length_157_cov_6.120370_g318626_i0	PRJNA641707	321289	157	6.12037	9.6089809	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	87.9	3.55e-13	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g318626	i0	100	28.1082802547771	47	0	30	0	111	157	1807744	1807790	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	4413	87.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
11360884	11360884	PRJNA641707_P_NODE_300449_length_164_cov_3.965217_g297786_i0	PRJNA641707	300449	164	3.965217	6.50295588	Bacteria	2	Bacteria	Bacteria	111	2.23e-20	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g297786	i0	93.421	2.29878048780488	76	3	46	1	39	114	262129	262202	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	377	111	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
15914904	15914904	PRJNA641707_P_NODE_15553_length_548_cov_114.272545_g13203_i0	PRJNA641707	15553	548	114.272545	626.2135466	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	499	1.6e-136	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g13203	i0	83.677	185.138686131387	533	84	97	2	9	540	594128	594658	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	101456	499	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
18466846	18466846	PRJNA641707_P_NODE_271735_length_173_cov_8.637097_g269072_i0	PRJNA641707	271735	173	8.637097	14.94217781	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g269072	i0	100	0.167630057803468	29	0	17	0	62	90	3521732	3521760	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
19739504	19739504	PRJNA641707_P_NODE_18316_length_509_cov_34.976087_g15864_i0	PRJNA641707	18316	509	34.976087	178.02828283	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	243	2.75e-59	NTclustered	gi\|2891481979\|emb\|OZ219754.1\|	3036252	g15864	i0	77.283	102.893909626719	449	79	92	21	68	503	2070477	2070039	MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1	blastn	52373	243	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured Candidatus Binatia bacterium
22292049	22292049	PRJNA641707_P_NODE_28438_length_406_cov_10.747899_g25838_i0	PRJNA641707	28438	406	10.747899	43.63646994	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	372	2.63e-98	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g25838	i0	88.387	180.839901477833	310	34	76	2	65	374	597147	596840	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	73421	372	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
23567517	23567517	PRJNA641707_P_NODE_279459_length_170_cov_8.735537_g276796_i0	PRJNA641707	279459	170	8.735537	14.8504129	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	134	4.94e-27	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g276796	i0	83.333	0.847058823529412	144	24	85	0	19	162	678970	679113	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	144	134	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	uncultured 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);;