metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1085664" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1085664" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
193566	193566	PRJNA1085664_S_NODE_30581_length_161_cov_0.932203_g30162_i0	PRJNA1085664	30581	161	0.932203	1.50084683	Corynebacterium kroppenstedtii	161879	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|2809007534\|gb\|CP119163.1\|	2736648	g30162	i0	99.379	383.645962732919	161	1	100	0	1	161	186261	186421	Corynebacterium kroppenstedtii subsp. demodicis strain Df-1 chromosome, complete genome	blastn	61767	292	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
1017248	1017248	PRJNA1085664_S_NODE_15641_length_220_cov_1.316384_g15222_i0	PRJNA1085664	15641	220	1.316384	2.8960448	root	1	Root_unresolved	Root_unresolved	396	7.809999999999997e-106	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g15222	i0	99.095	96.6454545454545	221	1	100	1	1	220	1316	1096	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	21262	396	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
1017255	1017255	PRJNA1085664_S_NODE_20821_length_192_cov_0.966443_g20402_i0	PRJNA1085664	20821	192	0.966443	1.85557056	Moraxellaceae	468	Bacteria	Bacteria	313	6.87e-81	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g20402	i0	100	307.026041666667	169	0	88	0	24	192	1496717	1496549	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	58949	313	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
1468192	1468192	PRJNA1085664_S_NODE_29342_length_164_cov_1.165289_g28923_i0	PRJNA1085664	29342	164	1.165289	1.91107396	Hathewaya histolytica	1498	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g28923	i0	100	1.85975609756098	164	0	100	0	1	164	2093558	2093721	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	305	303	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
1468234	1468234	PRJNA1085664_S_NODE_5802_length_354_cov_2.974277_g5383_i0	PRJNA1085664	5802	354	2.974277	10.52894058	uncultured bacterium	77133	Bacteria	Bacteria	575	1.6099999999999995e-159	NTclustered	gi\|309953369\|gb\|HM778584.1\|	77133	g5383	i0	98.176	101.290960451977	329	6	93	0	26	354	316	644	Uncultured bacterium clone JFR0501_aaa03b06 16S ribosomal RNA gene, partial sequence	blastn	35857	575	1	Bacteria								uncultured bacterium
4845433	4845433	PRJNA1085664_S_NODE_4184_length_407_cov_1.384615_g3766_i0	PRJNA1085664	4184	407	1.384615	5.63538305	root	1	Root_unresolved	Root_unresolved	752	0	NTclustered	gi\|643390720\|gb\|KF070478.1\|	77133	g3766	i0	100	100	407	0	100	0	1	407	727	321	Uncultured bacterium clone nbu591d10c1 16S ribosomal RNA gene, partial sequence	blastn	40700	752	1	Bacteria								uncultured bacterium
7395121	7395121	PRJNA1085664_S_NODE_986_length_768_cov_13.242759_g753_i0	PRJNA1085664	986	768	13.242759	101.70438912	Enterobacteriaceae	543	Bacteria	Bacteria	1203	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g753	i0	100	85.61328125	651	0	85	0	33	683	3406207	3405557	Escherichia coli strain Case 2 chromosome, complete genome	blastn	65751	1203	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7846151	7846151	PRJNA1085664_S_NODE_15227_length_223_cov_1.216667_g14808_i0	PRJNA1085664	15227	223	1.216667	2.71316741	Acinetobacter johnsonii	40214	Bacteria	Bacteria	359	1.04e-94	NTclustered	gi\|2456158263\|gb\|CP119200.1\|	40214	g14808	i0	95.928	683.627802690583	221	9	99	0	1	221	168773	168553	Acinetobacter johnsonii strain AJ572 chromosome, complete genome	blastn	152449	359	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
9121156	9121156	PRJNA1085664_S_NODE_22788_length_184_cov_1.000000_g22369_i0	PRJNA1085664	22788	184	1	1.84	Mycoplasma wenyonii	65123	Bacteria	Bacteria	224	3.139999999999999e-54	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g22369	i0	93.421	0.826086956521739	152	9	83	1	1	152	265012	264862	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	152	224	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9945511	9945511	PRJNA1085664_S_NODE_12928_length_241_cov_7.015152_g12509_i0	PRJNA1085664	12928	241	7.015152	16.90651632	Enterobacteriaceae	543	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g12509	i0	100	610.302904564315	217	0	90	0	25	241	78613	78397	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	147083	401	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11220757	11220757	PRJNA1085664_S_NODE_10669_length_266_cov_2.632287_g10250_i0	PRJNA1085664	10669	266	2.632287	7.00188342	Aeromonas	642	Bacteria	Bacteria	446	9.549999999999999e-121	NTclustered	gi\|2214134399\|gb\|CP094267.1\|	644	g10250	i0	100	780.586466165414	241	0	91	0	1	241	88180	87940	Aeromonas hydrophila strain A008N2 chromosome, complete genome	blastn	207636	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
11220760	11220760	PRJNA1085664_S_NODE_12009_length_251_cov_1.355769_g11590_i0	PRJNA1085664	12009	251	1.355769	3.40298019	Streptococcus	1301	Bacteria	Bacteria	440	4.149999999999998e-119	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g11590	i0	98.406	563.163346613546	251	3	99	1	1	250	17856	18106	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	141354	440	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
12496143	12496143	PRJNA1085664_S_NODE_29450_length_163_cov_2.741667_g29031_i0	PRJNA1085664	29450	163	2.741667	4.46891721	Lactobacillus	1578	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2323788530\|gb\|CP109946.1\|	1584	g29031	i0	100	557.914110429448	163	0	100	0	1	163	745674	745512	Lactobacillus delbrueckii strain sunkii chromosome, complete genome	blastn	90940	302	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
13770704	13770704	PRJNA1085664_S_NODE_32431_length_156_cov_3.566372_g32012_i0	PRJNA1085664	32431	156	3.566372	5.56354032	Borrelia	138	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g32012	i0	100	0.358974358974359	28	0	18	0	95	122	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria		Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
13770708	13770708	PRJNA1085664_S_NODE_34551_length_153_cov_0.872727_g34132_i0	PRJNA1085664	34551	153	0.872727	1.33527231	Micrococcus	1269	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g34132	i0	100	308.986928104575	153	0	100	0	1	153	347932	348084	Micrococcus luteus strain V017 chromosome, complete genome	blastn	47275	283	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15045020	15045020	PRJNA1085664_S_NODE_21452_length_189_cov_1.287671_g21033_i0	PRJNA1085664	21452	189	1.287671	2.43369819	Enterobacteriaceae	543	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g21033	i0	100	100	189	0	100	0	1	189	2352570	2352758	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	18900	350	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15496232	15496232	PRJNA1085664_S_NODE_32553_length_156_cov_1.716814_g32134_i0	PRJNA1085664	32553	156	1.716814	2.67822984	Acidovorax temperans	80878	Bacteria	Bacteria	268	1.1699999999999997e-67	NTclustered	gi\|2700484197\|gb\|CP147774.1\|	80878	g32134	i0	98.675	240.807692307692	151	2	97	0	1	151	2501212	2501062	Acidovorax temperans strain AA22 chromosome	blastn	37566	268	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax temperans
16319834	16319834	PRJNA1085664_S_NODE_10013_length_274_cov_9.731602_g9594_i0	PRJNA1085664	10013	274	9.731602	26.66458948	Enterobacteriaceae	543	Bacteria	Bacteria	464	2.7299999999999994e-126	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g9594	i0	100	627.310218978102	251	0	92	0	24	274	5149973	5149723	Escherichia coli strain HNTH2207 chromosome	blastn	171883	464	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16770465	16770465	PRJNA1085664_S_NODE_18614_length_202_cov_1.125786_g18195_i0	PRJNA1085664	18614	202	1.125786	2.27408772	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	285	1.59e-72	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g18195	i0	98.75	214.346534653465	160	2	81	0	1	160	1301599	1301758	Hymenobacter sp. APR13, complete genome	blastn	43298	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
16770506	16770506	PRJNA1085664_S_NODE_2814_length_481_cov_6.394977_g2411_i0	PRJNA1085664	2814	481	6.394977	30.75983937	Metapseudomonas otitidis	319939	Bacteria	Bacteria	843	0	NTclustered	gi\|2385414983\|gb\|CP102328.1\|	319939	g2411	i0	100	367.83367983368	456	0	95	0	1	456	688167	687712	Metapseudomonas otitidis strain BC12 chromosome, complete genome	blastn	176928	843	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Metapseudomonas	Metapseudomonas otitidis
17595126	17595126	PRJNA1085664_S_NODE_2654_length_492_cov_4.403118_g2253_i0	PRJNA1085664	2654	492	4.403118	21.66334056	Cutibacterium	1912216	Bacteria	Bacteria	909	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2253	i0	100	314.227642276423	492	0	100	0	1	492	56747	57238	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	154600	909	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18868964	18868964	PRJNA1085664_S_NODE_11775_length_253_cov_1.961905_g11356_i0	PRJNA1085664	11775	253	1.961905	4.96361965	root	1	Root_unresolved	Root_unresolved	424	4.22e-114	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g11356	i0	100	156.513833992095	229	0	91	0	25	253	819	1047	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	39598	424	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18868968	18868968	PRJNA1085664_S_NODE_18795_length_201_cov_1.082278_g18376_i0	PRJNA1085664	18795	201	1.082278	2.17537878	Pseudomonadaceae	135621	Bacteria	Bacteria	324	3.36e-84	NTclustered	gi\|2797109174\|gb\|CP154874.1\|	43263	g18376	i0	98.901	548.721393034826	182	1	91	1	20	201	3278	3458	Aquipseudomonas alcaligenes strain Med1 chromosome, complete genome	blastn	110293	324	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas alcaligenes
18868990	18868990	PRJNA1085664_S_NODE_7035_length_324_cov_2.156584_g6616_i0	PRJNA1085664	7035	324	2.156584	6.98733216	Escherichia	561	Bacteria	Bacteria	544	4.12e-150	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g6616	i0	97.196	693.567901234568	321	9	99	0	1	321	2295059	2295379	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	224716	544	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20143701	20143701	PRJNA1085664_S_NODE_14816_length_226_cov_1.573770_g14397_i0	PRJNA1085664	14816	226	1.57377	3.5567202	root	1	Root_unresolved	Root_unresolved	418	1.7199999999999998e-112	NTclustered	gi\|671777729\|gb\|KJ809241.1\|	77133	g14397	i0	100	100	226	0	100	0	1	226	284	59	Uncultured bacterium clone A26GN 16S ribosomal RNA gene, partial sequence	blastn	22600	418	1	Bacteria								uncultured bacterium
21419354	21419354	PRJNA1085664_S_NODE_21137_length_190_cov_2.448980_g20718_i0	PRJNA1085664	21137	190	2.44898	4.653062	root	1	Root_unresolved	Root_unresolved	351	1.4399999999999997e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g20718	i0	100	538.026315789474	190	0	100	0	1	190	1571647	1571458	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	102225	351	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21870397	21870397	PRJNA1085664_S_NODE_28558_length_166_cov_1.178862_g28139_i0	PRJNA1085664	28558	166	1.178862	1.95691092	Mycoplasma wenyonii	65123	Bacteria	Bacteria	263	5.9e-66	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g28139	i0	95.21	1.77710843373494	167	6	100	2	1	166	24126	24291	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	295	263	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
22694222	22694222	PRJNA1085664_S_NODE_19618_length_197_cov_1.246753_g19199_i0	PRJNA1085664	19618	197	1.246753	2.45610341	root	1	Root_unresolved	Root_unresolved	364	1.929999999999999e-96	NTclustered	gi\|2871849209\|gb\|PQ782541.1\|	329	g19199	i0	100	102	197	0	100	0	1	197	582	386	Ralstonia pickettii strain LT333 16S ribosomal RNA gene, partial sequence	blastn	20094	364	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
23145766	23145766	PRJNA1085664_S_NODE_34359_length_153_cov_0.872727_g33940_i0	PRJNA1085664	34359	153	0.872727	1.33527231	Lacimicrobium alkaliphilum	1526571	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|962030499\|gb\|CP013650.1\|	1526571	g33940	i0	100	0.183006535947712	28	0	18	0	37	64	3241351	3241324	Lacimicrobium alkaliphilum strain YelD216 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Lacimicrobium	Lacimicrobium alkaliphilum
23969743	23969743	PRJNA1085664_S_NODE_25539_length_175_cov_0.939394_g25120_i0	PRJNA1085664	25539	175	0.939394	1.6439395	Corynebacterium	1716	Bacteria	Bacteria	276	8.04e-70	NTclustered	gi\|470484386\|ref\|NR_076645.1\|	161879	g25120	i0	94.944	389.417142857143	178	6	100	1	1	175	470	647	Corynebacterium kroppenstedtii strain DSM 44385 23S ribosomal RNA gene, complete sequence	blastn	68148	276	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
25243685	25243685	PRJNA1085664_S_NODE_3340_length_446_cov_15.161290_g2928_i0	PRJNA1085664	3340	446	15.16129	67.6193534	Moraxellaceae	468	Bacteria	Bacteria	778	0	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g2928	i0	100	356.773542600897	421	0	94	0	1	421	1497447	1497867	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	159121	778	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
25243689	25243689	PRJNA1085664_S_NODE_3900_length_418_cov_2.600000_g3482_i0	PRJNA1085664	3900	418	2.6	10.868	Cutibacterium	1912216	Bacteria	Bacteria	773	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3482	i0	100	265.349282296651	418	0	100	0	1	418	55448	55865	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	110916	773	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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