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

13 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
2892160	2892160	PRJNA1237347_P_NODE_340443_length_308_cov_6.408511_g333870_i0	PRJNA1237347	340443	308	6.408511	19.73821388	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	206	2.09e-48	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g333870	i0	83.475	9.1461038961039	236	24	74	10	80	308	2045242	2045015	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	2817	206	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7426599	7426599	PRJNA1237347_P_NODE_391006_length_283_cov_2.180952_g384433_i0	PRJNA1237347	391006	283	2.180952	6.17209416	Chthonomonas	1077265	Bacteria	Bacteria	259	1.43e-64	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g384433	i0	85.657	138.3074204947	251	31	87	4	10	255	11	261	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	39141	259	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
13094410	13094410	PRJNA1237347_P_NODE_308111_length_328_cov_2.682353_g301538_i0	PRJNA1237347	308111	328	2.682353	8.79811784	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	224	6.179999999999998e-54	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g301538	i0	79.385	3.84756097560976	325	62	98	5	6	327	787720	787398	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	1262	224	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
14369674	14369674	PRJNA1237347_P_NODE_305532_length_330_cov_1.727626_g298959_i0	PRJNA1237347	305532	330	1.727626	5.7011658	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	121	8.4e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g298959	i0	83.333	2.5	132	21	43	1	106	237	1480546	1480416	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	825	121	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15644108	15644108	PRJNA1237347_P_NODE_331733_length_313_cov_13.054167_g325160_i0	PRJNA1237347	331733	313	13.054167	40.85954271	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	121	7.91e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g325160	i0	84.677	0.396166134185303	124	16	39	3	1	122	1625879	1625757	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	124	121	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15644507	15644507	PRJNA1237347_P_NODE_352933_length_301_cov_36.228070_g346360_i0	PRJNA1237347	352933	301	36.22807	109.0464907	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	364	3.169999999999999e-96	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g346360	i0	88.889	417.1926910299	297	32	99	1	4	300	1879368	1879663	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	125575	364	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
16922090	16922090	PRJNA1237347_P_NODE_531214_length_244_cov_0.900585_g524641_i0	PRJNA1237347	531214	244	0.900585	2.1974274	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g524641	i0	100	0.114754098360656	28	0	11	0	164	191	1240959	1240986	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
17626497	17626497	PRJNA1237347_P_NODE_407094_length_276_cov_4.246305_g400521_i0	PRJNA1237347	407094	276	4.246305	11.7198018	Fimbriimonas	1005038	Bacteria	Bacteria	122	1.9099999999999998e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g400521	i0	75.088	1.94927536231884	285	59	100	10	1	276	1625558	1625839	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	538	122	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18900434	18900434	PRJNA1237347_P_NODE_419255_length_271_cov_10.767677_g412682_i0	PRJNA1237347	419255	271	10.767677	29.18040467	Armatimonadota	67819	Bacteria	Bacteria	337	6.129999999999998e-88	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g412682	i0	91.165	201.206642066421	249	20	92	2	20	267	37378	37131	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	54527	337	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
22725612	22725612	PRJNA1237347_P_NODE_385598_length_286_cov_1.084507_g379025_i0	PRJNA1237347	385598	286	1.084507	3.10169002	Chthonomonas	1077265	Bacteria	Bacteria	182	3.23e-41	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g379025	i0	87.037	98.5384615384615	162	19	56	2	91	251	1541	1701	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	28182	182	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
22725770	22725770	PRJNA1237347_P_NODE_416898_length_272_cov_3.095477_g410325_i0	PRJNA1237347	416898	272	3.095477	8.41969744	Chthonomonas	1077265	Bacteria	Bacteria	337	6.15e-88	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g410325	i0	89.259	228.981617647059	270	28	99	1	1	270	1925	2193	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	62283	337	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
22726192	22726192	PRJNA1237347_P_NODE_503058_length_247_cov_1.321839_g496485_i0	PRJNA1237347	503058	247	1.321839	3.26494233	Armatimonadota	67819	Bacteria	Bacteria	106	1.69e-18	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g496485	i0	85.294	1.23886639676113	102	15	41	0	9	110	2493228	2493329	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	306	106	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
24569495	24569495	PRJNA1237347_P_NODE_440560_length_263_cov_1.315789_g433987_i0	PRJNA1237347	440560	263	1.315789	3.46052507	Fimbriimonas sp.	1936159	Bacteria	Bacteria	117	8.39e-22	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g433987	i0	87.255	1.79847908745247	102	13	39	0	70	171	2377920	2378021	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	473	117	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.

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