metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA345071" 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
393456	393456	PRJNA345071_P_NODE_6521_length_266_cov_1.616580_g6481_i0	PRJNA345071	6521	266	1.61658	4.3001028	Rossellomorea sp. y25	3118174	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2689064024\|gb\|CP145886.1\|	3118174	g6481	i0	100	0.105263157894737	28	0	11	0	100	127	643150	643177	Rossellomorea sp. y25 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea sp. y25
1070359	1070359	PRJNA345071_P_NODE_10421_length_243_cov_0.917647_g10381_i0	PRJNA345071	10421	243	0.917647	2.22988221	Bacillales	1385	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g10381	i0	100	519.864197530864	243	0	100	0	1	243	748827	748585	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	126327	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5496933	5496933	PRJNA345071_P_NODE_2685_length_358_cov_2.908772_g2645_i0	PRJNA345071	2685	358	2.908772	10.41340376	Anaerococcus nagyae	1755241	Bacteria	Bacteria	610	4.46e-170	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g2645	i0	97.479	152.751396648045	357	9	99	0	1	357	121133	121489	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	54685	610	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
7448253	7448253	PRJNA345071_P_NODE_11086_length_234_cov_3.366460_g11046_i0	PRJNA345071	11086	234	3.36646	7.8775164	Lactobacillus	1578	Bacteria	Bacteria	431	2.3e-116	NTclustered	gi\|1721134184\|emb\|LR698986.1\|	1587	g11046	i0	100	417.388888888889	233	0	99	0	2	234	981333	981565	Lactobacillus helveticus isolate MGYG-HGUT-02384 genome assembly, chromosome: 1	blastn	97669	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus helveticus
7448282	7448282	PRJNA345071_P_NODE_9306_length_247_cov_0.896552_g9266_i0	PRJNA345071	9306	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	457	4.05e-124	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g9266	i0	100	171	247	0	100	0	1	247	1370	1124	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	42237	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11273605	11273605	PRJNA345071_P_NODE_7629_length_253_cov_0.866667_g7589_i0	PRJNA345071	7629	253	0.866667	2.19266751	Lactiplantibacillus	2767842	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1611638273\|gb\|CP033616.1\|	1590	g7589	i0	100	100	253	0	100	0	1	253	146403	146655	Lactiplantibacillus plantarum strain J26 chromosome, complete genome	blastn	25300	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
16372931	16372931	PRJNA345071_P_NODE_10193_length_244_cov_0.912281_g10153_i0	PRJNA345071	10193	244	0.912281	2.22596564	Bacillati	1783272	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1663088249\|gb\|CP039160.1\|	1280	g10153	i0	100	53.9877049180328	244	0	100	0	1	244	2779085	2779328	Staphylococcus aureus strain Lr6 chromosome, complete genome	blastn	13173	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
18244895	18244895	PRJNA345071_P_NODE_3455_length_329_cov_3.535156_g3415_i0	PRJNA345071	3455	329	3.535156	11.63066324	Anaerococcus nagyae	1755241	Bacteria	Bacteria	603	6.819999999999999e-168	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g3415	i0	100	318.127659574468	326	0	99	0	3	328	122210	121885	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	104664	603	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
18921871	18921871	PRJNA345071_P_NODE_8475_length_250_cov_0.881356_g8435_i0	PRJNA345071	8475	250	0.881356	2.20339	Anaerococcus	165779	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g8435	i0	99.6	604.6	250	1	100	0	1	250	123153	122904	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	151150	457	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
19519265	19519265	PRJNA345071_P_NODE_9596_length_246_cov_0.901734_g9556_i0	PRJNA345071	9596	246	0.901734	2.21826564	Candidatus Lachnocurva vaginae	699240	Bacteria	Bacteria	377	3.2300000000000003e-100	NTclustered	gi\|1820025701\|gb\|CP049781.1\|	699240	g9556	i0	94.65	0.98780487804878	243	13	99	0	3	245	588851	588609	MAG: Candidatus Lachnocurva vaginae isolate UAB071 chromosome, complete genome	blastn	243	377	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Lachnocurva	Candidatus Lachnocurva vaginae
20794756	20794756	PRJNA345071_P_NODE_4837_length_293_cov_2.031818_g4797_i0	PRJNA345071	4837	293	2.031818	5.95322674	Anaerococcus sp. WGS1596	3366806	Bacteria	Bacteria	492	1.35e-134	NTclustered	gi\|2831295055\|gb\|CP170995.1\|	3366806	g4797	i0	96.939	158.21843003413	294	8	100	1	1	293	481381	481674	Anaerococcus sp. WGS1596 chromosome, complete genome	blastn	46358	492	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
21472120	21472120	PRJNA345071_P_NODE_6857_length_262_cov_1.449735_g6817_i0	PRJNA345071	6857	262	1.449735	3.7983057	Streptococcus	1301	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g6817	i0	100	327	262	0	100	0	1	262	625483	625222	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	85674	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
21472121	21472121	PRJNA345071_P_NODE_7197_length_257_cov_3.201087_g7157_i0	PRJNA345071	7197	257	3.201087	8.22679359	Streptococcus	1301	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1686100227\|gb\|MK330575.1\|	28037	g7157	i0	100	323.906614785992	257	0	100	0	1	257	2041	1785	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	83244	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
23345169	23345169	PRJNA345071_P_NODE_10959_length_239_cov_3.987952_g10919_i0	PRJNA345071	10959	239	3.987952	9.53120528	Anaerococcus nagyae	1755241	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g10919	i0	97.071	593.983263598326	239	7	100	0	1	239	123671	123433	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	141962	403	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
24022186	24022186	PRJNA345071_P_NODE_8139_length_251_cov_0.876404_g8099_i0	PRJNA345071	8139	251	0.876404	2.19977404	Enterococcus	1350	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g8099	i0	100	100	251	0	100	0	1	251	1588216	1587966	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	25100	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
24619602	24619602	PRJNA345071_P_NODE_7660_length_253_cov_0.866667_g7620_i0	PRJNA345071	7660	253	0.866667	2.19266751	Finegoldia magna	1260	Bacteria	Bacteria	379	9.269999999999998e-101	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g7620	i0	93.676	3.02371541501976	253	16	100	0	1	253	935590	935842	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	765	379	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna

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