metadata: contig_metadata: 27 rows where bioproject = "PRJEB64798" and tax

27 rows where 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
26590194	26590194	PRJEB64798_P_NODE_129241_length_198_cov_10.355705_g127475_i0	PRJEB64798	129241	198	10.355705	20.5042959	Kiritimatiellota bacterium	2599938	Bacteria	Bacteria	57.4	1.38e-7	NR	MCX7007978.1	2599938	g127475	i0	61	1.24242424242424	41	16	62.1	0	75	197	219	259	MCX7007978.1 hypothetical protein [Kiritimatiellota bacterium]	diamond	246	57.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium
26938590	26938590	PRJEB64798_P_NODE_127542_length_199_cov_7.706667_g125776_i0	PRJEB64798	127542	199	7.706667	15.33626733	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	59.7	2.24e-8	NR	MFO1521312.1	2212473	g125776	i0	50	0.874371859296482	58	25	87.4	2	187	14	1502	1555	MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium]	diamond	174	59.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27065376	27065376	PRJEB64798_P_NODE_53162_length_268_cov_6.036530_g51397_i0	PRJEB64798	53162	268	6.03653	16.1779004	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	53.1	1.15e-5	NR	MFO1521312.1	2212473	g51397	i0	43.4	0.850746268656716	76	40	85.1	2	265	38	1504	1576	MFO1521312.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium]	diamond	228	53.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28455126	28455126	PRJEB64798_P_NODE_17426_length_477_cov_9.130841_g15716_i0	PRJEB64798	17426	477	9.130841	43.55411157	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	52.4	1.89e-4	NR	HNX35679.1	2212473	g15716	i0	38.5	0.654088050314465	104	61	63.5	3	6	308	778	881	HNX35679.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium]	diamond	312	52.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28581432	28581432	PRJEB64798_P_NODE_233247_length_157_cov_8.138889_g231481_i0	PRJEB64798	233247	157	8.138889	12.77805573	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	56.6	4.62e-8	NR	MFO1490854.1	2212473	g231481	i0	52	0.955414012738854	50	23	95.5	1	151	2	82	130	MFO1490854.1 FHA domain-containing protein [Kiritimatiellia bacterium]	diamond	150	56.6	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29591156	29591156	PRJEB64798_P_NODE_111750_length_210_cov_3.378882_g109984_i0	PRJEB64798	111750	210	3.378882	7.0956522	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	96.7	2.04e-22	NR	WFB36037.1	3040511	g109984	i0	67.1	1.04285714285714	73	19	97.1	1	6	209	64	136	WFB36037.1 hypothetical protein P3T73_17935 [Kiritimatiellota bacterium B12222]	diamond	219	96.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
29591236	29591236	PRJEB64798_P_NODE_186810_length_171_cov_11.286885_g185044_i0	PRJEB64798	186810	171	11.286885	19.30057335	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	45.4	0.00166	NR	HMP34919.1	2212473	g185044	i0	53.8	0.912280701754386	52	20	91.2	1	165	10	1733	1780	HMP34919.1 SdrD B-like domain-containing protein [Kiritimatiellia bacterium]	diamond	156	45.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29812567	29812567	PRJEB64798_P_NODE_236411_length_156_cov_6.542056_g234645_i0	PRJEB64798	236411	156	6.542056	10.20560736	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	46.2	6.75e-4	NR	MCZ7591066.1	2212473	g234645	i0	44	0.961538461538462	50	26	96.2	1	154	5	921	968	MCZ7591066.1 carboxypeptidase regulatory-like domain-containing protein [Kiritimatiellia bacterium]	diamond	150	46.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30697180	30697180	PRJEB64798_P_NODE_233234_length_157_cov_8.240741_g231468_i0	PRJEB64798	233234	157	8.240741	12.93796337	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	44.3	0.00337	NR	MDD2598033.1	2212473	g231468	i0	62.5	1.29936305732484	32	12	61.1	0	96	1	41	72	MDD2598033.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	204	44.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30918515	30918515	PRJEB64798_P_NODE_131074_length_198_cov_2.664430_g129308_i0	PRJEB64798	131074	198	2.66443	5.2755714	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	125	5.96e-33	NR	MDD4059940.1	2212473	g129308	i0	92.2	0.96969696969697	64	5	97	0	193	2	37	100	MDD4059940.1 type I glyceraldehyde-3-phosphate dehydrogenase [Kiritimatiellia bacterium]	diamond	192	125	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30981812	30981812	PRJEB64798_P_NODE_196274_length_168_cov_5.361345_g194508_i0	PRJEB64798	196274	168	5.361345	9.0070596	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	53.5	1.66e-7	NR	MFA7174774.1	2212473	g194508	i0	86.2	1.03571428571429	29	4	51.8	0	77	163	1	29	MFA7174774.1 VRR-NUC domain-containing protein [Kiritimatiellia bacterium]	diamond	174	53.5	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31139316	31139316	PRJEB64798_P_NODE_36135_length_328_cov_8.627240_g34376_i0	PRJEB64798	36135	328	8.62724	28.2973472	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	77.8	4.84e-14	NR	MFA7160265.1	2212473	g34376	i0	52.9	0.640243902439024	70	33	64	0	8	217	101	170	MFA7160265.1 tetratricopeptide repeat protein [Kiritimatiellia bacterium]	diamond	210	77.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32215071	32215071	PRJEB64798_P_NODE_126618_length_200_cov_4.701987_g124852_i0	PRJEB64798	126618	200	4.701987	9.403974	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	45.1	0.0028	NR	MFA5043656.1	2212473	g124852	i0	61.1	1.05	36	14	54	0	83	190	3	38	MFA5043656.1 phosphoadenylyl-sulfate reductase [Kiritimatiellia bacterium]	diamond	210	45.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia 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);;