metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
2985637	2985637	PRJNA438572_P_NODE_15963_length_260_cov_1.299465_g15844_i0	PRJNA438572	15963	260	1.299465	3.378609	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	466	7.14e-127	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g15844	i0	99.225	76.1538461538462	258	2	99	0	1	258	2065788	2066045	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	19800	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
3641982	3641982	PRJNA438572_P_NODE_20443_length_248_cov_0.891429_g20324_i0	PRJNA438572	20443	248	0.891429	2.21074392	Thermus	270	Bacteria	Bacteria	241	4.46e-59	NTclustered	gi\|2701836506\|dbj\|AP031331.1\|	274	g20324	i0	97.842	19.5604838709677	139	3	100	0	110	248	46973	46835	Thermus thermophilus TF25 plasmid pTF25b DNA, complete sequence	blastn	4851	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11913601	11913601	PRJNA438572_P_NODE_10870_length_311_cov_2.525210_g10751_i0	PRJNA438572	10870	311	2.52521	7.8534031	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	449	8.82e-122	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g10751	i0	92.476	279.041800643087	319	16	100	6	1	311	201068	201386	Deinococcus sp. AJ005 chromosome, complete genome	blastn	86782	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
15737497	15737497	PRJNA438572_P_NODE_10813_length_312_cov_1.531381_g10694_i0	PRJNA438572	10813	312	1.531381	4.77790872	Deinococcus aetherius	200252	Bacteria	Bacteria	472	1.8899999999999998e-128	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g10694	i0	93.93	207.964743589744	313	18	100	1	1	312	82337	82025	Deinococcus aetherius ST0316 DNA, complete genome	blastn	64885	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
23387354	23387354	PRJNA438572_P_NODE_5659_length_421_cov_1.045977_g5540_i0	PRJNA438572	5659	421	1.045977	4.40356317	Trueperaceae bacterium	2026798	Bacteria	Bacteria	538	2.549999999999999e-148	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g5540	i0	89.835	520.216152019002	423	38	99	3	1	418	8022	7600	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	219011	538	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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