metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
2473733	2473733	PRJNA743294_P_NODE_36282_length_280_cov_1.903382_g35826_i0	PRJNA743294	36282	280	1.903382	5.3294696	root	1	Root_unresolved	Root_unresolved	84.2	9.15e-12	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g35826	i0	84.706	1.85357142857143	85	11	30	2	2	85	10635113	10635196	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	519	84.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
3273337	3273337	PRJNA743294_P_NODE_29203_length_307_cov_3.662393_g28747_i0	PRJNA743294	29203	307	3.662393	11.24354651	Labilithrix luteola	1391654	Bacteria	Bacteria	473	5.159999999999999e-129	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g28747	i0	94.737	134.221498371336	304	16	99	0	4	307	7090457	7090154	Labilithrix luteola strain DSM 27648, complete genome	blastn	41206	473	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4550685	4550685	PRJNA743294_P_NODE_50444_length_248_cov_1.508571_g49988_i0	PRJNA743294	50444	248	1.508571	3.74125608	Sorangium cellulosum	56	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g49988	i0	85.484	144.826612903226	248	32	99	4	3	248	3449580	3449825	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	35917	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5825490	5825490	PRJNA743294_P_NODE_15745_length_405_cov_1.524096_g15289_i0	PRJNA743294	15745	405	1.524096	6.1725888	Corallococcus exercitus	2316736	Bacteria	Bacteria	339	2.66e-88	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g15289	i0	83.024	66.683950617284	377	60	93	4	3	377	7614356	7614730	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	27007	339	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
5825595	5825595	PRJNA743294_P_NODE_29005_length_308_cov_3.114894_g28549_i0	PRJNA743294	29005	308	3.114894	9.59387352	Labilithrix luteola	1391654	Bacteria	Bacteria	414	3.18e-111	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g28549	i0	90.939	145.00974025974	309	26	100	2	1	308	7090147	7090454	Labilithrix luteola strain DSM 27648, complete genome	blastn	44663	414	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8375242	8375242	PRJNA743294_P_NODE_17507_length_385_cov_5.253205_g17051_i0	PRJNA743294	17507	385	5.253205	20.22483925	Labilithrix luteola	1391654	Bacteria	Bacteria	645	1.3299999999999995e-180	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17051	i0	97.12	144.677922077922	382	11	99	0	1	382	3943769	3944150	Labilithrix luteola strain DSM 27648, complete genome	blastn	55701	645	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10925982	10925982	PRJNA743294_P_NODE_34149_length_287_cov_2.462617_g33693_i0	PRJNA743294	34149	287	2.462617	7.06771079	Sorangium cellulosum	56	Bacteria	Bacteria	374	4.989999999999998e-99	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g33693	i0	90.526	146.418118466899	285	24	99	3	5	287	3489737	3490020	Sorangium cellulosum 'So ce 56' complete genome	blastn	42022	374	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11402053	11402053	PRJNA743294_P_NODE_35369_length_283_cov_2.080952_g34913_i0	PRJNA743294	35369	283	2.080952	5.88909416	Myxococcus	32	Bacteria	Bacteria	433	7.98e-117	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g34913	i0	94.326	248.780918727915	282	16	99	0	2	283	379477	379196	Myxococcus xanthus strain DK1050 chromosome	blastn	70405	433	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14750936	14750936	PRJNA743294_P_NODE_30852_length_300_cov_1.792952_g30396_i0	PRJNA743294	30852	300	1.792952	5.378856	Myxococcus landrumensis	2813577	Bacteria	Bacteria	130	1.25e-25	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g30396	i0	83.571	1.52666666666667	140	21	46	2	1	139	8666373	8666235	Myxococcus landrumus strain SCHIC003 chromosome	blastn	458	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
14751084	14751084	PRJNA743294_P_NODE_51592_length_247_cov_0.896552_g51136_i0	PRJNA743294	51592	247	0.896552	2.21448344	Pendulispora albinea	2741071	Bacteria	Bacteria	211	3.48e-50	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g51136	i0	82.258	17.587044534413	248	40	100	4	1	247	3589459	3589215	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	4344	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15226902	15226902	PRJNA743294_P_NODE_49492_length_249_cov_1.693182_g49036_i0	PRJNA743294	49492	249	1.693182	4.21602318	Myxococcaceae	31	Bacteria	Bacteria	84.2	7.99e-12	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g49036	i0	86.667	7.0281124497992	75	10	30	0	175	249	3991226	3991152	Myxococcus macrosporus strain HW-1, complete genome	blastn	1750	84.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
19849141	19849141	PRJNA743294_P_NODE_44716_length_256_cov_2.459016_g44260_i0	PRJNA743294	44716	256	2.459016	6.29508096	Sorangium cellulosum	56	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g44260	i0	100	0.11328125	29	0	11	0	82	110	5442557	5442529	Sorangium cellulosum So0157-2, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19849228	19849228	PRJNA743294_P_NODE_55956_length_242_cov_1.940828_g55500_i0	PRJNA743294	55956	242	1.940828	4.69680376	Labilithrix luteola	1391654	Bacteria	Bacteria	396	8.739999999999996e-106	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g55500	i0	96.266	196.785123966942	241	9	99	0	2	242	3943510	3943750	Labilithrix luteola strain DSM 27648, complete genome	blastn	47622	396	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20324788	20324788	PRJNA743294_P_NODE_4816_length_694_cov_4.056361_g4388_i0	PRJNA743294	4816	694	4.056361	28.15114534	Myxococcia	32015	Bacteria	Bacteria	1053	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4388	i0	94.203	150.515850144092	690	40	99	0	1	690	7089517	7090206	Labilithrix luteola strain DSM 27648, complete genome	blastn	104458	1062	0.991525423728814	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21600550	21600550	PRJNA743294_P_NODE_59357_length_228_cov_2.264516_g58901_i0	PRJNA743294	59357	228	2.264516	5.16309648	Stigmatella	40	Bacteria	Bacteria	222	1.46e-53	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g58901	i0	84.821	297.5	224	31	98	3	6	228	1489	1710	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	67830	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
22399478	22399478	PRJNA743294_P_NODE_28538_length_310_cov_5.101266_g28082_i0	PRJNA743294	28538	310	5.101266	15.8139246	Stigmatella aurantiaca	41	Bacteria	Bacteria	416	8.91e-112	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g28082	i0	91.026	368.348387096774	312	23	100	5	1	310	319	11	S.aurantiaca 23S rRNA gene	blastn	114188	416	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
22875836	22875836	PRJNA743294_P_NODE_33838_length_288_cov_3.855814_g33382_i0	PRJNA743294	33838	288	3.855814	11.10474432	Stigmatella	40	Bacteria	Bacteria	183	9.059999999999997e-42	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g33382	i0	84.127	48.0486111111111	189	30	66	0	99	287	1316	1504	S.aurantiaca 23S rRNA gene	blastn	13838	183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca

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