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

16 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax_kingdom = "Bacillati"

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
2433554	2433554	PRJNA641991_S_NODE_7662_length_201_cov_1.000000_g7543_i0	PRJNA641991	7662	201	1	2.01	Brevibacillus	55080	Bacteria	Bacteria	248	2.08e-61	NTclustered	gi\|507148245\|ref\|NR_103052.1\|	1393	g7543	i0	90.476	1009.2039800995	189	16	94	2	1	188	769	956	Brevibacillus brevis strain 47 23S ribosomal RNA gene, complete sequence	blastn	202850	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus brevis
4986759	4986759	PRJNA641991_S_NODE_13104_length_165_cov_0.879310_g12985_i0	PRJNA641991	13104	165	0.87931	1.4508615	Cutibacterium	1912216	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g12985	i0	100	51.0727272727273	159	0	96	0	1	159	845935	846093	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8427	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6996359	6996359	PRJNA641991_S_NODE_6666_length_213_cov_1.243902_g6547_i0	PRJNA641991	6666	213	1.243902	2.64951126	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	150	6.459999999999998e-32	NTclustered	gi\|2907625690\|emb\|OZ223250.1\|	1898209	g6547	i0	79.71	4.89201877934272	207	42	97	0	3	209	262246	262040	MAG: Acholeplasmataceae bacterium isolate c289da16-4743-485f-819d-17f5771af8e7 genome assembly, chromosome: 1	blastn	1042	150	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
8811329	8811329	PRJNA641991_S_NODE_2527_length_330_cov_2.548043_g2408_i0	PRJNA641991	2527	330	2.548043	8.4085419	Streptococcus	1301	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g2408	i0	100	626.575757575758	330	0	100	0	1	330	17847	17518	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	206770	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
10821962	10821962	PRJNA641991_P_NODE_3549_length_165_cov_0.879310_g3508_i0	PRJNA641991	3549	165	0.87931	1.4508615	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2851146212\|gb\|CP085027.1\|	1283	g3508	i0	100	41.6181818181818	165	0	100	0	1	165	1645411	1645247	Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome	blastn	6867	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
15186873	15186873	PRJNA641991_S_NODE_9512_length_184_cov_0.844444_g9393_i0	PRJNA641991	9512	184	0.844444	1.55377696	Rhodococcus	1827	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2088797821\|gb\|CP082159.1\|	37919	g9393	i0	100	2.6195652173913	29	0	16	0	91	119	184193	184221	Rhodococcus opacus strain DSM 44186 plasmid pRop44186_a, complete sequence	blastn	482	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
15920611	15920611	PRJNA641991_S_NODE_13293_length_164_cov_0.886957_g13174_i0	PRJNA641991	13293	164	0.886957	1.45460948	Streptomyces malaysiensis	92644	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2619783426\|gb\|CP137895.1\|	92644	g13174	i0	100	0.170731707317073	28	0	17	0	17	44	7943397	7943370	Streptomyces malaysiensis strain NA3722 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces malaysiensis
16461198	16461198	PRJNA641991_S_NODE_14713_length_161_cov_0.910714_g14594_i0	PRJNA641991	14713	161	0.910714	1.46624954	Streptococcus	1301	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1403302629\|emb\|LS483342.1\|	1311	g14594	i0	100	100	161	0	100	0	1	161	656016	655856	Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1	blastn	16100	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
17736308	17736308	PRJNA641991_S_NODE_11574_length_169_cov_1.275000_g11455_i0	PRJNA641991	11574	169	1.275	2.15475	Streptococcus	1301	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1403302629\|emb\|LS483342.1\|	1311	g11455	i0	100	634	169	0	100	0	1	169	19715	19883	Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1	blastn	107146	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
18470018	18470018	PRJNA641991_S_NODE_2135_length_359_cov_1.645161_g2016_i0	PRJNA641991	2135	359	1.645161	5.90612799	Streptococcus porcinus	1340	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1988318085\|gb\|CP070236.1\|	1340	g2016	i0	100	0.467966573816156	28	0	8	0	20	47	1207591	1207564	Streptococcus porcinus strain Colony573 chromosome	blastn	168	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus porcinus
19744612	19744612	PRJNA641991_S_NODE_12036_length_167_cov_0.864407_g11917_i0	PRJNA641991	12036	167	0.864407	1.44355969	Tsukamurella tyrosinosolvens	57704	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1540130960\|emb\|LR134451.1\|	57704	g11917	i0	98.204	9.65269461077844	167	3	100	0	1	167	74127	73961	Tsukamurella tyrosinosolvens strain NCTC13231 genome assembly, plasmid: 9	blastn	1612	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella tyrosinosolvens
19744635	19744635	PRJNA641991_S_NODE_4376_length_255_cov_1.723301_g4257_i0	PRJNA641991	4376	255	1.723301	4.39441755	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621704807\|emb\|OY763072.1\|	2026734	g4257	i0	100	0.109803921568627	28	0	11	0	142	169	3446192	3446219	MAG: Dehalococcoidia bacterium isolate 40e540cc-5106-4b3b-ab2b-631d7f64572a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20284800	20284800	PRJNA641991_S_NODE_13816_length_163_cov_0.894737_g13697_i0	PRJNA641991	13816	163	0.894737	1.45842131	Streptococcus	1301	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|909815781\|gb\|CP011327.1\|	1311	g13697	i0	100	126.134969325153	163	0	100	0	1	163	605322	605160	Streptococcus agalactiae strain GX064 genome	blastn	20560	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
24110287	24110287	PRJNA641991_S_NODE_5919_length_224_cov_1.165714_g5800_i0	PRJNA641991	5919	224	1.165714	2.61119936	Streptomyces	1883	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2015360468\|gb\|CP071839.1\|	80860	g5800	i0	92.308	0.758928571428571	39	3	17	0	31	69	1621424	1621386	Streptomyces cyanogenus strain S136 chromosome, complete genome	blastn	170	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cyanogenus
25384773	25384773	PRJNA641991_S_NODE_12820_length_165_cov_1.181034_g12701_i0	PRJNA641991	12820	165	1.181034	1.9487061	Streptococcus	1301	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1403302629\|emb\|LS483342.1\|	1311	g12701	i0	100	633.030303030303	165	0	100	0	1	165	19466	19302	Streptococcus agalactiae strain NCTC11930 genome assembly, chromosome: 1	blastn	104450	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
25384786	25384786	PRJNA641991_S_NODE_8840_length_189_cov_1.685714_g8721_i0	PRJNA641991	8840	189	1.685714	3.18599946	Streptococcus	1301	Bacteria	Bacteria	313	6.74e-81	NTclustered	gi\|2746253929\|gb\|PP939747.1\|	1306	g8721	i0	100	263.783068783069	169	0	89	0	21	189	191	23	Streptococcus sp. strain 1-4 16S ribosomal RNA gene, partial sequence	blastn	49855	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.

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