metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA773247" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
749167	749167	PRJNA773247_P_NODE_941_length_1972_cov_14.222749_g922_i0	PRJNA773247	941	1972	14.222749	280.47261028	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	503	4.68e-137	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g922	i0	76.271	33.3108519269777	1062	184	51	53	212	1224	2572046	2571004	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	65689	503	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2024939	2024939	PRJNA773247_P_NODE_34602_length_241_cov_4.279762_g34518_i0	PRJNA773247	34602	241	4.279762	10.31422642	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	97.1	9.88e-16	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g34518	i0	95.161	3.56016597510373	62	1	25	2	182	241	436789	436728	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	858	97.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
3299851	3299851	PRJNA773247_P_NODE_12143_length_439_cov_2.633880_g12060_i0	PRJNA773247	12143	439	2.63388	11.5627332	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	2.38e-49	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g12060	i0	80.208	17.4783599088838	288	49	65	8	1	284	5761202	5761485	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	7673	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3299968	3299968	PRJNA773247_P_NODE_19503_length_326_cov_2.569170_g19419_i0	PRJNA773247	19503	326	2.56917	8.3754942	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	178	4.85e-40	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g19419	i0	79.537	41.4846625766871	259	45	78	8	6	260	1854997	1855251	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	13524	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4576958	4576958	PRJNA773247_P_NODE_14424_length_394_cov_1.514019_g14340_i0	PRJNA773247	14424	394	1.514019	5.96523486	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	287	9.490000000000001e-73	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g14340	i0	80.992	0.921319796954315	363	67	92	2	30	391	813984	813623	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	363	287	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
6310980	6310980	PRJNA773247_P_NODE_11265_length_461_cov_10.247423_g11182_i0	PRJNA773247	11265	461	10.247423	47.24062003	FCB group	1783270	Bacteria	Bacteria	272	3.1599999999999992e-68	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11182	i0	78.588	55.9718004338395	425	81	91	8	25	444	4458755	4458336	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	25803	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7127722	7127722	PRJNA773247_P_NODE_34606_length_241_cov_4.053571_g34522_i0	PRJNA773247	34606	241	4.053571	9.76910611	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	189	1.58e-43	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g34522	i0	86.905	8.12033195020747	168	22	70	0	37	204	282221	282388	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1957	189	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
10953115	10953115	PRJNA773247_P_NODE_35469_length_236_cov_4.723926_g35385_i0	PRJNA773247	35469	236	4.723926	11.14846536	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	215	2.55e-51	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g35385	i0	84.545	0.932203389830508	220	30	92	4	18	235	4102851	4103068	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	220	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
13502423	13502423	PRJNA773247_P_NODE_14271_length_396_cov_3.854489_g14187_i0	PRJNA773247	14271	396	3.854489	15.263776439999999	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	215	4.5700000000000003e-51	NTclustered	gi\|2893356056\|emb\|OZ220479.1\|	2910168	g14187	i0	84.071	49.1439393939394	226	32	57	4	1	224	2920303	2920526	MAG: Longimicrobiales bacterium isolate ffc3e9c5-5d9e-49e8-9e51-7ae5a16491fe genome assembly, chromosome: 1	blastn	19461	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
13502610	13502610	PRJNA773247_P_NODE_25911_length_274_cov_3.532338_g25827_i0	PRJNA773247	25911	274	3.532338	9.67860612	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	346	1.03e-90	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g25827	i0	89.781	7.27372262773723	274	22	99	6	4	274	422236	421966	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	1993	346	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14777986	14777986	PRJNA773247_P_NODE_8892_length_537_cov_13.273707_g8809_i0	PRJNA773247	8892	537	13.273707	71.27980659	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	324	1.01e-83	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g8809	i0	77.716	1.01117318435754	543	111	99	8	3	537	2331583	2332123	Gemmatimonas phototrophica strain AP64, complete genome	blastn	543	324	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
19875671	19875671	PRJNA773247_P_NODE_30116_length_251_cov_2.089888_g30032_i0	PRJNA773247	30116	251	2.089888	5.24561888	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	202	2.13e-47	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g30032	i0	81.746	1.00398406374502	252	36	98	8	5	251	3713118	3712872	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	252	202	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
21151485	21151485	PRJNA773247_P_NODE_27517_length_265_cov_2.020833_g27433_i0	PRJNA773247	27517	265	2.020833	5.35520745	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2893356045\|emb\|OZ220468.1\|	2910168	g27433	i0	96.774	0.116981132075472	31	1	12	0	154	184	2204495	2204525	MAG: Longimicrobiales bacterium isolate ddfa3c06-a013-4680-9539-8883dc2ec397 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales 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);;