metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax_phylum = "Gemmatimonadota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
433965	433965	PRJNA438111_P_NODE_28521_length_210_cov_5.408840_g27896_i0	PRJNA438111	28521	210	5.40884	11.358564	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	102	1.8e-17	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g27896	i0	85.859	2.75714285714286	99	10	46	4	4	100	4885809	4885713	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	579	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2985264	2985264	PRJNA438111_P_NODE_70743_length_164_cov_1.970370_g70118_i0	PRJNA438111	70743	164	1.97037	3.2314068	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	91.6	2.9e-14	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g70118	i0	84.211	0.579268292682927	95	13	57	2	71	164	1020166	1020073	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	95	91.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2985423	2985423	PRJNA438111_P_NODE_83543_length_155_cov_3.190476_g82918_i0	PRJNA438111	83543	155	3.190476	4.9452378	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	185	1.2e-42	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g82918	i0	89.655	0.935483870967742	145	15	94	0	1	145	4100892	4100748	Gemmatimonas phototrophica strain AP64, complete genome	blastn	145	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
4261720	4261720	PRJNA438111_P_NODE_80204_length_157_cov_7.429688_g79579_i0	PRJNA438111	80204	157	7.429688	11.66461016	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	108	2.73e-19	NTclustered	gi\|2518552101\|emb\|OX638356.1\|	2910168	g79579	i0	80.556	7.77707006369427	144	24	90	4	1	142	1989933	1989792	MAG: Longimicrobiales bacterium isolate 11c1aa9f-90ef-4017-a54d-d6b2e11378d8 genome assembly, chromosome: 1	blastn	1221	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
5537692	5537692	PRJNA438111_P_NODE_29085_length_210_cov_4.988950_g28460_i0	PRJNA438111	29085	210	4.98895	10.476795	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	91.6	3.91e-14	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g28460	i0	86.585	2.17142857142857	82	11	39	0	118	199	265258	265339	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	456	91.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6812405	6812405	PRJNA438111_P_NODE_76846_length_160_cov_3.251908_g76221_i0	PRJNA438111	76846	160	3.251908	5.2030528	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	117	4.64e-22	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g76221	i0	80.625	6.5125	160	24	97	7	4	158	3754310	3754153	Gemmatimonas phototrophica strain AP64, complete genome	blastn	1042	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
9362048	9362048	PRJNA438111_P_NODE_32148_length_210_cov_3.513812_g31523_i0	PRJNA438111	32148	210	3.513812	7.3790052	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	80.5	8.45e-11	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g31523	i0	81	0.952380952380952	100	19	48	0	111	210	507521	507620	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	200	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
9362459	9362459	PRJNA438111_P_NODE_62188_length_170_cov_1.007092_g61563_i0	PRJNA438111	62188	170	1.007092	1.7120564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	124	2.97e-24	NTclustered	gi\|2108325062\|gb\|CP070666.1\|	2026742	g61563	i0	84.677	0.729411764705882	124	19	73	0	10	133	5476958	5476835	MAG: Gemmatimonadetes bacterium isolate bin75 chromosome	blastn	124	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
17668373	17668373	PRJNA438111_P_NODE_59834_length_171_cov_4.894366_g59209_i0	PRJNA438111	59834	171	4.894366	8.36936586	Pseudomonadati	3379134	Bacteria	Bacteria	198	1.7399999999999998e-46	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g59209	i0	87.719	89.4912280701754	171	20	99	1	1	170	131268	131098	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	15303	200	0.99	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17668454	17668454	PRJNA438111_P_NODE_70134_length_164_cov_3.822222_g69509_i0	PRJNA438111	70134	164	3.822222	6.26844408	FCB group	1783270	Bacteria	Bacteria	62.1	2.27e-5	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g69509	i0	97.222	212.518292682927	36	1	29	0	14	49	2454027	2453992	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	34853	62.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20835709	20835709	PRJNA438111_P_NODE_33077_length_209_cov_4.722222_g32452_i0	PRJNA438111	33077	209	4.722222	9.86944398	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	87.9	5.02e-13	NTclustered	gi\|2107779373\|gb\|CP070829.1\|	2448054	g32452	i0	86.25	0.382775119617225	80	11	38	0	128	207	2436702	2436781	MAG: Gemmatimonadales bacterium isolate bin109 chromosome	blastn	80	87.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
20836387	20836387	PRJNA438111_P_NODE_87057_length_152_cov_5.601626_g86432_i0	PRJNA438111	87057	152	5.601626	8.51447152	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	122	9.34e-24	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g86432	i0	82.192	1.92105263157895	146	23	96	2	5	150	2601160	2601018	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	292	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola

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