metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA576995" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA576995" 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
560904	560904	PRJNA576995_P_NODE_35761_length_250_cov_0.870056_g35169_i0	PRJNA576995	35761	250	0.870056	2.17514	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2188895606\|dbj\|AP025583.1\|	2485925	g35169	i0	100	0.24	30	0	12	87	116	2848823	2848794	Oscillospiraceae bacterium CE91-St40 DNA, complete genome	blastn	60	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
1136988	1136988	PRJNA576995_P_NODE_32521_length_264_cov_1.403141_g31929_i0	PRJNA576995	32521	264	1.403141	3.70429224	Bacillales	1385	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g31929	i0	99.621	533.598484848485	264	1	100	1	264	750197	749934	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	140870	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1137004	1137004	PRJNA576995_P_NODE_39641_length_246_cov_0.890173_g39049_i0	PRJNA576995	39641	246	0.890173	2.18982558	Pseudolactococcus	3436058	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|802122382\|emb\|LN774769.1\|	297352	g39049	i0	100	553.849593495935	246	0	100	1	246	33022	32777	Lactococcus piscium MKFS47 genome assembly L_piscium, chromosome : I	blastn	136247	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Pseudolactococcus	Pseudolactococcus piscium
2412403	2412403	PRJNA576995_P_NODE_36382_length_249_cov_1.426136_g35790_i0	PRJNA576995	36382	249	1.426136	3.55107864	Streptococcus	1301	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g35790	i0	99.598	337	249	1	100	1	249	1835234	1834986	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	83913	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
5664470	5664470	PRJNA576995_P_NODE_33905_length_255_cov_1.692308_g33313_i0	PRJNA576995	33905	255	1.692308	4.3153854	Vescimonas coprocola	2714355	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2025053910\|dbj\|AP023418.1\|	2714355	g33313	i0	100	0.109803921568627	28	0	11	80	107	1591305	1591332	Vescimonas coprocola MM50 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Vescimonas	Vescimonas coprocola
6240570	6240570	PRJNA576995_P_NODE_39705_length_246_cov_0.890173_g39113_i0	PRJNA576995	39705	246	0.890173	2.18982558	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1830032422\|gb\|CP050982.1\|	1290	g39113	i0	100	98.0894308943089	246	0	100	1	246	1854548	1854793	Staphylococcus hominis strain FDAARGOS_745 chromosome	blastn	24130	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
6938942	6938942	PRJNA576995_P_NODE_35346_length_251_cov_0.865169_g34754_i0	PRJNA576995	35346	251	0.865169	2.17157419	Desemzia incerta	82801	Bacteria	Bacteria	392	1.18e-104	NTclustered	gi\|2511735789\|gb\|CP126128.1\|	82801	g34754	i0	94.821	539.482071713147	251	13	100	1	251	390620	390870	Desemzia incerta strain EGm139 chromosome, complete genome	blastn	135410	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Desemzia	Desemzia incerta
7514807	7514807	PRJNA576995_P_NODE_32326_length_265_cov_1.598958_g31734_i0	PRJNA576995	32326	265	1.598958	4.2372387	Exiguobacterium	33986	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g31734	i0	99.623	753.788679245283	265	1	100	1	265	12964	13228	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	199754	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
8789832	8789832	PRJNA576995_P_NODE_33607_length_257_cov_1.673913_g33015_i0	PRJNA576995	33607	257	1.673913	4.30195641	Streptococcus	1301	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g33015	i0	100	558.385214007782	257	0	100	1	257	161660	161916	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	143505	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
12615963	12615963	PRJNA576995_P_NODE_24150_length_310_cov_2.573840_g23558_i0	PRJNA576995	24150	310	2.57384	7.978904	root	1	Root_unresolved	Root_unresolved	573	4.999999999999998e-159	NTclustered	gi\|529813127\|gb\|KF306379.1\|	1292	g23558	i0	100	105.167741935484	310	0	100	1	310	1402	1093	Staphylococcus warneri strain y357 16S ribosomal RNA gene, partial sequence	blastn	32602	573	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
15863550	15863550	PRJNA576995_P_NODE_39953_length_245_cov_0.895349_g39361_i0	PRJNA576995	39953	245	0.895349	2.19360505	Staphylococcus cohnii	29382	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g39361	i0	100	7.88163265306122	245	0	100	1	245	412082	412326	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	1931	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
17138450	17138450	PRJNA576995_P_NODE_37854_length_248_cov_0.880000_g37262_i0	PRJNA576995	37854	248	0.88	2.1824	Granulicatella elegans	137732	Bacteria	Bacteria	451	1.89e-122	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g37262	i0	99.595	457.334677419355	247	1	99	1	247	106245	105999	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	113419	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
18988327	18988327	PRJNA576995_P_NODE_40855_length_244_cov_0.900585_g40263_i0	PRJNA576995	40855	244	0.900585	2.1974274	Sulfobacillus	28033	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|361052061\|gb\|CP003179.1\|	679936	g40263	i0	100	0.229508196721311	28	0	11	170	197	1915286	1915313	Sulfobacillus acidophilus DSM 10332, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiales Family XVII. Incertae Sedis	Sulfobacillus	Sulfobacillus acidophilus
18988330	18988330	PRJNA576995_P_NODE_42355_length_242_cov_0.911243_g41763_i0	PRJNA576995	42355	242	0.911243	2.20520806	Mediterraneibacter	2316020	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1988050162\|gb\|CP070036.1\|	33038	g41763	i0	100	469.392561983471	242	0	100	1	242	441443	441202	Mediterraneibacter gnavus strain FDAARGOS_1342 chromosome, complete genome	blastn	113593	448	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
20263465	20263465	PRJNA576995_P_NODE_31516_length_270_cov_1.299492_g30924_i0	PRJNA576995	31516	270	1.299492	3.5086284	Staphylococcus	1279	Bacteria	Bacteria	497	2.6399999999999998e-136	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g30924	i0	100	99.7148148148148	269	0	99	2	270	1643327	1643059	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	26923	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20263480	20263480	PRJNA576995_P_NODE_37636_length_248_cov_0.880000_g37044_i0	PRJNA576995	37636	248	0.88	2.1824	Bacillus	1386	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2029954974\|gb\|CP047645.1\|	1423	g37044	i0	100	100	248	0	100	1	248	1581740	1581493	Bacillus subtilis strain PMB102 chromosome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
21538927	21538927	PRJNA576995_P_NODE_35197_length_251_cov_0.865169_g34605_i0	PRJNA576995	35197	251	0.865169	2.17157419	Anaerococcus	165779	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g34605	i0	100	392.051792828685	251	0	100	1	251	2418	2168	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	98405	464	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
22237944	22237944	PRJNA576995_P_NODE_42198_length_242_cov_0.911243_g41606_i0	PRJNA576995	42198	242	0.911243	2.20520806	Paenibacillus sp. CAA11	1532905	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1379398788\|gb\|CP028922.1\|	1532905	g41606	i0	100	0.119834710743802	29	0	12	40	68	1854718	1854690	Paenibacillus sp. CAA11 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. CAA11
23513109	23513109	PRJNA576995_P_NODE_31419_length_270_cov_1.969543_g30827_i0	PRJNA576995	31419	270	1.969543	5.3177661	Ornithinibacillus sp. FSL M8-0202	2921616	Bacteria	Bacteria	436	5.8499999999999985e-118	NTclustered	gi\|2709838836\|gb\|CP150248.1\|	2921616	g30827	i0	95.911	890.914814814815	269	11	99	1	269	1020350	1020082	Ornithinibacillus sp. FSL M8-0202 chromosome, complete genome	blastn	240547	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ornithinibacillus	Ornithinibacillus sp. FSL M8-0202

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