metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
5518578	5518578	PRJNA404067_P_NODE_38205_length_201_cov_1.807143_g37818_i0	PRJNA404067	38205	201	1.807143	3.63235743	Pendulispora rubella	2741070	Bacteria	Bacteria	344	2.5799999999999998e-90	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g37818	i0	97.512	106.363184079602	201	5	100	0	1	201	7292232	7292032	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	21379	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
10618307	10618307	PRJNA404067_P_NODE_11029_length_323_cov_1.354962_g10644_i0	PRJNA404067	11029	323	1.354962	4.37652726	Labilithrix luteola	1391654	Bacteria	Bacteria	449	9.199999999999999e-122	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10644	i0	97.348	145.557275541796	264	7	98	0	59	322	3942570	3942833	Labilithrix luteola strain DSM 27648, complete genome	blastn	47015	449	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11893271	11893271	PRJNA404067_P_NODE_18730_length_241_cov_1.750000_g18343_i0	PRJNA404067	18730	241	1.75	4.2175	Chondromyces crocatus	52	Bacteria	Bacteria	331	2.49e-86	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g18343	i0	91.983	160.867219917012	237	17	98	2	6	241	1431863	1431628	Chondromyces crocatus strain Cm c5, complete genome	blastn	38769	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
11893274	11893274	PRJNA404067_P_NODE_18950_length_240_cov_1.815642_g18563_i0	PRJNA404067	18950	240	1.815642	4.3575408	Pendulispora rubella	2741070	Bacteria	Bacteria	355	1.47e-93	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18563	i0	93.333	111.716666666667	240	16	100	0	1	240	7289411	7289172	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	26812	355	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14443768	14443768	PRJNA404067_P_NODE_39352_length_200_cov_2.618705_g38965_i0	PRJNA404067	39352	200	2.618705	5.23741	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	219	1.62e-52	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g38965	i0	87.701	83.365	187	23	94	0	2	188	9679256	9679070	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	16673	219	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15717230	15717230	PRJNA404067_P_NODE_22933_length_228_cov_1.371257_g22546_i0	PRJNA404067	22933	228	1.371257	3.12646596	Labilithrix luteola	1391654	Bacteria	Bacteria	342	1.08e-89	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22546	i0	94.196	181.40350877193	224	13	98	0	1	224	3943241	3943018	Labilithrix luteola strain DSM 27648, complete genome	blastn	41360	342	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16992122	16992122	PRJNA404067_P_NODE_27754_length_216_cov_1.619355_g27367_i0	PRJNA404067	27754	216	1.619355	3.4978068	Labilithrix luteola	1391654	Bacteria	Bacteria	252	1.75e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27367	i0	87.907	0.99537037037037	215	24	99	2	3	216	6447356	6447569	Labilithrix luteola strain DSM 27648, complete genome	blastn	215	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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