metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA861969" 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
846440	846440	PRJNA861969_P_NODE_33121_length_249_cov_0.875000_g32890_i0	PRJNA861969	33121	249	0.875	2.17875	Deinococcus cavernae	2320857	Bacteria	Bacteria	147	6.85e-41	NR	WP_119765991.1	2320857	g32890	i0	90.2	0.987951807228916	82	8	98.8	0	2	247	2	83	WP_119765991.1 alanine dehydrogenase [Deinococcus cavernae]	diamond	246	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
5949929	5949929	PRJNA861969_P_NODE_41345_length_241_cov_0.916667_g41114_i0	PRJNA861969	41345	241	0.916667	2.20916747	Calidithermus terrae	1408545	Bacteria	Bacteria	139	9.389999999999999e-40	NR	WP_119314407.1	1408545	g41114	i0	90.8	0.946058091286307	76	7	94.6	0	1	228	9	84	WP_119314407.1 DNA polymerase ligase N-terminal domain-containing protein [Calidithermus terrae]	diamond	228	139	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus terrae
27308155	27308155	PRJNA861969_P_NODE_39423_length_243_cov_0.905882_g39192_i0	PRJNA861969	39423	243	0.905882	2.20129326	Deinococcus cavernae	2320857	Bacteria	Bacteria	110	8.54e-27	NR	WP_119761192.1	2320857	g39192	i0	63.8	0.987654320987654	80	29	98.8	0	242	3	111	190	WP_119761192.1 3'-5' exonuclease [Deinococcus cavernae]	diamond	240	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
28507910	28507910	PRJNA861969_P_NODE_33367_length_249_cov_0.875000_g33136_i0	PRJNA861969	33367	249	0.875	2.17875	Truepera radiovictrix	332249	Bacteria	Bacteria	102	3.31e-24	NR	WP_013177751.1	332249	g33136	i0	89.3	0.674698795180723	56	6	67.5	0	170	3	1	56	WP_013177751.1 succinate--CoA ligase subunit alpha [Truepera radiovictrix]	diamond	168	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
30466141	30466141	PRJNA861969_P_NODE_25753_length_272_cov_1.402010_g25522_i0	PRJNA861969	25753	272	1.40201	3.8134672	Meiothermus sp. QL-1	2058095	Bacteria	Bacteria	62.4	6.22e-9	NR	WP_114799723.1	2058095	g25522	i0	59.7	0.794117647058823	72	26	79.4	2	258	43	400	468	WP_114799723.1 xylulokinase [Meiothermus sp. QL-1]	diamond	216	62.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. QL-1
32014957	32014957	PRJNA861969_P_NODE_23158_length_284_cov_1.203791_g22927_i0	PRJNA861969	23158	284	1.203791	3.41876644	Calidithermus timidus	307124	Bacteria	Bacteria	105	3.2299999999999997e-24	NR	WP_018465780.1	307124	g22927	i0	100	0.517605633802817	49	0	51.8	0	6	152	14	62	WP_018465780.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Calidithermus timidus]	diamond	147	105	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus timidus
32300085	32300085	PRJNA861969_P_NODE_31079_length_251_cov_0.865169_g30848_i0	PRJNA861969	31079	251	0.865169	2.17157419	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	76.6	4.71e-14	NR	WP_386842130.1	536443	g30848	i0	100	0.430278884462151	36	0	43	0	143	250	1	36	WP_386842130.1 NAD-dependent malic enzyme [Deinococcus taklimakanensis]	diamond	108	76.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis

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