metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1126198" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
1555846	1555846	PRJNA1126198_P_NODE_213942_length_288_cov_1.451163_g213221_i0	PRJNA1126198	213942	288	1.451163	4.17934944	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	499	7.92e-137	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g213221	i0	98.246	1.98958333333333	285	5	99	0	1	285	2439763	2440047	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	573	499	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
2305771	2305771	PRJNA1126198_P_NODE_407482_length_248_cov_0.885714_g406761_i0	PRJNA1126198	407482	248	0.885714	2.19657072	Fervidobacterium	2422	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g406761	i0	98.79	2	248	3	100	0	1	248	1839748	1839995	Fervidobacterium pennivorans strain DYC, complete genome	blastn	496	442	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
2832191	2832191	PRJNA1126198_P_NODE_369483_length_252_cov_0.871508_g368762_i0	PRJNA1126198	369483	252	0.871508	2.19620016	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g368762	i0	99.605	2.00793650793651	253	0	100	1	1	252	1368017	1368269	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	506	460	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
4858287	4858287	PRJNA1126198_P_NODE_24184_length_470_cov_2.282116_g23483_i0	PRJNA1126198	24184	470	2.282116	10.7259452	Thermus	270	Bacteria	Bacteria	846	0	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g23483	i0	99.149	146.614893617021	470	4	100	0	1	470	490	21	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	68909	846	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
5384195	5384195	PRJNA1126198_P_NODE_104665_length_339_cov_1.631579_g103946_i0	PRJNA1126198	104665	339	1.631579	5.53105281	Trueperaceae bacterium	2026798	Bacteria	Bacteria	505	2.0399999999999995e-138	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g103946	i0	93.75	473.271386430678	336	21	99	0	3	338	2559348	2559683	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	160439	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
5384578	5384578	PRJNA1126198_P_NODE_315485_length_262_cov_1.629630_g314764_i0	PRJNA1126198	315485	262	1.62963	4.2696306	Thermus brockianus	56956	Bacteria	Bacteria	346	9.789999999999999e-91	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g314764	i0	90.637	36.8167938931298	267	16	99	6	1	261	1029807	1029544	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	9646	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
6659060	6659060	PRJNA1126198_P_NODE_219806_length_286_cov_2.056338_g219085_i0	PRJNA1126198	219806	286	2.0563380000000002	5.88112668	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	305	1.84e-78	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g219085	i0	88.417	7.44405594405594	259	23	88	5	33	285	1538450	1538193	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	2129	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
7408309	7408309	PRJNA1126198_P_NODE_427506_length_246_cov_0.901734_g426785_i0	PRJNA1126198	427506	246	0.901734	2.21826564	Deinococcus	1298	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g426785	i0	100	2	246	0	100	0	1	246	390628	390383	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	492	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
8683639	8683639	PRJNA1126198_P_NODE_460427_length_243_cov_0.905882_g459706_i0	PRJNA1126198	460427	243	0.905882	2.20129326	Fervidobacterium	2422	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g459706	i0	100	6.32510288065844	243	0	100	0	1	243	1259812	1259570	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1537	449	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
9958461	9958461	PRJNA1126198_P_NODE_290088_length_268_cov_1.405128_g289367_i0	PRJNA1126198	290088	268	1.405128	3.76574304	Fervidobacterium	2422	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g289367	i0	100	5	268	0	100	0	1	268	1309044	1308777	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1340	496	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
9958628	9958628	PRJNA1126198_P_NODE_454808_length_243_cov_1.411765_g454087_i0	PRJNA1126198	454808	243	1.411765	3.43058895	Fervidobacterium	2422	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g454087	i0	100	2	243	0	100	0	1	243	287552	287794	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	486	449	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
10485184	10485184	PRJNA1126198_P_NODE_428469_length_246_cov_0.895954_g427748_i0	PRJNA1126198	428469	246	0.895954	2.20404684	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g427748	i0	99.187	11.0934959349593	246	2	100	0	1	246	1811719	1811474	Thermus sp. NEB1569 chromosome, complete genome	blastn	2729	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
11760189	11760189	PRJNA1126198_P_NODE_395670_length_249_cov_0.886364_g394949_i0	PRJNA1126198	395670	249	0.886364	2.20704636	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g394949	i0	99.197	4.97991967871486	249	2	100	0	1	249	2583020	2582772	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	1240	449	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
11760332	11760332	PRJNA1126198_P_NODE_450250_length_244_cov_0.900585_g449529_i0	PRJNA1126198	450250	244	0.900585	2.1974274	Thermus antranikianii	88190	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g449529	i0	100	9.08196721311475	244	0	100	0	1	244	508664	508907	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	2216	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
12509246	12509246	PRJNA1126198_P_NODE_463490_length_242_cov_1.846154_g462769_i0	PRJNA1126198	463490	242	1.846154	4.46769268	Thermus	270	Bacteria	Bacteria	399	6.759999999999999e-107	NTclustered	gi\|2074865435\|dbj\|AP024937.1\|	274	g462769	i0	97.046	43.2809917355372	237	7	98	0	6	242	1489319	1489555	Thermus thermophilus AK1 DNA, complete genome	blastn	10474	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
13035455	13035455	PRJNA1126198_P_NODE_459611_length_243_cov_0.911765_g458890_i0	PRJNA1126198	459611	243	0.911765	2.21558895	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g458890	i0	99.588	2	243	1	100	0	1	243	586527	586769	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	486	444	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
13783622	13783622	PRJNA1126198_P_NODE_272531_length_272_cov_1.567839_g271810_i0	PRJNA1126198	272531	272	1.567839	4.26452208	Fervidobacterium	2422	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g271810	i0	100	5.01470588235294	272	0	100	0	1	272	2057724	2057995	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1364	503	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
15584632	15584632	PRJNA1126198_P_NODE_451093_length_244_cov_0.871345_g450372_i0	PRJNA1126198	451093	244	0.871345	2.1260818	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	313	9.139999999999999e-81	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g450372	i0	89.754	44.655737704918	244	25	100	0	1	244	1470694	1470451	Thermus sp. NEB1569 chromosome, complete genome	blastn	10896	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
15584703	15584703	PRJNA1126198_P_NODE_479073_length_236_cov_3.521472_g478352_i0	PRJNA1126198	479073	236	3.521472	8.31067392	Deinococcus grandis	57498	Bacteria	Bacteria	329	8.73e-86	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g478352	i0	91.915	0.995762711864407	235	19	99	0	1	235	353328	353094	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	235	329	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
19407121	19407121	PRJNA1126198_P_NODE_218976_length_287_cov_1.074766_g218255_i0	PRJNA1126198	218976	287	1.074766	3.08457842	Trueperaceae bacterium	2026798	Bacteria	Bacteria	379	1.07e-100	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g218255	i0	90.559	494.578397212544	286	27	99	0	1	286	3599968	3599683	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	141944	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
19407598	19407598	PRJNA1126198_P_NODE_449956_length_244_cov_0.900585_g449235_i0	PRJNA1126198	449956	244	0.900585	2.1974274	Deinococcus sp. D7000	2755035	Bacteria	Bacteria	337	5.429999999999998e-88	NTclustered	gi\|1868561018\|gb\|CP058534.1\|	2755035	g449235	i0	91.736	4.75409836065574	242	20	99	0	2	243	1174693	1174934	Deinococcus sp. D7000 chromosome, complete genome	blastn	1160	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. D7000
20682673	20682673	PRJNA1126198_P_NODE_214497_length_288_cov_1.432558_g213776_i0	PRJNA1126198	214497	288	1.432558	4.12576704	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g213776	i0	99.653	14.6666666666667	288	1	100	0	1	288	1970703	1970416	Thermus sp. NEB1569 chromosome, complete genome	blastn	4224	527	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
21957998	21957998	PRJNA1126198_P_NODE_204438_length_291_cov_1.422018_g203718_i0	PRJNA1126198	204438	291	1.422018	4.13807238	Deinococcus sonorensis	309891	Bacteria	Bacteria	235	2.4899999999999997e-57	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g203718	i0	86.73	2.30584192439863	211	28	73	0	1	211	110039	110249	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	671	235	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
21958425	21958425	PRJNA1126198_P_NODE_408898_length_248_cov_0.880000_g408177_i0	PRJNA1126198	408898	248	0.88	2.1824	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g408177	i0	97.581	2.00806451612903	248	6	100	0	1	248	176976	176729	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	498	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
23233877	23233877	PRJNA1126198_P_NODE_376779_length_251_cov_0.876404_g376058_i0	PRJNA1126198	376779	251	0.876404	2.19977404	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g376058	i0	99.602	2	251	1	100	0	1	251	2126263	2126013	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	502	459	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
23233909	23233909	PRJNA1126198_P_NODE_385959_length_250_cov_0.881356_g385238_i0	PRJNA1126198	385959	250	0.881356	2.20339	Thermus parvatiensis	456163	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g385238	i0	98.8	44.864	250	3	100	0	1	250	6732	6981	Thermus parvatiensis strain RL, complete genome	blastn	11216	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
23982763	23982763	PRJNA1126198_P_NODE_475679_length_239_cov_2.704819_g474958_i0	PRJNA1126198	475679	239	2.704819	6.46451741	Deinococcus	1298	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g474958	i0	99.583	203.991631799163	240	0	100	1	1	239	1793389	1793628	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	48754	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
24507668	24507668	PRJNA1126198_P_NODE_448980_length_244_cov_0.906433_g448259_i0	PRJNA1126198	448980	244	0.906433	2.21169652	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	390	4.11e-104	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g448259	i0	95.492	89.2295081967213	244	11	100	0	1	244	1536680	1536437	Thermus sp. NEB1569 chromosome, complete genome	blastn	21772	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569

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