metadata: contig_metadata: 12 rows where bioproject = "PRJEB15333" and tax

12 rows where bioproject = "PRJEB15333" 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
985831	985831	PRJEB15333_P_NODE_12081_length_196_cov_2.761905_g11997_i0	PRJEB15333	12081	196	2.761905	5.4133338	Streptococcus	1301	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g11997	i0	100	332.061224489796	192	0	98	0	1	192	1571341	1571532	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	65084	355	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
985834	985834	PRJEB15333_P_NODE_7961_length_237_cov_1.654255_g7877_i0	PRJEB15333	7961	237	1.654255	3.92058435	root	1	Root_unresolved	Root_unresolved	438	1.4e-118	NTclustered	gi\|1861649571\|gb\|MT664063.1\|	1306	g7877	i0	100	100	237	0	100	0	1	237	312	76	Streptococcus sp. strain KCOM 2447 (= ChDC F176) 16S ribosomal RNA gene, partial sequence	blastn	23700	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
10224366	10224366	PRJEB15333_P_NODE_3669_length_332_cov_1.098940_g3585_i0	PRJEB15333	3669	332	1.09894	3.6484808	Anaerococcus nagyae	1755241	Bacteria	Bacteria	553	7.029999999999998e-153	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g3585	i0	96.96	49.7409638554217	329	10	99	0	3	331	121082	121410	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	16514	553	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
11499638	11499638	PRJEB15333_P_NODE_16830_length_169_cov_1.300000_g16746_i0	PRJEB15333	16830	169	1.3	2.197	Metabacillus halosaccharovorans	930124	Bacteria	Bacteria	296	5.9e-76	NTclustered	gi\|2780438057\|gb\|CP162630.1\|	930124	g16746	i0	98.225	804.568047337278	169	3	100	0	1	169	14208	14040	Metabacillus halosaccharovorans strain Hao 2024 chromosome, complete genome	blastn	135972	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus halosaccharovorans
15013689	15013689	PRJEB15333_P_NODE_14712_length_180_cov_1.190840_g14628_i0	PRJEB15333	14712	180	1.19084	2.143512	Exiguobacterium	33986	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g14628	i0	100	654.194444444444	180	0	100	0	1	180	473560	473381	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	117755	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
15013694	15013694	PRJEB15333_P_NODE_5812_length_272_cov_3.748879_g5728_i0	PRJEB15333	5812	272	3.748879	10.19695088	Streptococcus	1301	Bacteria	Bacteria	496	9.59e-136	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g5728	i0	99.631	330.882352941176	271	1	99	0	2	272	18076	17806	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	90000	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15013698	15013698	PRJEB15333_P_NODE_9512_length_219_cov_1.994118_g9428_i0	PRJEB15333	9512	219	1.994118	4.36711842	Streptococcus	1301	Bacteria	Bacteria	403	4.64e-108	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g9428	i0	100	346.438356164384	218	0	99	0	1	218	1568791	1569008	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	75870	403	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
18837642	18837642	PRJEB15333_P_NODE_20435_length_162_cov_1.566372_g20351_i0	PRJEB15333	20435	162	1.566372	2.53752264	Bacillus	1386	Bacteria	Bacteria	58.4	2.9e-4	NTclustered	gi\|942009880\|gb\|CP013000.1\|	1428	g20351	i0	100	5.35802469135802	31	0	19	0	27	57	251825	251795	Bacillus thuringiensis strain XL6 chromosome, complete genome	blastn	868	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
26684819	26684819	PRJEB15333_P_NODE_3661_length_332_cov_1.869258_g3577_i0	PRJEB15333	3661	332	1.869258	6.20593656	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	43.9	0.0393	NR	MBQ6539838.1	2485925	g3577	i0	31.8	0.795180722891566	88	53	75.9	4	3	254	155	239	MBQ6539838.1 sodium:proton antiporter [Oscillospiraceae bacterium]	diamond	264	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27633542	27633542	PRJEB15333_P_NODE_17384_length_168_cov_0.873950_g17300_i0	PRJEB15333	17384	168	0.87395	1.468236	Bacillales bacterium	1904864	Bacteria	Bacteria	75.9	2.76e-14	NR	HET7580570.1	1904864	g17300	i0	72.7	1.96428571428571	55	14	98.2	1	2	166	372	425	HET7580570.1 DNA polymerase/3'-5' exonuclease PolX [Bacillales bacterium]	diamond	330	75.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales bacterium
28927936	28927936	PRJEB15333_P_NODE_20528_length_162_cov_0.920354_g20444_i0	PRJEB15333	20528	162	0.920354	1.49097348	Eubacteriales Family XIII. Incertae Sedis	543314	Bacteria	Bacteria	41.2	0.0401	NR	WP_148396037.1	543314	g20444	i0	39.2	0.944444444444444	51	28	90.7	2	16	162	42	91	WP_148396037.1 MULTISPECIES: phosphatase PAP2 family protein [Anaerovoracaceae]	diamond	153	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae
31163869	31163869	PRJEB15333_P_NODE_18615_length_166_cov_0.888889_g18531_i0	PRJEB15333	18615	166	0.888889	1.47555574	Bacillaceae	186817	Bacteria	Bacteria	104	3.26e-25	NR	WP_134339215.1	94137	g18531	i0	90.9	27.8313253012048	55	5	99.4	0	165	1	221	275	WP_134339215.1 recombinase RecA [Filobacillus milosensis]	diamond	4620	105	0.990476190476191	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Filobacillus	Filobacillus milosensis

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