metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Armatimonadota"

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_class	tax_order	tax_family	tax_genus	tax_species
4733143	4733143	PRJNA928559_P_NODE_98444_length_359_cov_3.073427_g96875_i0	PRJNA928559	98444	359	3.073427	11.03360293	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	414	3.77e-111	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g96875	i0	87.569	1.63231197771588	362	40	100	5	1	359	1625519	1625878	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	586	414	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
9832403	9832403	PRJNA928559_P_NODE_89748_length_376_cov_1.029703_g88179_i0	PRJNA928559	89748	376	1.029703	3.87168328	Fimbriimonas sp.	1936159	Bacteria	Bacteria	516	1.06e-141	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g88179	i0	91.512	163.976063829787	377	28	100	4	1	376	1688888	1688515	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	61655	516	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
12382039	12382039	PRJNA928559_P_NODE_170310_length_268_cov_1.066667_g168741_i0	PRJNA928559	170310	268	1.066667	2.85866756	Armatimonadota bacterium	2033014	Bacteria	Bacteria	230	1.0599999999999998e-55	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g168741	i0	82.528	155.014925373134	269	40	100	7	1	268	2411267	2411005	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	41544	230	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
15280645	15280645	PRJNA928559_P_NODE_131392_length_309_cov_5.610169_g129823_i0	PRJNA928559	131392	309	5.610169	17.33542221	Fimbriimonas	1005038	Bacteria	Bacteria	335	2.559999999999999e-87	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g129823	i0	87.586	151.961165048544	290	35	94	1	14	302	29491	29780	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	46956	335	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25129702	25129702	PRJNA928559_P_NODE_216580_length_240_cov_2.491018_g215011_i0	PRJNA928559	216580	240	2.491018	5.9784432	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g215011	i0	94.118	0.141666666666667	34	2	14	0	6	39	2475734	2475701	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales 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);;