metadata: contig_metadata: 5 rows where bioproject = "PRJNA560932", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA560932", tax_clade = "Opisthokonta" and tax_phylum = "Chaetognatha"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1820335	1820335	PRJNA560932_P_NODE_33082_length_315_cov_1.590909_g32726_i0	PRJNA560932	33082	315	1.590909	5.01136335	Spadella cephaloptera	52888	Chaetognatha	other_Eukaryota	119	3.47e-32	NR	CAL69114.1	52888	g32726	i0	61.6	1.75238095238095	99	38	94.3	0	313	17	14	112	CAL69114.1 TPA: putative 40S ribosomal protein S25 isoform 1 [Spadella cephaloptera]	diamond	552	119	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
3095502	3095502	PRJNA560932_P_NODE_20023_length_393_cov_3.359375_g19667_i0	PRJNA560932	20023	393	3.359375	13.20234375	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	168	4.18e-51	NR	CAL69107.1	52888	g19667	i0	70.3	10.8625954198473	118	34	90.1	1	39	392	1	117	CAL69107.1 TPA: putative 40S ribosomal protein S17 isoform 2 [Spadella cephaloptera]	diamond	4269	168	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
21532523	21532523	PRJNA560932_P_NODE_14877_length_454_cov_3.304462_g14522_i0	PRJNA560932	14877	454	3.304462	15.00225748	Spadella cephaloptera	52888	Chaetognatha	other_Eukaryota	123	4.29e-33	NR	CAL69114.1	52888	g14522	i0	60	0.79295154185022	120	40	79.3	2	29	388	1	112	CAL69114.1 TPA: putative 40S ribosomal protein S25 isoform 1 [Spadella cephaloptera]	diamond	360	123	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
27584472	27584472	PRJNA560932_P_NODE_22904_length_370_cov_2.336700_g22548_i0	PRJNA560932	22904	370	2.3367	8.64579	Spadella cephaloptera	52888	Chaetognatha	other_Eukaryota	118	1.4499999999999998e-31	NR	CAL69114.1	52888	g22548	i0	62.2	2.3027027027027	98	37	79.5	0	345	52	12	109	CAL69114.1 TPA: putative 40S ribosomal protein S25 isoform 1 [Spadella cephaloptera]	diamond	852	118	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera
28703720	28703720	PRJNA560932_P_NODE_42087_length_281_cov_1.937500_g41731_i0	PRJNA560932	42087	281	1.9375	5.444375	Metazoa	33208	Chaetognatha	other_Eukaryota	108	2.03e-28	NR	CAL69114.1	52888	g41731	i0	65.5	4.44128113879004	84	29	89.7	0	30	281	12	95	CAL69114.1 TPA: putative 40S ribosomal protein S25 isoform 1 [Spadella cephaloptera]	diamond	1248	108	1	Eukaryota	Opisthokonta	Metazoa	Chaetognatha	Sagittoidea	Phragmophora	Spadellidae	Spadella	Spadella cephaloptera

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