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

5 rows where analysis = "diamond", bioproject = "PRJNA914897" and tax_kingdom = "Thermotogati"

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_genus	tax_species
27087869	27087869	PRJNA914897_P_NODE_42582_length_241_cov_0.916667_g42158_i0	PRJNA914897	42582	241	0.916667	2.20916747	Deinococcus soli (ex Cha et al. 2	1309411	Bacteria	Bacteria	49.3	1.78e-4	NR	WP_046843727.1	1309411	g42158	i0	91.7	5.37759336099585	24	2	29.9	0	169	240	1	24	WP_046843727.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Deinococcus soli (ex Cha et al. 2016)]	diamond	1296	49.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
27126291	27126291	PRJNA914897_P_NODE_22082_length_355_cov_1.092199_g21658_i0	PRJNA914897	22082	355	1.092199	3.87730645	FCB group	1783270	Bacteria	Bacteria	63.5	4.53e-10	NR	WP_024821140.1	81467	g21658	i0	62.2	1.12394366197183	45	17	38	0	267	133	49	93	WP_024821140.1 RidA family protein [Aminobacterium mobile]	diamond	399	63.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium mobile
28887690	28887690	PRJNA914897_P_NODE_8468_length_660_cov_2.293015_g8062_i0	PRJNA914897	8468	660	2.293015	15.133899	Marinitoga sp. 38H-ov	1755814	Bacteria	Bacteria	49.3	0.00738	NR	WP_165145512.1	1755814	g8062	i0	24.5	0.890909090909091	196	111	77.3	7	558	49	68	252	WP_165145512.1 AAA domain-containing protein [Marinitoga sp. 38H-ov]	diamond	588	49.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga sp. 38H-ov
29400316	29400316	PRJNA914897_P_NODE_30369_length_286_cov_1.370892_g29945_i0	PRJNA914897	30369	286	1.370892	3.92075112	Bacteria	2	Bacteria	Bacteria	57	4.83e-7	NR	WP_041445790.1	336261	g29945	i0	49.1	11.1713286713287	57	22	59.8	2	182	12	3	52	WP_041445790.1 4-hydroxy-tetrahydrodipicolinate synthase [Thermovirga lienii]	diamond	3195	57	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii
32718762	32718762	PRJNA914897_P_NODE_6300_length_788_cov_2.770629_g1090_i1	PRJNA914897	6300	788	2.770629	21.83255652	root	1	Root_unresolved	Root_unresolved	80.1	5.58e-13	NR	WP_299429942.1	157471	g1090	i1	45.3	5.1510152284264	86	47	32.7	0	260	3	314	399	WP_299429942.1 branched-chain amino acid ABC transporter ATP-binding protein/permease, partial [uncultured Meiothermus sp.]	diamond	4059	80.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	uncultured Meiothermus sp.

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