metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
2525668	2525668	PRJNA911178_P_NODE_225022_length_258_cov_2.108108_g222548_i0	PRJNA911178	225022	258	2.108108	5.43891864	Chthonomonas	1077265	Bacteria	Bacteria	320	5.83e-83	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g222548	i0	89.37	165.771317829457	254	27	98	0	2	255	2277	2024	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	42769	320	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
3442690	3442690	PRJNA911178_P_NODE_171243_length_288_cov_1.427907_g168770_i0	PRJNA911178	171243	288	1.427907	4.11237216	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	248	3.17e-61	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g168770	i0	83.895	98.4513888888889	267	35	91	8	2	264	3407317	3407579	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	28354	248	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
5994977	5994977	PRJNA911178_P_NODE_154985_length_300_cov_3.013216_g152512_i0	PRJNA911178	154985	300	3.013216	9.039648	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	220	7.23e-53	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g152512	i0	82.707	27.7666666666667	266	29	87	12	22	281	1305755	1305501	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	8330	220	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
5996878	5996878	PRJNA911178_P_NODE_96665_length_366_cov_2.648464_g94195_i0	PRJNA911178	96665	366	2.648464	9.69337824	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	571	2.1599999999999996e-158	NTclustered	gi\|375271370\|gb\|JQ648819.1\|	157466	g94195	i0	96.023	95.0628415300546	352	12	96	2	16	366	1	351	Uncultured Armatimonadetes bacterium clone PBL2-24 16S ribosomal RNA gene, partial sequence	blastn	34793	571	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
14004614	14004614	PRJNA911178_P_NODE_59511_length_453_cov_1.347368_g57065_i0	PRJNA911178	59511	453	1.347368	6.10357704	Fimbriimonas	1005038	Bacteria	Bacteria	638	2.6499999999999995e-178	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g57065	i0	92.14	255.569536423841	458	26	100	8	1	453	28939	28487	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	115773	638	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
14920039	14920039	PRJNA911178_P_NODE_198272_length_273_cov_1.005000_g195799_i0	PRJNA911178	198272	273	1.005	2.74365	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	156	1.86e-33	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g195799	i0	88.636	14.7912087912088	132	10	47	4	1	129	1305242	1305371	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	4038	156	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
15277444	15277444	PRJNA911178_P_NODE_114292_length_342_cov_0.828996_g111820_i0	PRJNA911178	114292	342	0.828996	2.83516632	Fimbriimonas	1005038	Bacteria	Bacteria	501	2.67e-137	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g111820	i0	93.235	208.868421052632	340	23	99	0	1	340	28554	28893	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	71433	501	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18743338	18743338	PRJNA911178_P_NODE_162515_length_294_cov_1.687783_g160042_i0	PRJNA911178	162515	294	1.687783	4.96208202	Armatimonadota bacterium	2033014	Bacteria	Bacteria	209	1.53e-49	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g160042	i0	81.538	338.928571428571	260	42	87	5	26	280	1692958	1692700	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	99645	209	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
20377056	20377056	PRJNA911178_P_NODE_85076_length_387_cov_1.111465_g82608_i0	PRJNA911178	85076	387	1.111465	4.30136955	Fimbriimonas	1005038	Bacteria	Bacteria	521	2.3399999999999993e-143	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g82608	i0	91.339	155.542635658915	381	33	98	0	7	387	28412	28032	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	60195	521	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25118730	25118730	PRJNA911178_P_NODE_267080_length_246_cov_0.890173_g264606_i0	PRJNA911178	267080	246	0.890173	2.18982558	Armatimonadota bacterium	2033014	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g264606	i0	79.424	207	243	36	97	13	9	246	2411015	2411248	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	50922	159	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota 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);;