metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
4645910	4645910	PRJNA814235_P_NODE_31904_length_338_cov_32.943522_g30518_i0	PRJNA814235	31904	338	32.943522	111.34910436	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	257	6.3e-64	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g30518	i0	93.642	154.846153846154	173	9	51	2	168	338	1306274	1306102	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	52338	257	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
8469794	8469794	PRJNA814235_P_NODE_184987_length_151_cov_3.947368_g183592_i0	PRJNA814235	184987	151	3.947368	5.96052568	Fimbriimonas sp.	1936159	Bacteria	Bacteria	75	2.63e-9	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g183592	i0	89.655	0.384105960264901	58	6	38	0	74	131	117557	117614	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	58	75	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
8471633	8471633	PRJNA814235_P_NODE_85307_length_206_cov_1.266272_g83912_i0	PRJNA814235	85307	206	1.266272	2.60852032	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	99	2.28e-16	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g83912	i0	89.744	43.495145631068	78	6	37	2	130	206	1305359	1305283	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	8960	99	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
8471691	8471691	PRJNA814235_P_NODE_8867_length_632_cov_4.381513_g7786_i0	PRJNA814235	8867	632	4.381513	27.69116216	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	289	4.39e-73	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g7786	i0	84.642	141.642405063291	293	41	79	4	20	309	1306103	1306394	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	89518	289	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
13569925	13569925	PRJNA814235_P_NODE_159311_length_167_cov_1.200000_g157916_i0	PRJNA814235	159311	167	1.2	2.004	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	128	2.26e-25	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g157916	i0	92.308	2.48502994011976	91	6	54	1	43	132	199807	199717	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	415	128	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
13572296	13572296	PRJNA814235_P_NODE_8711_length_638_cov_12.051581_g7637_i0	PRJNA814235	8711	638	12.051581	76.88908678	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	490	1.13e-133	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g7637	i0	81.126	776.197492163009	657	85	100	27	1	638	1306495	1305859	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	495214	490	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
13981228	13981228	PRJNA814235_P_NODE_66551_length_233_cov_3.122449_g65156_i0	PRJNA814235	66551	233	3.122449	7.27530617	Chthonomonas	1077265	Bacteria	Bacteria	263	8.85e-66	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g65156	i0	87.336	1.9656652360515	229	29	98	0	1	229	1245	1473	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	458	263	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
19077273	19077273	PRJNA814235_P_NODE_12235_length_543_cov_290.266798_g11000_i0	PRJNA814235	12235	543	290.266798	1576.14871314	Fimbriimonas	1005038	Bacteria	Bacteria	599	1.52e-166	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11000	i0	92.217	193.830570902394	424	31	78	2	60	482	26868	27290	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	105250	604	0.991721854304636	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
21628807	21628807	PRJNA814235_P_NODE_27537_length_364_cov_43.128440_g26158_i0	PRJNA814235	27537	364	43.12844	156.9875216	Fimbriimonas	1005038	Bacteria	Bacteria	291	6.7199999999999996e-74	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g26158	i0	84.385	368.739010989011	301	41	82	6	8	305	29487	29784	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	134221	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
22492772	22492772	PRJNA814235_P_NODE_144198_length_180_cov_1.475524_g142803_i0	PRJNA814235	144198	180	1.475524	2.6559432	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	145	2.45e-30	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g142803	i0	81.461	2.90555555555556	178	32	99	1	1	178	667589	667413	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	523	145	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
22494356	22494356	PRJNA814235_P_NODE_37178_length_313_cov_57.119565_g35789_i0	PRJNA814235	37178	313	57.119565	178.78423845	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	315	3.38e-81	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g35789	i0	86.824	222.05750798722	296	21	89	11	35	313	1306395	1306101	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	69504	315	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
22495017	22495017	PRJNA814235_P_NODE_64938_length_236_cov_2.748744_g63543_i0	PRJNA814235	64938	236	2.748744	6.48703584	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	231	2.53e-56	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g63543	i0	85	277.940677966102	240	22	99	10	3	236	1305063	1305294	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	65594	231	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
23769958	23769958	PRJNA814235_P_NODE_34659_length_324_cov_62.864111_g33271_i0	PRJNA814235	34659	324	62.864111	203.67971964	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	399	9.429999999999998e-107	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g33271	i0	89.058	434.848765432099	329	27	100	8	1	324	1306274	1305950	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	140891	399	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes 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);;