metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1248424" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1248424" 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
4879927	4879927	PRJNA1248424_P_NODE_45024_length_337_cov_0.859848_g38960_i0	PRJNA1248424	45024	337	0.859848	2.89768776	Deinococcus	1298	Bacteria	Bacteria	523	5.609999999999999e-144	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g38960	i0	94.69	200.59940652819	339	14	100	3	1	337	423436	423772	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	67602	523	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8006629	8006629	PRJNA1248424_P_NODE_72467_length_248_cov_0.880000_g66398_i0	PRJNA1248424	72467	248	0.88	2.1824	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	287	5.649999999999999e-73	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g66398	i0	88.841	74.7862903225806	233	26	94	0	16	248	3092320	3092552	Deinococcus sp. D7000 chromosome, complete genome	blastn	18547	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
13106316	13106316	PRJNA1248424_P_NODE_30671_length_498_cov_1.955294_g24632_i0	PRJNA1248424	30671	498	1.955294	9.73736412	Fervidobacterium changbaicum	310769	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|1563174866\|gb\|CP026721.1\|	310769	g24632	i0	100	0.0562248995983936	28	0	6	0	394	421	768390	768417	Fervidobacterium changbaicum strain CBS-1 chromosome	blastn	28	52.8	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium changbaicum
16930118	16930118	PRJNA1248424_P_NODE_54694_length_289_cov_1.171296_g48626_i0	PRJNA1248424	54694	289	1.171296	3.38504544	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	283	8.71e-72	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g48626	i0	87.149	24.9584775086505	249	32	86	0	13	261	811350	811598	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	7213	283	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18204660	18204660	PRJNA1248424_P_NODE_57555_length_282_cov_1.143541_g51487_i0	PRJNA1248424	57555	282	1.143541	3.22478562	Deinococcus radiophilus	32062	Bacteria	Bacteria	191	5.28e-44	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g51487	i0	79.924	3.38297872340426	264	49	93	4	1	262	550706	550445	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	954	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
23305523	23305523	PRJNA1248424_P_NODE_69439_length_251_cov_0.865169_g63370_i0	PRJNA1248424	69439	251	0.865169	2.17157419	Deinococcus proteolyticus	55148	Bacteria	Bacteria	353	5.569999999999998e-93	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g63370	i0	92.032	11.792828685259	251	20	100	0	1	251	2049165	2048915	Deinococcus proteolyticus MRP, complete genome	blastn	2960	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
25277973	25277973	PRJNA1248424_P_NODE_47760_length_322_cov_1.951807_g41693_i0	PRJNA1248424	47760	322	1.951807	6.28481854	Truepera	332248	Bacteria	Bacteria	185	2.86e-42	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g41693	i0	89.189	44.5807453416149	148	16	46	0	173	320	1760878	1760731	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	14355	185	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);;