metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1111082" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1111082" 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	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
1489924	1489924	PRJNA1111082_P_NODE_11062_length_250_cov_0.864407_g11017_i0	PRJNA1111082	11062	250	0.864407	2.1610175	Blautia obeum	40520	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|295107714\|emb\|FP929054.1\|	657314	g11017	i0	99.2	472.804	250	2	100	1	250	3227627	3227876	Ruminococcus obeum A2-162 draft genome	blastn	118201	451	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia obeum
2296702	2296702	PRJNA1111082_P_NODE_11402_length_248_cov_0.891429_g11357_i0	PRJNA1111082	11402	248	0.891429	2.21074392	Clostridioides	1870884	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2053274780\|gb\|CP037818.1\|	1496	g11357	i0	99.597	100	248	1	100	1	248	514857	514610	Clostridioides difficile strain Cd14 chromosome, complete genome	blastn	24800	453	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
3571831	3571831	PRJNA1111082_P_NODE_12023_length_245_cov_0.906977_g11978_i0	PRJNA1111082	12023	245	0.906977	2.22209365	Clostridia	186801	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|291545299\|emb\|FP929053.1\|	657323	g11978	i0	95.918	4	245	10	100	1	245	1544047	1543803	Ruminococcus sp. SR1/5 draft genome	blastn	980	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. SR1/5
5318117	5318117	PRJNA1111082_P_NODE_11045_length_250_cov_0.881356_g11000_i0	PRJNA1111082	11045	250	0.881356	2.20339	Paenibacillus urinalis	521520	Bacteria	Bacteria	340	4.31e-89	NTclustered	gi\|2446590601\|gb\|CP118106.1\|	521520	g11000	i0	91.2	3	250	22	100	1	250	2408601	2408850	Paenibacillus urinalis strain 2022CK-00833 chromosome, complete genome	blastn	750	340	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus urinalis
6593335	6593335	PRJNA1111082_P_NODE_11026_length_250_cov_0.881356_g10981_i0	PRJNA1111082	11026	250	0.881356	2.20339	Agathobacter rectalis	39491	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2264318351\|gb\|CP100127.1\|	39491	g10981	i0	99.6	8	250	1	100	1	250	2613152	2613401	Agathobacter rectalis strain NB2A-17-FMU chromosome	blastn	2000	457	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
18066864	18066864	PRJNA1111082_P_NODE_10615_length_252_cov_0.871508_g10570_i0	PRJNA1111082	10615	252	0.871508	2.19620016	Veillonella parvula	29466	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2777568751\|dbj\|AP031417.1\|	29466	g10570	i0	99.603	3.5952380952381	252	1	100	1	252	135463	135212	Veillonella parvula f34 DNA, complete genome	blastn	906	460	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
20616537	20616537	PRJNA1111082_P_NODE_4957_length_354_cov_1.320285_g4912_i0	PRJNA1111082	4957	354	1.320285	4.6738089	Anaerobutyricum hallii	39488	Bacteria	Bacteria	649	0	NTclustered	gi\|2029783370\|gb\|CP073280.1\|	39488	g4912	i0	99.718	500.149717514124	354	1	100	1	354	1723906	1723553	Anaerobutyricum hallii strain EHAL chromosome	blastn	177053	649	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerobutyricum	Anaerobutyricum hallii
21892048	21892048	PRJNA1111082_P_NODE_10998_length_250_cov_0.881356_g10953_i0	PRJNA1111082	10998	250	0.881356	2.20339	Lachnospiraceae bacterium GAM79	2109691	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1394501677\|dbj\|AP018536.1\|	2109691	g10953	i0	98	2.948	250	5	100	1	250	1415277	1415526	Lachnospiraceae bacterium GAM79 DNA, complete genome	blastn	737	435	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium GAM79
21892285	21892285	PRJNA1111082_P_NODE_8738_length_275_cov_1.267327_g8693_i0	PRJNA1111082	8738	275	1.267327	3.48514925	Pusillibacter faecalis	2714358	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2025056735\|dbj\|AP023420.1\|	2714358	g8693	i0	99.636	80.5090909090909	275	1	100	1	275	2597045	2596771	Pusillimonas faecalis MM59 DNA, complete genome	blastn	22140	503	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pusillibacter	Pusillibacter faecalis
25247650	25247650	PRJNA1111082_P_NODE_12200_length_244_cov_0.912281_g12155_i0	PRJNA1111082	12200	244	0.912281	2.22596564	Clostridia	186801	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|291545299\|emb\|FP929053.1\|	657323	g12155	i0	99.59	3.99180327868852	244	1	100	1	244	1889626	1889383	Ruminococcus sp. SR1/5 draft genome	blastn	974	446	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. SR1/5

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