metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA857143" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
844451	844451	PRJNA857143_S_NODE_82101_length_336_cov_1.133080_g81008_i0	PRJNA857143	82101	336	1.13308	3.8071488000000002	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|302777039\|gb\|CP002171.1\|	580327	g81008	i0	100	0.0863095238095238	29	0	9	0	298	326	1731647	1731619	Thermoanaerobacterium thermosaccharolyticum DSM 571, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
8495982	8495982	PRJNA857143_S_NODE_126087_length_286_cov_11.591549_g124994_i0	PRJNA857143	126087	286	11.591549	33.15183014	Pseudoflavonifractor gallinarum	2779352	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2777655128\|dbj\|AP031438.1\|	2779352	g124994	i0	100	0.0979020979020979	28	0	10	0	203	230	3222077	3222104	Pseudoflavonifractor gallinarum i42-0019-1B4 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor gallinarum
10163809	10163809	PRJNA857143_S_NODE_127628_length_285_cov_2.028302_g126535_i0	PRJNA857143	127628	285	2.028302	5.7806607	Bacillus	1386	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g126535	i0	100	1240.95789473684	285	0	100	0	1	285	12992	12708	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	353673	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
11046839	11046839	PRJNA857143_S_NODE_1369_length_1324_cov_7.980016_g1114_i0	PRJNA857143	1369	1324	7.980016	105.65541184	Cohnella cholangitidis	2598458	Bacteria	Bacteria	436	3.2e-117	NTclustered	gi\|1886419568\|gb\|CP041969.1\|	2598458	g1114	i0	76.613	300.39501510574	868	158	64	35	460	1309	1481104	1481944	Cohnella cholangitidis strain 1605-214 chromosome, complete genome	blastn	397723	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella cholangitidis
11439041	11439041	PRJNA857143_S_NODE_189829_length_244_cov_0.959064_g188736_i0	PRJNA857143	189829	244	0.959064	2.34011616	Bacteria	2	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g188736	i0	100	118.176229508197	244	0	100	0	1	244	547	304	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	28835	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12322759	12322759	PRJNA857143_S_NODE_175810_length_250_cov_1.282486_g174717_i0	PRJNA857143	175810	250	1.282486	3.206215	Pelosinus fermentans	365349	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|763683107\|gb\|CP010978.1\|	1192197	g174717	i0	98.4	536.208	250	4	100	0	1	250	28730	28481	Pelosinus fermentans JBW45, complete genome	blastn	134052	440	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Pelosinus	Pelosinus fermentans
16537870	16537870	PRJNA857143_S_NODE_120693_length_292_cov_0.990868_g119600_i0	PRJNA857143	120693	292	0.990868	2.89333456	root	1	Root_unresolved	Root_unresolved	331	3.1000000000000002e-86	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g119600	i0	100	107.441780821918	179	0	88	0	98	276	671	493	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	31373	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
16537945	16537945	PRJNA857143_S_NODE_6493_length_792_cov_7.293463_g5669_i0	PRJNA857143	6493	792	7.293463	57.76422696	Clostridium	1485	Bacteria	Bacteria	54.7	0.022	NTclustered	gi\|1944081129\|gb\|CP063959.1\|	1491	g5669	i0	100	0.227272727272727	29	0	4	0	575	603	1197664	1197692	Clostridium botulinum strain 3859/11 chromosome, complete genome	blastn	180	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
19086809	19086809	PRJNA857143_S_NODE_140055_length_274_cov_2.711443_g138962_i0	PRJNA857143	140055	274	2.711443	7.42935382	Bacillus	1386	Bacteria	Bacteria	58.4	5.41e-4	NTclustered	gi\|2893330844\|gb\|CP083238.1\|	1402	g138962	i0	97.059	0.886861313868613	34	1	12	0	169	202	60443	60476	Bacillus licheniformis strain 2709 chromosome, complete genome	blastn	243	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
19970447	19970447	PRJNA857143_S_NODE_21876_length_516_cov_1.126411_g20790_i0	PRJNA857143	21876	516	1.126411	5.81228076	Staphylococcus capitis	29388	Bacteria	Bacteria	84.2	1.79e-11	NTclustered	gi\|2770665075\|gb\|CP145244.1\|	74703	g20790	i0	87.5	0.201550387596899	72	9	14	0	264	335	1818763	1818692	Staphylococcus capitis subsp. urealyticus strain Sc1365670 chromosome, complete genome	blastn	104	84.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
21245519	21245519	PRJNA857143_S_NODE_161417_length_258_cov_1.351351_g160324_i0	PRJNA857143	161417	258	1.351351	3.48648558	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2318936730\|gb\|CP107220.1\|	2485925	g160324	i0	100	0.108527131782946	28	0	11	0	18	45	1494571	1494598	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0053 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
22519965	22519965	PRJNA857143_S_NODE_144818_length_271_cov_0.893939_g143725_i0	PRJNA857143	144818	271	0.893939	2.42257469	Staphylococcus hominis	1290	Bacteria	Bacteria	60.2	1.49e-4	NTclustered	gi\|2651490693\|gb\|CP121263.1\|	1290	g143725	i0	97.143	0.690036900369004	35	1	13	0	231	265	576265	576299	Staphylococcus hominis strain FSEL1 chromosome, complete genome	blastn	187	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
22912971	22912971	PRJNA857143_S_NODE_190318_length_244_cov_0.912281_g189225_i0	PRJNA857143	190318	244	0.912281	2.22596564	Paenibacillus	44249	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1868837427\|gb\|CP058552.1\|	2748863	g189225	i0	96.875	0.262295081967213	32	0	13	1	148	178	4157056	4157087	Paenibacillus sp. E222 chromosome	blastn	64	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. E222
23795891	23795891	PRJNA857143_S_NODE_187439_length_245_cov_1.116279_g186346_i0	PRJNA857143	187439	245	1.116279	2.73488355	Thermaerobacter marianensis	73919	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|315590829\|gb\|CP002344.1\|	644966	g186346	i0	100	0.114285714285714	28	0	11	0	49	76	307256	307283	Thermaerobacter marianensis DSM 12885, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiales Family XVII. Incertae Sedis	Thermaerobacter	Thermaerobacter marianensis

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