metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1166865" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1166865" 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
8692501	8692501	PRJNA1166865_P_NODE_15407_length_546_cov_1.188161_g15168_i0	PRJNA1166865	15407	546	1.188161	6.48735906	Bacteria	2	Bacteria	Bacteria	205	7.55e-62	NR	VCU53236.1	274	g15168	i0	61.9	25.8681318681319	181	63	99.5	1	545	3	82	256	VCU53236.1 Aqualysin-1 [Thermus thermophilus]	diamond	14124	207	0.990338164251208	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
28745828	28745828	PRJNA1166865_P_NODE_45527_length_325_cov_1.833333_g45286_i0	PRJNA1166865	45527	325	1.833333	5.95833225	Deinococcus ficus	317577	Bacteria	Bacteria	61.2	2.89e-8	NR	WP_191240463.1	317577	g45286	i0	56	1.83692307692308	50	22	46.2	0	172	321	2	51	WP_191240463.1 phosphoglycerate kinase [Deinococcus ficus]	diamond	597	61.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
28998787	28998787	PRJNA1166865_P_NODE_82908_length_247_cov_0.885057_g82667_i0	PRJNA1166865	82908	247	0.885057	2.18609079	Deinococcus detaillensis	2592048	Bacteria	Bacteria	81.3	1.32e-16	NR	WP_143720303.1	2592048	g82667	i0	53.8	0.97165991902834	80	36	97.2	1	3	242	34	112	WP_143720303.1 ribose 5-phosphate isomerase A [Deinococcus detaillensis]	diamond	240	81.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus detaillensis
29061757	29061757	PRJNA1166865_P_NODE_95248_length_241_cov_0.916667_g95007_i0	PRJNA1166865	95248	241	0.916667	2.20916747	Synergistes sp.	2774297	Bacteria	Bacteria	64.7	6.44e-10	NR	MCF0248145.1	2774297	g95007	i0	48.4	2.2655601659751	64	29	74.7	1	62	241	2	65	MCF0248145.1 GTPase domain-containing protein [Synergistes sp.]	diamond	546	64.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Synergistes	Synergistes sp.
29156546	29156546	PRJNA1166865_P_NODE_76889_length_250_cov_1.305085_g76648_i0	PRJNA1166865	76889	250	1.305085	3.2627125	Thermotogota bacterium	2053689	Bacteria	Bacteria	43.1	0.027	NR	MCL4407461.1	2053689	g76648	i0	45.7	0.552	46	25	55.2	0	1	138	115	160	MCL4407461.1 DUF4382 domain-containing protein [Thermotogota bacterium]	diamond	138	43.1	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
29648752	29648752	PRJNA1166865_P_NODE_50150_length_311_cov_1.941176_g49909_i0	PRJNA1166865	50150	311	1.941176	6.03705736	Bacteria	2	Bacteria	Bacteria	138	8.38e-36	NR	CAA9558294.1	543023	g49909	i0	63.4	2.96141479099678	101	37	97.4	0	305	3	148	248	CAA9558294.1 MAG: Aerobic glycerol-3-phosphate dehydrogenase [uncultured Truepera sp.]	diamond	921	138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
29851040	29851040	PRJNA1166865_P_NODE_34791_length_367_cov_1.391156_g34550_i0	PRJNA1166865	34791	367	1.391156	5.10554252	Thermotogota bacterium	2053689	Bacteria	Bacteria	43.9	0.05	NR	HPE70507.1	2053689	g34550	i0	34.7	0.400544959128065	49	32	40.1	0	68	214	62	110	HPE70507.1 alpha/beta fold hydrolase [Thermotogota bacterium]	diamond	147	43.9	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
31133699	31133699	PRJNA1166865_P_NODE_77175_length_250_cov_0.870056_g76934_i0	PRJNA1166865	77175	250	0.870056	2.17514	Deinococcus	1298	Bacteria	Bacteria	106	1.7e-24	NR	WP_058976689.1	57498	g76934	i0	63.4	8.856	82	30	98.4	0	250	5	75	156	WP_058976689.1 DEAD/DEAH box RNA helicase [Deinococcus grandis]	diamond	2214	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
31892976	31892976	PRJNA1166865_P_NODE_90797_length_243_cov_0.905882_g90556_i0	PRJNA1166865	90797	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	59.7	3.9e-8	NR	WP_146887687.1	401558	g90556	i0	61.4	2.76543209876543	44	17	54.3	0	47	178	180	223	WP_146887687.1 metallophosphoesterase family protein [Deinococcus cellulosilyticus]	diamond	672	60.1	0.993344425956739	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus
32348591	32348591	PRJNA1166865_P_NODE_52119_length_306_cov_1.124464_g51878_i0	PRJNA1166865	52119	306	1.124464	3.44085984	Marinitoga litoralis	570855	Bacteria	Bacteria	143	2.72e-39	NR	WP_205101102.1	570855	g51878	i0	70.3	1.98039215686275	101	30	99	0	306	4	184	284	WP_205101102.1 2-hydroxyacid dehydrogenase [Marinitoga litoralis]	diamond	606	143	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga litoralis

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