metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
403716	403716	PRJNA382357_P_NODE_37841_length_371_cov_14.070968_g37102_i0	PRJNA382357	37841	371	14.070968	52.20329128	Labilithrix luteola	1391654	Bacteria	Bacteria	320	8.76e-83	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g37102	i0	96.859	87.0242587601078	191	6	94	0	1	191	3942200	3942390	Labilithrix luteola strain DSM 27648, complete genome	blastn	32286	320	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1677410	1677410	PRJNA382357_P_NODE_123122_length_220_cov_2.540881_g122383_i0	PRJNA382357	123122	220	2.540881	5.5899382	Pendulispora brunnea	2905690	Bacteria	Bacteria	82.4	2.48e-11	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g122383	i0	94.34	1.2	53	3	24	0	168	220	7729722	7729670	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	264	82.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
1678017	1678017	PRJNA382357_P_NODE_164302_length_187_cov_4.396825_g163563_i0	PRJNA382357	164302	187	4.396825	8.22206275	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	91.6	3.39e-14	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g163563	i0	90	54.9251336898396	70	7	75	0	1	70	1124225	1124156	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	10271	91.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
2953764	2953764	PRJNA382357_P_NODE_157103_length_200_cov_12.841727_g156364_i0	PRJNA382357	157103	200	12.841727	25.683454	Nannocystis punicea	2995304	Bacteria	Bacteria	58.4	3.73e-4	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g156364	i0	94.595	1.315	37	2	35	0	35	71	8960703	8960739	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	263	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
3626254	3626254	PRJNA382357_P_NODE_83463_length_262_cov_1.701493_g82724_i0	PRJNA382357	83463	262	1.701493	4.45791166	Sorangium	39643	Bacteria	Bacteria	303	5.98e-78	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g82724	i0	89.113	87.4236641221374	248	22	93	5	1	244	1534	1780	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	22905	303	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6782127	6782127	PRJNA382357_P_NODE_79026_length_268_cov_2.188406_g78287_i0	PRJNA382357	79026	268	2.188406	5.86492808	Pendulispora albinea	2741071	Bacteria	Bacteria	313	1.02e-80	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g78287	i0	95.408	102.708955223881	196	9	96	0	1	196	3588735	3588930	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	27526	313	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
8727381	8727381	PRJNA382357_P_NODE_1467_length_1407_cov_12.207281_g1049_i0	PRJNA382357	1467	1407	12.207281	171.75644367	Stigmatella	40	Bacteria	Bacteria	1520	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1049	i0	96.047	214.668798862829	936	34	97	3	100	1033	1061	127	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	302039	1520	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
10003178	10003178	PRJNA382357_P_NODE_2708_length_1122_cov_14.784166_g1049_i1	PRJNA382357	2708	1122	14.784166	165.87834252	Stigmatella	40	Bacteria	Bacteria	950	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1049	i1	97.487	221.676470588235	557	13	99	1	100	655	1061	505	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	248721	950	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
11881247	11881247	PRJNA382357_P_NODE_118350_length_224_cov_9.374233_g117611_i0	PRJNA382357	118350	224	9.374233	20.99828192	Polyangium aurulentum	2567896	Bacteria	Bacteria	69.4	1.98e-7	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g117611	i0	83.562	0.808035714285714	73	12	46	0	136	208	11197113	11197041	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	181	69.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
12553065	12553065	PRJNA382357_P_NODE_12230_length_605_cov_87.590074_g11513_i0	PRJNA382357	12230	605	87.590074	529.9199477	Stigmatella	40	Bacteria	Bacteria	403	1.4399999999999994e-107	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g11513	i0	88.922	230.700826446281	334	28	96	8	191	522	1486	1160	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	139574	403	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
12553070	12553070	PRJNA382357_P_NODE_122930_length_220_cov_7.270440_g122191_i0	PRJNA382357	122930	220	7.27044	15.994968	Myxococcales	29	Bacteria	Bacteria	235	1.7999999999999998e-57	NTclustered	gi\|545790940\|gb\|KF270703.1\|	33	g122191	i0	99.231	253.45	130	1	90	0	1	130	405	534	Myxococcus fulvus strain Mxf428 23S ribosomal RNA gene, partial sequence	blastn	55759	235	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
13156476	13156476	PRJNA382357_P_NODE_129891_length_214_cov_3.895425_g129152_i0	PRJNA382357	129891	214	3.895425	8.3362095	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	189	1.3799999999999999e-43	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g129152	i0	91.912	168.532710280374	136	9	63	2	80	214	2259879	2259745	Anaeromyxobacter paludicola DNA, complete genome	blastn	36066	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
13158211	13158211	PRJNA382357_P_NODE_80351_length_266_cov_2.546341_g79612_i0	PRJNA382357	80351	266	2.546341	6.77326706	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	346	9.96e-91	NTclustered	gi\|545344187\|gb\|KF507419.1\|	417999	g79612	i0	98.469	105.503759398496	196	3	100	0	1	196	377	182	Uncultured Polyangiaceae bacterium clone 7057 16S ribosomal RNA gene, partial sequence	blastn	28064	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
14432658	14432658	PRJNA382357_P_NODE_46732_length_338_cov_9.158845_g45993_i0	PRJNA382357	46732	338	9.158845	30.9568961	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	167	1.09e-36	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g45993	i0	80.687	513.059171597633	233	29	68	10	21	249	8617271	8617491	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	173414	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15706942	15706942	PRJNA382357_P_NODE_67453_length_287_cov_18.814159_g66714_i0	PRJNA382357	67453	287	18.814159	53.99663633	Sorangium cellulosum	56	Bacteria	Bacteria	222	1.9099999999999999e-53	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g66714	i0	89.266	60.0766550522648	177	19	62	0	111	287	4848704	4848528	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	17242	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18926567	18926567	PRJNA382357_P_NODE_31615_length_402_cov_6.304985_g30876_i0	PRJNA382357	31615	402	6.304985	25.3460397	Myxococcales	29	Bacteria	Bacteria	313	1.6e-80	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g30876	i0	86.786	193.017412935323	280	37	70	0	71	350	451835	452114	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	77593	316	0.990506329113924	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
22079301	22079301	PRJNA382357_P_NODE_133178_length_212_cov_1.218543_g132439_i0	PRJNA382357	133178	212	1.218543	2.58331116	Melittangium boletus	83453	Bacteria	Bacteria	315	2.15e-81	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g132439	i0	93.396	237.995283018868	212	14	100	0	1	212	3598734	3598945	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	50455	315	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
22752418	22752418	PRJNA382357_P_NODE_87718_length_256_cov_3.153846_g86979_i0	PRJNA382357	87718	256	3.153846	8.07384576	Archangium	47	Bacteria	Bacteria	71.3	6.43e-8	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g86979	i0	88.525	24.4609375	61	4	23	3	154	212	6095517	6095458	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	6262	71.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
22752475	22752475	PRJNA382357_P_NODE_9358_length_676_cov_70.173984_g8664_i0	PRJNA382357	9358	676	70.173984	474.37613184	Myxococcia	32015	Bacteria	Bacteria	431	7.41e-116	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8664	i0	86.567	84.8639053254438	402	40	98	11	137	527	3941989	3942387	Labilithrix luteola strain DSM 27648, complete genome	blastn	57368	433	0.995381062355658	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23355379	23355379	PRJNA382357_P_NODE_167679_length_178_cov_10.418803_g166940_i0	PRJNA382357	167679	178	10.418803	18.54546934	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g166940	i0	96.97	0.185393258426966	33	0	18	1	55	86	6867791	6867823	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
24630927	24630927	PRJNA382357_P_NODE_86900_length_257_cov_3.602041_g86161_i0	PRJNA382357	86900	257	3.602041	9.25724537	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	78.7	3.86e-10	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g86161	i0	90	0.610894941634241	60	6	23	0	78	137	9048326	9048267	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	157	78.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus

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