metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA674308" 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
644857	644857	PRJNA674308_P_NODE_53621_length_162_cov_0.920354_g53386_i0	PRJNA674308	53621	162	0.920354	1.49097348	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	213	5.84e-51	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g53386	i0	90.303	1.01851851851852	165	13	100	1	1	162	464384	464548	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	165	213	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
4472614	4472614	PRJNA674308_P_NODE_17804_length_231_cov_1.384615_g17569_i0	PRJNA674308	17804	231	1.384615	3.19846065	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	379	8.339999999999999e-101	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g17569	i0	96.507	248.38961038961	229	8	99	0	1	229	138930	139158	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	57378	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
4472802	4472802	PRJNA674308_P_NODE_41584_length_167_cov_0.881356_g41349_i0	PRJNA674308	41584	167	0.881356	1.47186452	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	276	7.64e-70	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g41349	i0	96.407	14.4131736526946	167	6	100	0	1	167	26607	26773	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2407	276	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
4994831	4994831	PRJNA674308_P_NODE_27244_length_192_cov_1.706294_g27009_i0	PRJNA674308	27244	192	1.706294	3.27608448	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	355	1.13e-93	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g27009	i0	100	53.140625	192	0	100	0	1	192	137847	137656	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	10203	355	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
12124149	12124149	PRJNA674308_P_NODE_43390_length_166_cov_0.888889_g43155_i0	PRJNA674308	43390	166	0.888889	1.47555574	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	244	2.1399999999999998e-60	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g43155	i0	93.373	1	166	10	100	1	1	166	547732	547896	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	166	244	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
12124169	12124169	PRJNA674308_P_NODE_46070_length_165_cov_0.896552_g45835_i0	PRJNA674308	46070	165	0.896552	1.4793108	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g45835	i0	97.576	1	165	4	100	0	1	165	519272	519436	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	165	283	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
15195089	15195089	PRJNA674308_P_NODE_26032_length_196_cov_1.816327_g25797_i0	PRJNA674308	26032	196	1.816327	3.56000092	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	313	7.04e-81	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g25797	i0	95.408	214.112244897959	196	9	100	0	1	196	79852	79657	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	41966	313	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);;