metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA526367" 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
1771049	1771049	PRJNA526367_P_NODE_27802_length_324_cov_1.774545_g27593_i0	PRJNA526367	27802	324	1.774545	5.7495258	Archangium minus	83450	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g27593	i0	100	0.268518518518519	29	0	9	0	249	277	5471311	5471283	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
1771203	1771203	PRJNA526367_P_NODE_40382_length_182_cov_4.849624_g40172_i0	PRJNA526367	40382	182	4.849624	8.82631568	uncultured Sorangium sp.	491148	Bacteria	Bacteria	213	6.71e-51	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g40172	i0	100	97.4395604395604	115	0	63	0	63	177	1229	1115	Uncultured Sorangium sp. clone 3_E21 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17734	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
4322781	4322781	PRJNA526367_P_NODE_29824_length_324_cov_1.509091_g29615_i0	PRJNA526367	29824	324	1.509091	4.88945484	Sorangium cellulosum	56	Bacteria	Bacteria	139	2.27e-28	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g29615	i0	93.548	0.604938271604938	93	6	29	0	227	319	572321	572413	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	196	139	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5599723	5599723	PRJNA526367_P_NODE_27425_length_324_cov_1.803636_g27216_i0	PRJNA526367	27425	324	1.803636	5.84378064	Pendulispora brunnea	2905690	Bacteria	Bacteria	106	2.3e-18	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g27216	i0	91.026	4.08333333333333	78	7	24	0	234	311	228019	228096	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	1323	106	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
7491852	7491852	PRJNA526367_P_NODE_39446_length_184_cov_1.777778_g39236_i0	PRJNA526367	39446	184	1.777778	3.27111152	Stigmatella	40	Bacteria	Bacteria	283	5.11e-72	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g39236	i0	96.491	265.510869565217	171	6	93	0	8	178	720	890	S.aurantiaca 23S rRNA gene	blastn	48854	283	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
9424602	9424602	PRJNA526367_P_NODE_66208_length_150_cov_6.059406_g65998_i0	PRJNA526367	66208	150	6.059406	9.089109	Pendulispora albinea	2741071	Bacteria	Bacteria	137	3.28e-28	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g65998	i0	84.028	3.66	144	21	95	2	8	150	8528664	8528806	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	549	137	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15798702	15798702	PRJNA526367_P_NODE_41673_length_180_cov_2.908397_g41463_i0	PRJNA526367	41673	180	2.908397	5.2351146	Minicystis rosea	888845	Bacteria	Bacteria	255	1.08e-63	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g41463	i0	92.222	44.2166666666667	180	14	100	0	1	180	8033739	8033560	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	7959	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
20898517	20898517	PRJNA526367_P_NODE_8057_length_324_cov_4.196364_g7848_i0	PRJNA526367	8057	324	4.196364	13.59621936	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	87.9	8.34e-13	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g7848	i0	92.063	0.657407407407407	63	4	19	1	36	97	3020588	3020650	Anaeromyxobacter paludicola DNA, complete genome	blastn	213	87.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
22172553	22172553	PRJNA526367_P_NODE_20858_length_324_cov_2.363636_g20649_i0	PRJNA526367	20858	324	2.363636	7.65818064	Labilithrix luteola	1391654	Bacteria	Bacteria	158	6.27e-34	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g20649	i0	95	0.858024691358025	100	5	31	0	1	100	11030846	11030945	Labilithrix luteola strain DSM 27648, complete genome	blastn	278	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24721832	24721832	PRJNA526367_P_NODE_19680_length_324_cov_2.461818_g19471_i0	PRJNA526367	19680	324	2.461818	7.97629032	Pendulispora rubella	2741070	Bacteria	Bacteria	76.8	1.81e-9	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g19471	i0	83.951	1.28703703703704	81	11	25	2	20	99	9389091	9389170	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	417	76.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella

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