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

7 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax_kingdom = "Thermoproteati"

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_kingdom	tax_phylum	tax_genus	tax_species
673247	673247	PRJNA694557_P_NODE_15481_length_328_cov_8.690196_g15261_i0	PRJNA694557	15481	328	8.690196	28.50384288	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	276	1.6799999999999998e-69	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g15261	i0	83.618	0.893292682926829	293	48	89	0	21	313	1497616	1497908	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	293	276	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
673496	673496	PRJNA694557_P_NODE_6161_length_586_cov_4.721248_g5942_i0	PRJNA694557	6161	586	4.721248	27.66651328	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	795	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g5942	i0	91.901	0.969283276450512	568	46	97	0	1	568	783491	784058	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	568	795	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
4501239	4501239	PRJNA694557_P_NODE_15504_length_328_cov_2.921569_g15284_i0	PRJNA694557	15504	328	2.921569	9.58274632	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	231	3.69e-56	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g15284	i0	79.573	1	328	64	99	3	1	326	850528	850202	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	328	231	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius
8326364	8326364	PRJNA694557_P_NODE_17207_length_308_cov_2.357447_g16987_i0	PRJNA694557	17207	308	2.357447	7.26093676	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	425	1.47e-114	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g16987	i0	93.426	0.938311688311688	289	15	93	3	4	290	1211551	1211265	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	289	425	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
9601871	9601871	PRJNA694557_P_NODE_26668_length_229_cov_3.948718_g26448_i0	PRJNA694557	26668	229	3.948718	9.04256422	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	315	2.36e-81	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g26448	i0	96.335	1.9825327510917	191	7	83	0	23	213	391524	391714	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	454	315	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
17251232	17251232	PRJNA694557_P_NODE_21394_length_267_cov_1.577320_g21174_i0	PRJNA694557	21394	267	1.57732	4.2114444	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	401	2.1099999999999995e-107	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g21174	i0	93.985	1.99250936329588	266	15	99	1	1	265	32980	32715	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	532	401	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
18525127	18525127	PRJNA694557_P_NODE_10535_length_418_cov_1.339130_g10315_i0	PRJNA694557	10535	418	1.33913	5.5975634	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	595	1.4799999999999999e-165	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g10315	i0	92.344	1	418	32	100	0	1	418	32721	32304	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	418	595	1	Archaea	Thermoproteati	Nitrososphaerota	Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae

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