metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1180292" 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
1592558	1592558	PRJNA1180292_P_NODE_5562_length_296_cov_1.233184_g5430_i0	PRJNA1180292	5562	296	1.233184	3.65022464	Deinococcus aetherius	200252	Bacteria	Bacteria	435	2.34e-117	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g5430	i0	94.097	73.5878378378378	288	13	97	3	1	286	5198	4913	Deinococcus aetherius ST0316 DNA, complete genome	blastn	21782	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
4869341	4869341	PRJNA1180292_P_NODE_4384_length_330_cov_3.976654_g4252_i0	PRJNA1180292	4384	330	3.976654	13.1229582	Deinococcus	1298	Bacteria	Bacteria	494	4.29e-135	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g4252	i0	96.358	265.815151515152	302	7	91	4	2	301	714914	715213	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	87719	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
7971103	7971103	PRJNA1180292_P_NODE_13127_length_242_cov_0.923077_g12995_i0	PRJNA1180292	13127	242	0.923077	2.23384634	Deinococcus gobiensis	502394	Bacteria	Bacteria	163	9.65e-36	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g12995	i0	80	6.10743801652893	225	42	92	2	1	222	2230189	2229965	Deinococcus gobiensis I-0, complete genome	blastn	1478	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11796501	11796501	PRJNA1180292_P_NODE_4730_length_319_cov_1.650407_g4598_i0	PRJNA1180292	4730	319	1.650407	5.26479833	Deinococcus aetherius	200252	Bacteria	Bacteria	468	2.51e-127	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g4598	i0	93.125	16.742946708464	320	21	100	1	1	319	308346	308665	Deinococcus aetherius ST0316 DNA, complete genome	blastn	5341	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11796512	11796512	PRJNA1180292_P_NODE_5730_length_291_cov_1.431193_g5598_i0	PRJNA1180292	5730	291	1.431193	4.16477163	Deinococcus aetherius	200252	Bacteria	Bacteria	255	1.91e-63	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g5598	i0	94.048	2.77319587628866	168	10	58	0	124	291	76944	76777	Deinococcus aetherius ST0316 DNA, complete genome	blastn	807	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
15620698	15620698	PRJNA1180292_P_NODE_8513_length_252_cov_0.871508_g8381_i0	PRJNA1180292	8513	252	0.871508	2.19620016	Deinococcus aetherius	200252	Bacteria	Bacteria	425	1.17e-114	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g8381	i0	97.222	32.5396825396825	252	6	100	1	1	252	398467	398217	Deinococcus aetherius ST0316 DNA, complete genome	blastn	8200	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18169483	18169483	PRJNA1180292_P_NODE_13295_length_227_cov_2.525974_g13163_i0	PRJNA1180292	13295	227	2.525974	5.73396098	Deinococcus metallilatus	1211322	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g13163	i0	98.214	33.8986784140969	224	4	99	0	3	226	2536391	2536168	Deinococcus metallilatus strain MA1002 chromosome	blastn	7695	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
18892782	18892782	PRJNA1180292_P_NODE_7155_length_264_cov_1.408377_g7023_i0	PRJNA1180292	7155	264	1.408377	3.71811528	Deinococcus	1298	Bacteria	Bacteria	479	9.33e-131	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g7023	i0	99.248	161.352272727273	266	0	100	1	1	264	1792290	1792025	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	42597	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19443922	19443922	PRJNA1180292_P_NODE_8516_length_252_cov_0.871508_g8384_i0	PRJNA1180292	8516	252	0.871508	2.19620016	Deinococcus aetherius	200252	Bacteria	Bacteria	385	1.98e-102	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g8384	i0	94.4	40.3531746031746	250	14	99	0	1	250	846789	847038	Deinococcus aetherius ST0316 DNA, complete genome	blastn	10169	385	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
22718144	22718144	PRJNA1180292_P_NODE_3518_length_365_cov_2.585616_g3386_i0	PRJNA1180292	3518	365	2.585616	9.4374984	Deinococcus	1298	Bacteria	Bacteria	669	0	NTclustered	gi\|2678098150\|gb\|PP359631.1\|	47478	g3386	i0	99.726	106.093150684932	365	1	100	0	1	365	25	389	Deinococcus sp. strain BFCQ1 16S ribosomal RNA gene, partial sequence	blastn	38724	669	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25267524	25267524	PRJNA1180292_P_NODE_9560_length_249_cov_1.636364_g9428_i0	PRJNA1180292	9560	249	1.636364	4.07454636	Deinococcus	1298	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9428	i0	99.598	208.74297188755	249	1	100	0	1	249	1792859	1792611	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	51977	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis

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