metadata: contig_metadata: 13 rows where bioproject = "PRJNA436017" and tax

13 rows where bioproject = "PRJNA436017" 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
2364561	2364561	PRJNA436017_P_NODE_7242_length_330_cov_17.559727_g6945_i0	PRJNA436017	7242	330	17.559727	57.9470991	Deinococcus	1298	Bacteria	Bacteria	324	5.9599999999999995e-84	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g6945	i0	84.639	251.084848484848	332	44	99	6	3	330	1454358	1454686	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	82858	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
5534530	5534530	PRJNA436017_P_NODE_22625_length_172_cov_1.125926_g22327_i0	PRJNA436017	22625	172	1.125926	1.93659272	Deinococcus grandis	57498	Bacteria	Bacteria	279	6.08e-71	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g22327	i0	96.988	53.1220930232558	166	5	97	0	7	172	1057476	1057311	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	9137	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7467069	7467069	PRJNA436017_P_NODE_1266_length_833_cov_4.673367_g1081_i0	PRJNA436017	1266	833	4.673367	38.92914711	Deinococcus	1298	Bacteria	Bacteria	501	6.9199999999999985e-137	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g1081	i0	78.441	323.861944777911	821	140	97	32	27	833	2343021	2342224	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	269777	503	0.996023856858847	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
9358842	9358842	PRJNA436017_P_NODE_19228_length_186_cov_9.912752_g18930_i0	PRJNA436017	19228	186	9.912752	18.43771872	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	329	6.56e-86	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g18930	i0	98.913	239.430107526882	184	2	99	0	1	184	58051	58234	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	44534	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
10017221	10017221	PRJNA436017_P_NODE_7728_length_318_cov_31.131673_g7431_i0	PRJNA436017	7728	318	31.131673	98.99872014	Deinococcus	1298	Bacteria	Bacteria	473	5.3699999999999986e-129	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g7431	i0	97.163	83.562893081761	282	5	88	2	1	279	20566	20285	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	26573	473	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
15116815	15116815	PRJNA436017_P_NODE_16992_length_199_cov_2.629630_g16694_i0	PRJNA436017	16992	199	2.62963	5.2329637	Deinococcus	1298	Bacteria	Bacteria	268	1.5799999999999998e-67	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g16694	i0	91.045	317.130653266332	201	14	100	4	1	199	2430	2232	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	63109	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
15733354	15733354	PRJNA436017_P_NODE_18653_length_189_cov_11.506579_g18355_i0	PRJNA436017	18653	189	11.506579	21.74743431	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	292	8.78e-75	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g18355	i0	94.709	212.243386243386	189	8	100	2	1	189	543123	543309	Deinococcus sp. NW-56 chromosome, complete genome	blastn	40114	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15733454	15733454	PRJNA436017_P_NODE_24073_length_166_cov_1.744186_g23775_i0	PRJNA436017	24073	166	1.744186	2.89534876	Deinococcus grandis	57498	Bacteria	Bacteria	296	5.82e-76	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g23775	i0	98.795	26.6746987951807	166	2	100	0	1	166	426761	426596	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	4428	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
15733668	15733668	PRJNA436017_P_NODE_9513_length_281_cov_3.602459_g9215_i0	PRJNA436017	9513	281	3.602459	10.12290979	Thermus aquaticus	271	Bacteria	Bacteria	189	1.8899999999999993e-43	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g9215	i0	80.709	112.35231316726	254	40	89	9	1	250	45560	45808	Thermus aquaticus Y51MC23, complete genome	blastn	31571	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
16391633	16391633	PRJNA436017_P_NODE_4593_length_429_cov_1625.951531_g1738_i1	PRJNA436017	4593	429	1625.951531	6975.33206799	Deinococcus	1298	Bacteria	Bacteria	785	0	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g1738	i1	99.766	105.708624708625	428	1	99	0	2	429	413	840	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	45349	785	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
24657354	24657354	PRJNA436017_P_NODE_8980_length_291_cov_3.649606_g8682_i0	PRJNA436017	8980	291	3.649606	10.62035346	Meiothermus taiwanensis	172827	Bacteria	Bacteria	171	7.13e-38	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g8682	i0	82.266	119.237113402062	203	31	69	4	2	202	259880	259681	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	34698	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
29381068	29381068	PRJNA436017_P_NODE_13189_length_231_cov_1.798969_g12891_i0	PRJNA436017	13189	231	1.798969	4.15561839	Synergistaceae bacterium	2053624	Bacteria	Bacteria	103	6.6e-26	NR	MBP9958555.1	2053624	g12891	i0	61.3	0.974025974025974	75	29	97.4	0	230	6	20	94	MBP9958555.1 cysteine hydrolase [Synergistaceae bacterium]	diamond	225	103	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32542211	32542211	PRJNA436017_P_NODE_8299_length_306_cov_1.754647_g8002_i0	PRJNA436017	8299	306	1.754647	5.36921982	Deinococcus gobiensis I-	502394	Bacteria	Bacteria	42	0.0171	NR	AFD28174.1	745776	g8002	i0	65.5	0.284313725490196	29	10	28.4	0	198	284	33	61	AFD28174.1 hypothetical protein DGo_PE0030 [Deinococcus gobiensis I-0]	diamond	87	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis

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