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

14 rows where analysis = "blastn", bioproject = "PRJNA529241" 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
3049810	3049810	PRJNA529241_P_NODE_162463_length_180_cov_1.363636_g160141_i0	PRJNA529241	162463	180	1.363636	2.4545448	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	222	1.0999999999999999e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g160141	i0	89.011	23.9222222222222	182	16	100	4	1	180	3043635	3043456	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4306	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3052521	3052521	PRJNA529241_P_NODE_494243_length_151_cov_5.385965_g491921_i0	PRJNA529241	494243	151	5.385965	8.13280715	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	121	3.33e-23	NTclustered	gi\|2107779373\|gb\|CP070829.1\|	2448054	g491921	i0	85.039	1.17218543046358	127	10	78	6	34	151	2823302	2823176	MAG: Gemmatimonadales bacterium isolate bin109 chromosome	blastn	177	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
4326640	4326640	PRJNA529241_P_NODE_288344_length_173_cov_3.720588_g286022_i0	PRJNA529241	288344	173	3.720588	6.43661724	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	102	1.42e-17	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g286022	i0	91.781	0.421965317919075	73	6	42	0	1	73	1965620	1965548	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	73	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
5602725	5602725	PRJNA529241_P_NODE_174005_length_175_cov_1.413043_g171683_i0	PRJNA529241	174005	175	1.413043	2.47282525	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	196	6.44e-46	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g171683	i0	86.932	16.2457142857143	176	21	100	2	1	175	1903553	1903379	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2843	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5604804	5604804	PRJNA529241_P_NODE_440505_length_160_cov_1.585366_g438183_i0	PRJNA529241	440505	160	1.585366	2.5365856	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	200	4.48e-47	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g438183	i0	89.375	8.26875	160	15	99	2	1	159	422018	422176	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1323	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5604863	5604863	PRJNA529241_P_NODE_446445_length_158_cov_1.157025_g444123_i0	PRJNA529241	446445	158	1.157025	1.8280995	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	180	5.74e-41	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g444123	i0	88.312	103.075949367089	154	13	96	5	7	158	3042472	3042622	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	16286	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8769305	8769305	PRJNA529241_P_NODE_504987_length_151_cov_4.684211_g502665_i0	PRJNA529241	504987	151	4.684211	7.07315861	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	5.65e-11	NTclustered	gi\|2531976023\|emb\|OY282356.1\|	2026742	g502665	i0	97.826	1.97350993377483	46	1	30	0	27	72	1733088	1733043	MAG: Gemmatimonadota bacterium genome assembly, chromosome: 1	blastn	298	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
10703231	10703231	PRJNA529241_P_NODE_208709_length_173_cov_5.808824_g206387_i0	PRJNA529241	208709	173	5.808824	10.04926552	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	147	6.479999999999999e-31	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g206387	i0	78.736	1.44508670520231	174	31	100	4	1	173	4180518	4180686	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	250	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10706541	10706541	PRJNA529241_P_NODE_81289_length_237_cov_6.640000_g78967_i0	PRJNA529241	81289	237	6.64	15.7368	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	174	4.3499999999999997e-39	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g78967	i0	88.732	136.649789029536	142	16	60	0	69	210	254523	254382	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	32386	174	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13256557	13256557	PRJNA529241_P_NODE_96751_length_220_cov_7.524590_g94429_i0	PRJNA529241	96751	220	7.52459	16.554098	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	63.9	9e-6	NTclustered	gi\|2531976028\|emb\|OY282361.1\|	2910168	g94429	i0	100	3.30454545454545	34	0	15	0	1	34	1680035	1680002	MAG: Longimicrobiales bacterium genome assembly, chromosome: 1	blastn	727	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
17077126	17077126	PRJNA529241_P_NODE_298454_length_173_cov_3.566176_g296132_i0	PRJNA529241	298454	173	3.566176	6.16948448	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g296132	i0	93.333	5.54335260115607	75	5	43	0	98	172	3678262	3678188	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	959	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
17077782	17077782	PRJNA529241_P_NODE_385054_length_173_cov_2.507353_g382732_i0	PRJNA529241	385054	173	2.507353	4.33772069	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	106	1.1e-18	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g382732	i0	92	0.433526011560694	75	6	43	0	99	173	898743	898817	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	75	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24724499	24724499	PRJNA529241_P_NODE_135960_length_193_cov_2.717949_g133638_i0	PRJNA529241	135960	193	2.717949	5.24564157	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	287	4.189999999999999e-73	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g133638	i0	94.624	143.062176165803	186	9	96	1	2	186	3042858	3042673	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	27611	287	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24725921	24725921	PRJNA529241_P_NODE_315100_length_173_cov_3.316176_g312778_i0	PRJNA529241	315100	173	3.316176	5.73698448	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	113	6.5700000000000005e-21	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g312778	i0	93.421	5.87861271676301	76	5	44	0	1	76	456406	456481	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1017	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica

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