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

6 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax_phylum = "Candidatus Cloacimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_species
25534149	25534149	PRJNA1233465a_S_NODE_253585_length_158_cov_4.385321_g252311_i0	PRJNA1233465	253585	158	4.385321	6.92880718	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g252311	i0	100	0.177215189873418	28	0	18	0	14	41	1947234	1947207	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
25813621	25813621	PRJNA1233465d_S_NODE_117075_length_171_cov_1.631148_g115964_i0	PRJNA1233465	117075	171	1.631148	2.78926308	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g115964	i0	100	0.16374269005848	28	0	16	0	136	163	1947207	1947234	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
25959964	25959964	PRJNA1233465f_S_NODE_109028_length_230_cov_2.077348_g106748_i0	PRJNA1233465	109028	230	2.077348	4.7779004	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	67.6	7.33e-7	NTclustered	gi\|2621786373\|emb\|OY782831.1\|	3060593	g106748	i0	89.286	18.9173913043478	56	3	24	2	176	230	1166874	1166821	MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1	blastn	4351	67.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
26348219	26348219	PRJNA1233465a_S_NODE_158423_length_191_cov_1.373239_g157149_i0	PRJNA1233465	158423	191	1.373239	2.62288649	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2907625735\|emb\|OZ223295.1\|	3060593	g157149	i0	100	0.303664921465969	29	0	15	0	147	175	1394378	1394406	MAG: Candidatus Cloacimonadales bacterium isolate 6aa99263-f948-4c70-b254-b65c93863ac0 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
26491611	26491611	PRJNA1233465b_S_NODE_312544_length_171_cov_12.811475_g310859_i0	PRJNA1233465	312544	171	12.811475	21.90762225	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g310859	i0	100	0.16374269005848	28	0	16	0	28	55	1947234	1947207	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales bacterium
26495505	26495505	PRJNA1233465d_S_NODE_22184_length_345_cov_1.567568_g21073_i0	PRJNA1233465	22184	345	1.567568	5.4081096	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	67.6	1.17e-6	NTclustered	gi\|2621786373\|emb\|OY782831.1\|	3060593	g21073	i0	89.286	12.8434782608696	56	3	16	2	137	191	1166821	1166874	MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1	blastn	4431	67.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadales 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);;