metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1129273" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1129273" 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
1557824	1557824	PRJNA1129273_P_NODE_11002_length_231_cov_2.632911_g10722_i0	PRJNA1129273	11002	231	2.632911	6.08202441	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	390	3.849999999999999e-104	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g10722	i0	97.38	2.93073593073593	229	6	99	0	2	230	3214821	3215049	Deinococcus sp. QL22 chromosome, complete genome	blastn	677	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
2307001	2307001	PRJNA1129273_P_NODE_10682_length_241_cov_2.565476_g10402_i0	PRJNA1129273	10682	241	2.565476	6.18279716	Truepera	332248	Bacteria	Bacteria	342	1.1499999999999999e-89	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g10402	i0	93.162	1114.02489626556	234	15	97	1	2	235	2717	2949	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	268480	342	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6134504	6134504	PRJNA1129273_P_NODE_6325_length_283_cov_2.061905_g6045_i0	PRJNA1129273	6325	283	2.061905	5.83519115	Deinococcus	1298	Bacteria	Bacteria	449	7.930000000000001e-122	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g6045	i0	96.014	5.87632508833922	276	11	98	0	7	282	1548118	1547843	Deinococcus puniceus strain DY1, complete genome	blastn	1663	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
11235007	11235007	PRJNA1129273_P_NODE_229_length_1757_cov_15.068290_g54_i3	PRJNA1129273	229	1757	15.06829	264.7498553	Deinococcus	1298	Bacteria	Bacteria	3094	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g54	i3	98.519	219.036425725669	1755	22	99	4	1	1754	14	1765	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	384847	3094	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
11761876	11761876	PRJNA1129273_P_NODE_6830_length_275_cov_1.534653_g6550_i0	PRJNA1129273	6830	275	1.534653	4.22029575	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	405	1.68e-108	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g6550	i0	93.407	36.0072727272727	273	18	99	0	2	274	1304895	1304623	Deinococcus sp. QL22 chromosome, complete genome	blastn	9902	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
12510398	12510398	PRJNA1129273_P_NODE_3110_length_422_cov_7.510029_g2831_i0	PRJNA1129273	3110	422	7.510029	31.69232238	Deinococcus	1298	Bacteria	Bacteria	728	0	NTclustered	gi\|1016573077\|gb\|KU951469.1\|	68909	g2831	i0	98.313	105.613744075829	415	7	98	0	7	421	421	7	Deinococcus geothermalis strain MC3-4A 16S ribosomal RNA gene, partial sequence	blastn	44569	728	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12510407	12510407	PRJNA1129273_P_NODE_5470_length_302_cov_2.427948_g5190_i0	PRJNA1129273	5470	302	2.427948	7.33240296	Deinococcus	1298	Bacteria	Bacteria	496	1.08e-135	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g5190	i0	96.346	203.271523178808	301	11	99	0	1	301	69857	70157	Deinococcus swuensis strain DY59, complete genome	blastn	61388	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
13036986	13036986	PRJNA1129273_P_NODE_7531_length_265_cov_1.500000_g7251_i0	PRJNA1129273	7531	265	1.5	3.975	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	403	5.799999999999998e-108	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g7251	i0	94.297	11.611320754717	263	15	99	0	2	264	2289427	2289165	Deinococcus sp. QL22 chromosome, complete genome	blastn	3077	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
14312179	14312179	PRJNA1129273_P_NODE_10592_length_242_cov_0.911243_g10312_i0	PRJNA1129273	10592	242	0.911243	2.20520806	Deinococcus geothermalis	68909	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g10312	i0	96.653	1.96694214876033	239	8	99	0	4	242	1699817	1699579	Deinococcus geothermalis DSM 11300, complete genome	blastn	476	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19409165	19409165	PRJNA1129273_P_NODE_7576_length_264_cov_2.141361_g7296_i0	PRJNA1129273	7576	264	2.141361	5.65319304	Deinococcus aquaticus	328692	Bacteria	Bacteria	326	1.29e-84	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g7296	i0	89.313	167.443181818182	262	24	98	4	4	263	715949	716208	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	44205	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
22708528	22708528	PRJNA1129273_P_NODE_5998_length_288_cov_4.218605_g5718_i0	PRJNA1129273	5998	288	4.218605	12.1495824	Truepera	332248	Bacteria	Bacteria	388	1.79e-103	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g5718	i0	91.003	107.395833333333	289	24	99	1	2	288	1840	1552	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	30930	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
23983976	23983976	PRJNA1129273_P_NODE_1979_length_570_cov_2.376258_g1708_i0	PRJNA1129273	1979	570	2.376258	13.5446706	Truepera	332248	Bacteria	Bacteria	665	0	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g1708	i0	90.476	298.035087719298	504	48	88	0	66	569	762248	761745	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	169880	665	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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