metadata: contig_metadata: 15 rows where bioproject = "PRJEB14803" and tax

15 rows where 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
2261102	2261102	PRJEB14803_P_NODE_38562_length_169_cov_1.746269_g38096_i0	PRJEB14803	38562	169	1.746269	2.95119461	Deinococcus	1298	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g38096	i0	98.817	201.532544378698	169	2	100	0	1	169	70989	70821	Deinococcus swuensis strain DY59, complete genome	blastn	34059	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
3847673	3847673	PRJEB14803_P_NODE_34904_length_180_cov_1.496552_g34438_i0	PRJEB14803	34904	180	1.496552	2.6937936	Deinococcus gobiensis	502394	Bacteria	Bacteria	307	2.9500000000000003e-79	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g34438	i0	97.753	92.5666666666667	178	4	99	0	3	180	803305	803128	Deinococcus gobiensis I-0, complete genome	blastn	16662	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
5123765	5123765	PRJEB14803_P_NODE_13625_length_333_cov_2.258389_g13160_i0	PRJEB14803	13625	333	2.258389	7.52043537	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	566	9.06e-157	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g13160	i0	97.305	243.597597597598	334	8	100	1	1	333	75034	74701	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	81118	566	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
15013644	15013644	PRJEB14803_P_NODE_19872_length_260_cov_1.804444_g19406_i0	PRJEB14803	19872	260	1.804444	4.6915544	Deinococcus	1298	Bacteria	Bacteria	219	2.21e-52	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g19406	i0	82.51	457.657692307692	263	32	97	10	8	260	284	26	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	118991	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
16288502	16288502	PRJEB14803_P_NODE_40013_length_165_cov_1.915385_g39547_i0	PRJEB14803	40013	165	1.915385	3.16038525	Deinococcus	1298	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g39547	i0	100	206.684848484848	165	0	100	0	1	165	73081	72917	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	34103	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
23938156	23938156	PRJEB14803_P_NODE_16979_length_288_cov_35.027668_g16513_i0	PRJEB14803	16979	288	35.027668	100.87968384	Deinococcus	1298	Bacteria	Bacteria	472	1.73e-128	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g16513	i0	96.181	106.006944444444	288	11	100	0	1	288	850	563	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	30530	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25211865	25211865	PRJEB14803_P_NODE_12320_length_356_cov_1.601246_g11855_i0	PRJEB14803	12320	356	1.601246	5.70043576	Deinococcus	1298	Bacteria	Bacteria	555	2.1099999999999994e-153	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g11855	i0	95.665	172.587078651685	346	13	97	2	12	356	1476	1132	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	61441	555	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
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);;