metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA562549" 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
2406213	2406213	PRJNA562549_P_NODE_23762_length_240_cov_2.385475_g23529_i0	PRJNA562549	23762	240	2.385475	5.72514	Bacillati	1783272	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|470488168\|ref\|NR_076854.1\|	1579	g23529	i0	100	421.7625	240	0	100	0	1	240	2645	2884	Lactobacillus acidophilus strain 30SC 23S ribosomal RNA gene, complete sequence	blastn	101223	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus
2406293	2406293	PRJNA562549_P_NODE_37202_length_197_cov_2.764706_g36969_i0	PRJNA562549	37202	197	2.764706	5.44647082	Lactobacillus	1578	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g36969	i0	100	385.274111675127	197	0	100	0	1	197	1146046	1145850	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	75899	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
4958939	4958939	PRJNA562549_P_NODE_25764_length_231_cov_2.870588_g25531_i0	PRJNA562549	25764	231	2.870588	6.63105828	Staphylococcus	1279	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g25531	i0	100	534.761904761905	231	0	100	0	1	231	748724	748494	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	123530	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4959010	4959010	PRJNA562549_P_NODE_35084_length_204_cov_2.328671_g34851_i0	PRJNA562549	35084	204	2.328671	4.75048884	root	1	Root_unresolved	Root_unresolved	377	2.59e-100	NTclustered	gi\|308824094\|emb\|FP565809.1\|	1511	g34851	i0	100	110	204	0	100	0	1	204	15185	14982	Clostridium sticklandii str. DSM 519 chromosome, complete genome	blastn	22440	377	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium sticklandii
6234444	6234444	PRJNA562549_P_NODE_29445_length_217_cov_2.621795_g29212_i0	PRJNA562549	29445	217	2.621795	5.68929515	Staphylococcus	1279	Bacteria	Bacteria	396	7.689999999999997e-106	NTclustered	gi\|1279117992\|gb\|MG547954.1\|	1290	g29212	i0	99.539	169.972350230415	217	1	100	0	1	217	229	13	Staphylococcus hominis strain SOT3 16S ribosomal RNA gene, partial sequence	blastn	36884	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
11334040	11334040	PRJNA562549_P_NODE_38409_length_182_cov_5.545455_g38176_i0	PRJNA562549	38409	182	5.545455	10.0927281	Lactobacillus	1578	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g38176	i0	100	471.587912087912	182	0	100	0	1	182	90356	90537	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	85829	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
12609761	12609761	PRJNA562549_P_NODE_18870_length_267_cov_1.936893_g18637_i0	PRJNA562549	18870	267	1.936893	5.17150431	Veillonella	29465	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g18637	i0	100	633.655430711611	267	0	100	0	1	267	1410282	1410548	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	169186	494	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
14574655	14574655	PRJNA562549_P_NODE_14992_length_297_cov_2.118644_g14759_i0	PRJNA562549	14992	297	2.118644	6.29237268	Granulicatella adiacens	46124	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|2315116068\|gb\|CP106751.1\|	46124	g14759	i0	100	421.080808080808	297	0	100	0	1	297	1630727	1630431	Granulicatella adiacens strain KHUD_009 chromosome, complete genome	blastn	125061	549	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella adiacens
15158884	15158884	PRJNA562549_P_NODE_25752_length_231_cov_3.317647_g25519_i0	PRJNA562549	25752	231	3.317647	7.66376457	Bacillati	1783272	Bacteria	Bacteria	409	1.0600000000000001e-109	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g25519	i0	99.119	492.142857142857	227	2	98	0	1	227	748970	748744	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	113685	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15158895	15158895	PRJNA562549_P_NODE_26872_length_227_cov_1.819277_g26639_i0	PRJNA562549	26872	227	1.819277	4.12975879	Lactobacillus	1578	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g26639	i0	100	422.044052863436	227	0	100	0	1	227	89909	89683	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	95804	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
16433573	16433573	PRJNA562549_P_NODE_36793_length_200_cov_3.978417_g36560_i0	PRJNA562549	36793	200	3.978417	7.956834	Lactobacillus	1578	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g36560	i0	100	426.045	200	0	100	0	1	200	90916	90717	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	85209	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
17123360	17123360	PRJNA562549_P_NODE_15774_length_290_cov_1.921397_g15541_i0	PRJNA562549	15774	290	1.921397	5.5720513	Macrococcus armenti	2875764	Bacteria	Bacteria	396	1.08e-105	NTclustered	gi\|2099412911\|gb\|CP083608.1\|	2875764	g15541	i0	91.379	431.834482758621	290	23	99	2	2	290	359241	358953	Macrococcus armenti strain JEK37 chromosome, complete genome	blastn	125232	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus armenti
19672294	19672294	PRJNA562549_P_NODE_33836_length_207_cov_0.890411_g33603_i0	PRJNA562549	33836	207	0.890411	1.84315077	Mammaliicoccus stepanovicii	643214	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1231729876\|emb\|LT906462.1\|	643214	g33603	i0	96.774	0.14975845410628	31	1	15	0	171	201	546073	546103	Staphylococcus stepanovicii strain NCTC13839 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus stepanovicii
20257364	20257364	PRJNA562549_P_NODE_26496_length_228_cov_3.455090_g26263_i0	PRJNA562549	26496	228	3.45509	7.8776052	Carnobacterium	2747	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g26263	i0	100	392.140350877193	228	0	100	0	1	228	97138	96911	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	89408	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
21532738	21532738	PRJNA562549_P_NODE_10437_length_355_cov_3.931973_g10204_i0	PRJNA562549	10437	355	3.931973	13.95850415	Staphylococcus	1279	Bacteria	Bacteria	656	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10204	i0	100	474.380281690141	355	0	100	0	1	355	750816	750462	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	168405	656	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21532781	21532781	PRJNA562549_P_NODE_16457_length_284_cov_4.771300_g16224_i0	PRJNA562549	16457	284	4.7713	13.550492	root	1	Root_unresolved	Root_unresolved	525	1.2899999999999994e-144	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g16224	i0	100	180	284	0	100	0	1	284	1414	1131	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	51120	525	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22222892	22222892	PRJNA562549_P_NODE_38178_length_190_cov_2.015504_g37945_i0	PRJNA562549	38178	190	2.015504	3.8294576	Finegoldia magna	1260	Bacteria	Bacteria	346	6.690000000000001e-91	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g37945	i0	99.474	211.878947368421	190	1	100	0	1	190	426369	426180	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	40257	346	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
22808076	22808076	PRJNA562549_P_NODE_6378_length_456_cov_0.875949_g6145_i0	PRJNA562549	6378	456	0.875949	3.99432744	Romboutsia	1501226	Bacteria	Bacteria	728	0	NTclustered	gi\|1172272411\|emb\|LN555523.1\|	1115758	g6145	i0	95.425	1166.0548245614	459	17	100	4	1	456	3376	3833	Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1	blastn	531721	734	0.991825613079019	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia ilealis
23498051	23498051	PRJNA562549_P_NODE_18459_length_270_cov_1.138756_g18226_i0	PRJNA562549	18459	270	1.138756	3.0746412	Clostridium baratii	1561	Bacteria	Bacteria	464	2.6799999999999994e-126	NTclustered	gi\|2695230292\|gb\|CP124315.1\|	1561	g18226	i0	97.445	1013.4	274	3	100	2	1	270	6592	6319	Clostridium baratii strain C161 chromosome	blastn	273618	464	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium baratii
24082711	24082711	PRJNA562549_P_NODE_16219_length_286_cov_6.600000_g15986_i0	PRJNA562549	16219	286	6.6	18.876	Streptococcus	1301	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1686100227\|gb\|MK330575.1\|	28037	g15986	i0	100	324	286	0	100	0	1	286	2075	1790	Streptococcus mitis strain PL429 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	92664	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
24082876	24082876	PRJNA562549_P_NODE_38879_length_167_cov_5.735849_g38646_i0	PRJNA562549	38879	167	5.735849	9.57886783	Carnobacterium	2747	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g38646	i0	100	528.041916167665	167	0	100	0	1	167	98134	98300	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	88183	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
25357078	25357078	PRJNA562549_P_NODE_13720_length_310_cov_3.441767_g13487_i0	PRJNA562549	13720	310	3.441767	10.6694777	Bacillales	1385	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g13487	i0	100	533.9	310	0	100	0	1	310	750202	749893	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	165509	573	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25357232	25357232	PRJNA562549_P_NODE_36760_length_201_cov_2.028571_g36527_i0	PRJNA562549	36760	201	2.028571	4.07742771	Streptococcus	1301	Bacteria	Bacteria	348	1.99e-91	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g36527	i0	98	541.323383084577	200	4	99	0	2	201	163082	163281	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	108806	348	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus

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