metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA680334" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA680334" 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
3200748	3200748	PRJNA680334_S_NODE_49883_length_192_cov_2.540881_g49397_i0	PRJNA680334	49883	192	2.540881	4.87849152	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	327	2.45e-85	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g49397	i0	97.396	12.0052083333333	192	5	100	0	1	192	1148806	1148615	Thermus sp. NEB1569 chromosome, complete genome	blastn	2305	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
5753925	5753925	PRJNA680334_S_NODE_73665_length_169_cov_5.257353_g73179_i0	PRJNA680334	73665	169	5.257353	8.88492657	Truepera radiovictrix	332249	Bacteria	Bacteria	189	1.0299999999999998e-43	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g73179	i0	94.309	227.112426035503	123	7	73	0	1	123	946593	946715	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	38382	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7028975	7028975	PRJNA680334_S_NODE_72826_length_170_cov_2.781022_g72340_i0	PRJNA680334	72826	170	2.781022	4.7277374	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	180	6.25e-41	NTclustered	gi\|2238960682\|gb\|CP097150.1\|	2939437	g72340	i0	85.799	0.994117647058824	169	24	99	0	2	170	67524	67692	Deinococcus sp. QL22 plasmid unnamed5, complete sequence	blastn	169	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
8822153	8822153	PRJNA680334_S_NODE_106147_length_150_cov_8.811966_g105661_i0	PRJNA680334	106147	150	8.811966	13.217949	Deinococcus	1298	Bacteria	Bacteria	233	4.07e-57	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g105661	i0	97.101	203.926666666667	138	4	92	0	1	138	1814070	1813933	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	30589	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
8822382	8822382	PRJNA680334_S_NODE_7887_length_336_cov_318.943894_g7401_i0	PRJNA680334	7887	336	318.943894	1071.65148384	Truepera	332248	Bacteria	Bacteria	318	2.83e-82	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g7401	i0	91.703	454.723214285714	229	19	68	0	14	242	762020	762248	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	152787	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
13404201	13404201	PRJNA680334_S_NODE_67031_length_175_cov_1.450704_g66545_i0	PRJNA680334	67031	175	1.450704	2.538732	Deinococcus aetherius	200252	Bacteria	Bacteria	191	2.99e-44	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g66545	i0	86.286	1	175	24	100	0	1	175	3050075	3050249	Deinococcus aetherius ST0316 DNA, complete genome	blastn	175	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
14679747	14679747	PRJNA680334_S_NODE_97552_length_155_cov_1.475410_g97066_i0	PRJNA680334	97552	155	1.47541	2.2868855	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	191	2.59e-44	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g97066	i0	89.032	28.4709677419355	155	16	100	1	1	155	878519	878366	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	4413	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
15197752	15197752	PRJNA680334_S_NODE_27952_length_229_cov_10.081633_g27466_i0	PRJNA680334	27952	229	10.081633	23.08693957	Deinococcus	1298	Bacteria	Bacteria	359	1.07e-94	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g27466	i0	97.608	105.74672489083	209	5	91	0	21	229	700	492	D.radiodurans 16S ribosomal RNA gene	blastn	24216	361	0.994459833795014	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
15952808	15952808	PRJNA680334_S_NODE_57673_length_183_cov_4.500000_g57187_i0	PRJNA680334	57673	183	4.5	8.235	Deinococcus taeanensis	2737050	Bacteria	Bacteria	207	3.14e-49	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g57187	i0	87.363	18.3770491803279	182	21	98	1	3	182	31032	30851	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	3363	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
16472102	16472102	PRJNA680334_S_NODE_62973_length_178_cov_3.855172_g62487_i0	PRJNA680334	62973	178	3.855172	6.86220616	Deinococcus	1298	Bacteria	Bacteria	235	1.39e-57	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g62487	i0	90.909	148.516853932584	176	15	99	1	1	176	1626	1452	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	26436	237	0.991561181434599	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
17227199	17227199	PRJNA680334_S_NODE_106294_length_150_cov_6.188034_g105808_i0	PRJNA680334	106294	150	6.188034	9.282051	Deinococcus sonorensis	309891	Bacteria	Bacteria	193	6.9e-45	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g105808	i0	90.066	152.393333333333	151	12	100	3	1	150	337867	337719	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	22859	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
18502059	18502059	PRJNA680334_S_NODE_46915_length_195_cov_23.024691_g46429_i0	PRJNA680334	46915	195	23.024691	44.89814745	Meiothermus ruber	277	Bacteria	Bacteria	246	7.2e-61	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g46429	i0	98.561	43.1230769230769	139	2	92	0	1	139	3048370	3048508	Meiothermus ruber DSM 1279, complete genome	blastn	8409	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
18502727	18502727	PRJNA680334_S_NODE_88255_length_160_cov_1.937008_g87769_i0	PRJNA680334	88255	160	1.937008	3.0992128	Deinococcus radiophilus	32062	Bacteria	Bacteria	222	9.559999999999999e-54	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g87769	i0	91.515	419.50625	165	9	100	5	1	160	1813956	1813792	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	67121	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
21051732	21051732	PRJNA680334_S_NODE_11477_length_301_cov_3.522388_g10991_i0	PRJNA680334	11477	301	3.522388	10.60238788	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	529	1.0599999999999996e-145	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g10991	i0	98.339	55.7774086378738	301	5	100	0	1	301	2447636	2447936	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	16789	529	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22326574	22326574	PRJNA680334_S_NODE_11838_length_298_cov_4.867925_g11352_i0	PRJNA680334	11838	298	4.867925	14.5064165	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	451	2.34e-122	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g11352	i0	94.81	183.46644295302	289	15	97	0	1	289	3085408	3085696	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	54673	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
22846571	22846571	PRJNA680334_S_NODE_105678_length_151_cov_1.559322_g105192_i0	PRJNA680334	105678	151	1.559322	2.35457622	Deinococcus	1298	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g105192	i0	100	133.569536423841	151	0	100	0	1	151	448	298	D.radiodurans 16S ribosomal RNA gene	blastn	20169	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans

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