metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA454503" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
4269737	4269737	PRJNA454503_P_NODE_65444_length_208_cov_0.884354_g65115_i0	PRJNA454503	65444	208	0.884354	1.83945632	Thermus thermophilus	274	Bacteria	Bacteria	363	7.409999999999998e-96	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g65115	i0	98.077	36.3557692307692	208	4	100	0	1	208	1273678	1273471	Thermus thermophilus HB5008 DNA, complete genome	blastn	7562	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
5546113	5546113	PRJNA454503_P_NODE_40205_length_226_cov_2.660606_g39876_i0	PRJNA454503	40205	226	2.660606	6.01296956	Deinococcus aquaticus	328692	Bacteria	Bacteria	257	3.97e-64	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g39876	i0	89.95	29.0442477876106	199	20	88	0	28	226	80811	80613	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	6564	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
8095229	8095229	PRJNA454503_P_NODE_19427_length_271_cov_1.719048_g19098_i0	PRJNA454503	19427	271	1.719048	4.65862008	Deinococcus grandis	57498	Bacteria	Bacteria	401	2.1399999999999994e-107	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g19098	i0	94.318	205.066420664207	264	12	97	3	1	262	72256	72518	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	55573	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8096006	8096006	PRJNA454503_P_NODE_79067_length_204_cov_0.909091_g78738_i0	PRJNA454503	79067	204	0.909091	1.85454564	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	246	7.609999999999999e-61	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g78738	i0	99.265	1.50490196078431	136	1	67	0	69	204	2507220	2507085	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	307	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
11921321	11921321	PRJNA454503_P_NODE_51530_length_214_cov_1.450980_g51201_i0	PRJNA454503	51530	214	1.45098	3.1050972	Deinococcus aquaticus	328692	Bacteria	Bacteria	207	3.8e-49	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g51201	i0	84.404	1.01869158878505	218	26	100	8	1	214	1626973	1627186	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	218	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11921677	11921677	PRJNA454503_P_NODE_83230_length_202_cov_3.595745_g82901_i0	PRJNA454503	83230	202	3.595745	7.2634049	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	363	7.149999999999999e-96	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g82901	i0	99.497	273.311881188119	199	1	99	0	1	199	98665	98863	Deinococcus sp. AJ005 chromosome, complete genome	blastn	55209	363	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
13847296	13847296	PRJNA454503_P_NODE_40631_length_226_cov_1.575758_g40302_i0	PRJNA454503	40631	226	1.575758	3.56121308	Deinococcus	1298	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g40302	i0	99.558	3.94690265486726	226	1	100	0	1	226	646883	646658	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	892	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
17019998	17019998	PRJNA454503_P_NODE_58014_length_210_cov_0.872483_g57685_i0	PRJNA454503	58014	210	0.872483	1.8322143	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	339	1.26e-88	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g57685	i0	95.714	2	210	9	100	0	1	210	258102	258311	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	420	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
17671381	17671381	PRJNA454503_P_NODE_5434_length_493_cov_1.858796_g5108_i0	PRJNA454503	5434	493	1.858796	9.16386428	Deinococcus	1298	Bacteria	Bacteria	905	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g5108	i0	99.797	391.756592292089	493	1	100	0	1	493	69769	69277	Deinococcus swuensis strain DY59, complete genome	blastn	193136	905	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18294304	18294304	PRJNA454503_P_NODE_60135_length_209_cov_1.756757_g59806_i0	PRJNA454503	60135	209	1.756757	3.67162213	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	381	2.0599999999999996e-101	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g59806	i0	99.522	24.5693779904306	209	1	100	0	1	209	1930071	1930279	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	5135	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23394527	23394527	PRJNA454503_P_NODE_34279_length_234_cov_1.225434_g33950_i0	PRJNA454503	34279	234	1.225434	2.86751556	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	422	1.39e-113	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g33950	i0	99.145	30.2991452991453	234	2	100	0	1	234	1926998	1927231	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	7090	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23394808	23394808	PRJNA454503_P_NODE_54439_length_211_cov_1.446667_g54110_i0	PRJNA454503	54439	211	1.446667	3.05246737	Deinococcus aquaticus	328692	Bacteria	Bacteria	351	1.63e-92	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g54110	i0	97.115	5.71563981042654	208	6	99	0	4	211	722291	722084	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	1206	351	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
24045437	24045437	PRJNA454503_P_NODE_21019_length_264_cov_1.162562_g20690_i0	PRJNA454503	21019	264	1.162562	3.06916368	Deinococcus	1298	Bacteria	Bacteria	407	4.47e-109	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g20690	i0	95.686	274.056818181818	255	8	96	3	1	253	544895	544642	Deinococcus sp. NW-56 chromosome, complete genome	blastn	72351	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
24668916	24668916	PRJNA454503_P_NODE_69300_length_207_cov_0.890411_g68971_i0	PRJNA454503	69300	207	0.890411	1.84315077	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	316	5.819999999999998e-82	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g68971	i0	95.897	3.57487922705314	195	8	94	0	1	195	1488544	1488350	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	740	316	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)

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