metadata: contig_metadata: 10 rows where bioproject = "PRJEB10140" and tax

10 rows where bioproject = "PRJEB10140" and tax_kingdom = "Promethearchaeati"

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_class	tax_order	tax_family	tax_genus	tax_species
1286017	1286017	PRJEB10140_P_NODE_154642_length_241_cov_1.276042_g137334_i0	PRJEB10140	154642	241	1.276042	3.07526122	Promethearchaeota archaeon	2053489	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2107931243\|gb\|CP070805.1\|	2053489	g137334	i0	96.97	0.136929460580913	33	0	13	1	190	221	2013948	2013980	MAG: Promethearchaeota archaeon isolate bin132 chromosome	blastn	33	54.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
5114243	5114243	PRJEB10140_P_NODE_180545_length_212_cov_1.239264_g163236_i0	PRJEB10140	180545	212	1.239264	2.62723968	Promethearchaeum syntrophicum	2594042	Archaea	Archaea	52.8	0.019	NTclustered	gi\|2778339399\|gb\|CP042905.2\|	2594042	g163236	i0	100	0.132075471698113	28	0	13	0	111	138	1452339	1452366	Promethearchaeum syntrophicum strain MK-D1 chromosome, complete genome	blastn	28	52.8	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Promethearchaeum	Promethearchaeum syntrophicum
5115748	5115748	PRJEB10140_P_NODE_81125_length_452_cov_1.699752_g63869_i0	PRJEB10140	81125	452	1.699752	7.68287904	Candidatus Lokiarchaeum ossiferum	2951803	Archaea	Archaea	235	2.22e-74	NR	UYP48652.1	2951803	g63869	i0	77.2	2.97345132743363	149	34	98.9	0	448	2	54	202	UYP48652.1 Tyrosine--tRNA ligase [Candidatus Lokiarchaeum ossiferum]	diamond	1344	235	1	Archaea	Promethearchaeati	Promethearchaeota	Promethearchaeia	Promethearchaeales	Promethearchaeaceae	Candidatus Lokiarchaeum	Candidatus Lokiarchaeum ossiferum
27759587	27759587	PRJEB10140_P_NODE_50084_length_728_cov_1.810015_g34303_i0	PRJEB10140	50084	728	1.810015	13.1769092	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	75.9	3.47e-12	NR	NHJ01733.1	2026747	g34303	i0	28.6	2.73214285714286	192	121	77.1	6	2	562	87	267	NHJ01733.1 SDR family oxidoreductase [Candidatus Heimdallarchaeota archaeon]	diamond	1989	75.9	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
27916999	27916999	PRJEB10140_P_NODE_64165_length_572_cov_1.680688_g47244_i0	PRJEB10140	64165	572	1.680688	9.61353536	Candidatus Heimdallarchaeota archaeon	2026747	Archaea	Archaea	90.5	3.3e-20	NR	MFV2016881.1	2026747	g47244	i0	52.9	0.713286713286713	68	32	35.7	0	225	22	8	75	MFV2016881.1 hypothetical protein [Candidatus Heimdallarchaeota archaeon]	diamond	408	90.5	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon
30632825	30632825	PRJEB10140_P_NODE_62033_length_591_cov_2.760148_g45207_i0	PRJEB10140	62033	591	2.760148	16.31247468	Promethearchaeota archaeon	2053489	Archaea	Archaea	174	1.64e-46	NR	TFG24093.1	2053489	g45207	i0	54.8	3.13705583756345	155	67	78.2	3	3	464	117	269	TFG24093.1 MAG: hypothetical protein EU529_05205 [Promethearchaeota archaeon]	diamond	1854	174	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
31265000	31265000	PRJEB10140_P_NODE_72135_length_509_cov_2.567391_g54989_i0	PRJEB10140	72135	509	2.567391	13.06802019	Candidatus Heimdallarchaeota archaeon LC_2	1841597	Archaea	Archaea	64.3	1.41e-8	NR	OLS20438.1	1841597	g54989	i0	29.9	0.807465618860511	137	87	76.6	5	81	470	86	220	OLS20438.1 MAG: hypothetical protein HeimC2_37210 [Candidatus Heimdallarchaeota archaeon LC_2]	diamond	411	64.3	1	Archaea	Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon LC_2
32049642	32049642	PRJEB10140_P_NODE_291158_length_162_cov_0.920354_g273849_i0	PRJEB10140	291158	162	0.920354	1.49097348	Archaea	2157	Archaea	Archaea	48.5	1.11e-4	NR	TKJ24206.1	2012491	g273849	i0	40.4	5.61111111111111	52	31	96.3	0	5	160	523	574	TKJ24206.1 MAG: hypothetical protein CEE43_00550 [Promethearchaeota archaeon Loki_b32]	diamond	909	48.5	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon Loki_b32
32687867	32687867	PRJEB10140_P_NODE_36900_length_956_cov_1.987872_g23418_i0	PRJEB10140	36900	956	1.987872	19.00405632	Promethearchaeota archaeon	2053489	Archaea	Archaea	224	6.719999999999999e-66	NR	TFG11024.1	2053489	g23418	i0	50.2	1.46548117154812	237	110	74.1	6	944	237	50	279	TFG11024.1 MAG: hypothetical protein EU535_07865, partial [Promethearchaeota archaeon]	diamond	1401	224	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota archaeon
32845338	32845338	PRJEB10140_P_NODE_194200_length_200_cov_1.052980_g176891_i0	PRJEB10140	194200	200	1.05298	2.10596	Promethearchaeota archaeon	2053489	Archaea	Archaea	49.7	7.41e-5	NR	NVM44557.1	2053489	g176891	i0	55.6	0.675	45	20	67.5	0	195	61	358	402	NVM44557.1 putative DNA modification/repair radical SAM protein [Promethearchaeota archaeon]	diamond	135	49.7	1	Archaea	Promethearchaeati	Promethearchaeota					Promethearchaeota 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);;