metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA474426" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA474426" 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
2998209	2998209	PRJNA474426_P_NODE_24143_length_199_cov_2.973333_g23938_i0	PRJNA474426	24143	199	2.973333	5.91693267	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	250	5.71e-62	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g23938	i0	100	1.0251256281407	135	0	90	0	56	190	603512	603646	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	204	250	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
4274385	4274385	PRJNA474426_P_NODE_10504_length_330_cov_4.786477_g10299_i0	PRJNA474426	10504	330	4.786477	15.7953741	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	569	6.939999999999998e-158	NTclustered	gi\|258674431\|gb\|GQ495224.1\|	673862	g10299	i0	100	93.7909090909091	308	0	93	0	13	320	1332	1025	Delta proteobacterium BABL1 16S ribosomal RNA gene, partial sequence	blastn	30951	569	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
5551111	5551111	PRJNA474426_P_NODE_22685_length_207_cov_2.683544_g22480_i0	PRJNA474426	22685	207	2.683544	5.55493608	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	296	7.58e-76	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g22480	i0	93.5	66.7391304347826	200	12	97	1	8	207	665719	665521	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	13815	296	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
6825154	6825154	PRJNA474426_P_NODE_6886_length_412_cov_4.140496_g6682_i0	PRJNA474426	6886	412	4.140496	17.05884352	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	691	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g6682	i0	97.531	0.983009708737864	405	9	98	1	1	404	565250	565654	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	405	691	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
20849153	20849153	PRJNA474426_P_NODE_33577_length_166_cov_0.880342_g33372_i0	PRJNA474426	33577	166	0.880342	1.46136772	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	248	1.65e-61	NTclustered	gi\|1958073143\|gb\|CP064993.1\|	2026720	g33372	i0	96.644	15.4156626506024	149	5	90	0	1	149	156332	156184	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_MAXAC.330_cln chromosome, complete genome	blastn	2559	248	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
24048841	24048841	PRJNA474426_P_NODE_28519_length_181_cov_1.015152_g28314_i0	PRJNA474426	28519	181	1.015152	1.83742512	Bacteria	2	Bacteria	Bacteria	281	1.8e-71	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g28314	i0	96.491	292.292817679558	171	5	94	1	11	181	692202	692371	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	52905	283	0.992932862190813	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);;