metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA495917" 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
1107884	1107884	PRJNA495917_S_NODE_7961_length_188_cov_9.281046_g7767_i0	PRJNA495917	7961	188	9.281046	17.44836648	Fimbriimonas	1005038	Bacteria	Bacteria	231	1.93e-56	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7767	i0	88.83	112.898936170213	188	21	100	0	1	188	27432	27619	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	21225	231	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4936125	4936125	PRJNA495917_S_NODE_2044_length_340_cov_76.318033_g1850_i0	PRJNA495917	2044	340	76.318033	259.4813122	Fimbriimonas	1005038	Bacteria	Bacteria	503	7.38e-138	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1850	i0	93.491	183.391176470588	338	22	99	0	3	340	27480	27143	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	62353	503	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4936183	4936183	PRJNA495917_S_NODE_864_length_503_cov_13.405983_g678_i0	PRJNA495917	864	503	13.405983	67.43209449	Chthonomonas	1077265	Bacteria	Bacteria	239	3.52e-58	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g678	i0	75.882	231.13916500994	510	99	99	21	2	503	20	513	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	116263	239	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
6211267	6211267	PRJNA495917_S_NODE_105_length_1193_cov_20.139896_g21_i3	PRJNA495917	105	1193	20.139896	240.26895928	Fimbriimonas	1005038	Bacteria	Bacteria	1262	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g21	i3	88.52	149.544844928751	1054	105	93	13	3	1048	29230	28185	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	178407	1262	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7485901	7485901	PRJNA495917_S_NODE_106_length_1187_cov_14.803819_g21_i4	PRJNA495917	106	1187	14.803819	175.72133153	Fimbriimonas	1005038	Bacteria	Bacteria	1310	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g21	i4	89.418	129.099410278012	1049	97	93	11	1	1042	29226	28185	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	153241	1310	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10681148	10681148	PRJNA495917_S_NODE_1649_length_374_cov_43.634218_g1455_i0	PRJNA495917	1649	374	43.634218	163.19197532	Fimbriimonas sp.	1936159	Bacteria	Bacteria	444	5.03e-120	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g1455	i0	89.167	966.144385026738	360	33	95	5	17	373	1687572	1687928	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	361338	444	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
12586876	12586876	PRJNA495917_S_NODE_250_length_862_cov_34.989117_g21_i6	PRJNA495917	250	862	34.989117	301.60618854	Fimbriimonas	1005038	Bacteria	Bacteria	878	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g21	i6	89.106	175.118329466357	716	64	90	10	10	717	28894	28185	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	150952	878	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
24059789	24059789	PRJNA495917_S_NODE_1639_length_375_cov_46.841176_g1445_i0	PRJNA495917	1639	375	46.841176	175.65441	Fimbriimonas	1005038	Bacteria	Bacteria	608	1.689999999999999e-169	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g1445	i0	96	96.152	375	14	100	1	1	375	874251	874624	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	36057	608	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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