metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1226487" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1226487" 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
3597346	3597346	PRJNA1226487_P_NODE_32403_length_309_cov_10.805085_g32301_i0	PRJNA1226487	32403	309	10.805085	33.38771265	Deinococcus	1298	Bacteria	Bacteria	401	2.4899999999999988e-107	NTclustered	gi\|1735477873\|gb\|CP031501.1\|	1299	g32301	i0	90.492	16.8252427184466	305	27	98	2	1	304	228643	228340	Deinococcus radiodurans strain R1 dM1 chromosome II, complete sequence	blastn	5199	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
5438191	5438191	PRJNA1226487_P_NODE_45145_length_280_cov_1.869565_g45043_i0	PRJNA1226487	45145	280	1.869565	5.234782	Deinococcus geothermalis	68909	Bacteria	Bacteria	494	3.57e-135	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g45043	i0	98.571	2.40714285714286	280	3	99	1	1	279	1715174	1715453	Deinococcus geothermalis DSM 11300, complete genome	blastn	674	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
6149652	6149652	PRJNA1226487_P_NODE_30405_length_316_cov_2.061728_g30303_i0	PRJNA1226487	30405	316	2.061728	6.51506048	Deinococcus	1298	Bacteria	Bacteria	555	1.8499999999999999e-153	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g30303	i0	98.726	341.291139240506	314	1	98	2	1	311	2148405	2148718	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	107848	555	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7988448	7988448	PRJNA1226487_P_NODE_7187_length_495_cov_7.037915_g7090_i0	PRJNA1226487	7187	495	7.037915	34.83767925	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	281	5.66e-71	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g7090	i0	78.34	1.64040404040404	494	66	99	27	6	495	1361693	1362149	Deinococcus sp. NW-56 chromosome, complete genome	blastn	812	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14364093	14364093	PRJNA1226487_P_NODE_81392_length_228_cov_2.322581_g81290_i0	PRJNA1226487	81392	228	2.322581	5.29548468	Deinococcus grandis	57498	Bacteria	Bacteria	390	3.7899999999999996e-104	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g81290	i0	98.206	13.4473684210526	223	4	98	0	6	228	1494486	1494264	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	3066	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16349301	16349301	PRJNA1226487_P_NODE_28393_length_323_cov_2.068000_g28291_i0	PRJNA1226487	28393	323	2.068	6.67964	Deinococcus	1298	Bacteria	Bacteria	579	1.1299999999999997e-160	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g28291	i0	99.373	14.2074303405573	319	2	99	0	1	319	2014373	2014691	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	4589	579	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
18898318	18898318	PRJNA1226487_P_NODE_40055_length_288_cov_2.897674_g39953_i0	PRJNA1226487	40055	288	2.897674	8.34530112	Deinococcus	1298	Bacteria	Bacteria	257	5.26e-64	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g39953	i0	97.973	7.18402777777778	148	3	51	0	141	288	19648	19501	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	2069	257	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
18898352	18898352	PRJNA1226487_P_NODE_73395_length_244_cov_2.701754_g73293_i0	PRJNA1226487	73395	244	2.701754	6.59227976	Deinococci	188787	Bacteria	Bacteria	257	4.35e-64	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g73293	i0	85.656	69.5532786885246	244	35	100	0	1	244	1595537	1595294	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	16971	257	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);;