metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA760904" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA760904" 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
742234	742234	PRJNA760904_P_NODE_18261_length_245_cov_0.895349_g18204_i0	PRJNA760904	18261	245	0.895349	2.19360505	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	145	3.5499999999999996e-30	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g18204	i0	79.524	3.16734693877551	210	38	85	5	1	208	2281430	2281224	Deinococcus sp. NW-56 chromosome, complete genome	blastn	776	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
2018217	2018217	PRJNA760904_P_NODE_12402_length_268_cov_1.379487_g12345_i0	PRJNA760904	12402	268	1.379487	3.69702516	Deinococcus aetherius	200252	Bacteria	Bacteria	244	3.77e-60	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g12345	i0	88.235	2.27238805970149	204	24	100	0	1	204	442071	442274	Deinococcus aetherius ST0316 DNA, complete genome	blastn	609	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
2018252	2018252	PRJNA760904_P_NODE_19142_length_243_cov_1.788235_g19085_i0	PRJNA760904	19142	243	1.788235	4.34541105	Deinococcus aetherius	200252	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g19085	i0	88.479	2.87654320987654	217	25	89	0	27	243	856782	856998	Deinococcus aetherius ST0316 DNA, complete genome	blastn	699	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
4570607	4570607	PRJNA760904_P_NODE_18424_length_245_cov_0.895349_g18367_i0	PRJNA760904	18424	245	0.895349	2.19360505	Deinococcus aetherius	200252	Bacteria	Bacteria	272	1.56e-68	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g18367	i0	86.885	20.5714285714286	244	30	99	2	1	243	533551	533793	Deinococcus aetherius ST0316 DNA, complete genome	blastn	5040	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
7121001	7121001	PRJNA760904_P_NODE_21246_length_229_cov_2.596154_g21189_i0	PRJNA760904	21246	229	2.596154	5.94519266	Deinococcus aetherius	200252	Bacteria	Bacteria	100	7.19e-17	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g21189	i0	82.114	0.537117903930131	123	16	52	5	112	229	833030	833151	Deinococcus aetherius ST0316 DNA, complete genome	blastn	123	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
8395481	8395481	PRJNA760904_P_NODE_11847_length_272_cov_1.356784_g11790_i0	PRJNA760904	11847	272	1.356784	3.69045248	Deinococcus aetherius	200252	Bacteria	Bacteria	281	2.92e-71	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11790	i0	87.347	1.68014705882353	245	31	90	0	1	245	2219090	2218846	Deinococcus aetherius ST0316 DNA, complete genome	blastn	457	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
12221870	12221870	PRJNA760904_P_NODE_17750_length_246_cov_0.890173_g17693_i0	PRJNA760904	17750	246	0.890173	2.18982558	Deinococcus yunweiensis	367282	Bacteria	Bacteria	302	2e-77	NTclustered	gi\|2890656794\|gb\|CP177253.1\|	367282	g17693	i0	88.98	32.1666666666667	245	25	99	2	1	244	347767	348010	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP1, complete sequence	blastn	7913	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
13495974	13495974	PRJNA760904_P_NODE_11991_length_271_cov_1.308081_g11934_i0	PRJNA760904	11991	271	1.308081	3.54489951	Deinococcus aetherius	200252	Bacteria	Bacteria	346	1.02e-90	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11934	i0	89.668	26.3173431734317	271	28	100	0	1	271	1518080	1517810	Deinococcus aetherius ST0316 DNA, complete genome	blastn	7132	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
14771154	14771154	PRJNA760904_P_NODE_19952_length_242_cov_0.911243_g19895_i0	PRJNA760904	19952	242	0.911243	2.20520806	Deinococcus metallilatus	1211322	Bacteria	Bacteria	237	5.61e-58	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g19895	i0	84.524	1.71900826446281	252	26	99	10	1	240	1009144	1009394	Deinococcus metallilatus strain MA1002 chromosome	blastn	416	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
18593886	18593886	PRJNA760904_P_NODE_10695_length_282_cov_1.090909_g10638_i0	PRJNA760904	10695	282	1.090909	3.07636338	Deinococcus taeanensis	2737050	Bacteria	Bacteria	381	2.919999999999999e-101	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g10638	i0	91.135	163.882978723404	282	24	100	1	1	282	1409	1689	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	46215	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
19869113	19869113	PRJNA760904_P_NODE_15576_length_250_cov_0.870056_g15519_i0	PRJNA760904	15576	250	0.870056	2.17514	Deinococcus aetherius	200252	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g15519	i0	91.525	0.944	236	20	94	0	9	244	1494382	1494147	Deinococcus aetherius ST0316 DNA, complete genome	blastn	236	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21144816	21144816	PRJNA760904_P_NODE_4017_length_417_cov_0.877907_g3960_i0	PRJNA760904	4017	417	0.877907	3.66087219	Deinococcus aquaticus	328692	Bacteria	Bacteria	669	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g3960	i0	95.683	258.064748201439	417	16	99	2	3	417	715240	715656	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	107613	669	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
22419528	22419528	PRJNA760904_P_NODE_11158_length_278_cov_1.224390_g11101_i0	PRJNA760904	11158	278	1.22439	3.4038042	Deinococcus metallilatus	1211322	Bacteria	Bacteria	183	8.7e-42	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g11101	i0	87.037	1.72661870503597	162	21	58	0	1	162	2823350	2823189	Deinococcus metallilatus strain MA1002 chromosome	blastn	480	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
22419555	22419555	PRJNA760904_P_NODE_16758_length_248_cov_0.880000_g16701_i0	PRJNA760904	16758	248	0.88	2.1824	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g16701	i0	86.441	11.7540322580645	236	28	94	4	12	245	2099965	2099732	Deinococcus sp. NW-56 chromosome, complete genome	blastn	2915	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
22419592	22419592	PRJNA760904_P_NODE_7378_length_325_cov_2.158730_g7321_i0	PRJNA760904	7378	325	2.15873	7.0158725	Deinococcus altitudinis	468914	Bacteria	Bacteria	62.1	5.07e-5	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g7321	i0	94.872	0.12	39	2	12	0	22	60	2359048	2359010	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	39	62.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
24968846	24968846	PRJNA760904_P_NODE_18380_length_245_cov_0.895349_g18323_i0	PRJNA760904	18380	245	0.895349	2.19360505	Deinococcus aetherius	200252	Bacteria	Bacteria	289	1.55e-73	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g18323	i0	88.889	20.6857142857143	234	26	96	0	2	235	131330	131097	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	5068	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
24968849	24968849	PRJNA760904_P_NODE_19260_length_243_cov_0.905882_g19203_i0	PRJNA760904	19260	243	0.905882	2.20129326	Deinococcus aetherius	200252	Bacteria	Bacteria	291	4.26e-74	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g19203	i0	88.382	37.7860082304527	241	28	99	0	3	243	75436	75676	Deinococcus aetherius ST0316 DNA, complete genome	blastn	9182	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius

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