metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
371982	371982	PRJNA285816_S_NODE_20041_length_180_cov_1.946565_g19939_i0	PRJNA285816	20041	180	1.946565	3.503817	Paenibacillus baekrokdamisoli	1712516	Bacteria	Bacteria	60.2	9.13e-5	NTclustered	gi\|1514759603\|dbj\|AP019308.1\|	1712516	g19939	i0	97.143	0.194444444444444	35	1	19	0	146	180	6822058	6822024	Paenibacillus baekrokdamisoli KCTC 33723 DNA, complete genome	blastn	35	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus baekrokdamisoli
1059211	1059211	PRJNA285816_S_NODE_7401_length_260_cov_1.890995_g7299_i0	PRJNA285816	7401	260	1.890995	4.916587	Veillonella	29465	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g7299	i0	100	579.126923076923	260	0	100	0	1	260	81833	81574	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	150573	481	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
2334424	2334424	PRJNA285816_S_NODE_8002_length_252_cov_1.266010_g7900_i0	PRJNA285816	8002	252	1.26601	3.1903452	Anaerococcus	165779	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2831295055\|gb\|CP170995.1\|	3366806	g7900	i0	99.603	292.734126984127	252	1	100	0	1	252	1955	2206	Anaerococcus sp. WGS1596 chromosome, complete genome	blastn	73769	460	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1596
2922693	2922693	PRJNA285816_S_NODE_23803_length_169_cov_1.300000_g23701_i0	PRJNA285816	23803	169	1.3	2.197	Brevibacillus laterosporus	1465	Bacteria	Bacteria	63.9	6.52e-6	NTclustered	gi\|1717394875\|gb\|CP033464.1\|	1465	g23701	i0	91.304	2.92899408284024	46	4	27	0	114	159	1282940	1282895	Brevibacillus laterosporus strain 1821L chromosome, complete genome	blastn	495	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus laterosporus
2922713	2922713	PRJNA285816_S_NODE_25223_length_167_cov_1.406780_g25121_i0	PRJNA285816	25223	167	1.40678	2.3493226	Anaerococcus nagyae	1755241	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g25121	i0	98.802	349.616766467066	167	2	100	0	1	167	121580	121746	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	58386	298	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
2922788	2922788	PRJNA285816_S_NODE_4543_length_320_cov_7.811808_g4441_i0	PRJNA285816	4543	320	7.811808	24.9977856	Streptococcus sp. oral taxon 070	671226	Bacteria	Bacteria	586	6.65e-163	NTclustered	gi\|285161581\|gb\|GU399999.1\|	671226	g4441	i0	99.688	99.996875	320	1	100	0	1	320	18	337	Streptococcus sp. oral taxon 070 clone VP037 16S ribosomal RNA gene, partial sequence	blastn	31999	586	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. oral taxon 070
6749741	6749741	PRJNA285816_S_NODE_24786_length_168_cov_0.873950_g24684_i0	PRJNA285816	24786	168	0.87395	1.468236	Globicatella sp. PHS-GS-PNBC-21-1553	2885764	Bacteria	Bacteria	156	1.05e-33	NTclustered	gi\|2620023749\|gb\|CP085470.1\|	2885764	g24684	i0	83.636	144.815476190476	165	27	98	0	4	168	959099	959263	Globicatella sp. PHS-GS-PNBC-21-1553 chromosome, complete genome	blastn	24329	156	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Globicatella	Globicatella sp. PHS-GS-PNBC-21-1553
8711818	8711818	PRJNA285816_S_NODE_19947_length_181_cov_0.878788_g19845_i0	PRJNA285816	19947	181	0.878788	1.59060628	Oscillospiraceae	216572	Bacteria	Bacteria	278	2.33e-70	NTclustered	gi\|2189459107\|gb\|CP091720.1\|	41978	g19845	i0	94.475	195.359116022099	181	9	100	1	1	181	382853	382674	MAG: Ruminococcus sp. isolate nC33_bin.6.fa chromosome	blastn	35360	279	0.996415770609319	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
8711823	8711823	PRJNA285816_S_NODE_21127_length_177_cov_1.046875_g21025_i0	PRJNA285816	21127	177	1.046875	1.85296875	Lachnoanaerobaculum	1164882	Bacteria	Bacteria	316	4.799999999999999e-82	NTclustered	gi\|1721134208\|emb\|LR699010.1\|	617123	g21025	i0	98.87	471.039548022599	177	2	100	0	1	177	487446	487270	Lachnoanaerobaculum umeaense isolate MGYG-HGUT-02522 genome assembly, chromosome: 1	blastn	83374	316	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum umeaense
9987236	9987236	PRJNA285816_S_NODE_10048_length_230_cov_2.226519_g9946_i0	PRJNA285816	10048	230	2.226519	5.1209937	Carnobacterium	2747	Bacteria	Bacteria	106	1.55e-18	NTclustered	gi\|554508411\|gb\|CP006812.1\|	1266845	g9946	i0	79.739	187.565217391304	153	26	65	5	1	150	133262	133112	Carnobacterium inhibens subsp. gilichinskyi strain WN1359 chromosome, complete genome	blastn	43140	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium inhibens
9987254	9987254	PRJNA285816_S_NODE_18808_length_184_cov_2.044444_g18706_i0	PRJNA285816	18808	184	2.044444	3.76177696	Lachnospiraceae	186803	Bacteria	Bacteria	296	6.57e-76	NTclustered	gi\|2619716496\|gb\|CP137818.1\|	29347	g18706	i0	95.676	428.086956521739	185	6	100	2	1	184	18544	18361	[Clostridium] scindens strain MO32	blastn	78768	296	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoclostridium	[Clostridium] scindens
9987292	9987292	PRJNA285816_S_NODE_29768_length_161_cov_2.580357_g29666_i0	PRJNA285816	29768	161	2.580357	4.15437477	Streptococcus	1301	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2416353462\|gb\|OQ102967.1\|	1304	g29666	i0	100	117.416149068323	161	0	100	0	1	161	33	193	Streptococcus salivarius strain ASN1 16S ribosomal RNA gene, partial sequence	blastn	18904	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
10575829	10575829	PRJNA285816_S_NODE_12529_length_213_cov_1.146341_g12427_i0	PRJNA285816	12529	213	1.146341	2.44170633	Peptostreptococcus porci	2652282	Bacteria	Bacteria	327	2.78e-85	NTclustered	gi\|2677426753\|dbj\|AP029254.1\|	2652282	g12427	i0	94.366	1035.97183098592	213	12	100	0	1	213	222457	222669	Peptostreptococcus porci GAI11004 DNA, complete genome	blastn	220662	327	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus	Peptostreptococcus porci
10576044	10576044	PRJNA285816_S_NODE_29209_length_162_cov_1.371681_g29107_i0	PRJNA285816	29209	162	1.371681	2.22212322	Veillonella rogosae	423477	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2446175566\|gb\|CP117967.1\|	423477	g29107	i0	99.383	655.802469135802	162	1	100	0	1	162	1143383	1143544	Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome	blastn	106240	294	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
11850714	11850714	PRJNA285816_S_NODE_27730_length_164_cov_0.904348_g27628_i0	PRJNA285816	27730	164	0.904348	1.48313072	Gemella sanguinis	84135	Bacteria	Bacteria	189	1e-43	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g27628	i0	100	388.079268292683	102	0	98	0	1	102	516421	516522	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	63645	189	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
12537646	12537646	PRJNA285816_S_NODE_23490_length_170_cov_1.289256_g23388_i0	PRJNA285816	23490	170	1.289256	2.1917352	Finegoldia	150022	Bacteria	Bacteria	311	2.12e-80	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g23388	i0	100	408.029411764706	168	0	99	0	3	170	163885	164052	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	69365	311	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
14400975	14400975	PRJNA285816_S_NODE_20592_length_178_cov_2.627907_g20490_i0	PRJNA285816	20592	178	2.627907	4.67767446	Pediococcus damnosus	51663	Bacteria	Bacteria	86.1	1.48e-12	NTclustered	gi\|1015507319\|gb\|CP012271.1\|	51663	g20490	i0	84.211	15.9101123595506	95	8	50	7	62	150	15963	16056	Pediococcus damnosus strain TMW 2.1532 plasmid pL21532-2, complete sequence	blastn	2832	86.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus damnosus
15086761	15086761	PRJNA285816_S_NODE_28452_length_163_cov_1.236842_g28350_i0	PRJNA285816	28452	163	1.236842	2.01605246	Finegoldia	150022	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g28350	i0	100	551.650306748466	163	0	100	0	1	163	163581	163419	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	89919	302	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20773545	20773545	PRJNA285816_S_NODE_25957_length_166_cov_1.376068_g25855_i0	PRJNA285816	25957	166	1.376068	2.28427288	Lactobacillus iners	147802	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2769751966\|gb\|CP160079.1\|	147802	g25855	i0	99.398	79.1385542168675	166	1	100	0	1	166	1334825	1334990	Lactobacillus iners strain Liners_2503_V10-0 chromosome, complete genome	blastn	13137	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
22048442	22048442	PRJNA285816_S_NODE_19678_length_181_cov_2.643939_g19576_i0	PRJNA285816	19678	181	2.643939	4.78552959	Ligilactobacillus cholophilus	3050131	Bacteria	Bacteria	99	1.95e-16	NTclustered	gi\|2530740023\|gb\|CP127832.1\|	3050131	g19576	i0	85.87	51.9723756906077	92	13	51	0	90	181	834862	834771	Ligilactobacillus cholophilus strain BD7642 chromosome, complete genome	blastn	9407	99	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus cholophilus

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