metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA752278" 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
2003981	2003981	PRJNA752278_P_NODE_65662_length_262_cov_2.074074_g65459_i0	PRJNA752278	65662	262	2.074074	5.43407388	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	231	2.8599999999999996e-56	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g65459	i0	82.879	57.1221374045802	257	44	98	0	5	261	2562871	2563127	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	14966	231	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2004064	2004064	PRJNA752278_P_NODE_69942_length_258_cov_1.664865_g69739_i0	PRJNA752278	69942	258	1.664865	4.2953517	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	298	2.73e-76	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g69739	i0	87.645	46.9302325581395	259	29	100	3	1	258	1101976	1102232	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	12108	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9655840	9655840	PRJNA752278_P_NODE_34768_length_293_cov_2.745455_g34565_i0	PRJNA752278	34768	293	2.745455	8.04418315	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	283	8.849999999999999e-72	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g34565	i0	84.828	34.4607508532423	290	34	98	9	3	289	3042327	3042609	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	10097	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10931412	10931412	PRJNA752278_P_NODE_3949_length_635_cov_1.507117_g3751_i0	PRJNA752278	3949	635	1.507117	9.57019295	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	547	6.6e-151	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g3751	i0	83.172	229.433070866142	618	85	96	18	27	635	1102704	1103311	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	145690	547	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
13482079	13482079	PRJNA752278_P_NODE_83031_length_249_cov_0.875000_g82828_i0	PRJNA752278	83031	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g82828	i0	88.163	128.481927710843	245	25	98	4	7	249	802654	802412	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	31992	289	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18579937	18579937	PRJNA752278_P_NODE_77135_length_251_cov_1.730337_g76932_i0	PRJNA752278	77135	251	1.730337	4.34314587	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	215	2.74e-51	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g76932	i0	82.845	84.3187250996016	239	41	95	0	11	249	1624257	1624495	Gemmatimonas phototrophica strain AP64, complete genome	blastn	21164	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
23680199	23680199	PRJNA752278_P_NODE_29119_length_310_cov_3.248945_g28916_i0	PRJNA752278	29119	310	3.248945	10.0717295	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	180	1.27e-40	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g28916	i0	91.045	29.4870967741935	134	10	84	2	18	150	3042668	3042536	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	9141	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
23680491	23680491	PRJNA752278_P_NODE_42859_length_284_cov_1.360190_g42656_i0	PRJNA752278	42859	284	1.36019	3.8629396	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	424	4.82e-114	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g42656	i0	93.972	63.1619718309859	282	13	99	4	5	284	3043516	3043237	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	17938	424	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
23681006	23681006	PRJNA752278_P_NODE_72059_length_256_cov_1.683060_g71856_i0	PRJNA752278	72059	256	1.68306	4.3086336	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	268	2.1199999999999998e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g71856	i0	85.603	1.2265625	257	35	100	2	1	256	4421842	4422097	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	314	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24953230	24953230	PRJNA752278_P_NODE_103140_length_241_cov_2.422619_g102937_i0	PRJNA752278	103140	241	2.422619	5.83851179	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	150	7.48e-32	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g102937	i0	85.816	15.9294605809129	141	20	59	0	1	141	127421	127281	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	3839	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales 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);;