metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA685607" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA685607" 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
7045142	7045142	PRJNA685607_P_NODE_85846_length_244_cov_0.900585_g85487_i0	PRJNA685607	85846	244	0.900585	2.1974274	Deinococcus aestuarii	2774531	Bacteria	Bacteria	119	1.8099999999999999e-31	NR	WP_216326326.1	2774531	g85487	i0	79.5	0.959016393442623	78	16	95.9	0	3	236	13	90	WP_216326326.1 LutC/YkgG family protein [Deinococcus aestuarii]	diamond	234	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
19028227	19028227	PRJNA685607_P_NODE_8935_length_519_cov_0.995516_g8579_i0	PRJNA685607	8935	519	0.995516	5.16672804	Deinococcus antarcticus	1298767	Bacteria	Bacteria	188	3.0300000000000003e-58	NR	WP_380078269.1	1298767	g8579	i0	99	0.589595375722543	102	1	59	0	308	3	1	102	WP_380078269.1 CBS domain-containing protein [Deinococcus antarcticus]	diamond	306	188	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
24892539	24892539	PRJNA685607_P_NODE_76860_length_247_cov_0.885057_g76501_i0	PRJNA685607	76860	247	0.885057	2.18609079	uncultured Truepera sp.	543023	Bacteria	Bacteria	92.8	1.78e-20	NR	CAA9557627.1	543023	g76501	i0	85.4	0.582995951417004	48	7	58.3	0	145	2	22	69	CAA9557627.1 MAG: proline iminopeptidase-related protein [uncultured Truepera sp.]	diamond	144	92.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
26702193	26702193	PRJNA685607_P_NODE_81181_length_246_cov_0.890173_g80822_i0	PRJNA685607	81181	246	0.890173	2.18982558	Deinococcus antarcticus	1298767	Bacteria	Bacteria	170	4.3700000000000003e-51	NR	WP_380080614.1	1298767	g80822	i0	98.8	1	82	1	100	0	246	1	1	82	WP_380080614.1 alpha/beta hydrolase [Deinococcus antarcticus]	diamond	246	170	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
29292692	29292692	PRJNA685607_P_NODE_87289_length_244_cov_0.900585_g86930_i0	PRJNA685607	87289	244	0.900585	2.1974274	Deinococcus cavernae	2320857	Bacteria	Bacteria	157	2.6199999999999994e-42	NR	WP_158591524.1	2320857	g86930	i0	98.8	1.9672131147541	80	1	98.4	0	243	4	740	819	WP_158591524.1 phospholipase D-like domain-containing protein [Deinococcus cavernae]	diamond	480	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
30062059	30062059	PRJNA685607_P_NODE_66451_length_251_cov_0.865169_g66092_i0	PRJNA685607	66451	251	0.865169	2.17157419	Thermus	270	Bacteria	Bacteria	65.5	3.98e-10	NR	WP_185747603.1	1214928	g66092	i0	50.7	1.69721115537849	71	33	84.9	1	213	1	446	514	WP_185747603.1 DUF5591 domain-containing protein [Thermus tengchongensis]	diamond	426	65.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus tengchongensis
30082070	30082070	PRJNA685607_P_NODE_71212_length_249_cov_0.875000_g70853_i0	PRJNA685607	71212	249	0.875	2.17875	Deinococcus antarcticus	1298767	Bacteria	Bacteria	119	2.91e-32	NR	WP_380078512.1	1298767	g70853	i0	87.9	0.795180722891566	66	8	79.5	0	248	51	66	131	WP_380078512.1 hypothetical protein [Deinococcus antarcticus]	diamond	198	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30145111	30145111	PRJNA685607_P_NODE_74532_length_248_cov_0.880000_g74173_i0	PRJNA685607	74532	248	0.88	2.1824	Deinococcus piscis	394230	Bacteria	Bacteria	112	1.09e-26	NR	WP_189643872.1	394230	g74173	i0	85.3	0.82258064516129	68	10	82.3	0	248	45	412	479	WP_189643872.1 type I-C CRISPR-associated protein Cas8c/Csd1 [Deinococcus piscis]	diamond	204	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
30840551	30840551	PRJNA685607_P_NODE_18534_length_387_cov_0.980892_g18176_i0	PRJNA685607	18534	387	0.980892	3.79605204	Deinococcus antarcticus	1298767	Bacteria	Bacteria	199	1.51e-63	NR	WP_380080835.1	1298767	g18176	i0	98.1	0.821705426356589	106	2	82.2	0	318	1	1	106	WP_380080835.1 hypothetical protein [Deinococcus antarcticus]	diamond	318	199	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
31314565	31314565	PRJNA685607_P_NODE_95615_length_241_cov_0.916667_g95256_i0	PRJNA685607	95615	241	0.916667	2.20916747	Deinococcus fonticola	2528713	Bacteria	Bacteria	127	4.45e-32	NR	WP_135228095.1	2528713	g95256	i0	92.6	0.846473029045643	68	5	84.6	0	206	3	202	269	WP_135228095.1 2',3'-cyclic-nucleotide 2'-phosphodiesterase [Deinococcus fonticola]	diamond	204	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
31599390	31599390	PRJNA685607_P_NODE_65156_length_251_cov_0.865169_g64797_i0	PRJNA685607	65156	251	0.865169	2.17157419	Deinococcus ficus	317577	Bacteria	Bacteria	100	1.9300000000000001e-22	NR	WP_084473728.1	317577	g64797	i0	72.5	0.956175298804781	80	22	95.6	0	12	251	450	529	WP_084473728.1 tetratricopeptide repeat protein [Deinococcus ficus]	diamond	240	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
32168905	32168905	PRJNA685607_P_NODE_91978_length_242_cov_0.911243_g91619_i0	PRJNA685607	91978	242	0.911243	2.20520806	Deinococcus antarcticus	1298767	Bacteria	Bacteria	145	2.71e-40	NR	WP_380079439.1	1298767	g91619	i0	94.9	0.979338842975207	79	4	97.9	0	5	241	125	203	WP_380079439.1 glycosyltransferase [Deinococcus antarcticus]	diamond	237	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus

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