metadata: contig_metadata: 12 rows where bioproject = "PRJNA358009" and tax

12 rows where bioproject = "PRJNA358009" 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
2948954	2948954	PRJNA358009_P_NODE_9183_length_187_cov_6.739130_g9114_i0	PRJNA358009	9183	187	6.73913	12.6021731	Thermoplasmata archaeon	1906666	Archaea	Archaea	91.6	3.39e-14	NTclustered	gi\|2108430933\|gb\|CP070629.1\|	1906666	g9114	i0	88.158	21.6256684491979	76	9	41	0	11	86	286871	286946	MAG: Thermoplasmata archaeon isolate bin983 chromosome	blastn	4044	91.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
15700786	15700786	PRJNA358009_P_NODE_1113_length_364_cov_2.244444_g1052_i0	PRJNA358009	1113	364	2.244444	8.16977616	uncultured Methanomethylovorans sp.	183759	Archaea	Archaea	243	1.91e-59	NTclustered	gi\|2814788356\|emb\|OY782867.2\|	183759	g1052	i0	99.254	81.7967032967033	134	1	62	0	4	137	340124	340257	MAG: uncultured Methanomethylovorans sp. isolate 1bea500b-d65c-4789-84bd-533d56c43360 genome assembly, chromosome: 1	blastn	29774	243	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	uncultured Methanomethylovorans sp.
16975542	16975542	PRJNA358009_P_NODE_10714_length_178_cov_2.844961_g10645_i0	PRJNA358009	10714	178	2.844961	5.06403058	uncultured Methanomethylovorans sp.	183759	Archaea	Archaea	313	6.259999999999999e-81	NTclustered	gi\|2814788356\|emb\|OY782867.2\|	183759	g10645	i0	99.419	227.921348314607	172	1	97	0	7	178	339821	339650	MAG: uncultured Methanomethylovorans sp. isolate 1bea500b-d65c-4789-84bd-533d56c43360 genome assembly, chromosome: 1	blastn	40570	313	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	uncultured Methanomethylovorans sp.
19524201	19524201	PRJNA358009_P_NODE_9696_length_184_cov_4.755556_g9627_i0	PRJNA358009	9696	184	4.755556	8.75022304	uncultured Methanomethylovorans sp.	183759	Archaea	Archaea	305	1.09e-78	NTclustered	gi\|2814788356\|emb\|OY782867.2\|	183759	g9627	i0	97.74	71.9891304347826	177	4	96	0	8	184	340789	340613	MAG: uncultured Methanomethylovorans sp. isolate 1bea500b-d65c-4789-84bd-533d56c43360 genome assembly, chromosome: 1	blastn	13246	305	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanomethylovorans	uncultured Methanomethylovorans sp.
20198997	20198997	PRJNA358009_P_NODE_1156_length_359_cov_3.132258_g1095_i0	PRJNA358009	1156	359	3.132258	11.24480622	root	1	Root_unresolved	Root_unresolved	385	2.95e-102	NTclustered	gi\|103488695\|gb\|DQ516748.1\|	2190	g1095	i0	100	2.55710306406685	208	0	58	0	1	208	483	276	Methanocaldococcus jannaschii spike-in control MJ-500-31 genomic sequence	blastn	918	385	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus jannaschii
25299220	25299220	PRJNA358009_P_NODE_4220_length_327_cov_2.215827_g4157_i0	PRJNA358009	4220	327	2.215827	7.24575429	Halobacterium	2239	Archaea	Archaea	185	2.91e-42	NTclustered	gi\|255976512\|emb\|FN435862.1\|	115547	g4157	i0	100	47.9296636085627	100	0	61	0	1	100	292	391	Uncultured archaeon partial 16S rRNA gene, clone 15	blastn	15673	185	1	Archaea								uncultured archaeon
26694891	26694891	PRJNA358009_P_NODE_4761_length_327_cov_2.000000_g4698_i0	PRJNA358009	4761	327	2	6.54	Halocalculus aciditolerans	1383812	Archaea	Archaea	64.3	2.57e-9	NR	WP_229774124.1	1383812	g4698	i0	90.6	0.293577981651376	32	3	29.4	0	325	230	534	565	WP_229774124.1 SIR2 family protein [Halocalculus aciditolerans]	diamond	96	64.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halocalculus	Halocalculus aciditolerans
27408273	27408273	PRJNA358009_P_NODE_11503_length_174_cov_1.224000_g11434_i0	PRJNA358009	11503	174	1.224	2.12976	root	1	Root_unresolved	Root_unresolved	115	3.51e-28	NR	WP_068576323.1	54262	g11434	i0	96.5	18.6724137931034	57	2	98.3	0	2	172	310	366	WP_068576323.1 DNA polymerase [Thermococcus chitonophagus]	diamond	3249	115	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus chitonophagus
28906268	28906268	PRJNA358009_P_NODE_6768_length_325_cov_4.065217_g6705_i0	PRJNA358009	6768	325	4.065217	13.21195525	Methanofastidiosum sp.	2666341	Archaea	Archaea	113	3.4300000000000005e-27	NR	HQK63031.1	2666341	g6705	i0	59.6	0.96	104	3	96	1	317	6	7	71	HQK63031.1 transposase [Methanofastidiosum sp.]	diamond	312	113	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Methanofastidiosia	Candidatus Methanofastidiosales	Candidatus Methanofastidiosaceae	Candidatus Methanofastidiosum	Methanofastidiosum sp.
29442983	29442983	PRJNA358009_P_NODE_17890_length_154_cov_3.638095_g17821_i0	PRJNA358009	17890	154	3.638095	5.6026663	Candidatus Nanohaloarchaea archaeon	2594798	Archaea	Archaea	72.8	2.78e-13	NR	MFB6203993.1	2594798	g17821	i0	73.9	1.83116883116883	46	12	89.6	0	7	144	115	160	MFB6203993.1 alkaline phosphatase family protein [Candidatus Nanohaloarchaea archaeon]	diamond	282	72.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Candidatus Nanohaloarchaea				Candidatus Nanohaloarchaea archaeon
29712574	29712574	PRJNA358009_P_NODE_7750_length_224_cov_1.165714_g7681_i0	PRJNA358009	7750	224	1.165714	2.61119936	root	1	Root_unresolved	Root_unresolved	156	3.64e-42	NR	WP_011248956.1	311400	g7681	i0	100	2.97321428571429	74	0	99.1	0	224	3	171	244	WP_011248956.1 DNA polymerase [Thermococcus kodakarensis]	diamond	666	156	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus kodakarensis
32083474	32083474	PRJNA358009_P_NODE_14958_length_163_cov_4.026316_g14889_i0	PRJNA358009	14958	163	4.026316	6.56289508	Halanaeroarchaeum	1656823	Archaea	Archaea	71.2	7.71e-14	NR	MFB6082319.1	1963275	g14889	i0	62.5	1.85889570552147	48	18	88.3	0	20	163	34	81	MFB6082319.1 PH domain-containing protein [Halanaeroarchaeum sp.]	diamond	303	71.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halanaeroarchaeum	Halanaeroarchaeum sp.

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