metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA352850" 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
1071746	1071746	PRJNA352850_P_NODE_76261_length_256_cov_2.024155_g73428_i0	PRJNA352850	76261	256	2.024155	5.1818368	Allomeiothermus	2935559	Bacteria	Bacteria	457	4.22e-124	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g73428	i0	98.828	136.91796875	256	3	100	0	1	256	1440	1695	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	35051	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
2945868	2945868	PRJNA352850_P_NODE_28103_length_511_cov_4.586580_g25277_i0	PRJNA352850	28103	511	4.58658	23.4374238	uncultured Thermaceae bacterium	157469	Bacteria	Bacteria	876	0	NTclustered	gi\|118084513\|gb\|EF032761.1\|	157469	g25277	i0	100	98.9373776908024	474	0	93	0	36	509	1	474	Uncultured Thermaceae bacterium clone HAVOmat118 16S ribosomal RNA gene, partial sequence	blastn	50557	876	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae		uncultured Thermaceae bacterium
4224071	4224071	PRJNA352850_P_NODE_80444_length_249_cov_1.020000_g77611_i0	PRJNA352850	80444	249	1.02	2.5398	Allomeiothermus silvanus	52022	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g77611	i0	99.598	1	249	1	100	0	1	249	343530	343778	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	249	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
6773334	6773334	PRJNA352850_P_NODE_43626_length_375_cov_5.812883_g40793_i0	PRJNA352850	43626	375	5.812883	21.79831125	Deinococcus ficus	317577	Bacteria	Bacteria	619	7.8e-173	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g40793	i0	96.765	227.290666666667	371	12	99	0	5	375	2341548	2341178	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	85234	619	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8724183	8724183	PRJNA352850_P_NODE_63287_length_288_cov_2.903766_g60454_i0	PRJNA352850	63287	288	2.903766	8.36284608	Allomeiothermus	2935559	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g60454	i0	100	150.034722222222	288	0	100	0	1	288	1177	890	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	43210	532	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
9998985	9998985	PRJNA352850_P_NODE_15988_length_765_cov_3.428771_g13345_i0	PRJNA352850	15988	765	3.428771	26.23009815	Meiothermus	65551	Bacteria	Bacteria	944	0	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g13345	i0	89.418	148.62614379085	756	70	99	8	12	765	1531	784	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	113699	948	0.9957805907173	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
16974178	16974178	PRJNA352850_P_NODE_78954_length_251_cov_2.059406_g76121_i0	PRJNA352850	78954	251	2.059406	5.16910906	Meiothermus taiwanensis	172827	Bacteria	Bacteria	335	2.0199999999999998e-87	NTclustered	gi\|1395894659\|gb\|CP021130.1\|	1339250	g76121	i0	91.235	156.282868525896	251	15	99	6	3	250	259670	259916	Meiothermus taiwanensis WR-220 chromosome, complete genome	blastn	39227	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus taiwanensis
17648637	17648637	PRJNA352850_P_NODE_27114_length_524_cov_4.814737_g24291_i0	PRJNA352850	27114	524	4.814737	25.22922188	Allomeiothermus	2935559	Bacteria	Bacteria	900	0	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g24291	i0	98.812	151.440839694656	505	6	96	0	20	524	1	505	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	79355	904	0.995575221238938	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
22748199	22748199	PRJNA352850_P_NODE_44118_length_372_cov_3.133127_g41285_i0	PRJNA352850	44118	372	3.133127	11.65523244	Deinococcus	1298	Bacteria	Bacteria	121	9.56e-23	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g41285	i0	100	19.6532258064516	65	0	17	0	26	90	1599721	1599657	Deinococcus geothermalis DSM 11300, complete genome	blastn	7311	121	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
24023313	24023313	PRJNA352850_P_NODE_60979_length_296_cov_2.360324_g58146_i0	PRJNA352850	60979	296	2.360324	6.98655904	Deinococcus	1298	Bacteria	Bacteria	283	8.949999999999999e-72	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g58146	i0	87.352	151.266891891892	253	25	84	7	48	296	2342736	2342985	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	44775	285	0.992982456140351	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25296935	25296935	PRJNA352850_P_NODE_10600_length_1036_cov_2.875380_g8268_i0	PRJNA352850	10600	1036	2.87538	29.7889368	Deinococcus	1298	Bacteria	Bacteria	1701	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g8268	i0	96.336	214.569498069498	1037	34	100	4	1	1036	12	1045	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	222294	1707	0.996485061511424	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
25297073	25297073	PRJNA352850_P_NODE_18340_length_692_cov_3.573872_g13345_i1	PRJNA352850	18340	692	3.573872	24.73119424	Meiothermus	65551	Bacteria	Bacteria	569	1.54e-157	NTclustered	gi\|470485054\|ref\|NR_076682.1\|	277	g13345	i1	87.45	138.436416184971	502	53	72	7	12	511	1531	1038	Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence	blastn	95798	573	0.993019197207679	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
25297454	25297454	PRJNA352850_P_NODE_41640_length_388_cov_2.876106_g38808_i0	PRJNA352850	41640	388	2.876106	11.15929128	Deinococcus	1298	Bacteria	Bacteria	553	8.329999999999998e-153	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g38808	i0	92.545	219.128865979381	389	24	99	4	3	388	10	396	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	85022	553	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus

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