metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA415636" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA415636" 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
419115	419115	PRJNA415636_S_NODE_6561_length_202_cov_2.025806_g6514_i0	PRJNA415636	6561	202	2.025806	4.09212812	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	302	1.5800000000000001e-77	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g6514	i0	93.564	314.282178217822	202	13	100	0	1	202	1529646	1529445	Undibacterium sp. YM2 DNA, complete genome	blastn	63485	302	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
1083270	1083270	PRJNA415636_S_NODE_2701_length_289_cov_1.475207_g2654_i0	PRJNA415636	2701	289	1.475207	4.26334823	root	1	Root_unresolved	Root_unresolved	534	2.18e-147	NTclustered	gi\|2566177108\|gb\|CP132594.1\|	562	g2654	i0	100	88.3044982698962	289	0	100	0	1	289	3914871	3914583	Escherichia coli strain SIJ488 chromosome, complete genome	blastn	25520	534	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
1693939	1693939	PRJNA415636_S_NODE_3962_length_250_cov_1.201970_g3915_i0	PRJNA415636	3962	250	1.20197	3.004925	Streptococcus mitis	28037	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g3915	i0	100	99.98	250	0	100	0	1	250	1742079	1742328	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	24995	462	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
2969826	2969826	PRJNA415636_S_NODE_5843_length_214_cov_0.916168_g5796_i0	PRJNA415636	5843	214	0.916168	1.96059952	Mycoplasma wenyonii	65123	Bacteria	Bacteria	357	3.5699999999999996e-94	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5796	i0	96.729	1	214	7	100	0	1	214	187906	188119	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	214	357	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4246170	4246170	PRJNA415636_S_NODE_1884_length_330_cov_2.491166_g1837_i0	PRJNA415636	1884	330	2.491166	8.2208478	Phyllobacterium zundukense	1867719	Bacteria	Bacteria	344	4.58e-90	NTclustered	gi\|1276680390\|gb\|CP017940.1\|	1867719	g1837	i0	85.455	2.88787878787879	330	48	100	0	1	330	2250094	2250423	Phyllobacterium zundukense strain Tri-48, complete sequence.	blastn	953	344	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium zundukense
4246174	4246174	PRJNA415636_S_NODE_6104_length_210_cov_2.815951_g6057_i0	PRJNA415636	6104	210	2.815951	5.9134971	Mycoplasma wenyonii	65123	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6057	i0	99.524	1	210	1	100	0	1	210	609661	609452	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	383	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5522883	5522883	PRJNA415636_S_NODE_2945_length_280_cov_1.510730_g2898_i0	PRJNA415636	2945	280	1.51073	4.230044	Mycoplasma wenyonii	65123	Bacteria	Bacteria	468	2.16e-127	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2898	i0	96.786	1	280	9	100	0	1	280	537161	537440	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	280	468	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
8072405	8072405	PRJNA415636_S_NODE_227_length_660_cov_5.631321_g199_i0	PRJNA415636	227	660	5.631321	37.1667186	uncultured bacterium	77133	Bacteria	Bacteria	795	0	NTclustered	gi\|291258809\|gb\|GU923911.1\|	77133	g199	i0	94.412	146.972727272727	519	25	78	4	135	652	1	516	Uncultured bacterium clone F5K2Q4C04H9X1H 23S ribosomal RNA gene, partial sequence	blastn	97002	795	1	Bacteria								uncultured bacterium
8736134	8736134	PRJNA415636_S_NODE_4927_length_229_cov_4.236264_g4880_i0	PRJNA415636	4927	229	4.236264	9.70104456	Pseudomonas	286	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|858972107\|gb\|KT215485.1\|	294	g4880	i0	99.563	116	229	1	100	0	1	229	1094	1322	Pseudomonas fluorescens strain IC7 16S ribosomal RNA gene, partial sequence	blastn	26564	418	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
11897952	11897952	PRJNA415636_S_NODE_2610_length_293_cov_1.902439_g2563_i0	PRJNA415636	2610	293	1.902439	5.57414627	Paucibacter sediminis	3019553	Bacteria	Bacteria	481	2.92e-131	NTclustered	gi\|2517185782\|gb\|CP116346.1\|	3019553	g2563	i0	96.259	309.696245733788	294	9	100	2	1	293	899448	899740	Paucibacter sediminis strain S2-9 chromosome, complete genome	blastn	90741	481	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Paucibacter sediminis
13172877	13172877	PRJNA415636_S_NODE_1071_length_400_cov_3.660057_g1024_i0	PRJNA415636	1071	400	3.660057	14.640228	Paenarthrobacter sp. S56	3138179	Bacteria	Bacteria	67.6	1.37e-6	NTclustered	gi\|2734993624\|gb\|CP152470.1\|	3138179	g1024	i0	97.436	0.2975	39	1	10	0	204	242	3312890	3312928	Paenarthrobacter sp. S56 chromosome, complete genome	blastn	119	67.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Paenarthrobacter	Paenarthrobacter sp. S56
13836738	13836738	PRJNA415636_S_NODE_6211_length_209_cov_0.944444_g6164_i0	PRJNA415636	6211	209	0.944444	1.97388796	Pseudomonadota	1224	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|290633781\|gb\|GU740857.1\|	77133	g6164	i0	100	100.33014354067	209	0	100	0	1	209	289	81	Uncultured bacterium clone F1Q32TO03DAZI9 16S ribosomal RNA gene, partial sequence	blastn	20969	387	1	Bacteria								uncultured bacterium
15721779	15721779	PRJNA415636_S_NODE_3953_length_250_cov_2.078818_g3906_i0	PRJNA415636	3953	250	2.078818	5.197045	Mycoplasma wenyonii	65123	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3906	i0	98.406	1.004	251	3	100	1	1	250	560981	561231	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	251	440	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16385690	16385690	PRJNA415636_S_NODE_4113_length_246_cov_2.306533_g4066_i0	PRJNA415636	4113	246	2.306533	5.67407118	Streptococcus	1301	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g4066	i0	99.187	100	246	2	100	0	1	246	1772641	1772396	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	24600	444	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17660801	17660801	PRJNA415636_S_NODE_1314_length_375_cov_7.704268_g1267_i0	PRJNA415636	1314	375	7.704268	28.891005	Paenibacillus	44249	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g1267	i0	100	0.456	28	0	7	0	328	355	3149485	3149458	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	171	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
17660803	17660803	PRJNA415636_S_NODE_4734_length_233_cov_1.370968_g4687_i0	PRJNA415636	4734	233	1.370968	3.19435544	Pasteurella	745	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|2488138257\|gb\|CP121788.1\|	747	g4687	i0	99.571	99.7682403433476	233	1	100	0	1	233	547695	547927	Pasteurella multocida strain PM-3 chromosome, complete genome	blastn	23246	425	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Pasteurella	Pasteurella multocida
18270729	18270729	PRJNA415636_S_NODE_215_length_670_cov_3.701445_g187_i0	PRJNA415636	215	670	3.701445	24.7996815	uncultured bacterium	77133	Bacteria	Bacteria	920	0	NTclustered	gi\|291261469\|gb\|GU926571.1\|	77133	g187	i0	97.417	451.449253731343	542	11	81	3	105	645	541	2	Uncultured bacterium clone F5K2Q4C04JC04X 23S ribosomal RNA gene, partial sequence	blastn	302471	920	1	Bacteria								uncultured bacterium
18270736	18270736	PRJNA415636_S_NODE_5335_length_222_cov_1.497143_g5288_i0	PRJNA415636	5335	222	1.497143	3.32365746	Mycoplasma wenyonii	65123	Bacteria	Bacteria	361	2.8799999999999994e-95	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5288	i0	95.946	1	222	9	100	0	1	222	137419	137640	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	222	361	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19544940	19544940	PRJNA415636_S_NODE_4956_length_229_cov_1.197802_g4909_i0	PRJNA415636	4956	229	1.197802	2.74296658	Mycoplasma wenyonii	65123	Bacteria	Bacteria	350	6.47e-92	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4909	i0	94.298	0.995633187772926	228	13	99	0	2	229	188922	188695	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	228	350	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820832	20820832	PRJNA415636_S_NODE_3957_length_250_cov_1.502463_g3910_i0	PRJNA415636	3957	250	1.502463	3.7561575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3910	i0	99.6	1	250	1	100	0	1	250	37219	37468	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	250	457	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820834	20820834	PRJNA415636_S_NODE_4197_length_244_cov_1.258883_g4150_i0	PRJNA415636	4197	244	1.258883	3.07167452	Corynebacterium sp. 102791.4	3104612	Bacteria	Bacteria	385	1.91e-102	NTclustered	gi\|2627812303\|gb\|OR912476.1\|	3104612	g4150	i0	95.082	335.463114754098	244	12	100	0	1	244	1164	921	Corynebacterium sp. 102791.4 23S ribosomal RNA gene, partial sequence	blastn	81853	385	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. 102791.4
20820836	20820836	PRJNA415636_S_NODE_5537_length_219_cov_1.186047_g5490_i0	PRJNA415636	5537	219	1.186047	2.59744293	Mycoplasma wenyonii	65123	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5490	i0	97.235	0.990867579908676	217	4	99	2	4	219	556495	556280	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	217	366	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
22095533	22095533	PRJNA415636_S_NODE_4658_length_234_cov_3.053476_g4611_i0	PRJNA415636	4658	234	3.053476	7.14513384	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g4611	i0	100	0.128205128205128	30	0	13	0	11	40	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
22760242	22760242	PRJNA415636_S_NODE_4198_length_244_cov_1.167513_g4151_i0	PRJNA415636	4198	244	1.167513	2.84873172	Undibacterium	401469	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|2634174434\|gb\|CP133779.1\|	3048609	g4151	i0	95.902	438.483606557377	244	10	100	0	1	244	1462454	1462211	Undibacterium sp. CCC3.4 chromosome, complete genome	blastn	106990	399	0.992481203007519	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. CCC3.4
23371220	23371220	PRJNA415636_S_NODE_2419_length_301_cov_3.610236_g2372_i0	PRJNA415636	2419	301	3.610236	10.86681036	Mycoplasma wenyonii	65123	Bacteria	Bacteria	518	2.3e-142	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2372	i0	97.674	1	301	7	100	0	1	301	254865	254565	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	301	518	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24645516	24645516	PRJNA415636_S_NODE_4260_length_242_cov_3.923077_g4213_i0	PRJNA415636	4260	242	3.923077	9.49384634	Roseateles sp. DAIF2	2714952	Bacteria	Bacteria	58.4	4.69e-4	NTclustered	gi\|1934957904\|gb\|CP049919.1\|	2714952	g4213	i0	97.059	0.264462809917355	34	1	14	0	111	144	2008680	2008713	Roseateles sp. DAIF2 chromosome, complete genome	blastn	64	58.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles sp. DAIF2
25309422	25309422	PRJNA415636_S_NODE_560_length_490_cov_6.668172_g515_i0	PRJNA415636	560	490	6.668172	32.6740428	Pseudomonas	286	Bacteria	Bacteria	826	0	NTclustered	gi\|1877575224\|dbj\|AP022227.1\|	303	g515	i0	98.71	636.812244897959	465	6	95	0	1	465	188722	188258	Pseudomonas putida DNA, complete genome, strain: WP8-W18-CRE-01	blastn	312038	826	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida

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