metadata: contig_metadata: 8 rows where bioproject = "PRJEB65329" and tax

8 rows where bioproject = "PRJEB65329" 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_species
16706948	16706948	PRJEB65329_S_NODE_7534_length_266_cov_1.814346_g7372_i0	PRJEB65329	7534	266	1.814346	4.82616036	archaeon	1906665	Archaea	Archaea	170	2.12e-51	NR	RYH25290.1	1906665	g7372	i0	94.3	0.992481203007519	88	5	99.2	0	2	265	42	129	RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon]	diamond	264	170	1	Archaea	archaeon
16706991	16706991	PRJEB65329_S_NODE_9834_length_221_cov_2.833333_g9672_i0	PRJEB65329	9834	221	2.833333	6.26166593	archaeon	1906665	Archaea	Archaea	141	2.8e-40	NR	RYG65124.1	1906665	g9672	i0	93.2	0.990950226244344	73	5	99.1	0	2	220	85	157	RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon]	diamond	219	141	1	Archaea	archaeon
26716970	26716970	PRJEB65329_S_NODE_17301_length_156_cov_2.173228_g17139_i0	PRJEB65329	17301	156	2.173228	3.39023568	archaeon	1906665	Archaea	Archaea	58.9	4.49e-9	NR	RYH30350.1	1906665	g17139	i0	61.2	1.90384615384615	49	17	94.2	1	3	149	11	57	RYH30350.1 MAG: hypothetical protein EON65_05480 [archaeon]	diamond	297	58.9	1	Archaea	archaeon
27065464	27065464	PRJEB65329_S_NODE_6262_length_304_cov_2.865455_g6100_i0	PRJEB65329	6262	304	2.865455	8.7109832	archaeon	1906665	Archaea	Archaea	74.7	1.68e-13	NR	RYG68748.1	1906665	g6100	i0	80.6	0.355263157894737	36	7	35.5	0	108	1	62	97	RYG68748.1 MAG: hypothetical protein EON64_04460 [archaeon]	diamond	108	74.7	1	Archaea	archaeon
28455326	28455326	PRJEB65329_S_NODE_18566_length_150_cov_2.322314_g18404_i0	PRJEB65329	18566	150	2.322314	3.483471	archaeon	1906665	Archaea	Archaea	93.6	2.6200000000000003e-21	NR	RYG65852.1	1906665	g18404	i0	75	0.96	48	12	96	0	5	148	10	57	RYG65852.1 MAG: hypothetical protein EON64_11065 [archaeon]	diamond	144	93.6	1	Archaea	archaeon
30570839	30570839	PRJEB65329_S_NODE_7533_length_266_cov_1.848101_g7371_i0	PRJEB65329	7533	266	1.848101	4.91594866	archaeon	1906665	Archaea	Archaea	115	2.23e-30	NR	RYY87199.1	1906665	g7371	i0	60.7	0.947368421052632	84	32	93.6	1	253	5	4	87	RYY87199.1 MAG: hypothetical protein EON63_04475 [archaeon]	diamond	252	115	1	Archaea	archaeon
32183657	32183657	PRJEB65329_S_NODE_12318_length_191_cov_2.444444_g12156_i0	PRJEB65329	12318	191	2.444444	4.66888804	archaeon	1906665	Archaea	Archaea	132	3.5300000000000004e-36	NR	RYG68748.1	1906665	g12156	i0	82.5	1.97905759162304	63	11	99	0	2	190	112	174	RYG68748.1 MAG: hypothetical protein EON64_04460 [archaeon]	diamond	378	132	1	Archaea	archaeon
32626169	32626169	PRJEB65329_S_NODE_9220_length_231_cov_2.500000_g9058_i0	PRJEB65329	9220	231	2.5	5.775	archaeon	1906665	Archaea	Archaea	110	2.67e-28	NR	RYG65124.1	1906665	g9058	i0	78.5	0.844155844155844	65	14	84.4	0	230	36	150	214	RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon]	diamond	195	110	1	Archaea	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);;