metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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
1568669	1568669	PRJNA1148190_P_NODE_327582_length_309_cov_1.093220_g316409_i0	PRJNA1148190	327582	309	1.09322	3.3780498	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62.1	4.79e-5	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g316409	i0	91.304	2.8705501618123	46	3	15	1	143	187	920873	920918	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	887	62.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
6671182	6671182	PRJNA1148190_P_NODE_278726_length_329_cov_1.503906_g267555_i0	PRJNA1148190	278726	329	1.503906	4.94785074	Armatimonadota bacterium	2033014	Bacteria	Bacteria	213	1.34e-50	NTclustered	gi\|2621785506\|emb\|OY781964.1\|	2033014	g267555	i0	79.605	7.19756838905775	304	56	91	6	26	326	3748450	3748750	MAG: Armatimonadota bacterium isolate 4fa1d893-657a-425b-bdcb-33dea01a3015 genome assembly, chromosome: 1	blastn	2368	213	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
6678193	6678193	PRJNA1148190_P_NODE_795726_length_236_cov_3.576687_g784553_i0	PRJNA1148190	795726	236	3.576687	8.44098132	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	95.3	3.47e-15	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g784553	i0	86.905	3.45338983050847	84	11	64	0	102	185	1462279	1462196	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	815	95.3	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7951411	7951411	PRJNA1148190_P_NODE_638507_length_248_cov_1.371429_g627334_i0	PRJNA1148190	638507	248	1.371429	3.40114392	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	119	2.18e-22	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g627334	i0	91.765	27.5120967741935	85	7	34	0	55	139	1786352	1786268	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	6823	119	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
8686967	8686967	PRJNA1148190_P_NODE_131827_length_459_cov_0.772021_g120664_i0	PRJNA1148190	131827	459	0.772021	3.54357639	FCB group	1783270	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g120664	i0	100	1.34640522875817	30	0	7	0	308	337	3553221	3553250	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	618	56.5	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
11769838	11769838	PRJNA1148190_P_NODE_145150_length_436_cov_2.214876_g133984_i0	PRJNA1148190	145150	436	2.214876	9.65685936	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62.1	7e-5	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g133984	i0	97.222	0.165137614678899	36	1	8	0	211	246	2756677	2756642	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	72	62.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
11777109	11777109	PRJNA1148190_P_NODE_644730_length_248_cov_0.880000_g633557_i0	PRJNA1148190	644730	248	0.88	2.1824	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	76.8	1.33e-9	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g633557	i0	78.295	0.520161290322581	129	20	51	5	76	201	471019	470896	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	129	76.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
13048172	13048172	PRJNA1148190_P_NODE_358111_length_297_cov_2.339286_g346938_i0	PRJNA1148190	358111	297	2.339286	6.94767942	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g346938	i0	89.13	0.154882154882155	46	3	15	2	24	68	2594020	2594064	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	46	56.5	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
13051574	13051574	PRJNA1148190_P_NODE_607891_length_250_cov_0.870056_g596718_i0	PRJNA1148190	607891	250	0.870056	2.17514	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g596718	i0	91.623	0.764	191	15	76	1	60	250	2390445	2390256	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	191	263	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
14323143	14323143	PRJNA1148190_P_NODE_336612_length_305_cov_1.931034_g325439_i0	PRJNA1148190	336612	305	1.931034	5.8896537	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	220	7.37e-53	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g325439	i0	80.546	1.87868852459016	293	51	95	5	2	291	1599813	1600102	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	573	220	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
15598417	15598417	PRJNA1148190_P_NODE_426293_length_281_cov_1.350962_g415120_i0	PRJNA1148190	426293	281	1.350962	3.79620322	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	161	4.13e-35	NTclustered	gi\|2874253971\|emb\|OY970296.1\|	157466	g415120	i0	77.5	3.01779359430605	280	55	98	8	1	276	619557	619282	MAG: uncultured Armatimonadetes bacterium isolate MFD04408.bin.1.1 genome assembly, chromosome: 1	blastn	848	161	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
18886700	18886700	PRJNA1148190_P_NODE_414355_length_283_cov_1.880952_g403182_i0	PRJNA1148190	414355	283	1.880952	5.32309416	Armatimonadota	67819	Bacteria	Bacteria	122	1.9599999999999994e-23	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g403182	i0	94.937	28.0318021201413	79	2	28	2	90	168	2644086	2644162	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	7933	122	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
19424621	19424621	PRJNA1148190_P_NODE_644856_length_248_cov_0.880000_g633683_i0	PRJNA1148190	644856	248	0.88	2.1824	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	228	3.469999999999999e-55	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g633683	i0	85.022	1.38709677419355	227	30	91	3	20	244	2201499	2201723	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	344	228	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
19425354	19425354	PRJNA1148190_P_NODE_705496_length_245_cov_0.895349_g694323_i0	PRJNA1148190	705496	245	0.895349	2.19360505	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	76.8	1.31e-9	NTclustered	gi\|2076447151\|gb\|CP075366.1\|	2682144	g694323	i0	95.745	0.191836734693878	47	2	19	0	171	217	1114255	1114209	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome	blastn	47	76.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
21972870	21972870	PRJNA1148190_P_NODE_469518_length_272_cov_2.246231_g458345_i0	PRJNA1148190	469518	272	2.246231	6.10974832	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g458345	i0	100	0.102941176470588	28	0	10	0	117	144	4063094	4063121	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
21976013	21976013	PRJNA1148190_P_NODE_711558_length_245_cov_0.895349_g700385_i0	PRJNA1148190	711558	245	0.895349	2.19360505	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62.1	3.67e-5	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g700385	i0	100	4.42857142857143	33	0	19	0	127	159	1214021	1213989	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	1085	62.1	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);;