metadata: contig_metadata: 26 rows where bioproject = "PRJNA640143" and tax

26 rows where bioproject = "PRJNA640143" and tax_phylum = "Abditibacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3160757	3160757	PRJNA640143_S_NODE_18663_length_203_cov_1.722892_g18453_i0	PRJNA640143	18663	203	1.722892	3.49747076	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	211	2.76e-50	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g18453	i0	87.778	180.576354679803	180	22	89	0	22	201	2853037	2852858	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	36657	211	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4437390	4437390	PRJNA640143_S_NODE_13084_length_240_cov_2.113300_g12874_i0	PRJNA640143	13084	240	2.1133	5.07192	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	231	2.58e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12874	i0	84.914	0.966666666666667	232	31	96	3	1	230	6363892	6363663	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	232	231	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4437633	4437633	PRJNA640143_S_NODE_22764_length_184_cov_76.551020_g22554_i0	PRJNA640143	22764	184	76.55102	140.8538768	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	154	4.18e-33	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g22554	i0	85.714	73.2282608695652	147	19	80	2	37	183	2851182	2851326	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	13474	154	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14639051	14639051	PRJNA640143_S_NODE_4592_length_382_cov_1.808696_g4385_i0	PRJNA640143	4592	382	1.808696	6.90921872	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	130	1.64e-25	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4385	i0	80.682	28.7670157068063	176	27	45	5	179	351	2851016	2851187	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	10989	130	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
15913038	15913038	PRJNA640143_S_NODE_4433_length_388_cov_3.658120_g4229_i0	PRJNA640143	4433	388	3.65812	14.1935056	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	457	6.719999999999999e-124	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4229	i0	94.881	230.855670103093	293	14	76	1	34	326	2853304	2853595	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	89572	457	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
17188067	17188067	PRJNA640143_S_NODE_3614_length_423_cov_13.129534_g3416_i0	PRJNA640143	3614	423	13.129534	55.53792882	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	243	2.25e-59	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3416	i0	82.624	507.550827423168	282	42	66	6	108	387	2850969	2850693	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	214694	243	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
17188174	17188174	PRJNA640143_S_NODE_7434_length_309_cov_3.415441_g7224_i0	PRJNA640143	7434	309	3.415441	10.55371269	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	396	1.16e-105	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g7224	i0	92.419	77.4498381877023	277	21	90	0	33	309	2850693	2850969	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	23932	396	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
19736866	19736866	PRJNA640143_S_NODE_3316_length_438_cov_150.698254_g3120_i0	PRJNA640143	3316	438	150.698254	660.05835252	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	254	1.08e-62	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3120	i0	83.824	288.351598173516	272	38	61	6	1	269	2850962	2850694	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	126298	254	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
19736976	19736976	PRJNA640143_S_NODE_696_length_802_cov_5.325490_g629_i0	PRJNA640143	696	802	5.32549	42.7104298	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	802	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g629	i0	89.144	209.711970074813	654	57	80	9	1	643	2852013	2851363	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	168189	802	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
23562738	23562738	PRJNA640143_S_NODE_3499_length_429_cov_3.168367_g3302_i0	PRJNA640143	3499	429	3.168367	13.59229443	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	350	1.31e-91	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3302	i0	81.693	550.519813519814	437	64	100	12	1	429	2851830	2852258	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	236173	350	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26764476	26764476	PRJNA640143_S_NODE_31881_length_153_cov_0.939655_g31671_i0	PRJNA640143	31881	153	0.939655	1.43767215	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	67.4	1.69e-11	NR	HEX8237986.1	2800791	g31671	i0	64.6	0.941176470588235	48	17	94.1	0	3	146	57	104	HEX8237986.1 WYL domain-containing protein [Abditibacteriaceae bacterium]	diamond	144	67.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
27143808	27143808	PRJNA640143_S_NODE_19482_length_199_cov_1.185185_g19272_i0	PRJNA640143	19482	199	1.185185	2.35851815	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	134	1.15e-35	NR	WP_105483003.1	1960156	g19272	i0	86.4	0.994974874371859	66	9	99.5	0	198	1	126	191	WP_105483003.1 hypothetical protein [Abditibacterium utsteinense]	diamond	198	134	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
27428918	27428918	PRJNA640143_S_NODE_30063_length_158_cov_1.611570_g29853_i0	PRJNA640143	30063	158	1.61157	2.5462806	Abditibacterium sp.	2109264	Bacteria	Bacteria	89.4	8.85e-21	NR	HEX9995928.1	2109264	g29853	i0	89.4	0.892405063291139	47	5	89.2	0	146	6	14	60	HEX9995928.1 AtpZ/AtpI family protein [Abditibacterium sp.]	diamond	141	89.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
28091674	28091674	PRJNA640143_S_NODE_29585_length_160_cov_0.951220_g29375_i0	PRJNA640143	29585	160	0.95122	1.521952	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	89.7	1.47e-19	NR	BCM93668.1	2783868	g29375	i0	84.6	2.94375	52	8	97.5	0	159	4	55	106	BCM93668.1 ribose operon repressor [Abditibacteriota bacterium]	diamond	471	89.7	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
28155075	28155075	PRJNA640143_S_NODE_9285_length_281_cov_1.680328_g9075_i0	PRJNA640143	9285	281	1.680328	4.72172168	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	54.3	1.76e-6	NR	WP_105483738.1	1960156	g9075	i0	100	0.288256227758007	27	0	28.8	0	281	201	150	176	WP_105483738.1 50S ribosomal protein L10 [Abditibacterium utsteinense]	diamond	81	54.3	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
28217738	28217738	PRJNA640143_S_NODE_13986_length_233_cov_1.392857_g13776_i0	PRJNA640143	13986	233	1.392857	3.24535681	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	129	2.5399999999999997e-35	NR	WP_105483776.1	1960156	g13776	i0	85.3	0.965665236051502	75	11	96.6	0	233	9	118	192	WP_105483776.1 fructose-6-phosphate aldolase [Abditibacterium utsteinense]	diamond	225	129	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
28880955	28880955	PRJNA640143_S_NODE_29188_length_161_cov_1.508065_g28978_i0	PRJNA640143	29188	161	1.508065	2.42798465	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	59.3	2.23e-9	NR	MBV9470937.1	2800791	g28978	i0	88.5	0.484472049689441	26	3	48.4	0	2	79	108	133	MBV9470937.1 YjbQ family protein [Abditibacteriaceae bacterium]	diamond	78	59.3	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
29259742	29259742	PRJNA640143_S_NODE_27829_length_166_cov_0.906977_g27619_i0	PRJNA640143	27829	166	0.906977	1.50558182	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	77	9.39e-15	NR	WP_202973524.1	1960156	g27619	i0	86.8	0.686746987951807	38	5	68.7	0	141	28	369	406	WP_202973524.1 spore photoproduct lyase family protein [Abditibacterium utsteinense]	diamond	114	77	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
29701621	29701621	PRJNA640143_S_NODE_27310_length_168_cov_1.190840_g27100_i0	PRJNA640143	27310	168	1.19084	2.0006112	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	92	4.78e-21	NR	MDF2439275.1	2783868	g27100	i0	75.9	0.964285714285714	54	13	96.4	0	164	3	180	233	MDF2439275.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol [Abditibacteriota bacterium]	diamond	162	92	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
29796571	29796571	PRJNA640143_S_NODE_32211_length_152_cov_1.017391_g32001_i0	PRJNA640143	32211	152	1.017391	1.54643432	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	80.5	1.68e-16	NR	HEX8552559.1	2800791	g32001	i0	82	1.97368421052632	50	9	98.7	0	3	152	119	168	HEX8552559.1 bifunctional DNA-formamidopyrimidine glycosylase/DNA-(apurinic or apyrimidinic site) lyase [Abditibacteriaceae bacterium]	diamond	300	80.5	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30649490	30649490	PRJNA640143_S_NODE_29433_length_160_cov_1.626016_g29223_i0	PRJNA640143	29433	160	1.626016	2.6016256	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	53.1	2.21e-6	NR	WP_157947675.1	1960156	g29223	i0	57.1	1.575	42	17	78.8	1	158	33	131	171	WP_157947675.1 hypothetical protein [Abditibacterium utsteinense]	diamond	252	53.1	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
31029107	31029107	PRJNA640143_S_NODE_26255_length_172_cov_1.474074_g26045_i0	PRJNA640143	26255	172	1.474074	2.53540728	Abditibacterium sp.	2109264	Bacteria	Bacteria	62	9.35e-10	NR	HEX8465309.1	2109264	g26045	i0	50	1.04651162790698	60	27	99.4	1	1	171	30	89	HEX8465309.1 hypothetical protein [Abditibacterium sp.]	diamond	180	62	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
31250014	31250014	PRJNA640143_S_NODE_15295_length_223_cov_1.913978_g15085_i0	PRJNA640143	15295	223	1.913978	4.26817094	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	107	5.01e-25	NR	HEX8551834.1	2800791	g15085	i0	86.9	0.820627802690583	61	8	82.1	0	222	40	286	346	HEX8551834.1 endopeptidase La [Abditibacteriaceae bacterium]	diamond	183	107	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
31439789	31439789	PRJNA640143_S_NODE_23236_length_183_cov_1.335616_g23026_i0	PRJNA640143	23236	183	1.335616	2.44417728	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	97.8	1.0499999999999999e-23	NR	MDF2439475.1	2783868	g23026	i0	78.3	1.9672131147541	60	13	98.4	0	3	182	106	165	MDF2439475.1 large subunit ribosomal protein [Abditibacteriota bacterium]	diamond	360	97.8	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
32420666	32420666	PRJNA640143_S_NODE_29159_length_161_cov_1.572581_g28949_i0	PRJNA640143	29159	161	1.572581	2.53185541	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	49.7	4.36e-5	NR	HEY0075897.1	2800791	g28949	i0	43.4	0.987577639751553	53	29	98.8	1	161	3	757	808	HEY0075897.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium]	diamond	159	49.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
32641445	32641445	PRJNA640143_S_NODE_31720_length_153_cov_1.551724_g31510_i0	PRJNA640143	31720	153	1.551724	2.37413772	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	87.4	2.01e-18	NR	HEX8551219.1	2800791	g31510	i0	88.2	1	51	6	100	0	153	1	581	631	HEX8551219.1 hybrid sensor histidine kinase/response regulator [Abditibacteriaceae bacterium]	diamond	153	87.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae 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);;