metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB81463" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB81463" 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
997346	997346	PRJEB81463_P_NODE_24561_length_247_cov_0.896552_g24289_i0	PRJEB81463	24561	247	0.896552	2.21448344	Thermus	270	Bacteria	Bacteria	403	5.35e-108	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g24289	i0	96.327	42.6882591093117	245	9	99	0	3	247	1251865	1252109	Thermus scotoductus SA-01, complete genome	blastn	10544	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
2690382	2690382	PRJEB81463_P_NODE_11383_length_301_cov_1.535088_g11111_i0	PRJEB81463	11383	301	1.535088	4.62061488	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	427	3.9799999999999998e-115	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g11111	i0	92.131	221.34219269103	305	20	100	4	1	301	74639	74335	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	66624	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
2690549	2690549	PRJEB81463_P_NODE_21643_length_251_cov_0.876404_g21371_i0	PRJEB81463	21643	251	0.876404	2.19977404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g21371	i0	100	40.0996015936255	251	0	100	0	1	251	1196464	1196714	Thermus sp. NEB1569 chromosome, complete genome	blastn	10065	464	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
2690634	2690634	PRJEB81463_P_NODE_27623_length_243_cov_0.917647_g27351_i0	PRJEB81463	27623	243	0.917647	2.22988221	Thermus thermophilus	274	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|333967597\|gb\|CP002778.1\|	762633	g27351	i0	99.177	15.8930041152263	243	2	100	0	1	243	28617	28859	Thermus thermophilus SG0.5JP17-16 plasmid pTHTHE1601, complete sequence	blastn	3862	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
6100504	6100504	PRJEB81463_P_NODE_18365_length_261_cov_1.058511_g18093_i0	PRJEB81463	18365	261	1.058511	2.76271371	Deinococcus	1298	Bacteria	Bacteria	466	7.17e-127	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g18093	i0	98.851	200.674329501916	261	3	100	0	1	261	71609	71869	Deinococcus puniceus strain DY1, complete genome	blastn	52376	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6518772	6518772	PRJEB81463_P_NODE_27646_length_243_cov_0.917647_g27374_i0	PRJEB81463	27646	243	0.917647	2.22988221	Thermus thermophilus	274	Bacteria	Bacteria	416	6.739999999999998e-112	NTclustered	gi\|2199618903\|dbj\|AP025609.1\|	274	g27374	i0	97.531	43.2551440329218	243	6	100	0	1	243	676112	675870	Thermus thermophilus SNM3-3 DNA, complete genome	blastn	10511	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
7374862	7374862	PRJEB81463_P_NODE_12246_length_292_cov_1.296804_g11974_i0	PRJEB81463	12246	292	1.296804	3.78666768	Thermus	270	Bacteria	Bacteria	529	1.0299999999999996e-145	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g11974	i0	99.315	38.3047945205479	292	2	100	0	1	292	1348603	1348894	Thermus parvatiensis strain RL, complete genome	blastn	11185	529	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
7792742	7792742	PRJEB81463_P_NODE_22147_length_250_cov_0.881356_g21875_i0	PRJEB81463	22147	250	0.881356	2.20339	Thermus thermophilus	274	Bacteria	Bacteria	327	3.36e-85	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g21875	i0	98.907	43.536	183	2	100	0	68	250	1274920	1274738	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	10884	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
10343481	10343481	PRJEB81463_P_NODE_22829_length_249_cov_0.886364_g22557_i0	PRJEB81463	22829	249	0.886364	2.20704636	Thermus thermophilus	274	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g22557	i0	97.189	37.0120481927711	249	7	100	0	1	249	636332	636580	Thermus thermophilus AA2-29 DNA, complete genome	blastn	9216	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
11200626	11200626	PRJEB81463_P_NODE_13489_length_285_cov_1.396226_g13217_i0	PRJEB81463	13489	285	1.396226	3.9792441	Thermus	270	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g13217	i0	99.649	39.8912280701754	285	1	100	0	1	285	1586196	1585912	Thermus thermophilus TF27 DNA, complete genome	blastn	11369	521	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12476341	12476341	PRJEB81463_P_NODE_9210_length_332_cov_1.285714_g8938_i0	PRJEB81463	9210	332	1.285714	4.26857048	Thermus	270	Bacteria	Bacteria	603	6.889999999999997e-168	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g8938	i0	99.399	40.9789156626506	333	1	100	1	1	332	1965455	1965787	Thermus thermophilus HB5008 DNA, complete genome	blastn	13605	603	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
12893917	12893917	PRJEB81463_P_NODE_16391_length_270_cov_1.309645_g16119_i0	PRJEB81463	16391	270	1.309645	3.5360415	Thermus scotoductus	37636	Bacteria	Bacteria	483	7.409999999999998e-132	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g16119	i0	98.889	8.26296296296296	270	3	100	0	1	270	2227258	2226989	Thermus scotoductus SA-01, complete genome	blastn	2231	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
17992016	17992016	PRJEB81463_P_NODE_22855_length_249_cov_0.886364_g22583_i0	PRJEB81463	22855	249	0.886364	2.20704636	Thermus parvatiensis	456163	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g22583	i0	99.598	39	249	1	100	0	1	249	1590750	1590998	Thermus parvatiensis strain RL, complete genome	blastn	9711	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
18849102	18849102	PRJEB81463_P_NODE_25755_length_245_cov_0.906977_g25483_i0	PRJEB81463	25755	245	0.906977	2.22209365	Thermus	270	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g25483	i0	98.776	37.7061224489796	245	3	100	0	1	245	485466	485710	Thermus parvatiensis strain RL, complete genome	blastn	9238	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
19265911	19265911	PRJEB81463_P_NODE_18536_length_260_cov_1.315508_g18264_i0	PRJEB81463	18536	260	1.315508	3.4203208	Thermus scotoductus	37636	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g18264	i0	99.231	8.00769230769231	260	2	100	0	1	260	346490	346749	Thermus scotoductus SA-01, complete genome	blastn	2082	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
20541480	20541480	PRJEB81463_P_NODE_24897_length_246_cov_1.554913_g24625_i0	PRJEB81463	24897	246	1.554913	3.82508598	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g24625	i0	84.647	3.76829268292683	241	35	98	2	7	246	1552572	1552811	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	927	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
21817483	21817483	PRJEB81463_P_NODE_9258_length_331_cov_1.344961_g8986_i0	PRJEB81463	9258	331	1.344961	4.45182091	Thermus thermophilus	274	Bacteria	Bacteria	593	4.129999999999999e-165	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g8986	i0	99.091	405.848942598187	330	3	99	0	2	331	890397	890726	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	134336	593	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
22674248	22674248	PRJEB81463_P_NODE_19058_length_257_cov_1.695652_g18786_i0	PRJEB81463	19058	257	1.695652	4.35782564	Thermus	270	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2074862859\|dbj\|AP024933.1\|	274	g18786	i0	99.611	73.0272373540856	257	1	100	0	1	257	1272022	1271766	Thermus thermophilus AA3-7 DNA, complete genome	blastn	18768	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23092266	23092266	PRJEB81463_P_NODE_14479_length_280_cov_1.130435_g14207_i0	PRJEB81463	14479	280	1.130435	3.165218	Thermus aquaticus	271	Bacteria	Bacteria	287	6.5e-73	NTclustered	gi\|939575858\|gb\|CP010824.1\|	498848	g14207	i0	95.531	67.3928571428571	179	8	65	0	102	280	8094	7916	Thermus aquaticus Y51MC23 plasmid pTA16, complete sequence	blastn	18870	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
24366268	24366268	PRJEB81463_P_NODE_20600_length_252_cov_1.776536_g20328_i0	PRJEB81463	20600	252	1.776536	4.47687072	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	394	3.3e-105	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g20328	i0	94.882	218.396825396825	254	10	100	3	1	252	544622	544874	Deinococcus sp. NW-56 chromosome, complete genome	blastn	55036	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
24366303	24366303	PRJEB81463_P_NODE_23400_length_248_cov_1.611429_g23128_i0	PRJEB81463	23400	248	1.611429	3.99634392	Thermus thermophilus	274	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|333965676\|gb\|CP002777.1\|	762633	g23128	i0	100	35.0766129032258	248	0	100	0	1	248	671722	671475	Thermus thermophilus SG0.5JP17-16, complete genome	blastn	8699	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus 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);;