metadata: contig_metadata: 13 rows where bioproject = "PRJEB9859" and tax

13 rows where bioproject = "PRJEB9859" 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_kingdom	tax_phylum	tax_species
145010	145010	PRJEB9859_P_NODE_921_length_401_cov_7.803763_g887_i0	PRJEB9859	921	401	7.803763	31.29308963	archaeon	1906665	Archaea	Archaea	85.1	3.09e-18	NR	RYG63904.1	1906665	g887	i0	86.5	0.785536159600998	52	7	38.9	0	2	157	74	125	RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon]	diamond	315	85.1	1	Archaea			archaeon
1419667	1419667	PRJEB9859_P_NODE_5042_length_245_cov_1.027778_g5007_i0	PRJEB9859	5042	245	1.027778	2.5180561	archaeon	1906665	Archaea	Archaea	74.7	5.79e-15	NR	RYG68433.1	1906665	g5007	i0	81.8	0.538775510204082	44	8	53.9	0	3	134	86	129	RYG68433.1 MAG: hypothetical protein EON64_05195 [archaeon]	diamond	132	74.7	1	Archaea			archaeon
9927036	9927036	PRJEB9859_P_NODE_4028_length_254_cov_1.973333_g3993_i0	PRJEB9859	4028	254	1.973333	5.01226582	archaeon	1906665	Archaea	Archaea	135	4.37e-39	NR	RYH10236.1	1906665	g3993	i0	94.1	0.803149606299213	68	4	80.3	0	254	51	36	103	RYH10236.1 MAG: 50S ribosomal protein L14 [archaeon]	diamond	204	135	1	Archaea			archaeon
24370844	24370844	PRJEB9859_P_NODE_5460_length_242_cov_12799.370892_g5425_i0	PRJEB9859	5460	242	12799.370892	30974.47755864	uncultured Aenigmarchaeota archaeon	1462426	Archaea	Archaea	69.4	2.16e-7	NTclustered	gi\|1572541187\|emb\|LR135910.1\|	1462426	g5425	i0	93.617	15.995867768595	47	1	19	2	173	219	24568	24524	uncultured Aenigmarchaeota archaeon genomic DNA containing deoA-rbcL-e2b2 region region	blastn	3871	69.4	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	uncultured Aenigmarchaeota archaeon
25225142	25225142	PRJEB9859_P_NODE_4760_length_247_cov_1.018349_g4725_i0	PRJEB9859	4760	247	1.018349	2.51532203	archaeon	1906665	Archaea	Archaea	74.7	1.24e-15	NR	RYY70401.1	1906665	g4725	i0	87.2	0.473684210526316	39	5	47.4	0	242	126	31	69	RYY70401.1 MAG: hypothetical protein EON63_22650 [archaeon]	diamond	117	74.7	1	Archaea			archaeon
26907772	26907772	PRJEB9859_P_NODE_4262_length_251_cov_1.000000_g4227_i0	PRJEB9859	4262	251	1	2.51	archaeon	1906665	Archaea	Archaea	75.1	4.31e-15	NR	RYG63904.1	1906665	g4227	i0	83.7	0.585657370517928	49	8	58.6	0	249	103	78	126	RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon]	diamond	147	75.1	1	Archaea			archaeon
27192241	27192241	PRJEB9859_P_NODE_4642_length_248_cov_1.013699_g4607_i0	PRJEB9859	4642	248	1.013699	2.51397352	archaeon	1906665	Archaea	Archaea	112	1.21e-26	NR	RYH21652.1	1906665	g4607	i0	67.5	0.931451612903226	77	25	93.1	0	248	18	250	326	RYH21652.1 MAG: hypothetical protein EON65_20340 [archaeon]	diamond	231	112	1	Archaea			archaeon
28329184	28329184	PRJEB9859_P_NODE_2746_length_290_cov_1.835249_g2711_i0	PRJEB9859	2746	290	1.835249	5.3222221	archaeon	1906665	Archaea	Archaea	99	1.23e-24	NR	RYH04918.1	1906665	g2711	i0	69.6	0.817241379310345	79	22	81.7	1	2	238	21	97	RYH04918.1 MAG: 50S ribosomal protein L24 [archaeon]	diamond	237	99	1	Archaea			archaeon
29307981	29307981	PRJEB9859_P_NODE_5329_length_243_cov_2.014019_g5294_i0	PRJEB9859	5329	243	2.014019	4.89406617	archaeon	1906665	Archaea	Archaea	110	7.06e-29	NR	RYH05217.1	1906665	g5294	i0	86.9	0.753086419753086	61	8	75.3	0	5	187	73	133	RYH05217.1 MAG: 50S ribosomal protein L15 [archaeon]	diamond	183	110	1	Archaea			archaeon
29560462	29560462	PRJEB9859_P_NODE_2390_length_302_cov_10.446886_g2355_i0	PRJEB9859	2390	302	10.446886	31.54959572	archaeon	1906665	Archaea	Archaea	109	3.69e-28	NR	RYH30694.1	1906665	g2355	i0	91.8	0.605960264900662	61	5	60.6	0	3	185	91	151	RYH30694.1 MAG: 30S ribosomal protein S15 [archaeon]	diamond	183	109	1	Archaea			archaeon
30508307	30508307	PRJEB9859_P_NODE_2613_length_294_cov_2.290566_g2578_i0	PRJEB9859	2613	294	2.290566	6.73426404	archaeon	1906665	Archaea	Archaea	56.2	8.79e-8	NR	RYH00022.1	1906665	g2578	i0	68.4	0.581632653061224	57	18	58.2	0	1	171	42	98	RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon]	diamond	171	56.2	1	Archaea			archaeon
31329864	31329864	PRJEB9859_P_NODE_3016_length_281_cov_9.976190_g2981_i0	PRJEB9859	3016	281	9.97619	28.0330939	archaeon	1906665	Archaea	Archaea	43.1	0.0331	NR	RYH25290.1	1906665	g2981	i0	85	0.213523131672598	20	3	21.4	0	1	60	188	207	RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon]	diamond	60	43.1	1	Archaea			archaeon
31456528	31456528	PRJEB9859_P_NODE_2096_length_315_cov_2.965035_g2061_i0	PRJEB9859	2096	315	2.965035	9.33986025	archaeon	1906665	Archaea	Archaea	84	1.39e-18	NR	RYG96209.1	1906665	g2061	i0	75.5	0.504761904761905	53	13	50.5	0	314	156	45	97	RYG96209.1 MAG: hypothetical protein EON65_54770, partial [archaeon]	diamond	159	84	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);;