metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax_kingdom = "Bacillati"

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
181877	181877	PRJNA1068513_S_NODE_12261_length_251_cov_1.494382_g12215_i0	PRJNA1068513	12261	251	1.494382	3.75089882	Streptomyces sp. NBC_01497	2903885	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2661748798\|gb\|CP109427.1\|	2903885	g12215	i0	100	0.111553784860558	28	0	11	0	83	110	5557671	5557644	Streptomyces sp. NBC_01497 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01497
1013636	1013636	PRJNA1068513_S_NODE_5701_length_381_cov_2.649351_g5655_i0	PRJNA1068513	5701	381	2.649351	10.09402731	Streptomyces	1883	Bacteria	Bacteria	130	1.63e-25	NTclustered	gi\|2424005877\|gb\|CP114203.1\|	1920	g5655	i0	80.46	34.5223097112861	174	31	45	3	210	381	9245518	9245690	Streptomyces nigrescens strain DSM 40276 chromosome, complete genome	blastn	13153	130	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces nigrescens
1013639	1013639	PRJNA1068513_S_NODE_6801_length_350_cov_1.783394_g6755_i0	PRJNA1068513	6801	350	1.783394	6.241879	Clostridium	1485	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2385532608\|gb\|CP086246.1\|	2843318	g6755	i0	100	0.24	28	0	8	0	173	200	2436613	2436640	Clostridium sp. CF011 chromosome, complete genome	blastn	84	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. CF011
2288886	2288886	PRJNA1068513_S_NODE_6602_length_355_cov_8.248227_g6556_i0	PRJNA1068513	6602	355	8.248227	29.28120585	Blautia	572511	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2884834701\|gb\|CP176621.1\|	1532	g6556	i0	100	0.552112676056338	28	0	8	0	100	127	1870490	1870463	Blautia coccoides strain RS-04 chromosome, complete genome	blastn	196	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia coccoides
6116803	6116803	PRJNA1068513_S_NODE_7145_length_341_cov_2.764925_g7099_i0	PRJNA1068513	7145	341	2.764925	9.42839425	root	1	Root_unresolved	Root_unresolved	54.7	0.009	NTclustered	gi\|2702638792\|gb\|CP148048.1\|	33033	g7099	i0	100	0.859237536656892	29	0	9	0	152	180	1540077	1540105	Parvimonas micra strain JM503A chromosome, complete genome	blastn	293	54.7	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
6559715	6559715	PRJNA1068513_S_NODE_11766_length_256_cov_2.464481_g11720_i0	PRJNA1068513	11766	256	2.464481	6.30907136	Mesoplasma entomophilum	2149	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1359432926\|gb\|CP022507.1\|	2149	g11720	i0	100	0.328125	28	0	11	0	162	189	434124	434097	Mesoplasma entomophilum strain W17 chromosome	blastn	84	52.8	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma entomophilum
9109442	9109442	PRJNA1068513_S_NODE_6508_length_358_cov_2.315789_g6462_i0	PRJNA1068513	6508	358	2.315789	8.29052462	Mycoplasmatota bacterium WC30	3075149	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2877983046\|gb\|CP134495.1\|	3075149	g6462	i0	100	0.0782122905027933	28	0	8	0	72	99	816940	816967	Mycoplasmatota bacterium WC30 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Mycoplasmatota					Mycoplasmatota bacterium WC30
9941752	9941752	PRJNA1068513_S_NODE_11328_length_262_cov_4.571429_g11282_i0	PRJNA1068513	11328	262	4.571429	11.97714398	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|1878067685\|dbj\|LC566215.1\|	1352	g11282	i0	96.97	12.0572519083969	33	1	13	0	13	45	98	130	Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence	blastn	3159	56.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
10385184	10385184	PRJNA1068513_S_NODE_6529_length_358_cov_0.975439_g6483_i0	PRJNA1068513	6529	358	0.975439	3.49207162	Mycoplasma sp. 1654_15	2725994	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1832581539\|gb\|CP051214.1\|	2725994	g6483	i0	97.059	0.0949720670391061	34	0	9	1	37	70	766149	766181	Mycoplasma sp. 1654_15 chromosome, complete genome	blastn	34	56.5	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. 1654_15
11660462	11660462	PRJNA1068513_S_NODE_12870_length_246_cov_1.352601_g12824_i0	PRJNA1068513	12870	246	1.352601	3.32739846	Spiroplasma endosymbiont of Virgichneumon dumeticola	3139323	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2806755735\|emb\|OZ183478.1\|	3139323	g12824	i0	100	0.113821138211382	28	0	11	0	42	69	394438	394465	Spiroplasma endosymbiont of Virgichneumon dumeticola isolate 1d0b8646-e6ec-424d-883d-cc2662152a42 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Virgichneumon dumeticola
11660555	11660555	PRJNA1068513_S_NODE_8370_length_313_cov_2.008333_g8324_i0	PRJNA1068513	8370	313	2.008333	6.28608229	Clostridium beijerinckii	1520	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2324517193\|gb\|CP107022.1\|	1520	g8324	i0	94.286	0.335463258785943	35	1	11	1	197	230	3529705	3529739	Clostridium beijerinckii strain CloBei18h chromosome, complete genome	blastn	105	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
12935595	12935595	PRJNA1068513_S_NODE_2291_length_545_cov_5.430085_g2249_i0	PRJNA1068513	2291	545	5.430085	29.59396325	Micromonospora carbonacea	47853	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|1877131014\|gb\|CP058905.1\|	47853	g2249	i0	100	0.0532110091743119	29	0	5	0	333	361	3037975	3037947	Micromonospora carbonacea strain africana chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora carbonacea
14210540	14210540	PRJNA1068513_S_NODE_2512_length_529_cov_5.885965_g2469_i0	PRJNA1068513	2512	529	5.885965	31.13675485	Bacillus sp. Y1	352858	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|1480120062\|gb\|CP030028.1\|	352858	g2469	i0	100	0.054820415879017	29	0	5	0	352	380	3456154	3456126	Bacillus sp. Y1 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. Y1
14210577	14210577	PRJNA1068513_S_NODE_5552_length_386_cov_1.923323_g5506_i0	PRJNA1068513	5552	386	1.923323	7.42402678	Clostridium intestinale	36845	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2651387689\|gb\|CP121166.1\|	36845	g5506	i0	100	0.0725388601036269	28	0	7	0	30	57	1563141	1563114	Clostridium intestinale strain PC17 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
15041312	15041312	PRJNA1068513_S_NODE_5592_length_384_cov_3.758842_g5546_i0	PRJNA1068513	5592	384	3.758842	14.43395328	Agathobacter	1766253	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2202783703\|gb\|CP092643.1\|	39491	g5546	i0	100	0.309895833333333	29	0	8	0	7	35	552712	552740	Agathobacter rectalis strain VPI 0990 chromosome, complete genome	blastn	119	54.7	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
16758737	16758737	PRJNA1068513_S_NODE_1234_length_652_cov_3.880829_g1194_i0	PRJNA1068513	1234	652	3.880829	25.30300508	cyanobacterium endosymbiont of Epithemia clementina EcSB	3034674	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2499392380\|gb\|CP123991.1\|	3034674	g1194	i0	100	0.044478527607362	29	0	4	0	150	178	557534	557506	Cyanobacterium endosymbiont of Epithemia clementina EcSB isolate Gazos Creek chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia clementina EcSB
16758766	16758766	PRJNA1068513_S_NODE_2134_length_559_cov_1.288066_g2092_i0	PRJNA1068513	2134	559	1.288066	7.20028894	Mycoplasmatota bacterium WC44	3076018	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2878023906\|gb\|CP134881.1\|	3076018	g2092	i0	94.444	0.0644007155635063	36	2	6	0	348	383	2015778	2015813	Mycoplasmatota bacterium WC44 chromosome, complete genome	blastn	36	56.5	1	Bacteria		Bacillati	Mycoplasmatota					Mycoplasmatota bacterium WC44
17591402	17591402	PRJNA1068513_S_NODE_12894_length_246_cov_1.092486_g12848_i0	PRJNA1068513	12894	246	1.092486	2.68751556	Clostridium	1485	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2031304926\|gb\|CP073653.1\|	1520	g12848	i0	100	1.0609756097561	29	0	12	0	211	239	5633305	5633277	Clostridium beijerinckii strain DSM 791 chromosome, complete genome	blastn	261	54.7	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
19307472	19307472	PRJNA1068513_S_NODE_4696_length_417_cov_10.267442_g4651_i0	PRJNA1068513	4696	417	10.267442	42.81523314	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	58.4	8.62e-4	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g4651	i0	92.5	0.0959232613908873	40	3	10	0	89	128	2448830	2448791	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	40	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
20140062	20140062	PRJNA1068513_S_NODE_6776_length_351_cov_1.359712_g6730_i0	PRJNA1068513	6776	351	1.359712	4.77258912	Synechococcales	1890424	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2895565184\|gb\|CP138934.1\|	59925	g6730	i0	100	0.239316239316239	28	0	8	0	205	232	925807	925834	Prochlorococcus marinus str. GP2 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
24407703	24407703	PRJNA1068513_S_NODE_12720_length_247_cov_1.649425_g12674_i0	PRJNA1068513	12720	247	1.649425	4.07407975	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1951470321\|gb\|CP058446.1\|	28903	g12674	i0	100	0.11336032388664	28	0	11	0	161	188	208535	208562	Mycoplasmopsis bovis strain Mb166 chromosome	blastn	28	52.8	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis

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