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

16 rows where analysis = "blastn", bioproject = "PRJNA982106" 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
2238994	2238994	PRJNA982106_P_NODE_15802_length_279_cov_1.495146_g15562_i0	PRJNA982106	15802	279	1.495146	4.17145734	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	483	7.689999999999998e-132	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g15562	i0	97.849	1	279	6	100	0	1	279	1307724	1308002	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	279	483	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
7341747	7341747	PRJNA982106_P_NODE_29766_length_243_cov_0.905882_g29526_i0	PRJNA982106	29766	243	0.905882	2.20129326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	322	1.51e-83	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g29526	i0	91.489	0.967078189300412	235	18	96	1	1	233	968468	968702	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	235	322	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
8616872	8616872	PRJNA982106_P_NODE_25647_length_247_cov_0.885057_g25407_i0	PRJNA982106	25647	247	0.885057	2.18609079	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	339	1.5299999999999998e-88	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g25407	i0	91.463	2.18218623481781	246	21	99	0	1	246	1361847	1362092	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	539	339	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
11167048	11167048	PRJNA982106_P_NODE_14889_length_285_cov_1.452830_g14649_i0	PRJNA982106	14889	285	1.45283	4.1405655	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	370	6.4e-98	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g14649	i0	90.175	1	285	27	100	1	1	285	615882	615599	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	285	370	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
11167335	11167335	PRJNA982106_P_NODE_29929_length_243_cov_0.905882_g29689_i0	PRJNA982106	29929	243	0.905882	2.20129326	Methanimicrococcus hongohii	3028295	Archaea	Archaea	119	2.13e-22	NTclustered	gi\|2591774574\|gb\|CP131059.1\|	3028295	g29689	i0	82.143	57.522633744856	140	24	57	1	12	150	946106	946245	Methanimicrococcus hongohii strain Hf6 chromosome, complete genome	blastn	13978	119	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanimicrococcus	Methanimicrococcus hongohii
12442824	12442824	PRJNA982106_P_NODE_15410_length_282_cov_1.148325_g15170_i0	PRJNA982106	15410	282	1.148325	3.2382765	Halostagnicola larsenii	353800	Archaea	Archaea	327	3.86e-85	NTclustered	gi\|573479867\|gb\|CP007055.1\|	797299	g15170	i0	87.589	25.2695035460993	282	35	100	0	1	282	1061690	1061971	Halostagnicola larsenii XH-48, complete genome	blastn	7126	327	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halostagnicola	Halostagnicola larsenii
14991856	14991856	PRJNA982106_P_NODE_28712_length_244_cov_0.900585_g28472_i0	PRJNA982106	28712	244	0.900585	2.1974274	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	291	4.28e-74	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g28472	i0	88.115	1	244	29	100	0	1	244	44115	43872	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	244	291	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16266914	16266914	PRJNA982106_P_NODE_31593_length_242_cov_0.911243_g31353_i0	PRJNA982106	31593	242	0.911243	2.20520806	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	409	1.12e-109	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g31353	i0	97.107	2.59090909090909	242	7	100	0	1	242	377523	377764	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	627	409	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16573812	16573812	PRJNA982106_P_NODE_9453_length_332_cov_2.154440_g9213_i0	PRJNA982106	9453	332	2.15444	7.1527408	Thermoproteati	1783275	Archaea	Archaea	601	2.4799999999999996e-167	NTclustered	gi\|428675553\|gb\|JX889077.1\|	29281	g9213	i0	99.396	99.0903614457831	331	2	99	0	1	331	331	1	Uncultured crenarchaeote clone J4 ammonia monooxygenase subunit A (amoA) gene, partial cds	blastn	32898	601	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
17541624	17541624	PRJNA982106_P_NODE_16434_length_275_cov_1.311881_g16194_i0	PRJNA982106	16434	275	1.311881	3.60767275	Natronococcus occultus	29288	Archaea	Archaea	252	2.32e-62	NTclustered	gi\|433671692\|gb\|CP003929.1\|	694430	g16194	i0	85.141	2.04727272727273	249	33	90	4	14	260	3872567	3872813	Natronococcus occultus SP4, complete genome	blastn	563	252	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronococcus	Natronococcus occultus
20090300	20090300	PRJNA982106_P_NODE_22076_length_250_cov_0.870056_g21836_i0	PRJNA982106	22076	250	0.870056	2.17514	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	287	5.7e-73	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g21836	i0	87.402	1.016	254	27	100	3	1	250	527753	527501	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	254	287	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
20090387	20090387	PRJNA982106_P_NODE_26456_length_246_cov_0.890173_g26216_i0	PRJNA982106	26456	246	0.890173	2.18982558	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	405	1.48e-108	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g26216	i0	96.341	1	246	9	100	0	1	246	736492	736737	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	246	405	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
21365852	21365852	PRJNA982106_P_NODE_19817_length_254_cov_1.497238_g19577_i0	PRJNA982106	19817	254	1.497238	3.80298452	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	335	2.0399999999999993e-87	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g19577	i0	90.8	1.8740157480315	250	23	100	0	1	250	6767	7016	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	476	335	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
22641040	22641040	PRJNA982106_P_NODE_29798_length_243_cov_0.905882_g29558_i0	PRJNA982106	29798	243	0.905882	2.20129326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	355	1.49e-93	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g29558	i0	93.004	1	243	17	100	0	1	243	349208	349450	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	243	355	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
23916268	23916268	PRJNA982106_P_NODE_11259_length_314_cov_0.958506_g11019_i0	PRJNA982106	11259	314	0.958506	3.00970884	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	399	9.109999999999998e-107	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g11019	i0	90.196	0.974522292993631	306	30	97	0	1	306	1529495	1529190	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	306	399	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
23916526	23916526	PRJNA982106_P_NODE_26119_length_246_cov_0.890173_g25879_i0	PRJNA982106	26119	246	0.890173	2.18982558	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	427	3.16e-115	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g25879	i0	97.967	1.98780487804878	246	5	100	0	1	246	454964	455209	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	489	427	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae

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