metadata: contig_metadata: 5 rows where bioproject = "PRJNA1063685", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA1063685", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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
7832521	7832521	PRJNA1063685_S_NODE_80967_length_197_cov_5.516129_g80424_i0	PRJNA1063685	80967	197	5.516129	10.86677413	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	268	1.5599999999999998e-67	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g80424	i0	94.286	78.7715736040609	175	10	89	0	23	197	668342	668168	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	15518	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
18031552	18031552	PRJNA1063685_S_NODE_72155_length_245_cov_6.011628_g71612_i0	PRJNA1063685	72155	245	6.011628	14.7284886	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	329	9.12e-86	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g71612	i0	93.636	227.265306122449	220	14	90	0	23	242	219894	220113	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	55680	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
21856332	21856332	PRJNA1063685_S_NODE_25578_length_461_cov_12.569588_g25038_i0	PRJNA1063685	25578	461	12.569588	57.94580068	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	582	1.28e-161	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g25038	i0	90.972	102.119305856833	432	39	94	0	30	461	884054	883623	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	47077	582	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22689047	22689047	PRJNA1063685_S_NODE_9458_length_637_cov_9.900709_g8947_i0	PRJNA1063685	9458	637	9.900709	63.06751633	Bacteria	2	Bacteria	Bacteria	996	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g8947	i0	95.935	150.511773940345	615	24	96	1	24	637	696743	697357	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	95876	1002	0.994011976047904	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
27825346	27825346	PRJNA1063685_S_NODE_8204_length_659_cov_4.013652_g7704_i0	PRJNA1063685	8204	659	4.013652	26.44996668	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	222	9.12e-66	NR	MDB5177279.1	2026720	g7704	i0	64.1	0.987860394537178	217	71	96.1	5	659	27	130	345	MDB5177279.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	651	222	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;