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

14 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Kiritimatiellota"

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
1401547	1401547	PRJEB64798_P_NODE_145842_length_190_cov_8.212766_g144076_i0	PRJEB64798	145842	190	8.212766	15.6042554	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	122	1.2299999999999997e-23	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g144076	i0	81.699	2.42105263157895	153	23	80	4	5	156	417754	417902	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	460	122	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
1404000	1404000	PRJEB64798_P_NODE_69582_length_232_cov_3.710383_g67817_i0	PRJEB64798	69582	232	3.710383	8.60808856	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	272	1.46e-68	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g67817	i0	91.795	88.1853448275862	195	16	84	0	37	231	321387	321581	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	20459	272	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
1404459	1404459	PRJEB64798_P_NODE_9842_length_636_cov_410.398637_g8363_i0	PRJEB64798	9842	636	410.398637	2610.13533132	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	335	5.6e-87	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g8363	i0	80.128	392.764150943396	468	78	72	14	1	458	417418	416956	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	249798	335	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
2677728	2677728	PRJEB64798_P_NODE_182283_length_173_cov_5.830645_g180517_i0	PRJEB64798	182283	173	5.830645	10.08701585	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g180517	i0	98.204	364.601156069364	167	3	97	0	1	167	318894	319060	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	63076	292	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
5230381	5230381	PRJEB64798_P_NODE_1945_length_1288_cov_153.979822_g1059_i2	PRJEB64798	1945	1288	153.979822	1983.26010736	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	1057	0	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g1059	i2	82.278	372.204968944099	1264	185	96	38	1	1239	417075	418324	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	479400	1057	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
11604932	11604932	PRJEB64798_P_NODE_10990_length_603_cov_201.308664_g9459_i0	PRJEB64798	10990	603	201.308664	1213.89124392	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	523	1.0499999999999996e-143	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g9459	i0	83.08	749.733001658375	591	84	96	15	1	581	588701	588117	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	452089	523	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
11605076	11605076	PRJEB64798_P_NODE_11850_length_581_cov_445.552632_g10268_i0	PRJEB64798	11850	581	445.552632	2588.66079192	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	326	3.06e-84	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g10268	i0	79.461	423.595524956971	482	81	86	16	110	581	416945	417418	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	246109	326	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
12880682	12880682	PRJEB64798_P_NODE_1471_length_1457_cov_137.524148_g1059_i0	PRJEB64798	1471	1457	137.524148	2003.72683636	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	1110	0	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g1059	i0	81.351	326.916952642416	1421	216	95	47	1	1390	417075	418477	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	476318	1110	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
14156878	14156878	PRJEB64798_P_NODE_244512_length_153_cov_12.192308_g242746_i0	PRJEB64798	244512	153	12.192308	18.65423124	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	135	1.2099999999999999e-27	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g242746	i0	83.333	2.9281045751634	150	21	95	4	2	147	588587	588438	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	448	135	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
16705239	16705239	PRJEB64798_P_NODE_248434_length_152_cov_5.475728_g246668_i0	PRJEB64798	248434	152	5.475728	8.32310656	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	226	6.919999999999997e-55	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g246668	i0	95.139	201.381578947368	144	5	93	2	5	146	318793	318936	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	30610	226	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
16706297	16706297	PRJEB64798_P_NODE_7854_length_704_cov_365.117557_g6494_i0	PRJEB64798	7854	704	365.117557	2570.42760128	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	335	6.239999999999999e-87	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g6494	i0	83.607	351.677556818182	366	50	51	10	1	359	417418	417056	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	247581	335	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
19253925	19253925	PRJEB64798_P_NODE_234076_length_157_cov_4.472222_g232310_i0	PRJEB64798	234076	157	4.472222	7.02138854	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	117	4.53e-22	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g232310	i0	82.963	8.99363057324841	135	17	84	6	19	150	587863	587994	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	1412	117	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
23078698	23078698	PRJEB64798_P_NODE_123699_length_203_cov_6.961039_g121933_i0	PRJEB64798	123699	203	6.961039	14.13090917	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	300	5.72e-77	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g121933	i0	94	51.0591133004926	200	8	98	4	6	203	321126	320929	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	10365	300	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
24355003	24355003	PRJEB64798_P_NODE_5560_length_825_cov_160.712629_g4453_i0	PRJEB64798	5560	825	160.712629	1325.87918925	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	723	0	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g4453	i0	82.775	341.294545454545	836	119	99	24	5	825	417900	417075	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	281568	723	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222

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