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

16 rows where analysis = "blastn", bioproject = "PRJNA534016" 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
5611200	5611200	PRJNA534016_P_NODE_10685_length_273_cov_5.655000_g10595_i0	PRJNA534016	10685	273	5.655	15.43815	Macrococcus epidermidis	1902580	Bacteria	Bacteria	100	8.82e-17	NTclustered	gi\|2269510951\|gb\|CP073819.1\|	1902580	g10595	i0	81.667	0.43956043956044	120	22	44	0	146	265	2060161	2060280	Macrococcus epidermidis strain Epi3002-OL chromosome, complete genome	blastn	120	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus epidermidis
5611386	5611386	PRJNA534016_P_NODE_7445_length_310_cov_2.704641_g7355_i0	PRJNA534016	7445	310	2.704641	8.3843871	Eubacteriaceae bacterium ES3	3064258	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2556637776\|gb\|CP130741.1\|	3064258	g7355	i0	96.875	0.103225806451613	32	0	10	1	1	31	57466	57497	Eubacteriaceae bacterium ES3 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae		Eubacteriaceae bacterium ES3
6885054	6885054	PRJNA534016_P_NODE_11446_length_267_cov_3.788660_g11356_i0	PRJNA534016	11446	267	3.78866	10.1157222	Staphylococcus epidermidis	1282	Bacteria	Bacteria	472	1.5799999999999998e-128	NTclustered	gi\|2811870118\|gb\|CP170248.1\|	1282	g11356	i0	98.502	317.202247191011	267	4	100	0	1	267	1210488	1210754	Staphylococcus epidermidis strain PS25 chromosome, complete genome	blastn	84693	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8160189	8160189	PRJNA534016_P_NODE_10367_length_276_cov_1.738916_g10277_i0	PRJNA534016	10367	276	1.738916	4.79940816	Selenomonas sputigena	69823	Bacteria	Bacteria	488	1.6299999999999995e-133	NTclustered	gi\|329745630\|gb\|CP002637.1\|	546271	g10277	i0	98.551	68.9927536231884	276	4	100	0	1	276	930364	930639	Selenomonas sputigena ATCC 35185, complete genome	blastn	19042	488	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sputigena
8771317	8771317	PRJNA534016_P_NODE_18687_length_237_cov_2.414634_g18597_i0	PRJNA534016	18687	237	2.414634	5.72268258	Streptococcus	1301	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g18597	i0	99.578	327	237	1	100	0	1	237	625475	625239	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	77499	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
9435896	9435896	PRJNA534016_P_NODE_6828_length_323_cov_1.156000_g6738_i0	PRJNA534016	6828	323	1.156	3.73388	Lachnospiraceae bacterium oral taxon 500	712991	Bacteria	Bacteria	586	6.72e-163	NTclustered	gi\|1359148129\|gb\|CP027241.1\|	712991	g6738	i0	99.381	348.120743034056	323	2	100	0	1	323	369748	369426	Lachnospiraceae bacterium oral taxon 500 strain W11650 chromosome, complete genome	blastn	112443	586	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium oral taxon 500
11321337	11321337	PRJNA534016_P_NODE_17149_length_243_cov_2.276471_g17059_i0	PRJNA534016	17149	243	2.276471	5.53182453	Enterococcus	1350	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2706656888\|dbj\|AP031371.1\|	37734	g17059	i0	100	19.843621399177	243	0	100	0	1	243	869142	868900	Enterococcus casseliflavus KB1733 DNA, complete genome	blastn	4822	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
12597284	12597284	PRJNA534016_P_NODE_8810_length_288_cov_2.376744_g8720_i0	PRJNA534016	8810	288	2.376744	6.84502272	Tepidanaerobacter	499228	Bacteria	Bacteria	165	3.28e-36	NTclustered	gi\|470488597\|ref\|NR_076880.1\|	499229	g8720	i0	83.799	267.847222222222	179	24	61	5	97	273	274	99	Tepidanaerobacter acetatoxydans strain Re1 23S ribosomal RNA gene, complete sequence	blastn	77140	165	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermosediminibacterales	Tepidanaerobacteraceae	Tepidanaerobacter	Tepidanaerobacter acetatoxydans
13261346	13261346	PRJNA534016_P_NODE_18451_length_241_cov_0.916667_g18361_i0	PRJNA534016	18451	241	0.916667	2.20916747	Allobacillus halotolerans	570278	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2446175568\|gb\|CP117968.1\|	570278	g18361	i0	100	0.116182572614108	28	0	12	0	70	97	856163	856190	Allobacillus halotolerans strain BCRC 17939 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus	Allobacillus halotolerans
14536280	14536280	PRJNA534016_P_NODE_14132_length_250_cov_0.870056_g14042_i0	PRJNA534016	14132	250	0.870056	2.17514	Eubacterium limosum	1736	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2833687129\|gb\|CP171347.1\|	1736	g14042	i0	100	12	250	0	100	0	1	250	1663042	1662793	Eubacterium limosum strain El1405 chromosome, complete genome	blastn	3000	462	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium limosum
14536436	14536436	PRJNA534016_P_NODE_9712_length_281_cov_1.754808_g9622_i0	PRJNA534016	9712	281	1.754808	4.93101048	Clostridium estertheticum	238834	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557245743\|gb\|CP077618.1\|	238834	g9622	i0	97.059	0.241992882562278	34	0	12	1	54	87	1694457	1694489	Clostridium estertheticum strain CF007 chromosome, complete genome	blastn	68	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium estertheticum
15810156	15810156	PRJNA534016_P_NODE_10253_length_277_cov_1.490196_g10163_i0	PRJNA534016	10253	277	1.490196	4.12784292	Peribacillus frigoritolerans	450367	Bacteria	Bacteria	62.1	4.23e-5	NTclustered	gi\|2257755478\|gb\|CP085514.1\|	450367	g10163	i0	89.796	0.277978339350181	49	4	18	1	4	52	4985049	4985096	Peribacillus frigoritolerans strain KF19 chromosome, complete genome	blastn	77	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus frigoritolerans
17084852	17084852	PRJNA534016_P_NODE_11074_length_270_cov_2.873096_g10984_i0	PRJNA534016	11074	270	2.873096	7.7573592	Oceanirhabdus sp. W0125-5	2999116	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2429794163\|gb\|CP115913.1\|	2999116	g10984	i0	100	0.103703703703704	28	0	10	0	54	81	311084	311111	Oceanirhabdus sp. W0125-5 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Oceanirhabdus	Oceanirhabdus sp. W0125-5
17696225	17696225	PRJNA534016_P_NODE_19054_length_228_cov_4.032258_g18964_i0	PRJNA534016	19054	228	4.032258	9.19354824	Paenibacillus	44249	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|920787514\|gb\|CP011512.1\|	59893	g18964	i0	100	0.245614035087719	28	0	12	0	8	35	1643744	1643771	Paenibacillus peoriae strain HS311, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus peoriae
22795469	22795469	PRJNA534016_P_NODE_3158_length_459_cov_2.613990_g3068_i0	PRJNA534016	3158	459	2.61399	11.9982141	Erysipelotrichaceae	128827	Bacteria	Bacteria	584	3.5499999999999986e-162	NTclustered	gi\|1802450212\|dbj\|AP019711.1\|	2583452	g3068	i0	89.76	554.958605664488	459	44	99	3	2	459	294340	294796	Amedibacterium intestinale DNA, complete genome	blastn	254726	584	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Amedibacterium	Amedibacterium intestinale
22795480	22795480	PRJNA534016_P_NODE_8598_length_290_cov_1.774194_g8508_i0	PRJNA534016	8598	290	1.774194	5.1451626	Streptococcus	1301	Bacteria	Bacteria	531	2.83e-146	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g8508	i0	99.655	333.068965517241	290	1	100	0	1	290	17291	17002	Streptococcus oralis strain SOD chromosome, complete genome	blastn	96590	531	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis

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