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

9 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
4009770	4009770	PRJNA1068830_P_NODE_64144_length_271_cov_1.343434_g63441_i0	PRJNA1068830	64144	271	1.343434	3.64070614	Deinococcus grandis	57498	Bacteria	Bacteria	322	1.72e-83	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g63441	i0	88.043	82.2066420664207	276	27	100	6	1	271	116781	117055	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	22278	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
6561054	6561054	PRJNA1068830_P_NODE_56886_length_288_cov_4.204651_g56183_i0	PRJNA1068830	56886	288	4.204651	12.10939488	Thermus scotoductus	37636	Bacteria	Bacteria	279	1.12e-70	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g56183	i0	100	8.55555555555556	151	0	100	0	1	151	34501	34651	Thermus scotoductus SA-01, complete genome	blastn	2464	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
7836108	7836108	PRJNA1068830_P_NODE_74347_length_252_cov_0.871508_g73644_i0	PRJNA1068830	74347	252	0.871508	2.19620016	uncultured Thermotogae bacterium	453412	Bacteria	Bacteria	244	3.51e-60	NTclustered	gi\|2621705100\|emb\|OY763325.1\|	453412	g73644	i0	84.127	4.00396825396825	252	40	100	0	1	252	3411756	3412007	MAG: uncultured Thermotogae bacterium isolate fcbefaaa-1511-4f39-b5ed-7dc52d8fa8ec genome assembly, chromosome: 1	blastn	1009	244	1	Bacteria	Thermotogati	Thermotogota	Thermotogae				uncultured Thermotogae bacterium
8667558	8667558	PRJNA1068830_P_NODE_79987_length_248_cov_0.891429_g79284_i0	PRJNA1068830	79987	248	0.891429	2.21074392	Meiothermus	65551	Bacteria	Bacteria	387	5.409999999999998e-103	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g79284	i0	94.758	5.5	248	13	100	0	1	248	1946212	1946459	Meiothermus ruber DSM 1279, complete genome	blastn	1364	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
9111060	9111060	PRJNA1068830_P_NODE_71808_length_254_cov_0.779006_g71105_i0	PRJNA1068830	71808	254	0.779006	1.97867524	Trueperaceae bacterium	2026798	Bacteria	Bacteria	320	5.73e-83	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g71105	i0	89.683	374.720472440945	252	25	99	1	4	254	6814	6563	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	95179	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
10386679	10386679	PRJNA1068830_P_NODE_67929_length_262_cov_1.650794_g67226_i0	PRJNA1068830	67929	262	1.650794	4.32508028	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	394	3.45e-105	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g67226	i0	96.25	1.81297709923664	240	9	92	0	23	262	2777247	2777486	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	475	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
16760428	16760428	PRJNA1068830_P_NODE_73414_length_252_cov_1.743017_g72711_i0	PRJNA1068830	73414	252	1.743017	4.39240284	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g72711	i0	100	201.357142857143	252	0	100	0	1	252	1636172	1636423	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	50742	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
20140598	20140598	PRJNA1068830_P_NODE_36216_length_373_cov_1.380000_g35513_i0	PRJNA1068830	36216	373	1.38	5.1474	Deinococcus	1298	Bacteria	Bacteria	510	4.87e-140	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g35513	i0	94.345	84.9758713136729	336	13	89	5	1	332	356361	356028	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	31696	512	0.99609375	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
24408076	24408076	PRJNA1068830_P_NODE_15220_length_627_cov_3.054152_g14542_i0	PRJNA1068830	15220	627	3.054152	19.14953304	Deinococcus ficus	317577	Bacteria	Bacteria	1138	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g14542	i0	99.521	212.006379585327	626	2	99	1	1	626	2342918	2342294	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	132928	1138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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