metadata: contig_metadata: 10 rows where bioproject = "PRJNA999747" and tax

10 rows where bioproject = "PRJNA999747" and tax_clade = "Bacteria candidate phyla"

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_order	tax_family	tax_genus	tax_species
3531236	3531236	PRJNA999747_S_NODE_4083_length_157_cov_2.142857_g4051_i0	PRJNA999747	4083	157	2.142857	3.36428549	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	110	7.58e-20	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g4051	i0	80.625	23.3057324840764	160	16	98	7	2	155	814207	814057	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	3659	110	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
4808514	4808514	PRJNA999747_S_NODE_284_length_458_cov_24.658080_g254_i0	PRJNA999747	284	458	24.658080000000002	112.9340064	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	845	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g254	i0	100	98.0131004366812	457	0	99	0	2	458	503512	503968	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	44890	845	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
6083777	6083777	PRJNA999747_S_NODE_3105_length_177_cov_5.835616_g3073_i0	PRJNA999747	3105	177	5.835616	10.32904032	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g3073	i0	100	11.864406779661	174	0	98	0	4	177	501519	501346	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	2100	322	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
8633703	8633703	PRJNA999747_S_NODE_3147_length_176_cov_3.717241_g3115_i0	PRJNA999747	3147	176	3.717241	6.54234416	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g3115	i0	100	88.8181818181818	173	0	98	0	1	173	502559	502731	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	15632	320	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
13734108	13734108	PRJNA999747_S_NODE_611_length_350_cov_54.918495_g579_i0	PRJNA999747	611	350	54.918495	192.2147325	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	630	3.3399999999999984e-176	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g579	i0	99.145	294.237142857143	351	1	100	2	1	350	500478	500129	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	102983	630	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
15008499	15008499	PRJNA999747_S_NODE_92_length_658_cov_21.417863_g75_i0	PRJNA999747	92	658	21.417863	140.92953854	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	1044	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g75	i0	95.289	250.870820668693	658	31	100	0	1	658	501917	502574	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	165073	1044	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
16283337	16283337	PRJNA999747_S_NODE_313_length_448_cov_7.134293_g282_i0	PRJNA999747	313	448	7.134293	31.96163264	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	817	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g282	i0	99.775	90.8392857142857	445	1	99	0	4	448	501926	501482	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	40696	817	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
20107124	20107124	PRJNA999747_S_NODE_1376_length_259_cov_27.824561_g1344_i0	PRJNA999747	1376	259	27.824561	72.06561299	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	436	5.5699999999999985e-118	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g1344	i0	99.174	92.9073359073359	242	2	93	0	18	259	504754	504995	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	24063	436	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
21382765	21382765	PRJNA999747_S_NODE_957_length_298_cov_43.520599_g925_i0	PRJNA999747	957	298	43.520599	129.69138502	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	399	8.589999999999998e-107	NTclustered	gi\|258674431\|gb\|GQ495224.1\|	673862	g925	i0	90.728	95.3322147651007	302	24	100	2	1	298	728	1029	Delta proteobacterium BABL1 16S ribosomal RNA gene, partial sequence	blastn	28409	399	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
22657619	22657619	PRJNA999747_S_NODE_398_length_410_cov_19.213720_g366_i0	PRJNA999747	398	410	19.21372	78.776252	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	623	6.649999999999999e-174	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g366	i0	96.084	291.573170731707	383	13	93	2	1	382	502706	503087	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	119545	623	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis

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