metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA665531" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA665531" 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
5732767	5732767	PRJNA665531_P_NODE_15825_length_260_cov_1.556150_g15589_i0	PRJNA665531	15825	260	1.55615	4.04599	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	350	7.5e-92	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g15589	i0	91.732	35.0269230769231	254	17	99	4	2	254	68585	68835	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	9107	350	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
5732824	5732824	PRJNA665531_P_NODE_18005_length_247_cov_0.885057_g17769_i0	PRJNA665531	18005	247	0.885057	2.18609079	Deinococcus metallilatus	1211322	Bacteria	Bacteria	267	7.32e-67	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g17769	i0	86.179	16.7813765182186	246	34	99	0	2	247	2337700	2337945	Deinococcus metallilatus strain MA1002 chromosome	blastn	4145	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
6266162	6266162	PRJNA665531_P_NODE_765_length_1285_cov_5.850660_g674_i0	PRJNA665531	765	1285	5.85066	75.180981	Deinococcus	1298	Bacteria	Bacteria	2276	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g674	i0	98.602	352.356420233463	1288	15	100	3	1	1285	68968	70255	Deinococcus swuensis strain DY59, complete genome	blastn	452778	2276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
9557912	9557912	PRJNA665531_P_NODE_2228_length_775_cov_2.717949_g2030_i0	PRJNA665531	2228	775	2.717949	21.06410475	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	833	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g2030	i0	87.145	92.1767741935484	739	89	97	6	34	769	70155	69420	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	71437	833	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
12108543	12108543	PRJNA665531_P_NODE_11830_length_302_cov_1.257642_g11594_i0	PRJNA665531	11830	302	1.257642	3.79807884	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	453	6.6e-123	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g11594	i0	93.709	316.655629139073	302	19	100	0	1	302	69242	68941	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	95630	453	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15190826	15190826	PRJNA665531_P_NODE_13792_length_279_cov_1.495146_g13556_i0	PRJNA665531	13792	279	1.495146	4.17145734	Truepera	332248	Bacteria	Bacteria	82.4	3.28e-11	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g13556	i0	91.525	0.587813620071685	59	5	21	0	221	279	1059544	1059486	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	164	82.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16465139	16465139	PRJNA665531_P_NODE_1853_length_860_cov_4.606099_g1668_i0	PRJNA665531	1853	860	4.606099	39.6124514	Deinococcus	1298	Bacteria	Bacteria	1251	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g1668	i0	93.31	200.08488372093	852	49	98	7	15	860	70503	69654	Deinococcus swuensis strain DY59, complete genome	blastn	172073	1251	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
17740170	17740170	PRJNA665531_P_NODE_14274_length_274_cov_2.333333_g14038_i0	PRJNA665531	14274	274	2.333333	6.39333242	Thermus	270	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g14038	i0	100	136.007299270073	274	0	100	0	1	274	353158	352885	Thermus thermophilus HB5008 DNA, complete genome	blastn	37266	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25388746	25388746	PRJNA665531_P_NODE_18600_length_244_cov_1.350877_g18364_i0	PRJNA665531	18600	244	1.350877	3.29613988	Truepera	332248	Bacteria	Bacteria	237	5.6600000000000005e-58	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g18364	i0	84.362	1.94262295081967	243	36	99	2	1	242	286469	286228	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	474	237	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);;