metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
2097035	2097035	PRJNA827593_P_NODE_56242_length_264_cov_1.581152_g55943_i0	PRJNA827593	56242	264	1.581152	4.17424128	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	219	2.2499999999999993e-52	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g55943	i0	81.923	3.45075757575758	260	45	98	2	1	259	19531	19273	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	911	219	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
7199518	7199518	PRJNA827593_P_NODE_47646_length_291_cov_1.330275_g47347_i0	PRJNA827593	47646	291	1.330275	3.87110025	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	302	2.42e-77	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g47347	i0	88.98	0.84192439862543	245	26	84	1	1	244	1579375	1579131	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	245	302	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
9749345	9749345	PRJNA827593_P_NODE_44508_length_302_cov_2.951965_g44209_i0	PRJNA827593	44508	302	2.951965	8.9149343	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	209	1.58e-49	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g44209	i0	81.181	0.897350993377483	271	41	87	7	6	268	3299966	3300234	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	271	209	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
12300182	12300182	PRJNA827593_P_NODE_24990_length_420_cov_1.331412_g24691_i0	PRJNA827593	24990	420	1.331412	5.5919304	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	248	4.7999999999999995e-61	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g24691	i0	77.83	1.00952380952381	424	79	98	9	1	413	770630	770211	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	424	248	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
17399114	17399114	PRJNA827593_P_NODE_15634_length_546_cov_2.704017_g15337_i0	PRJNA827593	15634	546	2.704017	14.76393282	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	523	9.469999999999999e-144	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g15337	i0	86.91	55.4047619047619	466	61	85	0	79	544	2031599	2032064	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	30251	523	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
17399671	17399671	PRJNA827593_P_NODE_45774_length_298_cov_1.208889_g45475_i0	PRJNA827593	45774	298	1.208889	3.60248922	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	302	2.49e-77	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g45475	i0	85.085	18.1979865771812	295	44	99	0	2	296	1226790	1226496	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	5423	302	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
17399942	17399942	PRJNA827593_P_NODE_61594_length_250_cov_1.740113_g61295_i0	PRJNA827593	61594	250	1.740113	4.3502825	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	237	5.82e-58	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g61295	i0	84.274	1.6	248	33	97	5	1	243	1701401	1701647	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	400	237	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
17399962	17399962	PRJNA827593_P_NODE_62854_length_248_cov_2.028571_g62555_i0	PRJNA827593	62854	248	2.028571	5.03085608	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	313	9.32e-81	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g62555	i0	89.474	73.0120967741936	247	26	99	0	1	247	3098495	3098249	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	18107	313	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
19947337	19947337	PRJNA827593_P_NODE_14596_length_568_cov_1.244444_g14301_i0	PRJNA827593	14596	568	1.244444	7.06844192	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	322	3.87e-83	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g14301	i0	81.141	3.55281690140845	403	74	71	2	1	402	1285355	1285756	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	2018	322	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
21223427	21223427	PRJNA827593_P_NODE_48257_length_289_cov_1.222222_g47958_i0	PRJNA827593	48257	289	1.222222	3.53222158	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	446	1.05e-120	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g47958	i0	94.464	69.1314878892734	289	16	100	0	1	289	1210621	1210333	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	19979	446	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
22498011	22498011	PRJNA827593_P_NODE_41898_length_313_cov_1.191667_g41599_i0	PRJNA827593	41898	313	1.191667	3.72991771	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	189	2.1399999999999993e-43	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g41599	i0	78.594	1	313	48	98	12	1	308	3165114	3164816	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	313	189	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
23773977	23773977	PRJNA827593_P_NODE_58819_length_257_cov_1.630435_g58520_i0	PRJNA827593	58819	257	1.630435	4.19021795	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	233	7.78e-57	NTclustered	gi\|2233025045\|gb\|CP096137.1\|	2030800	g58520	i0	83.936	1.84046692607004	249	35	96	4	10	257	1884521	1884765	MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome	blastn	473	233	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);;