metadata: contig_metadata: 29 rows where bioproject = "PRJNA704949" and tax

29 rows where bioproject = "PRJNA704949" 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
1186554	1186554	PRJNA704949_P_NODE_1445281_length_206_cov_1.222930_g1429943_i0	PRJNA704949	1445281	206	1.22293	2.5192358	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	119	5.58e-30	NR	HEX8550723.1	2800791	g1429943	i0	87.3	5.50485436893204	63	8	91.7	0	1	189	2	64	HEX8550723.1 adenylosuccinate synthase [Abditibacteriaceae bacterium]	diamond	1134	119	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
5792876	5792876	PRJNA704949_P_NODE_1418465_length_208_cov_1.962264_g1403127_i0	PRJNA704949	1418465	208	1.962264	4.08150912	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	185	1.72e-42	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g1403127	i0	86.047	1.73076923076923	172	24	83	0	37	208	2433043	2432872	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	360	185	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14725676	14725676	PRJNA704949_P_NODE_334912_length_467_cov_1.882775_g319976_i0	PRJNA704949	334912	467	1.882775	8.79255925	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	532	1.33e-146	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g319976	i0	88.377	156.21199143469	456	35	96	15	2	447	2852587	2852140	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	72951	532	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
18552907	18552907	PRJNA704949_P_NODE_833555_length_291_cov_1.169421_g818221_i0	PRJNA704949	833555	291	1.169421	3.40301511	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g818221	i0	100	0.0962199312714777	28	0	10	0	233	260	4632966	4632993	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26893503	26893503	PRJNA704949_P_NODE_1723441_length_183_cov_1.552239_g1708102_i0	PRJNA704949	1723441	183	1.552239	2.84059737	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	69.7	3.78e-13	NR	HEY0074165.1	2800791	g1708102	i0	68.5	0.885245901639344	54	17	88.5	0	20	181	94	147	HEY0074165.1 DinB family protein [Abditibacteriaceae bacterium]	diamond	162	69.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
26925210	26925210	PRJNA704949_P_NODE_567662_length_361_cov_1.413462_g552350_i0	PRJNA704949	567662	361	1.413462	5.10259782	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	82.4	1.75e-15	NR	BCM89528.1	2783868	g552350	i0	50.7	1.27146814404432	75	37	62.3	0	1	225	59	133	BCM89528.1 trifunctional NAD biosynthesis/regulator protein NadR [Abditibacteriota bacterium]	diamond	459	82.4	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
26988083	26988083	PRJNA704949_P_NODE_1966482_length_168_cov_0.873950_g1951143_i0	PRJNA704949	1966482	168	0.87395	1.468236	Abditibacterium sp.	2109264	Bacteria	Bacteria	55.1	6.19e-7	NR	HEX9996106.1	2109264	g1951143	i0	51.1	0.803571428571429	45	22	80.4	0	156	22	330	374	HEX9996106.1 response regulator [Abditibacterium sp.]	diamond	135	55.1	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
27146193	27146193	PRJNA704949_P_NODE_791022_length_300_cov_1.486056_g775690_i0	PRJNA704949	791022	300	1.486056	4.458168	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	52.8	2.19e-5	NR	BCM92932.1	2783868	g775690	i0	56.3	0.48	48	19	47	2	140	280	1	47	BCM92932.1 hypothetical protein IAD21_04816 [Abditibacteriota bacterium]	diamond	144	52.8	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
27335853	27335853	PRJNA704949_P_NODE_110003_length_753_cov_2.437500_g97334_i0	PRJNA704949	110003	753	2.4375	18.354375	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	92	2.25e-19	NR	MDF2440786.1	2783868	g97334	i0	54.4	0.314741035856574	79	36	31.5	0	517	753	1	79	MDF2440786.1 two-component system, chemotaxis family, chemotaxis protein CheY [Abditibacteriota bacterium]	diamond	237	92	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
27651917	27651917	PRJNA704949_P_NODE_1841764_length_174_cov_2.912000_g1826425_i0	PRJNA704949	1841764	174	2.912	5.06688	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	68.2	1.15e-11	NR	WP_105483331.1	1960156	g1826425	i0	68	2.58620689655172	50	16	86.2	0	25	174	190	239	WP_105483331.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Abditibacterium utsteinense]	diamond	450	68.2	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
27652130	27652130	PRJNA704949_P_NODE_468184_length_398_cov_1.868195_g452964_i0	PRJNA704949	468184	398	1.868195	7.4354161	Abditibacterium sp.	2109264	Bacteria	Bacteria	82.8	2.04e-15	NR	HEX9997674.1	2109264	g452964	i0	39.5	0.972361809045226	129	74	95	3	379	2	558	685	HEX9997674.1 S8 family serine peptidase [Abditibacterium sp.]	diamond	387	82.8	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
28188574	28188574	PRJNA704949_P_NODE_736526_length_313_cov_1.102273_g721197_i0	PRJNA704949	736526	313	1.102273	3.45011449	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	139	1.37e-37	NR	BCM92260.1	2783868	g721197	i0	63.1	0.987220447284345	103	38	98.7	0	311	3	184	286	BCM92260.1 hypothetical protein IAD21_04139 [Abditibacteriota bacterium]	diamond	309	139	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
28409364	28409364	PRJNA704949_P_NODE_1151506_length_238_cov_1.904762_g1136170_i0	PRJNA704949	1151506	238	1.904762	4.53333356	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	45.8	0.00167	NR	WP_105483608.1	1960156	g1136170	i0	45.7	0.441176470588235	35	17	44.1	1	1	105	144	176	WP_105483608.1 nuclear transport factor 2 family protein [Abditibacterium utsteinense]	diamond	105	45.8	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
29325237	29325237	PRJNA704949_P_NODE_256869_length_526_cov_1.962264_g242282_i0	PRJNA704949	256869	526	1.962264	10.32150864	Abditibacterium sp.	2109264	Bacteria	Bacteria	85.5	1.27e-16	NR	HEX9997954.1	2109264	g242282	i0	76.8	0.319391634980989	56	11	31.9	1	524	357	110	163	HEX9997954.1 SIMPL domain-containing protein [Abditibacterium sp.]	diamond	168	85.5	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
29798952	29798952	PRJNA704949_P_NODE_653551_length_334_cov_2.961404_g638225_i0	PRJNA704949	653551	334	2.961404	9.89108936	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	178	4.85e-52	NR	WP_202973548.1	1960156	g638225	i0	79	1.88622754491018	105	22	94.3	0	18	332	135	239	WP_202973548.1 pyridoxal phosphate-dependent aminotransferase [Abditibacterium utsteinense]	diamond	630	178	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
29988289	29988289	PRJNA704949_P_NODE_1493431_length_201_cov_2.203947_g1478093_i0	PRJNA704949	1493431	201	2.203947	4.42993347	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	132	8.49e-34	NR	WP_105482588.1	1960156	g1478093	i0	94	2	67	4	100	0	1	201	435	501	WP_105482588.1 vitamin B12-dependent ribonucleotide reductase [Abditibacterium utsteinense]	diamond	402	132	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
30177812	30177812	PRJNA704949_P_NODE_1760972_length_180_cov_1.786260_g1745633_i0	PRJNA704949	1760972	180	1.78626	3.215268	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	102	8.03e-25	NR	BCM90698.1	2783868	g1745633	i0	78	1.96666666666667	59	13	98.3	0	2	178	129	187	BCM90698.1 hypothetical protein IAD21_02558 [Abditibacteriota bacterium]	diamond	354	102	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
30178012	30178012	PRJNA704949_P_NODE_448332_length_407_cov_1.162011_g433138_i0	PRJNA704949	448332	407	1.162011	4.72938477	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	54.3	1.97e-5	NR	HEY0073631.1	2800791	g433138	i0	51.2	0.316953316953317	43	21	31.7	0	3	131	582	624	HEY0073631.1 FAD-dependent oxidoreductase [Abditibacteriaceae bacterium]	diamond	129	54.3	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30273027	30273027	PRJNA704949_P_NODE_1901932_length_170_cov_2.148760_g1886593_i0	PRJNA704949	1901932	170	2.14876	3.652892	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	43.9	0.00455	NR	BCM88540.1	2783868	g1886593	i0	76	0.441176470588235	25	6	44.1	0	3	77	187	211	BCM88540.1 hypothetical protein IAD21_00373 [Abditibacteriota bacterium]	diamond	75	43.9	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
30367697	30367697	PRJNA704949_P_NODE_1120432_length_242_cov_2.621762_g1105096_i0	PRJNA704949	1120432	242	2.621762	6.34466404	Abditibacterium sp.	2109264	Bacteria	Bacteria	108	2.5e-25	NR	HEX8464110.1	2109264	g1105096	i0	63.3	0.979338842975207	79	29	97.9	0	4	240	526	604	HEX8464110.1 ATP-dependent DNA helicase RecQ [Abditibacterium sp.]	diamond	237	108	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
30368011	30368011	PRJNA704949_P_NODE_2150032_length_162_cov_2.300885_g2134693_i0	PRJNA704949	2150032	162	2.300885	3.7274337	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	59.7	1.32e-8	NR	MEO6908681.1	2800791	g2134693	i0	65.9	0.814814814814815	44	15	81.5	0	132	1	163	206	MEO6908681.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	132	59.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30588570	30588570	PRJNA704949_P_NODE_1989533_length_167_cov_1.322034_g1974194_i0	PRJNA704949	1989533	167	1.322034	2.20779678	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	62	1.78e-9	NR	HEX8551934.1	2800791	g1974194	i0	82.9	0.62874251497006	35	6	62.9	0	58	162	1	35	HEX8551934.1 TIGR01777 family oxidoreductase [Abditibacteriaceae bacterium]	diamond	105	62	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
30599398	30599398	PRJNA704949_P_NODE_2195213_length_157_cov_2.407407_g2179874_i0	PRJNA704949	2195213	157	2.407407	3.77962899	Bacteria	2	Bacteria	Bacteria	64.7	2.01e-10	NR	WP_106380495.1	1960156	g2179874	i0	52.9	1.94904458598726	51	24	97.5	0	2	154	137	187	WP_106380495.1 AI-2E family transporter [Abditibacterium utsteinense]	diamond	306	64.7	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
30999220	30999220	PRJNA704949_P_NODE_114914_length_739_cov_3.092754_g102116_i0	PRJNA704949	114914	739	3.092754	22.85545206	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	80.5	1.47e-15	NR	BCM90438.1	2783868	g102116	i0	48.8	0.690121786197564	84	43	34.1	0	102	353	7	90	BCM90438.1 hypothetical protein IAD21_02291 [Abditibacteriota bacterium]	diamond	510	80.5	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
31347162	31347162	PRJNA704949_P_NODE_169756_length_628_cov_2.062176_g156024_i0	PRJNA704949	169756	628	2.062176	12.95046528	Abditibacterium sp.	2109264	Bacteria	Bacteria	177	2.4100000000000002e-49	NR	HEX9998805.1	2109264	g156024	i0	56.4	1.00796178343949	211	67	96	9	6	608	1	196	HEX9998805.1 hypothetical protein [Abditibacterium sp.]	diamond	633	177	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium sp.
31600565	31600565	PRJNA704949_P_NODE_727836_length_315_cov_1.353383_g712507_i0	PRJNA704949	727836	315	1.353383	4.26315645	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	93.6	1.22e-19	NR	MBV9866972.1	2800791	g712507	i0	42.7	0.914285714285714	96	55	91.4	0	307	20	298	393	MBV9866972.1 polysaccharide lyase 8 family protein [Abditibacteriaceae bacterium]	diamond	288	93.6	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
32106423	32106423	PRJNA704949_P_NODE_347578_length_459_cov_1.987805_g332606_i0	PRJNA704949	347578	459	1.987805	9.12402495	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	164	2.37e-47	NR	HEY0073700.1	2800791	g332606	i0	75.2	0.660130718954248	101	25	66	0	322	20	3	103	HEY0073700.1 phytanoyl-CoA dioxygenase family protein [Abditibacteriaceae bacterium]	diamond	303	164	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
32674934	32674934	PRJNA704949_P_NODE_124620_length_715_cov_1.533033_g111609_i0	PRJNA704949	124620	715	1.533033	10.96118595	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	98.2	5.5e-21	NR	HEX8236968.1	2800791	g111609	i0	35.9	0.876923076923077	209	116	83.9	7	689	90	19	218	HEX8236968.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	627	98.2	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae		Abditibacteriaceae bacterium
32675222	32675222	PRJNA704949_P_NODE_214780_length_568_cov_2.531792_g200505_i0	PRJNA704949	214780	568	2.531792	14.38057856	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	225	4.21e-69	NR	HVF10079.1	2800791	g200505	i0	60.1	3.95598591549296	188	74	98.8	1	3	563	134	321	HVF10079.1 phosphate acyltransferase PlsX [Abditibacteriaceae bacterium]	diamond	2247	225	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);;