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

12 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_phylum = "Thermoplasmatota"

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_species
1706507	1706507	PRJNA437204_P_NODE_107682_length_245_cov_0.895349_g107383_i0	PRJNA437204	107682	245	0.895349	2.19360505	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	436	5.229999999999999e-118	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g107383	i0	98.776	1	245	3	100	0	1	245	528859	528615	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	245	436	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
5536535	5536535	PRJNA437204_P_NODE_53225_length_293_cov_4.559091_g52926_i0	PRJNA437204	53225	293	4.559091	13.35813663	Methanomassiliicoccales archaeon LGM-RCC1	3018355	Archaea	Archaea	387	6.56e-103	NTclustered	gi\|2514099340\|gb\|CP115555.1\|	3018355	g52926	i0	90.444	6.02389078498294	293	28	100	0	1	293	1399195	1399487	Methanomassiliicoccales archaeon LGM-RCC1 chromosome, complete genome	blastn	1765	387	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccales archaeon LGM-RCC1
5536834	5536834	PRJNA437204_P_NODE_69145_length_266_cov_1.585492_g68846_i0	PRJNA437204	69145	266	1.585492	4.21740872	Thermoplasmatales archaeon BRNA1	1054217	Archaea	Archaea	241	4.840000000000001e-59	NTclustered	gi\|472831278\|gb\|CP002916.1\|	1054217	g68846	i0	83.588	5.70676691729323	262	37	97	3	1	259	802300	802558	Thermoplasmatales archaeon BRNA1, complete genome	blastn	1518	241	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Thermoplasmatales	Thermoplasmatales archaeon BRNA1
6809416	6809416	PRJNA437204_P_NODE_112366_length_244_cov_0.900585_g112067_i0	PRJNA437204	112366	244	0.900585	2.1974274	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	418	1.8799999999999994e-112	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g112067	i0	97.541	3.63934426229508	244	6	100	0	1	244	1313768	1313525	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	888	418	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
6810578	6810578	PRJNA437204_P_NODE_53846_length_292_cov_1.406393_g53547_i0	PRJNA437204	53846	292	1.406393	4.10666756	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	540	4.74e-149	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g53547	i0	100	34.3869863013699	292	0	100	0	1	292	1531864	1531573	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	10041	540	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
8084997	8084997	PRJNA437204_P_NODE_114267_length_244_cov_0.900585_g113968_i0	PRJNA437204	114267	244	0.900585	2.1974274	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	446	8.639999999999999e-121	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g113968	i0	99.59	2.95901639344262	244	1	100	0	1	244	1910381	1910624	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	722	446	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
9361427	9361427	PRJNA437204_P_NODE_83028_length_251_cov_0.865169_g82729_i0	PRJNA437204	83028	251	0.865169	2.17157419	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	453	5.34e-123	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g82729	i0	99.597	0.98804780876494	248	1	99	0	1	248	238024	238271	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	248	453	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
13187193	13187193	PRJNA437204_P_NODE_89791_length_249_cov_0.875000_g89492_i0	PRJNA437204	89791	249	0.875	2.17875	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	420	5.36e-113	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g89492	i0	97.177	2.00401606425703	248	7	99	0	1	248	1435027	1435274	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	499	420	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
20833749	20833749	PRJNA437204_P_NODE_14217_length_468_cov_6.881013_g13918_i0	PRJNA437204	14217	468	6.881013	32.20314084	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	859	0	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g13918	i0	99.786	87.6923076923077	468	1	100	0	1	468	1742090	1741623	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	41040	859	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
20834535	20834535	PRJNA437204_P_NODE_55377_length_289_cov_1.425926_g55078_i0	PRJNA437204	55377	289	1.425926	4.12092614	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	534	2.18e-147	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g55078	i0	100	7.31141868512111	289	0	100	0	1	289	882529	882817	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	2113	534	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
22109614	22109614	PRJNA437204_P_NODE_63218_length_275_cov_2.737624_g62919_i0	PRJNA437204	63218	275	2.737624	7.528466	methanogenic archaeon ISO4-H5	1495144	Archaea	Archaea	503	5.809999999999998e-138	NTclustered	gi\|992543061\|gb\|CP014214.1\|	1495144	g62919	i0	99.636	7.56727272727273	275	1	100	0	1	275	1465332	1465606	Methanogenic archaeon ISO4-H5 chromosome, complete genome	blastn	2081	503	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata		methanogenic archaeon ISO4-H5
23383780	23383780	PRJNA437204_P_NODE_104679_length_246_cov_0.890173_g104380_i0	PRJNA437204	104679	246	0.890173	2.18982558	Methanomassiliicoccales archaeon LGM-RCC1	3018355	Archaea	Archaea	455	1.4500000000000002e-123	NTclustered	gi\|2514099340\|gb\|CP115555.1\|	3018355	g104380	i0	100	14.020325203252	246	0	100	0	1	246	143014	142769	Methanomassiliicoccales archaeon LGM-RCC1 chromosome, complete genome	blastn	3449	455	1	Archaea	Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccales archaeon LGM-RCC1

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