metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax_phylum = "Bacillota"

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
335588	335588	PRJNA1233317_S_NODE_1001_length_459_cov_3.940000_g965_i0	PRJNA1233317	1001	459	3.94	18.0846	Bacillus pacificus	2026187	Bacteria	Bacteria	771	0	NTclustered	gi\|2648508204\|gb\|CP142003.1\|	2026187	g965	i0	96.95	100.213507625272	459	14	100	0	1	459	336118	336576	Bacillus pacificus strain AT31 chromosome, complete genome	blastn	45998	771	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pacificus
335638	335638	PRJNA1233317_S_NODE_2021_length_391_cov_3.593373_g1985_i0	PRJNA1233317	2021	391	3.593373	14.05008843	Staphylococcus argensis	1607738	Bacteria	Bacteria	717	0	NTclustered	gi\|1487186646\|gb\|MF678862.1\|	1607738	g1985	i0	99.744	501.086956521739	391	1	100	0	1	391	3453	3063	Staphylococcus argensis strain DSM 29875 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	195925	717	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus argensis
1047099	1047099	PRJNA1233317_S_NODE_11721_length_227_cov_1.452381_g11685_i0	PRJNA1233317	11721	227	1.452381	3.29690487	Staphylococcus	1279	Bacteria	Bacteria	401	1.7399999999999995e-107	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g11685	i0	100	95.5947136563877	217	0	96	0	11	227	2243357	2243141	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	21700	401	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2322460	2322460	PRJNA1233317_S_NODE_14582_length_201_cov_2.147887_g14546_i0	PRJNA1233317	14582	201	2.147887	4.31725287	Sporosarcina	1569	Bacteria	Bacteria	344	2.5799999999999998e-90	NTclustered	gi\|1005378703\|gb\|CP014616.1\|	1476	g14546	i0	97.512	847.676616915423	201	5	100	0	1	201	2301	2501	Sporosarcina psychrophila strain DSM 6497 chromosome, complete genome	blastn	170383	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina psychrophila
4162708	4162708	PRJNA1233317_S_NODE_6824_length_289_cov_3.526087_g6788_i0	PRJNA1233317	6824	289	3.526087	10.19039143	Staphylococcus epidermidis	1282	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g6788	i0	100	100	289	0	100	0	1	289	2299521	2299809	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	28900	534	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4875237	4875237	PRJNA1233317_S_NODE_424_length_596_cov_40.554935_g390_i0	PRJNA1233317	424	596	40.554935	241.7074126	Clostridioides	1870884	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2319031117\|gb\|CP107108.1\|	1496	g390	i0	97.059	5.21308724832215	34	1	6	0	494	527	3418918	3418885	Clostridioides difficile strain R_phiCD75-3 chromosome, complete genome	blastn	3107	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
6150002	6150002	PRJNA1233317_S_NODE_6545_length_293_cov_4.615385_g6509_i0	PRJNA1233317	6545	293	4.615385	13.52307805	Streptococcus	1301	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g6509	i0	100	560.044368600683	293	0	100	0	1	293	18284	17992	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	164093	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
7425042	7425042	PRJNA1233317_S_NODE_26_length_1434_cov_11.762909_g22_i0	PRJNA1233317	26	1434	11.762909	168.68011506	root	1	Root_unresolved	Root_unresolved	1631	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g22	i0	98.184	132.478382147838	936	13	100	2	499	1434	1116	185	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	189974	1637	0.996334758704948	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8700171	8700171	PRJNA1233317_S_NODE_3147_length_357_cov_2.687919_g3111_i0	PRJNA1233317	3147	357	2.687919	9.59587083	Lactobacillus	1578	Bacteria	Bacteria	660	0	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g3111	i0	100	426.064425770308	357	0	100	0	1	357	90841	90485	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	152105	660	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
9263671	9263671	PRJNA1233317_S_NODE_1628_length_408_cov_4.848138_g1592_i0	PRJNA1233317	1628	408	4.848138	19.78040304	Brochothrix campestris	2757	Bacteria	Bacteria	385	3.399999999999999e-102	NTclustered	gi\|2869630853\|gb\|CP175511.1\|	2757	g1592	i0	98.618	0.531862745098039	217	3	53	0	1	217	1150358	1150142	Brochothrix campestris strain DSM 4712 chromosome, complete genome	blastn	217	385	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Brochothrix	Brochothrix campestris
9975268	9975268	PRJNA1233317_S_NODE_9168_length_256_cov_4.522843_g9132_i0	PRJNA1233317	9168	256	4.522843	11.57847808	Sporosarcina	1569	Bacteria	Bacteria	407	4.31e-109	NTclustered	gi\|1005378703\|gb\|CP014616.1\|	1476	g9132	i0	98.276	880.828125	232	4	91	0	23	254	3982	3751	Sporosarcina psychrophila strain DSM 6497 chromosome, complete genome	blastn	225492	407	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina psychrophila
10539454	10539454	PRJNA1233317_S_NODE_10409_length_241_cov_3.230769_g10373_i0	PRJNA1233317	10409	241	3.230769	7.78615329	Streptococcus salivarius	1304	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1348284726\|gb\|CP020451.2\|	1304	g10373	i0	100	48.0788381742739	241	0	100	0	1	241	505438	505198	Streptococcus salivarius strain FDAARGOS_259 chromosome, complete genome	blastn	11587	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
10539562	10539562	PRJNA1233317_S_NODE_9089_length_257_cov_4.737374_g9053_i0	PRJNA1233317	9089	257	4.737374	12.17505118	Paraclostridium ghonii	29358	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2789028785\|gb\|CP161000.1\|	29358	g9053	i0	100	0.108949416342412	28	0	11	0	192	219	1896131	1896158	Paraclostridium ghonii strain NCTR 3900 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium ghonii
13089282	13089282	PRJNA1233317_S_NODE_15531_length_195_cov_0.897059_g15495_i0	PRJNA1233317	15531	195	0.897059	1.74926505	Hathewaya histolytica	1498	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g15495	i0	100	844.615384615385	195	0	100	0	1	195	1008	1202	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	164700	361	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
16912681	16912681	PRJNA1233317_S_NODE_11054_length_234_cov_2.091429_g11018_i0	PRJNA1233317	11054	234	2.091429	4.89394386	Streptococcus oralis	1303	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g11018	i0	100	99.8461538461538	234	0	100	0	1	234	608419	608186	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	23364	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
16912726	16912726	PRJNA1233317_S_NODE_2854_length_365_cov_4.584967_g2818_i0	PRJNA1233317	2854	365	4.584967	16.73512955	Lactobacillus iners	147802	Bacteria	Bacteria	675	0	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g2818	i0	100	520.238356164384	365	0	100	0	1	365	3138	2774	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	189887	675	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
17624901	17624901	PRJNA1233317_S_NODE_54_length_1174_cov_13.094170_g22_i1	PRJNA1233317	54	1174	13.09417	153.7255558	root	1	Root_unresolved	Root_unresolved	2119	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g22	i1	99.233	139.528960817717	1174	9	100	0	1	1174	1358	185	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	163807	2119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20737132	20737132	PRJNA1233317_S_NODE_8617_length_263_cov_3.843137_g8581_i0	PRJNA1233317	8617	263	3.843137	10.10745031	Staphylococcus cohnii	29382	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g8581	i0	100	31.3384030418251	263	0	100	0	1	263	871656	871394	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	8242	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
21448997	21448997	PRJNA1233317_S_NODE_17317_length_181_cov_2.893443_g17281_i0	PRJNA1233317	17317	181	2.893443	5.23713183	Streptococcus	1301	Bacteria	Bacteria	298	1.79e-76	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g17281	i0	100	291.67955801105	161	0	89	0	1	161	1571442	1571602	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	52794	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
21449015	21449015	PRJNA1233317_S_NODE_4657_length_325_cov_4.755639_g4621_i0	PRJNA1233317	4657	325	4.755639	15.45582675	Staphylococcus	1279	Bacteria	Bacteria	601	2.4199999999999993e-167	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g4621	i0	100	99.9723076923077	325	0	100	0	1	325	1462169	1461845	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	32491	601	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
23999247	23999247	PRJNA1233317_S_NODE_6299_length_297_cov_4.054622_g6263_i0	PRJNA1233317	6299	297	4.054622	12.04222734	Mammaliicoccus	2803850	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|2624849685\|gb\|CP120190.1\|	1296	g6263	i0	100	514.511784511785	297	0	100	0	1	297	562260	562556	Mammaliicoccus sciuri strain Dog011 chromosome, complete genome	blastn	152810	549	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sciuri
24561821	24561821	PRJNA1233317_S_NODE_2220_length_384_cov_3.566154_g2184_i0	PRJNA1233317	2220	384	3.566154	13.69403136	Jeotgalibaca porci	1868793	Bacteria	Bacteria	599	1.0399999999999995e-166	NTclustered	gi\|1821109506\|gb\|CP049889.1\|	1868793	g2184	i0	96.667	1.30208333333333	360	12	94	0	1	360	2082413	2082054	Jeotgalibaca porci strain CCUG 69148 chromosome, complete genome	blastn	500	599	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Jeotgalibaca	Jeotgalibaca porci
25273288	25273288	PRJNA1233317_S_NODE_15680_length_194_cov_1.355556_g15644_i0	PRJNA1233317	15680	194	1.355556	2.62977864	Sporosarcina	1569	Bacteria	Bacteria	348	1.91e-91	NTclustered	gi\|1005378703\|gb\|CP014616.1\|	1476	g15644	i0	98.969	883.726804123711	194	2	100	0	1	194	3749	3556	Sporosarcina psychrophila strain DSM 6497 chromosome, complete genome	blastn	171443	348	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina psychrophila
25273306	25273306	PRJNA1233317_S_NODE_5380_length_312_cov_2.169960_g5344_i0	PRJNA1233317	5380	312	2.16996	6.7702752	Staphylococcus	1279	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g5344	i0	100	100	312	0	100	0	1	312	251625	251936	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	31200	577	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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