metadata: contig_metadata: 13 rows where bioproject = "PRJNA358490" and tax

13 rows where bioproject = "PRJNA358490" 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
1073225	1073225	PRJNA358490_P_NODE_18181_length_152_cov_1.070796_g17837_i0	PRJNA358490	18181	152	1.070796	1.62760992	Deinococcus	1298	Bacteria	Bacteria	254	3.17e-63	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g17837	i0	96.711	21.1644736842105	152	5	100	0	1	152	2197253	2197404	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	3217	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
2949500	2949500	PRJNA358490_P_NODE_10103_length_327_cov_4.406250_g9761_i0	PRJNA358490	10103	327	4.40625	14.4084375	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	525	1.5099999999999994e-144	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g9761	i0	96.815	217.409785932722	314	10	96	0	14	327	1362530	1362217	Deinococcus sp. QL22 chromosome, complete genome	blastn	71093	525	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
2949684	2949684	PRJNA358490_P_NODE_5523_length_578_cov_1.636364_g5222_i0	PRJNA358490	5523	578	1.636364	9.45818392	Deinococcus aquaticus	328692	Bacteria	Bacteria	80.5	2.6200000000000003e-10	NTclustered	gi\|2444124408\|gb\|CP115168.1\|	328692	g5222	i0	90.164	0.105536332179931	61	6	11	0	110	170	71934	71994	Deinococcus aquaticus strain PB-314 plasmid pDATS03, complete sequence	blastn	61	80.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4901175	4901175	PRJNA358490_P_NODE_1844_length_1031_cov_3.949597_g1710_i0	PRJNA358490	1844	1031	3.949597	40.72034507	Deinococcus	1298	Bacteria	Bacteria	1459	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g1710	i0	93.214	199.229873908826	1002	53	96	13	15	1007	1630	635	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	205406	1459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
8052267	8052267	PRJNA358490_P_NODE_18007_length_153_cov_1.052632_g17663_i0	PRJNA358490	18007	153	1.052632	1.61052696	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	274	2.4599999999999997e-69	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g17663	i0	99.338	197.849673202614	151	1	100	0	1	151	630513	630363	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	30271	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8725903	8725903	PRJNA358490_P_NODE_8467_length_413_cov_2.780749_g8126_i0	PRJNA358490	8467	413	2.780749	11.48449337	Deinococcus	1298	Bacteria	Bacteria	597	4.069999999999999e-166	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g8126	i0	93.366	166.261501210654	407	21	98	6	10	413	71330	70927	Deinococcus puniceus strain DY1, complete genome	blastn	68666	603	0.990049751243781	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
8725907	8725907	PRJNA358490_P_NODE_8847_length_395_cov_1.516854_g8506_i0	PRJNA358490	8847	395	1.516854	5.9915733	Deinococcus	1298	Bacteria	Bacteria	616	1.0699999999999998e-171	NTclustered	gi\|2155018471\|emb\|OV024757.1\|	1299	g8506	i0	96.267	20.0177215189873	375	14	95	0	1	375	1625099	1625473	Deinococcus radiodurans isolate DRR11 genome assembly, chromosome: 1	blastn	7907	616	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
15101007	15101007	PRJNA358490_P_NODE_18032_length_152_cov_3.247788_g17688_i0	PRJNA358490	18032	152	3.247788	4.93663776	Deinococcus	1298	Bacteria	Bacteria	268	1.13e-67	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g17688	i0	98.675	232.263157894737	151	2	99	0	2	152	70495	70645	Deinococcus swuensis strain DY59, complete genome	blastn	35304	268	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
19524740	19524740	PRJNA358490_P_NODE_10436_length_310_cov_3.199262_g10094_i0	PRJNA358490	10436	310	3.199262	9.9177122	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	182	3.5399999999999987e-41	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g10094	i0	80.658	1.51290322580645	243	39	77	6	27	265	3342614	3342852	Deinococcus sp. AJ005 chromosome, complete genome	blastn	469	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
20800542	20800542	PRJNA358490_P_NODE_3297_length_787_cov_66.588235_g3085_i0	PRJNA358490	3297	787	66.588235	524.04940945	Deinococcus yunweiensis	367282	Bacteria	Bacteria	1177	0	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g3085	i0	94.517	95.4904701397713	766	36	97	6	5	767	2654145	2654907	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	75151	1177	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
21474881	21474881	PRJNA358490_P_NODE_15877_length_171_cov_1.848485_g15533_i0	PRJNA358490	15877	171	1.848485	3.16090935	Truepera	332248	Bacteria	Bacteria	206	1.04e-48	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g15533	i0	94.074	52.625730994152	135	8	79	0	17	151	2580546	2580680	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	8999	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21474917	21474917	PRJNA358490_P_NODE_4177_length_691_cov_3.707055_g1710_i1	PRJNA358490	4177	691	3.707055	25.61575005	Deinococcus	1298	Bacteria	Bacteria	1027	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g1710	i1	94.478	205.141823444284	670	31	97	6	1	667	1301	635	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	141753	1027	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
22750030	22750030	PRJNA358490_P_NODE_13758_length_203_cov_2.713415_g13414_i0	PRJNA358490	13758	203	2.713415	5.50823245	Truepera	332248	Bacteria	Bacteria	300	5.72e-77	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g13414	i0	93.532	588.187192118227	201	13	99	0	1	201	8	208	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	119402	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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