metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA312899" 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
380097	380097	PRJNA312899_P_NODE_7301_length_689_cov_5.404687_g6938_i0	PRJNA312899	7301	689	5.404687	37.23829343	Corallococcus interemptor	2316720	Bacteria	Bacteria	693	0	NTclustered	gi\|2809283937\|gb\|CP102579.1\|	2316720	g6938	i0	85.586	8.72714078374456	666	90	96	6	1	663	8517672	8518334	Corallococcus interemptor strain YZPH-2 chromosome, complete genome	blastn	6013	693	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
1654194	1654194	PRJNA312899_P_NODE_35362_length_305_cov_1.593750_g34920_i0	PRJNA312899	35362	305	1.59375	4.8609375	Corallococcus macrosporus	35	Bacteria	Bacteria	78.7	4.69e-10	NTclustered	gi\|1243045502\|gb\|CP022203.1\|	1189310	g34920	i0	87.879	0.216393442622951	66	8	22	0	5	70	2483578	2483643	Corallococcus macrosporus DSM 14697 chromosome, complete genome	blastn	66	78.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
5483497	5483497	PRJNA312899_P_NODE_69625_length_194_cov_2.786207_g69183_i0	PRJNA312899	69625	194	2.786207	5.40524158	Pendulispora brunnea	2905690	Bacteria	Bacteria	130	7.52e-26	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g69183	i0	81.25	1.50515463917526	160	30	82	0	35	194	12877313	12877154	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	292	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
9307467	9307467	PRJNA312899_P_NODE_37628_length_293_cov_9.135246_g37186_i0	PRJNA312899	37628	293	9.135246	26.76627078	Cystobacter fuscus	43	Bacteria	Bacteria	303	6.79e-78	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g37186	i0	89.831	2.64163822525597	236	24	81	0	2	237	3772955	3772720	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	774	303	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
9307975	9307975	PRJNA312899_P_NODE_66188_length_202_cov_7.594771_g65746_i0	PRJNA312899	66188	202	7.594771	15.34143742	uncultured Sorangium sp.	491148	Bacteria	Bacteria	239	1.26e-58	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g65746	i0	100	103.950495049505	129	0	64	0	2	130	1101	1229	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	20998	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
11859077	11859077	PRJNA312899_P_NODE_93210_length_164_cov_2.339130_g92768_i0	PRJNA312899	93210	164	2.33913	3.8361732	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	165	1.69e-36	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g92768	i0	84.848	312.231707317073	165	24	100	1	1	164	190	26	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	51206	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
13133484	13133484	PRJNA312899_P_NODE_51611_length_241_cov_2.645833_g51169_i0	PRJNA312899	51611	241	2.645833	6.37645753	Pendulispora albinea	2741071	Bacteria	Bacteria	165	2.67e-36	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g51169	i0	80.631	2.79668049792531	222	36	91	5	1	220	6661272	6661488	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	674	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
14407818	14407818	PRJNA312899_P_NODE_10572_length_581_cov_73.791353_g10160_i0	PRJNA312899	10572	581	73.791353	428.72776093	Polyangium aurulentum	2567896	Bacteria	Bacteria	172	4.2199999999999996e-38	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g10160	i0	86.538	1.46815834767642	156	21	27	0	1	156	4558500	4558655	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	853	172	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
16957199	16957199	PRJNA312899_P_NODE_56934_length_226_cov_1.728814_g56492_i0	PRJNA312899	56934	226	1.728814	3.90711964	Labilithrix luteola	1391654	Bacteria	Bacteria	241	4e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g56492	i0	86.026	5.11061946902655	229	26	100	5	1	226	10293899	10294124	Labilithrix luteola strain DSM 27648, complete genome	blastn	1155	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23331029	23331029	PRJNA312899_P_NODE_12519_length_534_cov_42.490722_g12090_i0	PRJNA312899	12519	534	42.490722	226.90045548	Pendulispora brunnea	2905690	Bacteria	Bacteria	857	0	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g12090	i0	95.701	152.535580524345	535	20	100	3	1	534	9037081	9037613	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	81454	857	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
23332367	23332367	PRJNA312899_P_NODE_8799_length_636_cov_19.669506_g8410_i0	PRJNA312899	8799	636	19.669506	125.09805816	Archangium violaceum	83451	Bacteria	Bacteria	459	3.19e-124	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g8410	i0	80.255	4.46698113207547	628	109	98	13	1	622	931297	931915	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	2841	459	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum

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