metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA382558" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA382558" 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
1075677	1075677	PRJNA382558_S_NODE_3141_length_240_cov_6.147783_g3137_i0	PRJNA382558	3141	240	6.147783	14.7546792	Staphylococcus	1279	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g3137	i0	97.5	478.004166666667	240	6	100	0	1	240	1785587	1785348	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	114721	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2351115	2351115	PRJNA382558_S_NODE_6022_length_200_cov_11.269939_g6018_i0	PRJNA382558	6022	200	11.269939	22.539878	Bacillus	1386	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2273857370\|gb\|CP101399.1\|	293387	g6018	i0	94.595	16.62	37	1	19	1	59	95	3435919	3435884	Bacillus altitudinis strain HM-7 chromosome, complete genome	blastn	3324	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus altitudinis
4232098	4232098	PRJNA382558_S_NODE_5724_length_204_cov_4.041916_g5720_i0	PRJNA382558	5724	204	4.041916	8.24550864	Bacillus cereus	1396	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|301030550\|gb\|GU230872.1\|	1396	g5720	i0	99.51	1	204	1	100	0	1	204	358	155	Bacillus cereus strain ATCC 12480 transposase gene, partial cds	blastn	204	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
6178653	6178653	PRJNA382558_S_NODE_11305_length_166_cov_9.581395_g11301_i0	PRJNA382558	11305	166	9.581395	15.9051157	Bacillales	1385	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g11301	i0	100	510.024096385542	166	0	100	0	1	166	748775	748610	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	84664	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6782737	6782737	PRJNA382558_S_NODE_9306_length_176_cov_9.107914_g9302_i0	PRJNA382558	9306	176	9.107914	16.02992864	Streptococcus oralis	1303	Bacteria	Bacteria	300	4.8e-77	NTclustered	gi\|288522\|emb\|X68427.1\|	1303	g9302	i0	97.701	323.130681818182	174	4	99	0	2	175	1411	1238	S.oralis gene for 23S rRNA	blastn	56871	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
16378240	16378240	PRJNA382558_S_NODE_9313_length_176_cov_8.791367_g9309_i0	PRJNA382558	9313	176	8.791367	15.47280592	Staphylococcus	1279	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g9309	i0	99.432	500.914772727273	176	1	100	0	1	176	784016	783841	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	88161	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16982419	16982419	PRJNA382558_S_NODE_9874_length_173_cov_8.566176_g9870_i0	PRJNA382558	9874	173	8.566176	14.81948448	Hathewaya histolytica	1498	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g9870	i0	100	733.791907514451	170	0	98	0	4	173	1185	1016	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	126946	315	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
18927190	18927190	PRJNA382558_S_NODE_13835_length_156_cov_11.042017_g13831_i0	PRJNA382558	13835	156	11.042017	17.22554652	Streptococcus	1301	Bacteria	Bacteria	278	1.95e-70	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g13831	i0	98.718	325.794871794872	156	2	100	0	1	156	1569626	1569471	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	50824	278	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
19530853	19530853	PRJNA382558_S_NODE_7956_length_185_cov_5.385135_g7952_i0	PRJNA382558	7956	185	5.385135	9.96249975	Bacillus cereus	1396	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|301030550\|gb\|GU230872.1\|	1396	g7952	i0	100	1	185	0	100	0	1	185	694	510	Bacillus cereus strain ATCC 12480 transposase gene, partial cds	blastn	185	342	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus

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