metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA879067" 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
854748	854748	PRJNA879067_P_NODE_31421_length_740_cov_8.110945_g28080_i0	PRJNA879067	31421	740	8.110945	60.020993	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1002	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g28080	i0	91.093	1.00135135135135	741	64	100	2	1	740	270901	271640	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	741	1002	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
2131023	2131023	PRJNA879067_P_NODE_64362_length_421_cov_1.942529_g60877_i0	PRJNA879067	64362	421	1.942529	8.17804709	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	701	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g60877	i0	96.675	1.99524940617577	421	14	100	0	1	421	663964	663544	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	840	701	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
3405465	3405465	PRJNA879067_P_NODE_30883_length_749_cov_5.241124_g27554_i0	PRJNA879067	30883	749	5.241124	39.25601876	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1000	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g27554	i0	90.704	1.31375166889186	753	66	100	3	1	749	1323475	1322723	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	984	1000	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
4682887	4682887	PRJNA879067_P_NODE_25944_length_846_cov_5.402329_g22737_i0	PRJNA879067	25944	846	5.402329	45.70370334	Nitrosopumilus zosterae	718286	Archaea	Archaea	54.7	0.024	NTclustered	gi\|2289589374\|dbj\|AP026695.1\|	718286	g22737	i0	96.875	0.0378250591016548	32	1	4	0	368	399	1617635	1617604	Nitrosopumilus zosterae NM25 DNA, complete genome	blastn	32	54.7	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus zosterae
7233564	7233564	PRJNA879067_P_NODE_52146_length_507_cov_4.122120_g48662_i0	PRJNA879067	52146	507	4.12212	20.8991484	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	660	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g48662	i0	91.649	2.465483234714	479	37	94	3	30	507	1045943	1045467	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	1250	660	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
7233703	7233703	PRJNA879067_P_NODE_56666_length_472_cov_10.596491_g53181_i0	PRJNA879067	56666	472	10.596491	50.01543752	uncultured crenarchaeote	29281	Archaea	Archaea	638	2.77e-178	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g53181	i0	92.955	47.2944915254237	440	28	93	3	9	447	6340	5903	Uncultured crenarchaeote 34 kb genomic fragment	blastn	22323	638	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
7234369	7234369	PRJNA879067_P_NODE_8266_length_1730_cov_11.960772_g6375_i0	PRJNA879067	8266	1730	11.960772	206.9213556	Candidatus Nitrosotenuis sp. DW1	2259672	Archaea	Archaea	501	1.4699999999999999e-136	NTclustered	gi\|1869227213\|gb\|CP030846.1\|	2259672	g6375	i0	73.721	6.21560693641618	1446	311	81	46	121	1516	21503	22929	Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome	blastn	10753	501	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp. DW1
8507374	8507374	PRJNA879067_P_NODE_24567_length_878_cov_11.309317_g21418_i0	PRJNA879067	24567	878	11.309317	99.29580326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1493	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g21418	i0	98.465	1.91002277904328	847	13	96	0	32	878	302145	301299	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	1677	1493	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
8509126	8509126	PRJNA879067_P_NODE_83927_length_322_cov_3.670683_g80441_i0	PRJNA879067	83927	322	3.670683	11.81959926	Haloferax volcanii	2246	Archaea	Archaea	52.8	0.03	NTclustered	gi\|291370026\|gb\|CP001956.1\|	309800	g80441	i0	100	0.0869565217391304	28	0	9	0	4	31	1819402	1819375	Haloferax volcanii DS2, complete sequence	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax volcanii
12335520	12335520	PRJNA879067_P_NODE_9350_length_1623_cov_2.479355_g7318_i0	PRJNA879067	9350	1623	2.479355	40.23993165	Salinigranum rubrum	755307	Archaea	Archaea	54.7	0.046	NTclustered	gi\|1336549475\|gb\|CP026309.1\|	755307	g7318	i0	100	0.0178681454097351	29	0	2	0	27	55	1743183	1743155	Salinigranum rubrum strain GX10 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Salinigranum	Salinigranum rubrum
13608688	13608688	PRJNA879067_P_NODE_41951_length_601_cov_4.566288_g38496_i0	PRJNA879067	41951	601	4.566288	27.44339088	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	885	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g38496	i0	94.618	0.958402662229617	576	24	95	2	1	570	1492535	1493109	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	576	885	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
13609586	13609586	PRJNA879067_P_NODE_73891_length_367_cov_3.921769_g70406_i0	PRJNA879067	73891	367	3.921769	14.39289223	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	556	6.06e-154	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g70406	i0	96.176	0.926430517711172	340	13	93	0	28	367	1369295	1368956	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	340	556	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
14883655	14883655	PRJNA879067_P_NODE_62732_length_431_cov_3.539106_g59247_i0	PRJNA879067	62732	431	3.539106	15.25354686	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	322	2.87e-83	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g59247	i0	87.234	0.654292343387471	282	36	65	0	32	313	2964693	2964974	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	282	322	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
16156820	16156820	PRJNA879067_P_NODE_16053_length_1172_cov_8.823476_g13355_i0	PRJNA879067	16053	1172	8.823476	103.41113872	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1375	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g13355	i0	88.225	4.16723549488055	1155	131	98	5	1	1152	1160268	1159116	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	4884	1375	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
17434643	17434643	PRJNA879067_P_NODE_93634_length_285_cov_1.452830_g90148_i0	PRJNA879067	93634	285	1.45283	4.1405655	Methanobacterium formicicum	2162	Archaea	Archaea	510	3.61e-140	NTclustered	gi\|952971377\|emb\|LN734822.1\|	2162	g90148	i0	98.947	4	285	3	100	0	1	285	1280514	1280230	Methanobacterium formicicum genome assembly isolate Mb9, chromosome : I	blastn	1140	510	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium formicicum
21257448	21257448	PRJNA879067_P_NODE_5357_length_2176_cov_14.075131_g3904_i0	PRJNA879067	5357	2176	14.075131	306.27485056	Candidatus Nitrosotenuis chungbukensis	1353246	Archaea	Archaea	1134	0	NTclustered	gi\|2551106379\|gb\|CP130341.1\|	1353246	g3904	i0	76.987	6.88465073529412	2038	435	93	32	143	2161	1454489	1456511	Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome	blastn	14981	1134	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis chungbukensis

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