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

14 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
2052884	2052884	PRJNA792582_P_NODE_36382_length_287_cov_1.794393_g35568_i0	PRJNA792582	36382	287	1.794393	5.14990791	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	316	8.519999999999998e-82	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g35568	i0	87.589	15.6898954703833	282	24	98	3	3	283	35157	35428	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4503	316	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3328242	3328242	PRJNA792582_P_NODE_48103_length_255_cov_1.692308_g47289_i0	PRJNA792582	48103	255	1.692308	4.3153854	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	244	3.56e-60	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g47289	i0	83.984	1.00392156862745	256	39	100	2	1	255	972283	972537	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	256	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4605354	4605354	PRJNA792582_P_NODE_40124_length_277_cov_2.024510_g39310_i0	PRJNA792582	40124	277	2.02451	5.6078927	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	178	4.029999999999999e-40	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g39310	i0	81.013	7.86642599277978	237	34	84	10	34	266	3630999	3631228	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	2179	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8430221	8430221	PRJNA792582_P_NODE_48607_length_254_cov_1.243094_g47793_i0	PRJNA792582	48607	254	1.243094	3.15745876	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	307	4.4600000000000006e-79	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g47793	i0	88.845	120.807086614173	251	26	98	2	1	249	1553871	1553621	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	30685	307	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9705110	9705110	PRJNA792582_P_NODE_19628_length_388_cov_2.704762_g18814_i0	PRJNA792582	19628	388	2.704762	10.49447656	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	331	4.2500000000000004e-86	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g18814	i0	82.443	156.559278350515	393	51	100	10	1	388	422487	422108	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	60745	331	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9705247	9705247	PRJNA792582_P_NODE_37308_length_285_cov_1.254717_g36494_i0	PRJNA792582	37308	285	1.254717	3.57594345	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.82e-83	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g36494	i0	87.018	9.50877192982456	285	37	100	0	1	285	209813	210097	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	2710	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12256630	12256630	PRJNA792582_P_NODE_44970_length_264_cov_1.638743_g44156_i0	PRJNA792582	44970	264	1.638743	4.32628152	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g44156	i0	89.773	228.083333333333	264	27	100	0	1	264	174103	174366	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	60214	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13530588	13530588	PRJNA792582_P_NODE_37211_length_285_cov_1.452830_g36397_i0	PRJNA792582	37211	285	1.45283	4.1405655	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	226	1.47e-54	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36397	i0	81.588	0.971929824561404	277	47	96	4	4	278	4375878	4375604	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	277	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13530860	13530860	PRJNA792582_P_NODE_60031_length_237_cov_2.335366_g59217_i0	PRJNA792582	60031	237	2.335366	5.53481742	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	335	1.8899999999999996e-87	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g59217	i0	93.392	303.586497890295	227	14	96	1	1	227	3044934	3045159	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	71950	335	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14805596	14805596	PRJNA792582_P_NODE_4252_length_794_cov_2.341193_g3570_i0	PRJNA792582	4252	794	2.341193	18.58907242	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1026	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g3570	i0	90.113	90.9861460957179	799	66	100	12	1	794	3486021	3485231	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	72243	1026	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16518474	16518474	PRJNA792582_P_NODE_5393_length_711_cov_1.318182_g4655_i0	PRJNA792582	5393	711	1.318182	9.37227402	Gemmatimonas	173479	Bacteria	Bacteria	1085	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g4655	i0	94.468	116.066104078762	705	37	99	2	1	705	913	1615	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	82523	1085	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
19903770	19903770	PRJNA792582_P_NODE_38536_length_281_cov_2.961538_g37722_i0	PRJNA792582	38536	281	2.961538	8.32192178	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	305	1.8e-78	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g37722	i0	86.713	50.9003558718861	286	24	99	14	1	280	343477	343754	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	14303	305	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22454208	22454208	PRJNA792582_P_NODE_35698_length_289_cov_1.425926_g34884_i0	PRJNA792582	35698	289	1.425926	4.12092614	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	220	6.93e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g34884	i0	87.565	0.667820069204152	193	20	66	4	97	288	3953670	3953859	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	193	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22893092	22893092	PRJNA792582_P_NODE_41358_length_274_cov_1.512438_g40544_i0	PRJNA792582	41358	274	1.512438	4.14408012	Gemmatirosa	1706036	Bacteria	Bacteria	267	8.26e-67	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g40544	i0	84.871	71.6021897810219	271	33	97	8	1	267	420781	421047	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	19619	267	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);;