metadata: contig_metadata: 11 rows where bioproject = "PRJNA492363" and tax

11 rows where bioproject = "PRJNA492363" and tax_phylum = "Elusimicrobiota"

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_species
25567016	25567016	PRJNA492363_S_NODE_82441_length_211_cov_1.706667_g81620_i0	PRJNA492363	82441	211	1.706667	3.60106737	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	268	1.6899999999999994e-67	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g81620	i0	89.623	1.94312796208531	212	21	100	1	1	211	2285322	2285111	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	410	268	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
25567085	25567085	PRJNA492363_S_NODE_86033_length_209_cov_1.195946_g85212_i0	PRJNA492363	86033	209	1.195946	2.49952714	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	241	3.6400000000000003e-59	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g85212	i0	88.038	1	209	17	98	7	1	205	3041881	3041677	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	209	241	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26111593	26111593	PRJNA492363_S_NODE_88045_length_208_cov_0.870748_g87224_i0	PRJNA492363	88045	208	0.870748	1.81115584	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	278	2.76e-70	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g87224	i0	91.626	0.975961538461538	203	14	98	3	6	208	2824721	2824522	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	203	278	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26247826	26247826	PRJNA492363_S_NODE_89646_length_207_cov_1.315068_g88825_i0	PRJNA492363	89646	207	1.315068	2.72219076	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	344	2.67e-90	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g88825	i0	96.618	96.5652173913043	207	7	100	0	1	207	632135	631929	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	19989	344	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26247884	26247884	PRJNA492363_S_NODE_91630_length_206_cov_0.882759_g90809_i0	PRJNA492363	91630	206	0.882759	1.81848354	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	130	8.09e-26	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g90809	i0	90.909	0.480582524271845	99	6	48	3	2	99	1419026	1419122	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	99	130	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26247940	26247940	PRJNA492363_S_NODE_93430_length_205_cov_0.888889_g92609_i0	PRJNA492363	93430	205	0.888889	1.82222245	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	291	3.48e-74	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g92609	i0	92.195	1	205	16	100	0	1	205	73078	73282	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	205	291	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26248039	26248039	PRJNA492363_S_NODE_97190_length_203_cov_0.901408_g96369_i0	PRJNA492363	97190	203	0.901408	1.82985824	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	292	9.58e-75	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g96369	i0	92.611	1	203	15	100	0	1	203	3420007	3420209	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	203	292	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
26518374	26518374	PRJNA492363_S_NODE_114200_length_191_cov_2.107692_g113379_i0	PRJNA492363	114200	191	2.107692	4.02569172	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	303	4.11e-78	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g113379	i0	95.745	1.33507853403141	188	8	98	0	1	188	2288213	2288026	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	255	303	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
32952647	32952647	PRJNA492363_S_NODE_93306_length_205_cov_0.888889_g92485_i0	PRJNA492363	93306	205	0.888889	1.82222245	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	119	2.25e-29	NR	MDP3541146.1	2030800	g92485	i0	91.2	2.98536585365854	68	6	99.5	0	2	205	537	604	MDP3541146.1 DUF87 domain-containing protein [Elusimicrobiota bacterium]	diamond	612	119	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
32969829	32969829	PRJNA492363_S_NODE_97106_length_203_cov_0.901408_g96285_i0	PRJNA492363	97106	203	0.901408	1.82985824	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	103	4.3500000000000006e-27	NR	MBI4387298.1	2030800	g96285	i0	76.6	2.86699507389163	64	15	94.6	0	202	11	10	73	MBI4387298.1 helix-turn-helix transcriptional regulator [Elusimicrobiota bacterium]	diamond	582	103	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
33071882	33071882	PRJNA492363_S_NODE_9381_length_313_cov_1.015873_g8560_i0	PRJNA492363	9381	313	1.015873	3.17968249	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	160	5.089999999999998e-43	NR	MCM2305374.1	2030800	g8560	i0	77.7	3.94888178913738	103	23	98.7	0	311	3	495	597	MCM2305374.1 acyltransferase domain-containing protein [Elusimicrobiota bacterium]	diamond	1236	160	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota 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);;