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

19 rows where analysis = "blastn", bioproject = "PRJNA559720" 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
4370851	4370851	PRJNA559720_P_NODE_10304_length_302_cov_1.257642_g10165_i0	PRJNA559720	10304	302	1.257642	3.79807884	Priestia megaterium	1404	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1844619902\|gb\|CP045273.1\|	1404	g10165	i0	100	0.0927152317880795	28	0	9	195	222	530134	530107	Priestia megaterium strain FDU301 plasmid pFDU301A, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
4370932	4370932	PRJNA559720_P_NODE_15544_length_244_cov_0.900585_g15405_i0	PRJNA559720	15544	244	0.900585	2.1974274	Mageeibacillus indolicus	884684	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|307346916\|gb\|CP001850.2\|	699246	g15405	i0	99.18	21.7418032786885	244	2	100	1	244	1736426	1736183	Mageeibacillus indolicus UPII9-5 chromosome, complete genome	blastn	5305	440	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Mageeibacillus	Mageeibacillus indolicus
4958469	4958469	PRJNA559720_P_NODE_16104_length_242_cov_0.911243_g15965_i0	PRJNA559720	16104	242	0.911243	2.20520806	Veillonella	29465	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1231683529\|emb\|LT906445.1\|	29466	g15965	i0	100	15.9710743801653	242	0	100	1	242	1686633	1686392	Veillonella parvula strain NCTC11810 genome assembly, chromosome: 1	blastn	3865	448	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
9472188	9472188	PRJNA559720_P_NODE_6348_length_406_cov_8.450450_g6209_i0	PRJNA559720	6348	406	8.45045	34.308827	Staphylococcus epidermidis	1282	Bacteria	Bacteria	60.2	2.33e-4	NTclustered	gi\|1369209706\|gb\|MG787416.1\|	1282	g6209	i0	100	0.0788177339901478	32	0	8	48	79	3685	3654	Staphylococcus epidermidis strain I14OR1 ACME IV mobile element, complete sequence	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10058917	10058917	PRJNA559720_P_NODE_13048_length_257_cov_1.673913_g12909_i0	PRJNA559720	13048	257	1.673913	4.30195641	Staphylococcus	1279	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g12909	i0	99.611	40.0077821011673	257	1	100	1	257	2054992	2054736	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	10282	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
10058922	10058922	PRJNA559720_P_NODE_14388_length_248_cov_0.880000_g14249_i0	PRJNA559720	14388	248	0.88	2.1824	Bacillati	1783272	Bacteria	Bacteria	250	7.41e-62	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g14249	i0	93.939	10.1048387096774	165	10	67	84	248	675529	675365	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	2506	250	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
10747814	10747814	PRJNA559720_P_NODE_11269_length_285_cov_1.240566_g11130_i0	PRJNA559720	11269	285	1.240566	3.5356131	Staphylococcus epidermidis	1282	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g11130	i0	99.649	100	285	1	100	1	285	1881201	1880917	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	28500	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12609319	12609319	PRJNA559720_P_NODE_13570_length_251_cov_0.865169_g13431_i0	PRJNA559720	13570	251	0.865169	2.17157419	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1143273938\|gb\|CP019597.1\|	29382	g13431	i0	100	7	251	0	100	1	251	743819	744069	Staphylococcus cohnii strain SNUDS-2 chromosome, complete genome	blastn	1757	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
13297615	13297615	PRJNA559720_P_NODE_16351_length_241_cov_0.916667_g16212_i0	PRJNA559720	16351	241	0.916667	2.20916747	Marinilactibacillus sp. 15R	1911586	Bacteria	Bacteria	351	1.91e-92	NTclustered	gi\|1112927908\|gb\|CP017761.1\|	1911586	g16212	i0	92.946	1	241	17	100	1	241	2256372	2256612	Marinilactibacillus sp. 15R chromosome, complete sequence	blastn	241	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Marinilactibacillus	Marinilactibacillus sp. 15R
15846315	15846315	PRJNA559720_P_NODE_14453_length_248_cov_0.880000_g14314_i0	PRJNA559720	14453	248	0.88	2.1824	Agathobacter rectalis	39491	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|291526582\|emb\|FP929043.1\|	657317	g14314	i0	99.194	6.54435483870968	248	2	100	1	248	2663089	2662842	Eubacterium rectale M104/1 draft genome	blastn	1623	448	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
16433079	16433079	PRJNA559720_P_NODE_15873_length_243_cov_0.905882_g15734_i0	PRJNA559720	15873	243	0.905882	2.20129326	Streptococcus	1301	Bacteria	Bacteria	394	3.16e-105	NTclustered	gi\|1985957267\|gb\|CP069427.1\|	1303	g15734	i0	95.885	81.8559670781893	243	10	100	1	243	72359	72117	Streptococcus oralis strain SF100 chromosome, complete genome	blastn	19891	396	0.994949494949495	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17121207	17121207	PRJNA559720_P_NODE_13814_length_250_cov_0.870056_g13675_i0	PRJNA559720	13814	250	0.870056	2.17514	Carnobacterium viridans	174587	Bacteria	Bacteria	390	4.22e-104	NTclustered	gi\|2119245265\|gb\|CP084918.1\|	174587	g13675	i0	94.8	2.988	250	13	100	1	250	9894	9645	Carnobacterium viridans strain AB01 plasmid pDC01-1, complete sequence	blastn	747	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium viridans
18981759	18981759	PRJNA559720_P_NODE_13895_length_250_cov_0.870056_g13756_i0	PRJNA559720	13895	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2714337209\|gb\|CP150752.1\|	1280	g13756	i0	100	100	250	0	100	1	250	1614193	1613944	Staphylococcus aureus strain TUM22458 chromosome, complete genome	blastn	25000	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19669980	19669980	PRJNA559720_P_NODE_13636_length_251_cov_0.865169_g13497_i0	PRJNA559720	13636	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1848615759\|gb\|CP054006.1\|	1290	g13497	i0	100	66.6294820717131	251	0	100	1	251	1627889	1628139	Staphylococcus hominis strain FDAARGOS_762 chromosome, complete genome	blastn	16724	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
19669984	19669984	PRJNA559720_P_NODE_13916_length_250_cov_0.870056_g13777_i0	PRJNA559720	13916	250	0.870056	2.17514	Staphylococcus ureilyticus	94138	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2905461398\|gb\|CP180185.1\|	94138	g13777	i0	98.8	32.844	250	3	100	1	250	1443576	1443825	Staphylococcus ureilyticus strain RSM-JSascm chromosome	blastn	8211	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus ureilyticus
20945690	20945690	PRJNA559720_P_NODE_13617_length_251_cov_0.865169_g13478_i0	PRJNA559720	13617	251	0.865169	2.17157419	Veillonella orientalis	2682455	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|2021399589\|dbj\|AP022322.1\|	2682455	g13478	i0	97.61	14.8486055776892	251	6	100	1	251	296872	297122	Veillonella sp. S12025-13 DNA, complete genome	blastn	3727	431	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella orientalis
20945706	20945706	PRJNA559720_P_NODE_15037_length_246_cov_0.890173_g14898_i0	PRJNA559720	15037	246	0.890173	2.18982558	Parvimonas micra	33033	Bacteria	Bacteria	185	2.1e-42	NTclustered	gi\|2702638792\|gb\|CP148048.1\|	33033	g14898	i0	84.211	11.719512195122	190	30	77	3	192	6293	6104	Parvimonas micra strain JM503A chromosome, complete genome	blastn	2883	185	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
20945774	20945774	PRJNA559720_P_NODE_5797_length_427_cov_25.158192_g5658_i0	PRJNA559720	5797	427	25.158192	107.42547984	Staphylococcus epidermidis	1282	Bacteria	Bacteria	60.2	2.46e-4	NTclustered	gi\|1369209706\|gb\|MG787416.1\|	1282	g5658	i0	100	0.0749414519906323	32	0	7	349	380	3654	3685	Staphylococcus epidermidis strain I14OR1 ACME IV mobile element, complete sequence	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23495873	23495873	PRJNA559720_P_NODE_12479_length_266_cov_1.595855_g12340_i0	PRJNA559720	12479	266	1.595855	4.2449743	Staphylococcus pasteuri	45972	Bacteria	Bacteria	296	1.02e-75	NTclustered	gi\|1250047636\|gb\|CP017464.1\|	45972	g12340	i0	88.797	245.804511278195	241	27	100	1	241	49681	49441	Staphylococcus pasteuri strain JS7 plasmid pSNJS701, complete sequence	blastn	65384	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri

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