metadata: contig_metadata: 20 rows where bioproject = "PRJNA1126198", tax_kingdom = "Thermotogati" and tax

20 rows where bioproject = "PRJNA1126198", tax_kingdom = "Thermotogati" and tax_phylum = "Deinococcota"

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
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
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
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
13035069	13035069	PRJNA1126198_P_NODE_286071_length_269_cov_1.352041_g285350_i0	PRJNA1126198	286071	269	1.352041	3.63699029	uncultured Truepera sp.	543023	Bacteria	Bacteria	127	4.06e-33	NR	CAA9584620.1	543023	g285350	i0	73.9	1.96282527881041	88	22	98.1	1	269	6	35	121	CAA9584620.1 MAG: putative ATP/GTP-binding integral membrane protein [uncultured Truepera sp.]	diamond	528	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
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
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
32662284	32662284	PRJNA1126198_P_NODE_450960_length_244_cov_0.883041_g450239_i0	PRJNA1126198	450960	244	0.883041	2.15462004	Deinococcota bacterium	1913990	Bacteria	Bacteria	60.5	5.5e-10	NR	MEM7737363.1	1913990	g450239	i0	52.7	0.676229508196721	55	26	67.6	0	243	79	11	65	MEM7737363.1 hypothetical protein [Deinococcota bacterium]	diamond	165	60.5	1	Bacteria	Thermotogati	Deinococcota					Deinococcota 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);;