metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

14 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
25426	25426	PRJEB28062_P_NODE_76321_length_389_cov_13.000000_g73959_i0	PRJEB28062	76321	389	13	50.57	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	255	2.64e-63	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g73959	i0	80.723	0.938303341902314	332	61	85	3	41	370	2595931	2595601	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	365	255	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
1299375	1299375	PRJEB28062_P_NODE_58702_length_458_cov_3.792208_g56343_i0	PRJEB28062	58702	458	3.792208	17.36831264	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	239	3.18e-58	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g56343	i0	87.805	0.447598253275109	205	23	45	2	233	436	126760	126557	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	205	239	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
2574755	2574755	PRJEB28062_P_NODE_46863_length_524_cov_32.423503_g44519_i0	PRJEB28062	46863	524	32.423503	169.89915572	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	274	1.01e-68	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g44519	i0	83.007	13.8206106870229	306	48	58	3	196	499	600363	600060	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	7242	274	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
6404117	6404117	PRJEB28062_P_NODE_99346_length_317_cov_1.262295_g96984_i0	PRJEB28062	99346	317	1.262295	4.00147515	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	167	1.02e-36	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g96984	i0	77.592	0.943217665615142	299	51	92	15	13	303	1049718	1049428	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	299	167	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
8950541	8950541	PRJEB28062_P_NODE_103308_length_305_cov_1.913793_g100945_i0	PRJEB28062	103308	305	1.913793	5.83706865	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	279	1.2e-70	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g100945	i0	84.247	1.12459016393443	292	41	94	2	19	305	1423499	1423208	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	343	279	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
8952400	8952400	PRJEB28062_P_NODE_72288_length_403_cov_6.445455_g69927_i0	PRJEB28062	72288	403	6.445455	25.97518365	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	248	4.5899999999999995e-61	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g69927	i0	79.272	0.885856079404467	357	73	88	1	19	374	538312	538668	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	357	248	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
11503415	11503415	PRJEB28062_P_NODE_71410_length_406_cov_7.210210_g69049_i0	PRJEB28062	71410	406	7.21021	29.2734526	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	292	2.11e-74	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g69049	i0	87.903	2.33990147783251	248	30	65	0	22	269	1342505	1342752	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	950	292	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
15326571	15326571	PRJEB28062_P_NODE_25293_length_739_cov_15.680180_g23067_i0	PRJEB28062	25293	739	15.68018	115.8765302	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	327	1.1e-84	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g23067	i0	84.756	0.769959404600812	328	49	76	1	390	716	2214233	2213906	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	569	327	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
16601554	16601554	PRJEB28062_P_NODE_40074_length_574_cov_28.542914_g37741_i0	PRJEB28062	40074	574	28.542914	163.83632636	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	361	8.289999999999999e-95	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g37741	i0	79.395	0.921602787456446	529	95	91	13	21	542	2518458	2517937	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	529	361	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
16602111	16602111	PRJEB28062_P_NODE_66494_length_424_cov_51.301994_g64133_i0	PRJEB28062	66494	424	51.301994	217.52045456	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	403	9.79e-108	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g64133	i0	86.813	1.75	364	44	88	4	41	401	2625046	2625408	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	742	403	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
21700998	21700998	PRJEB28062_P_NODE_20278_length_833_cov_13.980263_g18219_i0	PRJEB28062	20278	833	13.980263	116.45559079	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	708	0	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g18219	i0	83.596	4.78031212484994	762	117	91	8	23	780	2799256	2800013	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	3982	708	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
21701452	21701452	PRJEB28062_P_NODE_39318_length_581_cov_3.295276_g36987_i0	PRJEB28062	39318	581	3.295276	19.14555356	Capsulimonas corticalis	2219043	Bacteria	Bacteria	135	5.5400000000000005e-27	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g36987	i0	78.641	0.354561101549053	206	42	35	2	93	296	669562	669357	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	206	135	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
21701822	21701822	PRJEB28062_P_NODE_55318_length_474_cov_23.389027_g52964_i0	PRJEB28062	55318	474	23.389027	110.86398798	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	449	1.4e-121	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g52964	i0	85.615	25.7278481012658	431	58	90	4	23	450	1613195	1613624	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	12195	449	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
22976677	22976677	PRJEB28062_P_NODE_38639_length_586_cov_99.196881_g36311_i0	PRJEB28062	38639	586	99.196881	581.29372266	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	283	1.89e-71	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g36311	i0	76.592	2.13310580204778	534	113	90	11	17	543	2263151	2262623	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	1250	283	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales 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);;