metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Thermomicrobiota"

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
25503923	25503923	PRJEB14175_P_NODE_162169_length_262_cov_32.099502_g159902_i0	PRJEB14175	162169	262	32.099502	84.10069524	Sphaerobacter thermophilus DSM 2	2057	Bacteria	Bacteria	128	3.86e-25	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g159902	i0	82.667	1.34732824427481	150	21	55	4	71	215	1711214	1711065	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	353	128	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25611598	25611598	PRJEB14175_P_NODE_91961_length_376_cov_11.685714_g89695_i0	PRJEB14175	91961	376	11.685714	43.93828464	Sphaerobacter	2056	Bacteria	Bacteria	185	3.38e-42	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g89695	i0	79.181	97.6090425531915	293	42	74	15	27	303	10	299	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	36701	185	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25644659	25644659	PRJEB14175_P_NODE_280466_length_167_cov_6.084906_g278198_i0	PRJEB14175	280466	167	6.084906	10.16179302	Sphaerobacter thermophilus DSM 2	2057	Bacteria	Bacteria	128	2.26e-25	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g278198	i0	97.333	12.0658682634731	75	2	45	0	63	137	1771815	1771889	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	2015	128	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25745887	25745887	PRJEB14175_P_NODE_244970_length_204_cov_22.783217_g242702_i0	PRJEB14175	244970	204	22.783217	46.47776268	Bacteria	2	Bacteria	Bacteria	111	2.89e-20	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g242702	i0	93.421	15.6470588235294	76	4	37	1	33	108	581478	581404	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	3192	111	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25781891	25781891	PRJEB14175_P_NODE_47227_length_543_cov_5.493776_g45001_i0	PRJEB14175	47227	543	5.493776	29.83120368	Sphaerobacter thermophilus DSM 2	2057	Bacteria	Bacteria	202	5.01e-47	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g45001	i0	75.089	19.4567219152855	562	75	95	45	22	536	1710790	1711333	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	10565	202	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25881273	25881273	PRJEB14175_P_NODE_223675_length_211_cov_1.706667_g221407_i0	PRJEB14175	223675	211	1.706667	3.60106737	root	1	Root_unresolved	Root_unresolved	75	3.96e-9	NTclustered	gi\|57434210\|emb\|AJ871226.1\|	2057	g221407	i0	100	18.957345971564	40	0	19	0	172	211	210	171	Sphaerobacter thermophilus partial 16S rRNA gene, clone 165-7	blastn	4000	75	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
26017939	26017939	PRJEB14175_P_NODE_24396_length_746_cov_45.181022_g22433_i0	PRJEB14175	24396	746	45.181022	337.05042412	Sphaerobacter	2056	Bacteria	Bacteria	342	3.96e-89	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g22433	i0	77.833	30.8002680965147	609	97	78	28	143	725	610	14	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	22977	342	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
26153482	26153482	PRJEB14175_P_NODE_214269_length_217_cov_12.089744_g212002_i0	PRJEB14175	214269	217	12.089744	26.23474448	Thermomicrobium	499	Bacteria	Bacteria	219	1.7899999999999998e-52	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g212002	i0	90.798	187.649769585253	163	15	75	0	54	216	1696	1858	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	40720	219	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
26184612	26184612	PRJEB14175_P_NODE_166902_length_257_cov_36.056122_g164635_i0	PRJEB14175	166902	257	36.056122	92.66423354	Sphaerobacter thermophilus DSM 2	2057	Bacteria	Bacteria	69.4	2.32e-7	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g164635	i0	92	13.1206225680934	50	3	19	1	30	78	1085437	1085486	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	3372	69.4	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
26287623	26287623	PRJEB14175_P_NODE_114470_length_329_cov_4.578358_g112204_i0	PRJEB14175	114470	329	4.578358	15.06279782	Sphaerobacter	2056	Bacteria	Bacteria	119	3.01e-22	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g112204	i0	74.684	18.6534954407295	316	57	92	14	23	326	206	510	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	6137	119	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
26559628	26559628	PRJEB14175_P_NODE_119392_length_320_cov_35.389961_g117126_i0	PRJEB14175	119392	320	35.389961	113.2478752	Sphaerobacter	2056	Bacteria	Bacteria	130	1.35e-25	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g117126	i0	79.208	205.6375	202	30	59	6	110	299	268	67	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	65804	130	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
26562703	26562703	PRJEB14175_P_NODE_33456_length_644_cov_25.204117_g31328_i0	PRJEB14175	33456	644	25.204117	162.31451348	Sphaerobacter	2056	Bacteria	Bacteria	368	5.599999999999998e-97	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g31328	i0	78.993	152.020186335404	576	93	86	20	53	609	590	24	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	97901	368	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus

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