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

12 rows where analysis = "blastn", bioproject = "PRJNA900028" 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
875936	875936	PRJNA900028_P_NODE_7201_length_402_cov_3.025496_g6456_i0	PRJNA900028	7201	402	3.025496	12.16249392	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	390	7.189999999999999e-104	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g6456	i0	84.352	100.31592039801	409	53	100	8	1	402	1103316	1102912	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	40327	390	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
3425192	3425192	PRJNA900028_P_NODE_113323_length_169_cov_1.700000_g112574_i0	PRJNA900028	113323	169	1.7	2.873	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	150	4.86e-32	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g112574	i0	85.616	27.3431952662722	146	17	85	3	2	145	749690	749547	Gemmatimonas phototrophica strain AP64, complete genome	blastn	4621	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
3425737	3425737	PRJNA900028_P_NODE_170423_length_163_cov_0.894737_g169674_i0	PRJNA900028	170423	163	0.894737	1.45842131	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g169674	i0	92.683	0.809815950920245	41	3	25	0	53	93	1126595	1126555	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	132	60.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3426261	3426261	PRJNA900028_P_NODE_39283_length_222_cov_1.179191_g38534_i0	PRJNA900028	39283	222	1.179191	2.61780402	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	219	1.83e-52	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g38534	i0	85.135	82.0135135135135	222	24	98	8	3	219	3042609	3042392	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	18207	219	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
3426728	3426728	PRJNA900028_P_NODE_783_length_1530_cov_3.674544_g397_i0	PRJNA900028	783	1530	3.674544	56.2205232	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	2084	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g397	i0	91.347	306.165359477124	1537	114	99	17	5	1530	3043861	3042333	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	468433	2084	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9803434	9803434	PRJNA900028_P_NODE_4188_length_524_cov_1.566316_g3463_i0	PRJNA900028	4188	524	1.566316	8.20749584	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	523	9.059999999999997e-144	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g3463	i0	84.934	45.9503816793893	531	65	100	15	1	524	421902	422424	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	24078	523	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16177702	16177702	PRJNA900028_P_NODE_173433_length_163_cov_0.894737_g172684_i0	PRJNA900028	173433	163	0.894737	1.45842131	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	158	2.8e-34	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g172684	i0	85.161	78.7423312883436	155	21	94	2	1	154	197945	198098	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	12835	158	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17453119	17453119	PRJNA900028_P_NODE_165614_length_163_cov_1.324561_g164865_i0	PRJNA900028	165614	163	1.324561	2.15903443	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	191	2.76e-44	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g164865	i0	89.241	71.0490797546012	158	10	94	4	1	154	3042777	3042623	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	11581	191	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18727305	18727305	PRJNA900028_P_NODE_67535_length_190_cov_1.446809_g66786_i0	PRJNA900028	67535	190	1.446809	2.7489371	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	237	4.2e-58	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g66786	i0	89.84	9.47894736842105	187	16	97	3	1	185	1102850	1103035	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1801	237	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
20371366	20371366	PRJNA900028_P_NODE_197316_length_161_cov_0.910714_g196567_i0	PRJNA900028	197316	161	0.910714	1.46624954	FCB group	1783270	Bacteria	Bacteria	69.4	1.33e-7	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g196567	i0	90.566	50.8571428571429	53	3	32	2	99	150	2688479	2688428	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	8188	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22552021	22552021	PRJNA900028_P_NODE_192498_length_161_cov_0.910714_g191749_i0	PRJNA900028	192498	161	0.910714	1.46624954	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	108	2.81e-19	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g191749	i0	83.333	22.5217391304348	120	16	73	3	40	157	4033149	4033032	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3626	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22552950	22552950	PRJNA900028_P_NODE_89158_length_181_cov_1.159091_g88409_i0	PRJNA900028	89158	181	1.159091	2.09795471	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	58.4	3.3e-4	NTclustered	gi\|2621703971\|emb\|OY762926.1\|	2026742	g88409	i0	97.059	0.497237569060773	34	1	19	0	40	73	503986	503953	MAG: Gemmatimonadota bacterium isolate 6e3ee631-f785-49ea-85f7-2f24cfa146af genome assembly, chromosome: 1	blastn	90	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;