metadata: contig_metadata: 9 rows where bioproject = "PRJNA437204", tax_clade = "Stenosarchaea group" and tax

9 rows where bioproject = "PRJNA437204", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

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
2983364	2983364	PRJNA437204_P_NODE_46923_length_307_cov_1.316239_g46624_i0	PRJNA437204	46923	307	1.316239	4.04085373	Halovivax cerinus	1487865	Archaea	Archaea	52.8	0.029	NTclustered	gi\|2279709464\|gb\|CP101824.1\|	1487865	g46624	i0	100	0.0912052117263844	28	0	9	0	20	47	429192	429219	Halovivax cerinus strain IBRC-M 10256 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovivax	Halovivax cerinus
8086459	8086459	PRJNA437204_P_NODE_73807_length_259_cov_1.650538_g73508_i0	PRJNA437204	73807	259	1.650538	4.27489342	Halosimplex aquaticum	3026162	Archaea	Archaea	52.8	0.024	NTclustered	gi\|2446562038\|gb\|CP118158.1\|	3026162	g73508	i0	100	0.108108108108108	28	0	11	0	214	241	3501527	3501554	Halosimplex aquaticum strain XZYJT29 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halosimplex	Halosimplex aquaticum
9360018	9360018	PRJNA437204_P_NODE_124848_length_241_cov_1.684524_g124549_i0	PRJNA437204	124848	241	1.684524	4.05970284	Haloarcula halobia	3033388	Archaea	Archaea	52.8	0.022	NTclustered	gi\|2463595540\|gb\|CP119787.1\|	3033388	g124549	i0	100	0.116182572614108	28	0	12	0	200	227	2516842	2516815	Haloarcula halobia strain XH51 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Haloarcula	Haloarcula halobia
10637492	10637492	PRJNA437204_P_NODE_93569_length_248_cov_0.880000_g93270_i0	PRJNA437204	93569	248	0.88	2.1824	Halopiger xanaduensis	387343	Archaea	Archaea	54.7	0.006	NTclustered	gi\|335336085\|gb\|CP002839.1\|	797210	g93270	i0	100	0.116935483870968	29	0	12	0	175	203	180678	180706	Halopiger xanaduensis SH-6, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halopiger	Halopiger xanaduensis
10637519	10637519	PRJNA437204_P_NODE_9489_length_549_cov_2.296218_g9191_i0	PRJNA437204	9489	549	2.296218	12.60623682	methanogenic archaeon mixed culture ISO4-G1	1452364	Archaea	Archaea	965	0	NTclustered	gi\|998155847\|gb\|CP013703.1\|	1452364	g9191	i0	98.361	57.8324225865209	549	9	100	0	1	549	1291062	1290514	Methanogenic archaeon mixed culture ISO4-G1 chromosome, complete genome	blastn	31750	965	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			methanogenic archaeon mixed culture ISO4-G1
19558074	19558074	PRJNA437204_P_NODE_21016_length_404_cov_1.362538_g20717_i0	PRJNA437204	21016	404	1.362538	5.50465352	Haloterrigena alkaliphila	2816475	Archaea	Archaea	52.8	0.039	NTclustered	gi\|2006064443\|gb\|CP071462.1\|	2816475	g20717	i0	100	0.0693069306930693	28	0	7	0	322	349	370035	370008	Haloterrigena alkaliphila strain KZCA68 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena alkaliphila
23384304	23384304	PRJNA437204_P_NODE_16559_length_442_cov_1.945799_g16260_i0	PRJNA437204	16559	442	1.945799	8.60043158	Natronorubrum daqingense	588898	Archaea	Archaea	69.4	4.24e-7	NTclustered	gi\|1134979927\|gb\|CP019327.1\|	588898	g16260	i0	85.294	0.153846153846154	68	8	15	2	148	214	592951	592885	Natronorubrum daqingense strain JX313, complete sequence	blastn	68	69.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronorubrum	Natronorubrum daqingense
28086454	28086454	PRJNA437204_P_NODE_113125_length_244_cov_0.900585_g112826_i0	PRJNA437204	113125	244	0.900585	2.1974274	Methanogenium sp.	2196	Archaea	Archaea	75.1	1.14e-13	NR	MFA5396831.1	2196	g112826	i0	45.1	1.00819672131148	82	42	98.4	2	242	3	131	211	MFA5396831.1 DUF559 domain-containing protein [Methanogenium sp.]	diamond	246	75.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium sp.
28844190	28844190	PRJNA437204_P_NODE_60048_length_281_cov_1.110577_g59749_i0	PRJNA437204	60048	281	1.110577	3.12072137	Methanococcoides burtonii	29291	Archaea	Archaea	54.3	4.8e-6	NR	WP_232221983.1	29291	g59749	i0	35.2	0.97153024911032	91	58	97.2	1	273	1	37	126	WP_232221983.1 serpin family protein [Methanococcoides burtonii]	diamond	273	54.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanococcoides	Methanococcoides burtonii

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