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

10 rows where bioproject = "PRJNA1093380" and tax_kingdom = "Thermoproteati"

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
7851938	7851938	PRJNA1093380_P_NODE_67_length_1655_cov_1.948799_g46_i0	PRJNA1093380	67	1655	1.948799	32.25262345	uncultured crenarchaeote	29281	Archaea	Archaea	2772	0	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g46	i0	96.917	99.0761329305136	1654	51	99	0	1	1654	41643	43296	Uncultured crenarchaeote genomic fragment 54d9	blastn	163971	2772	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
9947449	9947449	PRJNA1093380_P_NODE_7068_length_279_cov_1.082524_g6962_i0	PRJNA1093380	7068	279	1.082524	3.02024196	Thermoproteati	1783275	Archaea	Archaea	399	7.969999999999998e-107	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g6962	i0	92.5	21.494623655914	280	19	99	2	2	279	41363	41084	Uncultured crenarchaeote genomic fragment 54d9	blastn	5997	401	0.99501246882793	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
17596991	17596991	PRJNA1093380_P_NODE_474_length_820_cov_1.965194_g381_i0	PRJNA1093380	474	820	1.965194	16.1145908	Archaea	2157	Archaea	Archaea	1448	0	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g381	i0	98.537	66.919512195122	820	12	100	0	1	820	40897	41716	Uncultured crenarchaeote genomic fragment 54d9	blastn	54874	1448	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
25245583	25245583	PRJNA1093380_P_NODE_17140_length_241_cov_0.916667_g17034_i0	PRJNA1093380	17140	241	0.916667	2.20916747	Nitrososphaera	497726	Archaea	Archaea	351	1.91e-92	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g17034	i0	92.975	25.5311203319502	242	15	100	2	1	241	1874	1634	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	6153	351	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
26750691	26750691	PRJNA1093380_P_NODE_12381_length_250_cov_0.870056_g12275_i0	PRJNA1093380	12381	250	0.870056	2.17514	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	143	2.4e-42	NR	HEY6950672.1	2169593	g12275	i0	100	1.656	69	0	82.8	0	250	44	32	100	HEY6950672.1 ferredoxin [Nitrososphaeraceae archaeon]	diamond	414	143	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27193909	27193909	PRJNA1093380_P_NODE_12042_length_251_cov_0.865169_g11936_i0	PRJNA1093380	12042	251	0.865169	2.17157419	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	171	1.76e-50	NR	HEY6950272.1	2169593	g11936	i0	100	0.99203187250996006	83	0	99.2	0	1	249	44	126	HEY6950272.1 type II glyceraldehyde-3-phosphate dehydrogenase [Nitrososphaeraceae archaeon]	diamond	249	171	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28330818	28330818	PRJNA1093380_P_NODE_10506_length_259_cov_1.360215_g10400_i0	PRJNA1093380	10506	259	1.360215	3.52295685	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	110	1.57e-29	NR	HTH20629.1	2169593	g10400	i0	98.2	0.637065637065637	55	1	63.7	0	259	95	18	72	HTH20629.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	165	110	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28930887	28930887	PRJNA1093380_P_NODE_12368_length_250_cov_0.870056_g12262_i0	PRJNA1093380	12368	250	0.870056	2.17514	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	120	1.03e-29	NR	HKX21393.1	2169593	g12262	i0	95	0.72	60	3	72	0	71	250	415	474	HKX21393.1 phospholipid carrier-dependent glycosyltransferase [Nitrososphaeraceae archaeon]	diamond	180	120	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30036054	30036054	PRJNA1093380_P_NODE_10491_length_259_cov_1.521505_g10385_i0	PRJNA1093380	10491	259	1.521505	3.94069795	Nitrosopumilales archaeon	2026768	Archaea	Archaea	77.4	2.54e-14	NR	RPI84747.1	2026768	g10385	i0	67.2	1.38996138996139	64	19	73	2	52	240	9	71	RPI84747.1 MAG: PDZ domain-containing protein, partial [Nitrosopumilales archaeon]	diamond	360	77.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
32240537	32240537	PRJNA1093380_P_NODE_5178_length_290_cov_1.419355_g5072_i0	PRJNA1093380	5178	290	1.419355	4.1161295	Nitrososphaeria	1643678	Archaea	Archaea	107	1.17e-24	NR	RPJ31302.1	2026768	g5072	i0	94.4	3.91034482758621	54	3	55.9	0	162	1	1	54	RPJ31302.1 MAG: tRNA guanosine(15) transglycosylase TgtA [Nitrosopumilales archaeon]	diamond	1134	108	0.990740740740741	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales 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);;