metadata: contig_metadata: 22 rows where bioproject = "PRJNA1148965" and tax

22 rows where bioproject = "PRJNA1148965" and tax_superkingdom = "Bacteria"

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
1036583	1036583	PRJNA1148965_S_NODE_401_length_309_cov_1.220339_g398_i0	PRJNA1148965	401	309	1.220339	3.77084751	Bacteria	2	Bacteria	Bacteria	503	6.629999999999998e-138	NTclustered	gi\|2501871037\|gb\|CP084890.1\|	287	g398	i0	100	1025.88349514563	272	0	89	0	25	296	7102686	7102415	Pseudomonas aeruginosa strain CH1 chromosome	blastn	316998	503	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
2311813	2311813	PRJNA1148965_S_NODE_122_length_435_cov_12.135359_g119_i0	PRJNA1148965	122	435	12.135359	52.78881165	Pseudomonas	286	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2792427225\|gb\|CP167888.1\|	287	g119	i0	97.143	0.289655172413793	35	0	8	1	16	49	4558687	4558721	Pseudomonas aeruginosa strain 33008169 chromosome	blastn	126	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
2851777	2851777	PRJNA1148965_S_NODE_803_length_245_cov_1.017442_g800_i0	PRJNA1148965	803	245	1.017442	2.4927329	Pseudomonas tolaasii	29442	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|1168987590\|gb\|CP020369.1\|	29442	g800	i0	94.595	0.453061224489796	37	2	19	0	195	231	5489280	5489316	Pseudomonas tolaasii strain 2192T chromosome	blastn	111	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas tolaasii
3586984	3586984	PRJNA1148965_S_NODE_563_length_271_cov_2.116162_g560_i0	PRJNA1148965	563	271	2.116162	5.73479902	Escherichia	561	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g560	i0	100	100	271	0	100	0	1	271	916884	917154	Escherichia coli strain 427603 chromosome, complete genome	blastn	27100	501	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3586985	3586985	PRJNA1148965_S_NODE_63_length_535_cov_1.145022_g61_i0	PRJNA1148965	63	535	1.145022	6.1258677	Enterobacteriaceae	543	Bacteria	Bacteria	989	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g61	i0	100	100	535	0	100	0	1	535	2904855	2905389	Escherichia coli strain Case 2 chromosome, complete genome	blastn	53500	989	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
6139358	6139358	PRJNA1148965_S_NODE_185_length_386_cov_1.015974_g182_i0	PRJNA1148965	185	386	1.015974	3.92165964	Enterobacteriaceae	543	Bacteria	Bacteria	660	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g182	i0	99.722	124.339378238342	360	1	93	0	1	360	2906511	2906870	Escherichia coli strain Case 2 chromosome, complete genome	blastn	47995	660	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
6139359	6139359	PRJNA1148965_S_NODE_45_length_572_cov_1.444890_g43_i0	PRJNA1148965	45	572	1.44489	8.2647708	Enterobacteriaceae	543	Bacteria	Bacteria	1011	0	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g43	i0	100	361.493006993007	547	0	96	0	26	572	3935426	3934880	Escherichia coli strain BW25113 frmA KO chromosome	blastn	206774	1011	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7414403	7414403	PRJNA1148965_S_NODE_766_length_248_cov_0.891429_g763_i0	PRJNA1148965	766	248	0.891429	2.21074392	Enterobacteriaceae	543	Bacteria	Bacteria	418	1.9199999999999994e-112	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g763	i0	100	91.1290322580645	226	0	91	0	23	248	2112208	2111983	Escherichia coli strain Case 2 chromosome, complete genome	blastn	22600	418	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8689604	8689604	PRJNA1148965_S_NODE_467_length_291_cov_1.073394_g464_i0	PRJNA1148965	467	291	1.073394	3.12357654	Enterobacteriaceae	543	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g464	i0	100	100	291	0	100	0	1	291	2935321	2935611	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	29100	538	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8689605	8689605	PRJNA1148965_S_NODE_707_length_253_cov_0.866667_g704_i0	PRJNA1148965	707	253	0.866667	2.19266751	Bacillati	1783272	Bacteria	Bacteria	377	3.33e-100	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g704	i0	98.592	147.343873517787	213	3	84	0	17	229	1105	893	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	37278	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9964720	9964720	PRJNA1148965_S_NODE_48_length_568_cov_1.331313_g46_i0	PRJNA1148965	48	568	1.331313	7.56185784	Bacillus	1386	Bacteria	Bacteria	459	2.8199999999999996e-124	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g46	i0	100	43.6619718309859	248	0	44	0	321	568	3965601	3965354	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9964721	9964721	PRJNA1148965_S_NODE_788_length_246_cov_0.901734_g785_i0	PRJNA1148965	788	246	0.901734	2.21826564	Escherichia	561	Bacteria	Bacteria	424	4.09e-114	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g785	i0	100	93.0894308943089	229	0	93	0	18	246	2110151	2110379	Escherichia coli strain Case 2 chromosome, complete genome	blastn	22900	424	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11239852	11239852	PRJNA1148965_S_NODE_109_length_443_cov_1.562162_g106_i0	PRJNA1148965	109	443	1.562162	6.92037766	Enterobacteriaceae	543	Bacteria	Bacteria	802	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g106	i0	99.323	100	443	3	100	0	1	443	2905928	2905486	Escherichia coli strain Case 2 chromosome, complete genome	blastn	44300	802	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11239853	11239853	PRJNA1148965_S_NODE_669_length_257_cov_0.891304_g666_i0	PRJNA1148965	669	257	0.891304	2.29065128	Bacillus	1386	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g666	i0	99.611	100	257	1	100	0	1	257	3949950	3949694	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	25700	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
11239854	11239854	PRJNA1148965_S_NODE_89_length_465_cov_1.724490_g86_i0	PRJNA1148965	89	465	1.72449	8.0188785	Bacillus	1386	Bacteria	Bacteria	710	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g86	i0	99.742	1043.69677419355	387	1	83	0	59	445	13087	12701	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	485319	710	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
11239855	11239855	PRJNA1148965_S_NODE_9_length_942_cov_2.235903_g7_i0	PRJNA1148965	9	942	2.235903	21.06220626	Bacillus	1386	Bacteria	Bacteria	872	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g7	i0	99.789	93.8460721868365	475	1	94	0	62	536	3972107	3972581	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	88403	872	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
15064239	15064239	PRJNA1148965_S_NODE_12_length_897_cov_11.253641_g10_i0	PRJNA1148965	12	897	11.253641	100.94515977	Bacillus	1386	Bacteria	Bacteria	1447	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g10	i0	99.747	87.8472686733556	789	2	88	0	33	821	3357929	3357141	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	78799	1447	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
17614297	17614297	PRJNA1148965_S_NODE_34_length_613_cov_1.590741_g32_i0	PRJNA1148965	34	613	1.590741	9.75124233	Bacillus	1386	Bacteria	Bacteria	1127	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g32	i0	99.837	99.8613376835237	613	1	100	0	1	613	3357108	3356496	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	61215	1127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
22713472	22713472	PRJNA1148965_S_NODE_58_length_544_cov_3663.006369_g56_i0	PRJNA1148965	58	544	3663.006369	19926.75464736	Enterobacteriaceae	543	Bacteria	Bacteria	804	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g56	i0	100	79.9632352941177	435	0	80	0	110	544	2629907	2629473	Escherichia coli strain Case 2 chromosome, complete genome	blastn	43500	804	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23988768	23988768	PRJNA1148965_S_NODE_479_length_288_cov_1.032558_g476_i0	PRJNA1148965	479	288	1.032558	2.97376704	Enterobacteriaceae	543	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g476	i0	100	100	288	0	100	0	1	288	2630709	2630996	Escherichia coli strain Case 2 chromosome, complete genome	blastn	28800	532	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25262822	25262822	PRJNA1148965_S_NODE_20_length_759_cov_1.867347_g18_i0	PRJNA1148965	20	759	1.867347	14.17316373	Escherichia	561	Bacteria	Bacteria	1402	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g18	i0	100	100	759	0	100	0	1	759	2114563	2113805	Escherichia coli strain Case 2 chromosome, complete genome	blastn	75900	1402	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28019601	28019601	PRJNA1148965_S_NODE_865_length_242_cov_0.875740_g862_i0	PRJNA1148965	865	242	0.87574	2.1192908	Shigella sonnei	624	Bacteria	Bacteria	123	5.929999999999998e-35	NR	WP_353799288.1	624	g862	i0	96.7	1.51239669421488	61	2	75.6	0	241	59	1	61	WP_353799288.1 hypothetical protein, partial [Shigella sonnei]	diamond	366	123	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei

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