metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Thermomicrobiota"

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
590200	590200	PRJNA611476_P_NODE_94581_length_247_cov_0.885057_g93790_i0	PRJNA611476	94581	247	0.885057	2.18609079	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g93790	i0	99.59	2.25910931174089	244	1	99	0	1	244	510851	511094	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	558	446	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
1864896	1864896	PRJNA611476_P_NODE_113322_length_242_cov_0.911243_g112531_i0	PRJNA611476	113322	242	0.911243	2.20520806	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g112531	i0	97.521	1	242	6	100	0	1	242	433777	434018	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	242	414	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
3139754	3139754	PRJNA611476_P_NODE_106163_length_244_cov_0.900585_g105372_i0	PRJNA611476	106163	244	0.900585	2.1974274	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g105372	i0	100	1	244	0	100	0	1	244	2341017	2341260	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	244	451	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
4417632	4417632	PRJNA611476_P_NODE_84824_length_250_cov_0.870056_g84033_i0	PRJNA611476	84824	250	0.870056	2.17514	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g84033	i0	100	1	250	0	100	0	1	250	2701	2452	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	250	462	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
5693599	5693599	PRJNA611476_P_NODE_79605_length_251_cov_0.865169_g78814_i0	PRJNA611476	79605	251	0.865169	2.17157419	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g78814	i0	98.805	1	251	3	100	0	1	251	33411	33161	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	251	448	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
6968517	6968517	PRJNA611476_P_NODE_93266_length_247_cov_0.885057_g92475_i0	PRJNA611476	93266	247	0.885057	2.18609079	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g92475	i0	99.595	1	247	1	100	0	1	247	782534	782288	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	247	451	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
6968590	6968590	PRJNA611476_P_NODE_98526_length_246_cov_0.890173_g97735_i0	PRJNA611476	98526	246	0.890173	2.18982558	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g97735	i0	97.222	7.34959349593496	252	1	100	2	1	246	1469058	1469309	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	1808	422	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8242042	8242042	PRJNA611476_P_NODE_112447_length_242_cov_0.911243_g111656_i0	PRJNA611476	112447	242	0.911243	2.20520806	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g111656	i0	99.587	3.01652892561983	242	1	100	0	1	242	598976	599217	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	730	442	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8243161	8243161	PRJNA611476_P_NODE_86547_length_249_cov_0.875000_g85756_i0	PRJNA611476	86547	249	0.875	2.17875	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g85756	i0	98.795	1.22489959839357	249	3	100	0	1	249	404016	404264	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	305	444	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
10793088	10793088	PRJNA611476_P_NODE_105949_length_244_cov_0.900585_g105158_i0	PRJNA611476	105949	244	0.900585	2.1974274	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g105158	i0	98.77	1	244	3	100	0	1	244	355185	355428	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	244	435	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
10794446	10794446	PRJNA611476_P_NODE_95629_length_247_cov_0.885057_g94838_i0	PRJNA611476	95629	247	0.885057	2.18609079	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g94838	i0	99.595	1	247	1	100	0	1	247	88693	88939	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	247	451	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
14617825	14617825	PRJNA611476_P_NODE_106612_length_244_cov_0.900585_g105821_i0	PRJNA611476	106612	244	0.900585	2.1974274	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	411	3.1499999999999996e-110	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g105821	i0	97.51	0.987704918032787	241	5	99	1	1	241	225426	225665	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	241	411	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
15893018	15893018	PRJNA611476_P_NODE_83633_length_250_cov_0.870056_g82842_i0	PRJNA611476	83633	250	0.870056	2.17514	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g82842	i0	100	1	250	0	100	0	1	250	2240323	2240572	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	250	462	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
17167596	17167596	PRJNA611476_P_NODE_60174_length_285_cov_0.863208_g59383_i0	PRJNA611476	60174	285	0.863208	2.4601428	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	499	7.82e-137	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g59383	i0	98.246	1.19298245614035	285	5	100	0	1	285	25435	25151	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	340	499	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
18441630	18441630	PRJNA611476_P_NODE_49675_length_309_cov_0.978814_g48884_i0	PRJNA611476	49675	309	0.978814	3.02453526	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	549	8.389999999999996e-152	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g48884	i0	98.706	1	309	4	100	0	1	309	518496	518804	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	309	549	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
18442266	18442266	PRJNA611476_P_NODE_96995_length_246_cov_0.890173_g96204_i0	PRJNA611476	96995	246	0.890173	2.18982558	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g96204	i0	97.967	1	246	5	100	0	1	246	1651329	1651084	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	246	427	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
20991223	20991223	PRJNA611476_P_NODE_104677_length_244_cov_0.900585_g103886_i0	PRJNA611476	104677	244	0.900585	2.1974274	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g103886	i0	98.77	1	244	3	100	0	1	244	1352667	1352910	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	244	435	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
20992505	20992505	PRJNA611476_P_NODE_95737_length_247_cov_0.885057_g94946_i0	PRJNA611476	95737	247	0.885057	2.18609079	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g94946	i0	99.19	1	247	2	100	0	1	247	1227657	1227903	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	247	446	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
22266516	22266516	PRJNA611476_P_NODE_34058_length_358_cov_1.315789_g33267_i0	PRJNA611476	34058	358	1.315789	4.71052462	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	662	0	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g33267	i0	100	1	358	0	100	0	1	358	671883	672240	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	358	662	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
22267132	22267132	PRJNA611476_P_NODE_79418_length_251_cov_0.865169_g78627_i0	PRJNA611476	79418	251	0.865169	2.17157419	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	414	2.52e-111	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g78627	i0	96.414	51.2629482071713	251	9	100	0	1	251	322961	322711	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	12867	414	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
22267320	22267320	PRJNA611476_P_NODE_92278_length_248_cov_0.880000_g91487_i0	PRJNA611476	92278	248	0.88	2.1824	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g91487	i0	98.79	1	248	3	100	0	1	248	1752440	1752193	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	248	442	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
23542232	23542232	PRJNA611476_P_NODE_64039_length_278_cov_1.087805_g63248_i0	PRJNA611476	64039	278	1.087805	3.0240979	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	503	5.88e-138	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g63248	i0	99.281	1	278	2	100	0	1	278	66625	66348	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	278	503	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
24816078	24816078	PRJNA611476_P_NODE_65960_length_274_cov_1.388060_g65169_i0	PRJNA611476	65960	274	1.38806	3.8032844	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	501	2.08e-137	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g65169	i0	99.635	1	274	1	100	0	1	274	1924484	1924211	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	274	501	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus

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