metadata: contig_metadata: 17 rows where bioproject = "PRJNA1010662" and tax

17 rows where bioproject = "PRJNA1010662" 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
2705213	2705213	PRJNA1010662_S_NODE_2483_length_208_cov_5.600000_g2438_i0	PRJNA1010662	2483	208	5.6	11.648	Deinococcus puniceus	1182568	Bacteria	Bacteria	331	2.0900000000000002e-86	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g2438	i0	95.652	199.389423076923	207	8	99	1	1	207	72026	71821	Deinococcus puniceus strain DY1, complete genome	blastn	41473	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6104621	6104621	PRJNA1010662_P_NODE_9445_length_188_cov_1.899281_g9386_i0	PRJNA1010662	9445	188	1.899281	3.57064828	Deinococcus	1298	Bacteria	Bacteria	320	4e-83	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9386	i0	100	216.56914893617	173	0	92	0	16	188	1793549	1793377	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	40715	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7379023	7379023	PRJNA1010662_P_NODE_4626_length_247_cov_1.722222_g4567_i0	PRJNA1010662	4626	247	1.722222	4.25388834	Deinococcus	1298	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g4567	i0	100	133.846153846154	247	0	100	0	1	247	788	542	D.radiodurans 16S ribosomal RNA gene	blastn	33060	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9082403	9082403	PRJNA1010662_P_NODE_4148_length_259_cov_1.728571_g4089_i0	PRJNA1010662	4148	259	1.728571	4.47699889	uncultured Deinococcota bacterium	179882	Bacteria	Bacteria	440	4.309999999999998e-119	NTclustered	gi\|134152601\|dbj\|AB265894.2\|	179882	g4089	i0	97.308	100.181467181467	260	6	100	1	1	259	355	96	Uncultured Thermus/Deinococcus group bacterium gene for 16S rRNA, partial sequence, clone: LH-71	blastn	25947	440	1	Bacteria	Thermotogati	Deinococcota					uncultured Deinococcota bacterium
9082475	9082475	PRJNA1010662_S_NODE_228_length_541_cov_26.610442_g185_i0	PRJNA1010662	228	541	26.610442	143.96249122	Deinococcus radiophilus	32062	Bacteria	Bacteria	944	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g185	i0	98.866	96.7153419593346	529	6	98	0	1	529	203145	202617	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	52323	944	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
10358113	10358113	PRJNA1010662_S_NODE_4509_length_163_cov_5.458333_g4464_i0	PRJNA1010662	4509	163	5.458333	8.89708279	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	300	4.39e-77	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g4464	i0	100	81.558282208589	162	0	100	0	1	162	2130278	2130117	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	13294	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12480261	12480261	PRJNA1010662_P_NODE_16670_length_162_cov_0.920354_g16611_i0	PRJNA1010662	16670	162	0.920354	1.49097348	Deinococcus	1298	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g16611	i0	100	8	162	0	100	0	1	162	307021	306860	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	1296	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
13754840	13754840	PRJNA1010662_P_NODE_371_length_814_cov_2.060131_g328_i0	PRJNA1010662	371	814	2.060131	16.76946634	Deinococcus	1298	Bacteria	Bacteria	1441	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g328	i0	98.649	357.19656019656	814	10	100	1	1	814	1792805	1791993	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	290758	1441	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
20556103	20556103	PRJNA1010662_P_NODE_6677_length_215_cov_1.132530_g6618_i0	PRJNA1010662	6677	215	1.13253	2.4349395	Bacteria	2	Bacteria	Bacteria	125	1.99e-31	NR	WP_337870273.1	1955249	g6618	i0	83.1	17.693023255814	71	12	99.1	0	214	2	689	759	WP_337870273.1 aminomethyl-transferring glycine dehydrogenase [Meiothermus sp.]	diamond	3804	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
21403590	21403590	PRJNA1010662_S_NODE_657_length_351_cov_28.435065_g612_i0	PRJNA1010662	657	351	28.435065	99.80707815	Deinococcus	1298	Bacteria	Bacteria	625	1.5599999999999998e-174	NTclustered	gi\|2549460888\|gb\|OR304356.1\|	32062	g612	i0	98.864	104.019943019943	352	0	99	3	2	351	764	415	Deinococcus radiophilus strain LMITABS01070 16S ribosomal RNA gene, partial sequence	blastn	36511	625	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
22678330	22678330	PRJNA1010662_S_NODE_698_length_339_cov_18.327703_g653_i0	PRJNA1010662	698	339	18.327703	62.13091317	Deinococcus	1298	Bacteria	Bacteria	608	1.509999999999999e-169	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g653	i0	99.115	134	339	1	99	2	2	339	816	479	D.radiodurans 16S ribosomal RNA gene	blastn	45426	608	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
29837389	29837389	PRJNA1010662_P_NODE_2011_length_358_cov_1.326861_g1952_i0	PRJNA1010662	2011	358	1.326861	4.75016238	Bacteria	2	Bacteria	Bacteria	166	1.13e-45	NR	WP_345455539.1	1656885	g1952	i0	66.1	20.7653631284916	118	40	98.9	0	5	358	209	326	WP_345455539.1 NAD-dependent malic enzyme [Deinococcus aluminii]	diamond	7434	166	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aluminii
30824373	30824373	PRJNA1010662_P_NODE_11394_length_175_cov_1.579365_g11335_i0	PRJNA1010662	11394	175	1.579365	2.76388875	Thermotoga sp. Ku-13t	1755813	Bacteria	Bacteria	69.7	6.73e-13	NR	WP_165275142.1	1755813	g11335	i0	64.7	0.874285714285714	51	18	87.4	0	156	4	119	169	WP_165275142.1 macro domain-containing protein [Thermotoga sp. Ku-13t]	diamond	153	69.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp. Ku-13t
31164159	31164159	PRJNA1010662_P_NODE_555_length_667_cov_2.281553_g504_i0	PRJNA1010662	555	667	2.281553	15.21795851	root	1	Root_unresolved	Root_unresolved	103	2.5e-24	NR	WP_128080917.1	2335	g504	i0	45.6	5.84257871064468	125	60	55.3	4	539	171	6	124	WP_128080917.1 MULTISPECIES: glycine cleavage system protein GcvH [Thermotoga]	diamond	3897	104	0.990384615384615	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga
31266864	31266864	PRJNA1010662_P_NODE_13335_length_167_cov_1.576271_g13276_i0	PRJNA1010662	13335	167	1.576271	2.63237257	Deinococcus sp.	47478	Bacteria	Bacteria	71.2	1.14e-12	NR	MBI3962125.1	47478	g13276	i0	55.6	2.94610778443114	54	24	97	0	166	5	262	315	MBI3962125.1 LON peptidase substrate-binding domain-containing protein [Deinococcus sp.]	diamond	492	71.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
32500825	32500825	PRJNA1010662_P_NODE_16299_length_163_cov_0.877193_g16240_i0	PRJNA1010662	16299	163	0.877193	1.42982459	Thermotoga sp. KOL6	126741	Bacteria	Bacteria	59.3	1.8e-8	NR	WP_101510730.1	126741	g16240	i0	51.9	2.98159509202454	54	23	99.4	1	1	162	467	517	WP_101510730.1 AAA family ATPase [Thermotoga sp. KOL6]	diamond	486	59.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp. KOL6
32784174	32784174	PRJNA1010662_P_NODE_4420_length_252_cov_1.522167_g4361_i0	PRJNA1010662	4420	252	1.522167	3.83586084	Deinococcus apachensis	309886	Bacteria	Bacteria	70.9	7.27e-13	NR	WP_019586246.1	309886	g4361	i0	39.1	2.10714285714286	87	49	98.8	1	250	2	57	143	WP_019586246.1 SMI1/KNR4 family protein [Deinococcus apachensis]	diamond	531	70.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus apachensis

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