metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1120586" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1120586" 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
6131154	6131154	PRJNA1120586_P_NODE_10705_length_373_cov_1.881579_g10514_i0	PRJNA1120586	10705	373	1.881579	7.01828967	Truepera	332248	Bacteria	Bacteria	592	1.6899999999999999e-164	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g10514	i0	95.652	173.069705093834	368	16	99	0	6	373	1796	2163	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	64555	592	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6131198	6131198	PRJNA1120586_P_NODE_1865_length_754_cov_3.899270_g1695_i0	PRJNA1120586	1865	754	3.89927	29.4004958	Deinococcus	1298	Bacteria	Bacteria	1144	0	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g1695	i0	94.055	210.594164456233	757	40	100	4	1	754	511	1265	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	158788	1144	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
6654269	6654269	PRJNA1120586_P_NODE_52226_length_226_cov_0.917197_g52035_i0	PRJNA1120586	52226	226	0.917197	2.07286522	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	381	2.259999999999999e-101	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g52035	i0	97.321	2.32300884955752	224	6	99	0	1	224	169837	170060	Deinococcus sp. NW-56 chromosome, complete genome	blastn	525	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
7406200	7406200	PRJNA1120586_P_NODE_22246_length_288_cov_2.214612_g22055_i0	PRJNA1120586	22246	288	2.214612	6.37808256	Deinococcus	1298	Bacteria	Bacteria	292	1.44e-74	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g22055	i0	87.209	190.628472222222	258	31	89	2	1	257	26	282	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	54901	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7929335	7929335	PRJNA1120586_P_NODE_54447_length_214_cov_44.958621_g54256_i0	PRJNA1120586	54447	214	44.958621	96.21144894	Deinococcus aetherius	200252	Bacteria	Bacteria	143	1.09e-29	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g54256	i0	79.279	9.54672897196262	222	32	100	11	1	214	822913	823128	Deinococcus aetherius ST0316 DNA, complete genome	blastn	2043	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
8681515	8681515	PRJNA1120586_P_NODE_17587_length_312_cov_3.934156_g17396_i0	PRJNA1120586	17587	312	3.934156	12.27456672	root	1	Root_unresolved	Root_unresolved	95.3	4.78e-15	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g17396	i0	91.549	6.53846153846154	71	3	22	3	5	73	2141052	2141121	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	2040	95.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
10479637	10479637	PRJNA1120586_P_NODE_30049_length_260_cov_3.486911_g29858_i0	PRJNA1120586	30049	260	3.486911	9.0659686	Deinococcus metallilatus	1211322	Bacteria	Bacteria	390	4.419999999999999e-104	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g29858	i0	93.893	326.323076923077	262	10	100	5	1	260	329116	328859	Deinococcus metallilatus strain MA1002 chromosome	blastn	84844	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
13029450	13029450	PRJNA1120586_P_NODE_1231_length_898_cov_2.726176_g1087_i0	PRJNA1120586	1231	898	2.726176	24.48106048	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1195	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g1087	i0	90.858	479.821826280624	897	75	99	5	8	898	8227	7332	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	430880	1195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
14304980	14304980	PRJNA1120586_P_NODE_36572_length_242_cov_3.028902_g36381_i0	PRJNA1120586	36572	242	3.028902	7.32994284	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g36381	i0	100	193.190082644628	242	0	100	0	1	242	75838	76079	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	46752	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
21953246	21953246	PRJNA1120586_P_NODE_5438_length_484_cov_4.110843_g5248_i0	PRJNA1120586	5438	484	4.110843	19.89648012	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	863	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g5248	i0	98.768	215.227272727273	487	3	100	1	1	484	73747	73261	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	104170	863	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
23228770	23228770	PRJNA1120586_P_NODE_7119_length_436_cov_1.901907_g6928_i0	PRJNA1120586	7119	436	1.901907	8.29231452	Deinococcus puniceus	1182568	Bacteria	Bacteria	586	9.339999999999998e-163	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g6928	i0	91.455	378.717889908257	433	28	99	9	2	431	71443	71017	Deinococcus puniceus strain DY1, complete genome	blastn	165121	586	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus

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