metadata: contig_metadata: 6 rows where bioproject = "PRJNA977246" and tax

6 rows where bioproject = "PRJNA977246" and tax_phylum = "Armatimonadota"

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_species
2544369	2544369	PRJNA977246_S_NODE_11662_length_441_cov_6682.099515_g10703_i0	PRJNA977246	11662	441	6682.099515	29468.05886115	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84.7	1.66e-18	NR	GIV22148.1	2033014	g10703	i0	69.2	0.857142857142857	65	20	44.2	0	366	172	11	75	GIV22148.1 MAG: hypothetical protein KatS3mg023_3899 [Armatimonadota bacterium]	diamond	378	84.7	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
27500245	27500245	PRJNA977246_S_NODE_14823_length_381_cov_3.559659_g13833_i0	PRJNA977246	14823	381	3.559659	13.56230079	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	191	2.4300000000000003e-58	NR	HZP81090.1	2739509	g13833	i0	74.4	3.92913385826772	125	32	98.4	0	3	377	103	227	HZP81090.1 pseudouridine synthase [Chthonomonadaceae bacterium]	diamond	1497	191	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonadaceae bacterium
27910309	27910309	PRJNA977246_S_NODE_35045_length_201_cov_3.139535_g34053_i0	PRJNA977246	35045	201	3.139535	6.31046535	Armatimonadota bacterium	2033014	Bacteria	Bacteria	98.6	3.6300000000000003e-22	NR	MCL6532406.1	2033014	g34053	i0	98	0.761194029850746	51	1	76.1	0	2	154	415	465	MCL6532406.1 trypsin-like peptidase domain-containing protein [Armatimonadota bacterium]	diamond	153	98.6	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
30279273	30279273	PRJNA977246_S_NODE_29252_length_231_cov_3.564356_g28260_i0	PRJNA977246	29252	231	3.564356	8.23366236	Armatimonadota bacterium	2033014	Bacteria	Bacteria	143	5.979999999999999e-38	NR	MCL6533101.1	2033014	g28260	i0	94.8	1	77	4	100	0	1	231	37	113	MCL6533101.1 protein prkA [Armatimonadota bacterium]	diamond	231	143	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
32049189	32049189	PRJNA977246_S_NODE_23398_length_276_cov_3.275304_g22406_i0	PRJNA977246	23398	276	3.275304	9.03983904	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	117	3.24e-28	NR	MCW3101489.1	2739509	g22406	i0	69.6	1.71739130434783	79	24	85.9	0	1	237	478	556	MCW3101489.1 retrovirus-related Pol polyprotein from transposon 1-94 [Chthonomonadaceae bacterium]	diamond	474	117	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonadaceae bacterium
32587207	32587207	PRJNA977246_S_NODE_8879_length_520_cov_5.503055_g8003_i0	PRJNA977246	8879	520	5.503055	28.615886	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	48.9	0.003	NR	MCW5943536.1	2682144	g8003	i0	32.6	0.813461538461538	141	84	77.3	5	472	71	31	167	MCW5943536.1 ACP S-malonyltransferase [Fimbriimonadaceae bacterium]	diamond	423	48.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium

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