metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_kingdom = "Methanobacteriati"

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
26763174	26763174	PRJNA591127_P_NODE_17421_length_197_cov_2.493750_g17252_i0	PRJNA591127	17421	197	2.49375	4.9126875	Natronosalvus halobius	2953746	Archaea	Archaea	75.1	7.96e-14	NR	WP_253437457.1	2953746	g17252	i0	71	0.944162436548223	62	9	94.4	1	10	195	458	510	WP_253437457.1 DEAD/DEAH box helicase family protein [Natronosalvus halobius]	diamond	186	75.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natronosalvus	Natronosalvus halobius
29840431	29840431	PRJNA591127_P_NODE_30391_length_151_cov_2.903509_g30222_i0	PRJNA591127	30391	151	2.903509	4.38429859	Methanomassiliicoccus	1080709	Archaea	Archaea	57.8	5.27e-8	NR	WP_026068762.1	1080712	g30222	i0	100	1.49006622516556	25	0	49.7	0	150	76	328	352	WP_026068762.1 coenzyme-B sulfoethylthiotransferase subunit beta [Methanomassiliicoccus luminyensis]	diamond	225	57.8	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae	Methanomassiliicoccus	Methanomassiliicoccus luminyensis
30142544	30142544	PRJNA591127_P_NODE_25772_length_164_cov_2.984252_g25603_i0	PRJNA591127	25772	164	2.984252	4.89417328	Hadesarchaea archaeon	2250276	Archaea	Archaea	48.9	1.03e-5	NR	MCS7131446.1	2250276	g25603	i0	46.3	0.98780487804878	54	28	98.8	1	1	162	19	71	MCS7131446.1 50S ribosomal protein L34e [Hadesarchaea archaeon]	diamond	162	48.9	1	Archaea		Methanobacteriati	Candidatus Hadarchaeota	Candidatus Hadarchaeia				Hadesarchaea archaeon
31786295	31786295	PRJNA591127_P_NODE_20657_length_196_cov_3.069182_g20488_i0	PRJNA591127	20657	196	3.069182	6.01559672	Methanobacterium sp.	2164	Archaea	Archaea	45.1	0.00266	NR	MDD1775483.1	2164	g20488	i0	76	0.75	25	6	38.3	0	75	1	79	103	MDD1775483.1 CPBP family intramembrane metalloprotease [Methanobacterium sp.]	diamond	147	45.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
31831376	31831376	PRJNA591127_P_NODE_14237_length_197_cov_4.643750_g14068_i0	PRJNA591127	14237	197	4.64375	9.1481875	Halalkalicoccus	332246	Archaea	Archaea	58.9	3.7e-8	NR	WP_066383698.1	1008153	g14068	i0	92	1.52284263959391	25	2	38.1	0	2	76	125	149	WP_066383698.1 DUF354 domain-containing protein [Halalkalicoccus paucihalophilus]	diamond	300	58.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus paucihalophilus

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