metadata: contig_metadata: 5 rows where bioproject = "PRJNA685060" and tax

5 rows where bioproject = "PRJNA685060" 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
9594794	9594794	PRJNA685060_P_NODE_4488_length_458_cov_2.031169_g4398_i0	PRJNA685060	4488	458	2.031169	9.30275402	archaeon	1906665	Archaea	Archaea	229	6.449999999999999e-72	NR	RYG67981.1	1906665	g4398	i0	74.7	1.96506550218341	150	38	98.3	0	7	456	79	228	RYG67981.1 MAG: malate dehydrogenase [archaeon]	diamond	900	229	1	Archaea								archaeon
15204720	15204720	PRJNA685060_P_NODE_14572_length_248_cov_0.880000_g14482_i0	PRJNA685060	14572	248	0.88	2.1824	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	433	6.86e-117	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g14482	i0	98.387	72.9435483870968	248	0	100	1	1	248	847790	848033	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	18090	433	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
18518215	18518215	PRJNA685060_P_NODE_12335_length_264_cov_1.591623_g12245_i0	PRJNA685060	12335	264	1.591623	4.20188472	haloarchaeon 3A1-DGR	1071085	Archaea	Archaea	56.5	0.002	NTclustered	gi\|1804090075\|gb\|CP048032.1\|	1071085	g12245	i0	100	0.443181818181818	30	0	11	0	36	65	1418813	1418784	Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome	blastn	117	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			haloarchaeon 3A1-DGR
18518300	18518300	PRJNA685060_P_NODE_8715_length_322_cov_1.216867_g8625_i0	PRJNA685060	8715	322	1.216867	3.91831174	Haloglomus halophilum	2962672	Archaea	Archaea	52.8	0.03	NTclustered	gi\|2273560679\|gb\|CP101166.1\|	2962672	g8625	i0	100	0.0869565217391304	28	0	9	0	227	254	2332056	2332029	Haloglomus halophilum strain ZY41 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Haloglomus	Haloglomus halophilum
32275362	32275362	PRJNA685060_P_NODE_11798_length_272_cov_1.105528_g11708_i0	PRJNA685060	11798	272	1.105528	3.00703616	root	1	Root_unresolved	Root_unresolved	60.5	3.19e-8	NR	AIF23262.1	1456558	g11708	i0	40.3	4.33455882352941	77	44	82.7	2	225	1	1950	2026	AIF23262.1 RCC1 domain-containing protein [uncultured marine group II/III euryarchaeote SAT1000_14_B08]	diamond	1179	60.5	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured marine group II/III euryarchaeote SAT1000_14_B08

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