metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA627467" 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
1150734	1150734	PRJNA627467_P_NODE_11881_length_181_cov_2.590909_g11812_i0	PRJNA627467	11881	181	2.590909	4.68954529	Deinococcus	1298	Bacteria	Bacteria	322	1.06e-83	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g11812	i0	99.435	192.845303867403	177	1	98	0	1	177	1636185	1636361	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	34905	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
4426829	4426829	PRJNA627467_P_NODE_19864_length_159_cov_2.527273_g19795_i0	PRJNA627467	19864	159	2.527273	4.01836407	Deinococcus sonorensis	309891	Bacteria	Bacteria	76.8	7.81e-10	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g19795	i0	97.727	0.830188679245283	44	1	28	0	4	47	336817	336774	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	132	76.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
4979020	4979020	PRJNA627467_P_NODE_20044_length_158_cov_2.972477_g19975_i0	PRJNA627467	20044	158	2.972477	4.69651366	Thermus	270	Bacteria	Bacteria	285	1.18e-72	NTclustered	gi\|383508497\|gb\|CP003252.1\|	798128	g19975	i0	100	44.0949367088608	154	0	97	0	4	157	175834	175987	Thermus thermophilus JL-18, complete genome	blastn	6967	285	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
5702847	5702847	PRJNA627467_P_NODE_425_length_494_cov_3.633708_g360_i0	PRJNA627467	425	494	3.633708	17.95051752	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	527	6.569999999999999e-145	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g360	i0	98.98	200.334008097166	294	3	94	0	3	296	545056	545349	Deinococcus sp. NW-56 chromosome, complete genome	blastn	98965	527	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6977646	6977646	PRJNA627467_P_NODE_19526_length_160_cov_4.396396_g19457_i0	PRJNA627467	19526	160	4.396396	7.0342336	Deinococcus aetherius	200252	Bacteria	Bacteria	148	1.6499999999999995e-31	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g19457	i0	83.974	193.875	156	24	98	1	1	156	81838	81684	Deinococcus aetherius ST0316 DNA, complete genome	blastn	31020	148	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
8252293	8252293	PRJNA627467_P_NODE_14387_length_173_cov_1.387097_g14318_i0	PRJNA627467	14387	173	1.387097	2.39967781	Thermus scotoductus	37636	Bacteria	Bacteria	309	7.81e-80	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g14318	i0	99.412	4.91329479768786	170	1	98	0	1	170	1146632	1146463	Thermus scotoductus SA-01, complete genome	blastn	850	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10079378	10079378	PRJNA627467_P_NODE_4508_length_316_cov_1.734082_g4440_i0	PRJNA627467	4508	316	1.734082	5.47969912	Deinococcus	1298	Bacteria	Bacteria	169	2.8199999999999997e-37	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g4440	i0	97	55.8639240506329	100	3	32	0	1	100	423298	423199	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	17653	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
11354235	11354235	PRJNA627467_P_NODE_2409_length_316_cov_2.651685_g2341_i0	PRJNA627467	2409	316	2.651685	8.3793246	FCB group	1783270	Bacteria	Bacteria	182	3.62e-41	NTclustered	gi\|2444209308\|gb\|KU060869.2\|	47478	g2341	i0	100	33.9113924050633	98	0	31	0	216	313	418	321	Deinococcus sp. strain UYEF24 16S ribosomal RNA gene, partial sequence	blastn	10716	183	0.994535519125683	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
13904707	13904707	PRJNA627467_P_NODE_14831_length_171_cov_3.106557_g14762_i0	PRJNA627467	14831	171	3.106557	5.31221247	Thermus	270	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g14762	i0	99.405	146.087719298246	168	1	98	0	1	168	2229	2062	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	24981	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
16453579	16453579	PRJNA627467_P_NODE_18493_length_162_cov_4.442478_g18424_i0	PRJNA627467	18493	162	4.442478	7.19681436	Deinococcus	1298	Bacteria	Bacteria	239	9.64e-59	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g18424	i0	93.75	205.660493827161	160	8	98	2	4	162	1791961	1791803	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	33317	241	0.991701244813278	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18451172	18451172	PRJNA627467_P_NODE_13075_length_177_cov_2.414062_g13006_i0	PRJNA627467	13075	177	2.414062	4.27288974	Deinococcus aquaticus	328692	Bacteria	Bacteria	196	6.53e-46	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g13006	i0	89.172	1.07909604519774	157	17	89	0	16	172	2489229	2489073	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	191	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
20277262	20277262	PRJNA627467_P_NODE_19896_length_159_cov_2.336364_g19827_i0	PRJNA627467	19896	159	2.336364	3.71481876	Thermus	270	Bacteria	Bacteria	289	9.22e-74	NTclustered	gi\|320151725\|gb\|CP001963.1\|	743525	g19827	i0	99.371	50.0062893081761	159	1	100	0	1	159	7573	7731	Thermus scotoductus SA-01 plasmid pTSC8, complete sequence	blastn	7951	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
22276309	22276309	PRJNA627467_P_NODE_19818_length_159_cov_3.018182_g19749_i0	PRJNA627467	19818	159	3.018182	4.79890938	Thermus thermophilus	274	Bacteria	Bacteria	292	7.13e-75	NTclustered	gi\|1519241055\|emb\|LR027520.1\|	274	g19749	i0	100	2.9811320754717	158	0	99	0	2	159	28278	28435	Thermus thermophilus isolate TTHNAR1 genome assembly, plasmid: 4	blastn	474	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23551838	23551838	PRJNA627467_P_NODE_8539_length_204_cov_1.541935_g8470_i0	PRJNA627467	8539	204	1.541935	3.1455474	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	255	1.26e-63	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g8470	i0	91.005	5.97549019607843	189	17	93	0	16	204	69809	69621	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	1219	255	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
23551841	23551841	PRJNA627467_P_NODE_8799_length_197_cov_5.358108_g8730_i0	PRJNA627467	8799	197	5.358108	10.55547276	Deinococcus aetherius	200252	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g8730	i0	95.745	195.51269035533	188	8	95	0	5	192	83595	83782	Deinococcus aetherius ST0316 DNA, complete genome	blastn	38516	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
24825335	24825335	PRJNA627467_P_NODE_17900_length_164_cov_0.886957_g17831_i0	PRJNA627467	17900	164	0.886957	1.45460948	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	289	9.59e-74	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g17831	i0	99.371	5.96341463414634	159	1	97	0	3	161	322505	322347	Thermus sp. NEB1569 chromosome, complete genome	blastn	978	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
24825432	24825432	PRJNA627467_P_NODE_6640_length_273_cov_3.946429_g6571_i0	PRJNA627467	6640	273	3.946429	10.77375117	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	492	1.2499999999999996e-134	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g6571	i0	99.267	201.915750915751	273	1	100	1	1	273	1638229	1638500	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	55123	492	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
25377356	25377356	PRJNA627467_P_NODE_8180_length_212_cov_4.067485_g8111_i0	PRJNA627467	8180	212	4.067485	8.6230682	Deinococcus	1298	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g8111	i0	97.475	189.372641509434	198	5	94	0	14	211	423521	423718	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	40147	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis

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