metadata: contig_metadata: 16 rows where bioproject = "PRJNA983848" and tax

16 rows where bioproject = "PRJNA983848" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4794359	4794359	PRJNA983848_P_NODE_107224_length_291_cov_1.431193_g101341_i0	PRJNA983848	107224	291	1.431193	4.16477163	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g101341	i0	100	1	291	0	100	0	1	291	281362	281072	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	291	538	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
4795682	4795682	PRJNA983848_P_NODE_145484_length_249_cov_0.886364_g139601_i0	PRJNA983848	145484	249	0.886364	2.20704636	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g139601	i0	92	6.79919678714859	250	19	100	1	1	249	217867	217618	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	1693	350	1	Bacteria	Bacteria candidate phyla						Candidatus Dependentiae bacterium Noda2021
8624031	8624031	PRJNA983848_P_NODE_87767_length_327_cov_1.842520_g81884_i0	PRJNA983848	87767	327	1.84252	6.0250404	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	599	8.759999999999997e-167	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g81884	i0	99.694	98.6788990825688	327	1	100	0	1	327	503849	503523	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	32268	599	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
11172867	11172867	PRJNA983848_P_NODE_46529_length_522_cov_9.581292_g40659_i0	PRJNA983848	46529	522	9.581292	50.01434424	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	965	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g40659	i0	100	92.0478927203065	522	0	100	0	1	522	973291	972770	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	48049	965	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
13721412	13721412	PRJNA983848_P_NODE_148671_length_247_cov_1.793103_g142788_i0	PRJNA983848	148671	247	1.793103	4.42896441	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g142788	i0	100	1	247	0	100	0	1	247	1092831	1092585	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	247	457	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
14998490	14998490	PRJNA983848_P_NODE_74432_length_362_cov_9.636678_g68549_i0	PRJNA983848	74432	362	9.636678	34.88477436	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	289	2.3999999999999994e-73	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g68549	i0	82.051	6.41988950276243	351	51	95	9	1	345	126120	125776	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	2324	289	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18818284	18818284	PRJNA983848_P_NODE_113055_length_282_cov_3.913876_g107172_i0	PRJNA983848	113055	282	3.913876	11.03713032	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	387	6.279999999999998e-103	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g107172	i0	91.489	7.13829787234043	282	23	99	1	1	281	1250912	1250631	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	2013	387	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
20097519	20097519	PRJNA983848_P_NODE_88596_length_325_cov_2.261905_g82713_i0	PRJNA983848	88596	325	2.261905	7.35119125	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	479	1.1799999999999993e-130	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g82713	i0	93.231	899.304615384615	325	22	100	0	1	325	1251283	1250959	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	292274	479	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
25196685	25196685	PRJNA983848_P_NODE_73380_length_366_cov_1.819113_g67497_i0	PRJNA983848	73380	366	1.819113	6.65795358	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	597	3.559999999999998e-166	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g67497	i0	96.175	265.825136612022	366	13	99	1	1	365	502254	501889	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	97292	597	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
27595186	27595186	PRJNA983848_P_NODE_139664_length_252_cov_0.871508_g133781_i0	PRJNA983848	139664	252	0.871508	2.19620016	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42	0.0495	NR	HYF96458.1	2052139	g133781	i0	34.5	0.654761904761905	55	32	60.7	1	53	205	95	149	HYF96458.1 deaminase [Patescibacteria group bacterium]	diamond	165	42	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27759234	27759234	PRJNA983848_P_NODE_137484_length_253_cov_1.611111_g131601_i0	PRJNA983848	137484	253	1.611111	4.07611083	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0371	NR	HYA96478.1	2072417	g131601	i0	47.5	2.37154150197628	40	20	46.2	1	251	135	121	160	HYA96478.1 DUF177 domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	600	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
29710155	29710155	PRJNA983848_P_NODE_139810_length_252_cov_0.871508_g133927_i0	PRJNA983848	139810	252	0.871508	2.19620016	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	77	3.46e-14	NR	HEY6019682.1	2053589	g133927	i0	46.8	0.916666666666667	77	41	91.7	0	251	21	311	387	HEY6019682.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	231	77	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29741831	29741831	PRJNA983848_P_NODE_146190_length_249_cov_0.886364_g140307_i0	PRJNA983848	146190	249	0.886364	2.20704636	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	51.6	2.9e-5	NR	HOW45102.1	2052149	g140307	i0	33.3	2.08433734939759	87	44	88	3	21	239	246	332	HOW45102.1 Do family serine endopeptidase [Candidatus Aminicenantes bacterium]	diamond	519	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
29963229	29963229	PRJNA983848_P_NODE_137991_length_253_cov_0.866667_g132108_i0	PRJNA983848	137991	253	0.866667	2.19266751	bacterium (Candidatus Gribaldobacteria) CG_4_1	2798521	Bacteria	Bacteria	47.4	8.58e-4	NR	PIZ01041.1	2014266	g132108	i0	50	1.04347826086957	44	22	52.2	0	239	108	98	141	PIZ01041.1 MAG: 30S ribosomal protein S1 [bacterium (Candidatus Gribaldobacteria) CG_4_10_14_0_8_um_filter_33_9]	diamond	264	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Gribaldobacteria					bacterium (Candidatus Gribaldobacteria) CG_4_10_14_0_8_um_filter_33_9
30089454	30089454	PRJNA983848_P_NODE_140132_length_252_cov_0.871508_g134249_i0	PRJNA983848	140132	252	0.871508	2.19620016	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	61.6	8.87e-9	NR	MEA3357601.1	2052139	g134249	i0	59.6	0.55952380952381	47	19	56	0	218	78	252	298	MEA3357601.1 hypothetical protein [Patescibacteria group bacterium]	diamond	141	61.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30784644	30784644	PRJNA983848_P_NODE_144634_length_249_cov_2.215909_g138751_i0	PRJNA983848	144634	249	2.215909	5.51761341	candidate division WWE3 bacterium CSP1-7	1576480	Bacteria	Bacteria	48.9	1.92e-5	NR	KRT67739.1	1576480	g138751	i0	52.3	1.02409638554217	44	21	53	0	62	193	15	58	KRT67739.1 MAG: Uncharacterized protein XU08_C0001G0148 [candidate division WWE3 bacterium CSP1-7]	diamond	255	48.9	1	Bacteria	Bacteria candidate phyla	candidate division WWE3					candidate division WWE3 bacterium CSP1-7

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