metadata: contig_metadata: 14 rows where bioproject = "PRJNA408129" and tax

14 rows where bioproject = "PRJNA408129" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
418381	418381	PRJNA408129_S_NODE_21041_length_176_cov_2.287770_g21023_i0	PRJNA408129	21041	176	2.28777	4.0264752	archaeon	1906665	Archaea	Archaea	61.2	1.03e-9	NR	RYG67142.1	1906665	g21023	i0	80	2.28409090909091	35	7	59.7	0	2	106	140	174	RYG67142.1 MAG: hypothetical protein EON64_08125, partial [archaeon]	diamond	402	61.2	1	Archaea								archaeon
1693401	1693401	PRJNA408129_S_NODE_8842_length_229_cov_10.020833_g8824_i0	PRJNA408129	8842	229	10.020833	22.94770757	Methanosarcina barkeri	2208	Archaea	Archaea	54.7	0.006	NTclustered	gi\|805384997\|gb\|CP009517.1\|	1434107	g8824	i0	96.97	0.14410480349345	33	0	14	1	178	209	2441374	2441342	Methanosarcina barkeri 3, complete genome	blastn	33	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
26663720	26663720	PRJNA408129_S_NODE_20221_length_178_cov_3.439716_g20203_i0	PRJNA408129	20221	178	3.439716	6.12269448	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	71.2	1.1e-13	NR	MDW0290255.1	2169593	g20203	i0	64	0.842696629213483	50	18	84.3	0	152	3	30	79	MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	150	71.2	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27012200	27012200	PRJNA408129_S_NODE_28082_length_161_cov_3.556452_g28064_i0	PRJNA408129	28082	161	3.556452	5.72588772	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	98.6	1.05e-22	NR	HEY6588048.1	2169593	g28064	i0	100	3.27950310559006	44	0	82	0	29	160	133	176	HEY6588048.1 tRNA (N(6)-L-threonylcarbamoyladenosine(37)-C(2))-methylthiotransferase [Nitrososphaeraceae archaeon]	diamond	528	98.6	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27517929	27517929	PRJNA408129_S_NODE_11663_length_212_cov_1.857143_g11645_i0	PRJNA408129	11663	212	1.857143	3.93714316	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	43.1	0.0107	NR	MDW0290255.1	2169593	g11645	i0	47.5	0.566037735849057	40	20	56.6	1	66	185	101	139	MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	120	43.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27580981	27580981	PRJNA408129_S_NODE_7524_length_240_cov_2.014778_g7506_i0	PRJNA408129	7524	240	2.014778	4.8354672	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	51.6	9.34e-6	NR	MDW0290255.1	2169593	g7506	i0	43.5	0.775	62	35	77.5	0	6	191	98	159	MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	186	51.6	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27612769	27612769	PRJNA408129_S_NODE_31404_length_156_cov_1.983193_g31386_i0	PRJNA408129	31404	156	1.983193	3.09378108	halophilic archaeon J	29295	Archaea	Archaea	77	1.42e-15	NR	ERH12629.1	1085029	g31386	i0	88.1	0.807692307692308	42	5	80.8	0	3	128	175	216	ERH12629.1 MAG: K+ transport system, NAD-binding component [halophilic archaeon J07HB67]	diamond	126	77	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			halophilic archaeon J07HB67
28166097	28166097	PRJNA408129_S_NODE_24825_length_167_cov_3.584615_g24807_i0	PRJNA408129	24825	167	3.584615	5.98630705	Nitrososphaeria	1643678	Archaea	Archaea	105	1.16e-24	NR	RPJ30093.1	2026768	g24807	i0	96.1	1.83233532934132	51	2	91.6	0	14	166	397	447	RPJ30093.1 MAG: lysine--tRNA ligase [Nitrosopumilales archaeon]	diamond	306	106	0.990566037735849	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
28559982	28559982	PRJNA408129_S_NODE_9567_length_224_cov_5.080214_g9549_i0	PRJNA408129	9567	224	5.080214	11.37967936	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	50.1	5.17e-5	NR	MDW0290256.1	2169593	g9549	i0	55.6	0.602678571428571	45	20	60.3	0	163	29	131	175	MDW0290256.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	135	50.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28906926	28906926	PRJNA408129_S_NODE_10468_length_219_cov_1.241758_g10450_i0	PRJNA408129	10468	219	1.241758	2.71945002	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	58.9	1.14e-8	NR	MDW0290255.1	2169593	g10450	i0	75.8	0.452054794520548	33	8	45.2	0	112	14	12	44	MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	99	58.9	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29159967	29159967	PRJNA408129_S_NODE_13269_length_203_cov_3.746988_g13251_i0	PRJNA408129	13269	203	3.746988	7.60638564	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	93.6	2.91e-22	NR	HJS64018.1	2169593	g13251	i0	85.4	0.70935960591133	48	7	70.9	0	154	11	1	48	HJS64018.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	144	93.6	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29159974	29159974	PRJNA408129_S_NODE_24849_length_167_cov_3.300000_g24831_i0	PRJNA408129	24849	167	3.3	5.511	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	45.1	0.00113	NR	MDW0290255.1	2169593	g24831	i0	56.8	0.664670658682635	37	16	66.5	0	40	150	67	103	MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	111	45.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29696108	29696108	PRJNA408129_S_NODE_10950_length_216_cov_2.128492_g10932_i0	PRJNA408129	10950	216	2.128492	4.59754272	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	124	3.859999999999999e-31	NR	MDR4512716.1	2169593	g10932	i0	81.9	1	72	13	100	0	1	216	779	850	MDR4512716.1 type I restriction endonuclease subunit R [Nitrososphaeraceae archaeon]	diamond	216	124	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32793434	32793434	PRJNA408129_S_NODE_32880_length_154_cov_2.025641_g32862_i0	PRJNA408129	32880	154	2.025641	3.11948714	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	42.4	0.0132	NR	MDW0290256.1	2169593	g32862	i0	73.1	0.506493506493506	26	7	50.6	0	75	152	77	102	MDW0290256.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	78	42.4	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon

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