metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1146366" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1146366" 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
290304	290304	PRJNA1146366_S_NODE_2101_length_255_cov_1.467033_g2098_i0	PRJNA1146366	2101	255	1.467033	3.74093415	Corynebacterium afermentans	38286	Bacteria	Bacteria	425	1.18e-114	NTclustered	gi\|2531253808\|gb\|CP046530.1\|	144184	g2098	i0	98.347	355.690196078431	242	4	95	0	13	254	639089	639330	Corynebacterium afermentans subsp. lipophilum strain DSM 44282 chromosome, complete genome	blastn	90701	425	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
2308997	2308997	PRJNA1146366_S_NODE_1662_length_277_cov_1.911765_g1659_i0	PRJNA1146366	1662	277	1.911765	5.29558905	root	1	Root_unresolved	Root_unresolved	512	9.73e-141	NTclustered	gi\|643405730\|gb\|KF085441.1\|	77133	g1659	i0	100	100	277	0	100	0	1	277	552	828	Uncultured bacterium clone ncm30h11c1 16S ribosomal RNA gene, partial sequence	blastn	27700	512	1	Bacteria								uncultured bacterium
2841128	2841128	PRJNA1146366_S_NODE_2263_length_249_cov_2.181818_g2260_i0	PRJNA1146366	2263	249	2.181818	5.43272682	Staphylococcus auricularis	29379	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g2260	i0	100	479.618473895582	249	0	100	0	1	249	1486313	1486065	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	119425	460	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
6668188	6668188	PRJNA1146366_S_NODE_2266_length_249_cov_1.772727_g2263_i0	PRJNA1146366	2266	249	1.772727	4.41409023	Myroides odoratus	256	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|2636494101\|gb\|CP139975.1\|	256	g2263	i0	92.063	99.0923694779116	252	14	100	4	1	249	952229	952477	Myroides odoratus strain HAMBI_1923 chromosome, complete genome	blastn	24674	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratus
7411569	7411569	PRJNA1146366_S_NODE_1166_length_309_cov_2.084746_g1163_i0	PRJNA1146366	1166	309	2.084746	6.44186514	Cutibacterium	1912216	Bacteria	Bacteria	538	1.8199999999999993e-148	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1163	i0	98.058	263.847896440129	309	6	100	0	1	309	55481	55789	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	81529	538	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7411570	7411570	PRJNA1146366_S_NODE_1986_length_261_cov_1.069149_g1983_i0	PRJNA1146366	1986	261	1.069149	2.79047889	Providencia	586	Bacteria	Bacteria	466	7.17e-127	NTclustered	gi\|1356799678\|gb\|CP027418.1\|	587	g1983	i0	98.855	687.505747126437	262	2	100	1	1	261	433242	432981	Providencia rettgeri strain FDAARGOS_330 chromosome, complete genome	blastn	179439	466	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Providencia	Providencia rettgeri
8686806	8686806	PRJNA1146366_S_NODE_1187_length_307_cov_3.628205_g1184_i0	PRJNA1146366	1187	307	3.628205	11.13858935	Staphylococcus	1279	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g1184	i0	100	100	307	0	100	0	1	307	180852	180546	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	30700	568	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8686807	8686807	PRJNA1146366_S_NODE_427_length_401_cov_2.192073_g424_i0	PRJNA1146366	427	401	2.192073	8.79021273	Streptococcus	1301	Bacteria	Bacteria	728	0	NTclustered	gi\|2886508907\|emb\|OZ217344.1\|	28037	g424	i0	99.501	100.980049875312	401	1	100	1	1	401	1190840	1191239	Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1	blastn	40493	728	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
9218333	9218333	PRJNA1146366_S_NODE_648_length_363_cov_2.817241_g645_i0	PRJNA1146366	648	363	2.817241	10.22658483	Finegoldia magna	1260	Bacteria	Bacteria	671	0	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g645	i0	100	6.08264462809917	363	0	100	0	1	363	966697	966335	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	2208	671	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
9961806	9961806	PRJNA1146366_S_NODE_768_length_348_cov_1.850909_g765_i0	PRJNA1146366	768	348	1.850909	6.44116332	Paenibacillus	44249	Bacteria	Bacteria	368	2.88e-97	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g765	i0	98.558	533.206896551724	208	3	60	0	1	208	422957	422750	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	185556	368	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
16867427	16867427	PRJNA1146366_S_NODE_374_length_415_cov_1.549708_g371_i0	PRJNA1146366	374	415	1.549708	6.4312882	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	728	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g371	i0	99.5	222.378313253012	400	2	96	0	16	415	501741	502140	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	92287	728	1	Bacteria	Bacteria candidate phyla			Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
18142027	18142027	PRJNA1146366_S_NODE_1355_length_296_cov_2.394619_g1352_i0	PRJNA1146366	1355	296	2.394619	7.08807224	Dolosigranulum pigrum	29394	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g1352	i0	100	469.341216216216	296	0	100	0	1	296	1791826	1791531	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	138925	547	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
20160044	20160044	PRJNA1146366_S_NODE_1436_length_290_cov_4.023041_g1433_i0	PRJNA1146366	1436	290	4.023041	11.6668189	Micrococcus	1269	Bacteria	Bacteria	525	1.32e-144	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g1433	i0	99.31	326.510344827586	290	2	100	0	1	290	347277	347566	Micrococcus luteus strain V017 chromosome, complete genome	blastn	94688	525	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
21967142	21967142	PRJNA1146366_S_NODE_1598_length_280_cov_1.516908_g1595_i0	PRJNA1146366	1598	280	1.516908	4.2473424	Corynebacterium lujinxingii	2763010	Bacteria	Bacteria	462	1.01e-125	NTclustered	gi\|1899778044\|gb\|CP061032.1\|	2763010	g1595	i0	98.479	345.403571428571	263	3	96	1	1	263	1135687	1135948	Corynebacterium lujinxingii strain zg-917 chromosome, complete genome	blastn	96713	462	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lujinxingii
21967150	21967150	PRJNA1146366_S_NODE_2498_length_241_cov_2.321429_g2495_i0	PRJNA1146366	2498	241	2.321429	5.59464389	Anaerococcus nagyae	1755241	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g2495	i0	100	5.21991701244813	241	0	100	0	1	241	1033952	1033712	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	1258	446	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
24516210	24516210	PRJNA1146366_S_NODE_1540_length_284_cov_1.478673_g1537_i0	PRJNA1146366	1540	284	1.478673	4.19943132	Ralstonia pickettii	329	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|2556944802\|gb\|CP104381.1\|	329	g1537	i0	99.648	84.8767605633803	284	1	100	0	1	284	2042843	2042560	Ralstonia pickettii strain MCR chromosome 1, complete sequence	blastn	24105	520	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii

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