metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_phylum = "Deinococcota"

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
26621550	26621550	PRJEB14803_P_NODE_39121_length_168_cov_1.165414_g38655_i0	PRJEB14803	39121	168	1.165414	1.95789552	Thermus thalpophilus	2908147	Bacteria	Bacteria	41.6	0.0343	NR	GAA6756877.1	2908147	g38655	i0	41.5	0.946428571428571	53	30	94.6	1	5	163	225	276	GAA6756877.1 hypothetical protein Thermus77420_23530 [Thermus thalpophilus]	diamond	159	41.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thalpophilus
27570182	27570182	PRJEB14803_P_NODE_29944_length_198_cov_1.472393_g29478_i0	PRJEB14803	29944	198	1.472393	2.91533814	Deinococcota bacterium	1913990	Bacteria	Bacteria	42.7	0.0209	NR	MDQ3460049.1	1913990	g29478	i0	41.4	0.878787878787879	58	31	87.9	1	174	1	242	296	MDQ3460049.1 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Deinococcota bacterium]	diamond	174	42.7	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
28170165	28170165	PRJEB14803_P_NODE_35046_length_180_cov_1.096552_g34580_i0	PRJEB14803	35046	180	1.096552	1.9737936	Deinococcus roseus	392414	Bacteria	Bacteria	41.6	0.0398	NR	WP_189002135.1	392414	g34580	i0	42.2	1.06666666666667	64	24	85	2	175	23	220	283	WP_189002135.1 complex I NDUFA9 subunit family protein [Deinococcus roseus]	diamond	192	41.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
29243745	29243745	PRJEB14803_P_NODE_47689_length_150_cov_1.026087_g47223_i0	PRJEB14803	47689	150	1.026087	1.5391305	Deinococcus aetherius	200252	Bacteria	Bacteria	43.5	0.00555	NR	WP_264778174.1	200252	g47223	i0	47.7	0.88	44	23	88	0	140	9	476	519	WP_264778174.1 BTAD domain-containing putative transcriptional regulator [Deinococcus aetherius]	diamond	132	43.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
29338487	29338487	PRJEB14803_P_NODE_41529_length_162_cov_1.212598_g41063_i0	PRJEB14803	41529	162	1.212598	1.96440876	Calidithermus terrae	1408545	Bacteria	Bacteria	41.2	0.0434	NR	WP_119315375.1	1408545	g41063	i0	55.6	0.5	27	12	50	0	160	80	55	81	WP_119315375.1 M14 family metallopeptidase [Calidithermus terrae]	diamond	81	41.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus terrae
30475553	30475553	PRJEB14803_P_NODE_31633_length_191_cov_2.051282_g31167_i0	PRJEB14803	31633	191	2.051282	3.91794862	Deinococcus taeanensis	2737050	Bacteria	Bacteria	78.2	6.01e-15	NR	WP_225476513.1	2737050	g31167	i0	57.1	0.989528795811518	63	26	97.4	1	191	6	385	447	WP_225476513.1 G8 domain-containing protein [Deinococcus taeanensis]	diamond	189	78.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
31132252	31132252	PRJEB14803_P_NODE_36155_length_176_cov_1.624113_g35689_i0	PRJEB14803	36155	176	1.624113	2.85843888	PVC group	1783257	Bacteria	Bacteria	79.7	7.43e-16	NR	WP_029475990.1	249403	g35689	i0	66.7	13.2784090909091	54	18	92	0	14	175	1	54	WP_029475990.1 malate dehydrogenase [Deinococcus frigens]	diamond	2337	79.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus frigens
32461255	32461255	PRJEB14803_P_NODE_42339_length_160_cov_1.280000_g41873_i0	PRJEB14803	42339	160	1.28	2.048	Bacteria	2	Bacteria	Bacteria	69.3	2.93e-12	NR	WP_337961599.1	328692	g41873	i0	72.3	6.15	47	13	88.1	0	1	141	72	118	WP_337961599.1 shikimate dehydrogenase [Deinococcus aquaticus]	diamond	984	69.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus

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