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

16 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax_phylum = "Myxococcota"

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
2729824	2729824	PRJNA1063685_S_NODE_1203_length_1051_cov_13.226994_g53_i9	PRJNA1063685	1203	1051	13.226994	139.01570694	Labilithrix luteola	1391654	Bacteria	Bacteria	1539	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53	i9	93.094	126.811607992388	1057	63	100	8	1	1051	7090923	7089871	Labilithrix luteola strain DSM 27648, complete genome	blastn	133279	1539	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2730081	2730081	PRJNA1063685_S_NODE_363_length_1577_cov_182.149601_g53_i4	PRJNA1063685	363	1577	182.149601	2872.49920777	Labilithrix luteola	1391654	Bacteria	Bacteria	2399	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53	i4	94.125	150.163601775523	1583	84	100	7	1	1577	7090923	7089344	Labilithrix luteola strain DSM 27648, complete genome	blastn	236808	2399	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4005884	4005884	PRJNA1063685_S_NODE_22264_length_488_cov_43.624096_g21725_i0	PRJNA1063685	22264	488	43.624096	212.88558848	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	654	0	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g21725	i0	92.06	174.254098360656	466	35	95	2	1	465	8615151	8615615	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	85036	654	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
5282153	5282153	PRJNA1063685_S_NODE_17025_length_539_cov_11.678112_g16492_i0	PRJNA1063685	17025	539	11.678112	62.94502368	Labilithrix luteola	1391654	Bacteria	Bacteria	359	2.79e-94	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16492	i0	79.96	2.61966604823748	499	90	92	9	46	539	1347679	1348172	Labilithrix luteola strain DSM 27648, complete genome	blastn	1412	359	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6115365	6115365	PRJNA1063685_S_NODE_79845_length_209_cov_12658.948529_g79302_i0	PRJNA1063685	79845	209	12658.948529	26457.20242561	Pseudomonadati	3379134	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g79302	i0	100	606.282296650718	209	0	100	0	1	209	911	703	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	126713	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6557400	6557400	PRJNA1063685_S_NODE_246_length_1823_cov_187.862286_g53_i3	PRJNA1063685	246	1823	187.862286	3424.72947378	Labilithrix luteola	1391654	Bacteria	Bacteria	2207	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53	i3	93.712	114.427317608338	1479	83	81	7	350	1823	7914083	7915556	Labilithrix luteola strain DSM 27648, complete genome	blastn	208601	2207	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6557696	6557696	PRJNA1063685_S_NODE_5826_length_710_cov_5.467818_g5360_i0	PRJNA1063685	5826	710	5.467818	38.8215078	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	412	2.829999999999999e-110	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g5360	i0	80.762	1.16760563380282	551	86	76	18	62	602	2265909	2266449	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	829	412	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8665079	8665079	PRJNA1063685_S_NODE_30067_length_428_cov_4.397183_g29525_i0	PRJNA1063685	30067	428	4.397183	18.81994324	Archangium	47	Bacteria	Bacteria	723	0	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g29525	i0	98.768	220.792056074766	406	5	95	0	1	406	107967	108372	Archangium gephyra strain DSM 2261, complete genome	blastn	94499	723	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
10382940	10382940	PRJNA1063685_S_NODE_45469_length_340_cov_3.430712_g44926_i0	PRJNA1063685	45469	340	3.430712	11.6644208	Myxococcus sp. MxC21-1	3041439	Bacteria	Bacteria	84.2	1.14e-11	NTclustered	gi\|2592002496\|gb\|CP123278.1\|	3041439	g44926	i0	96.078	7.33235294117647	51	2	15	0	290	340	8026384	8026334	Myxococcus sp. MxC21-1 chromosome, complete genome	blastn	2493	84.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MxC21-1
18031228	18031228	PRJNA1063685_S_NODE_32715_length_410_cov_3.934718_g32173_i0	PRJNA1063685	32715	410	3.934718	16.1323438	Pendulispora albinea	2741071	Bacteria	Bacteria	111	6.41e-20	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g32173	i0	87.5	4.00731707317073	96	12	23	0	291	386	6022196	6022291	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	1643	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
20138519	20138519	PRJNA1063685_S_NODE_61536_length_275_cov_1.123762_g60993_i0	PRJNA1063685	61536	275	1.123762	3.0903455	Sorangium	39643	Bacteria	Bacteria	189	1.8499999999999993e-43	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g60993	i0	88.889	2.89818181818182	153	17	56	0	10	162	2176051	2176203	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	797	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20580371	20580371	PRJNA1063685_S_NODE_1117_length_1071_cov_212.925852_g53_i8	PRJNA1063685	1117	1071	212.925852	2280.43587492	Labilithrix luteola	1391654	Bacteria	Bacteria	1749	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53	i8	96.172	149.18487394958	1071	40	100	1	1	1071	7090413	7089344	Labilithrix luteola strain DSM 27648, complete genome	blastn	159777	1749	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21413963	21413963	PRJNA1063685_S_NODE_3237_length_803_cov_361.990411_g2845_i0	PRJNA1063685	3237	803	361.990411	2906.78300033	Pseudomonadati	3379134	Bacteria	Bacteria	172	5.929999999999999e-38	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g2845	i0	100	69.0298879202989	93	0	12	0	1	93	1009	1101	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55431	172	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21856707	21856707	PRJNA1063685_S_NODE_75838_length_235_cov_6.716049_g75295_i0	PRJNA1063685	75838	235	6.716049	15.78271515	Sorangium cellulosum	56	Bacteria	Bacteria	126	1.22e-24	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g75295	i0	82	12.0255319148936	150	25	63	2	86	234	12991098	12990950	Sorangium cellulosum 'So ce 56' complete genome	blastn	2826	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23131916	23131916	PRJNA1063685_S_NODE_419_length_1488_cov_163.024735_g53_i6	PRJNA1063685	419	1488	163.024735	2425.8080568	Labilithrix luteola	1391654	Bacteria	Bacteria	2224	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53	i6	94.353	141.362231182796	1452	79	98	3	38	1488	7088962	7090411	Labilithrix luteola strain DSM 27648, complete genome	blastn	210347	2224	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24405799	24405799	PRJNA1063685_S_NODE_70900_length_248_cov_1.982857_g70357_i0	PRJNA1063685	70900	248	1.982857	4.91748536	Sorangium cellulosum	56	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g70357	i0	84.615	58.8306451612903	247	36	99	2	1	246	14391617	14391862	Sorangium cellulosum So0157-2, complete genome	blastn	14590	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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