metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax_phylum = "Annelida"

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
21085772	21085772	PRJNA700095_P_NODE_8817_length_664_cov_4.263959_g7621_i0	PRJNA700095	8817	664	4.263959	28.31268776	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	238	6.87e-71	NR	CAH1802338.1	6347	g7621	i0	61.5	2.54819277108434	192	71	86.3	3	2	574	445	634	CAH1802338.1 unnamed protein product [Owenia fusiformis]	diamond	1692	238	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28893821	28893821	PRJNA700095_P_NODE_24648_length_347_cov_1.251825_g23384_i0	PRJNA700095	24648	347	1.251825	4.34383275	Opisthokonta	33154	Annelida	Annelida	73.6	1.93e-12	NR	CAH1800435.1	6347	g23384	i0	37.2	1.96253602305476	113	49	97.7	3	345	7	484	574	CAH1800435.1 unnamed protein product [Owenia fusiformis]	diamond	681	74.3	0.990578734858681	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29450822	29450822	PRJNA700095_P_NODE_14050_length_499_cov_1.309859_g12791_i0	PRJNA700095	14050	499	1.309859	6.53619641	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	54.3	3.36e-5	NR	CAD5115989.1	2664684	g12791	i0	27.6	1.79759519038076	152	80	89.6	3	490	44	137	261	CAD5115989.1 DgyrCDS4925 [Dimorphilus gyrociliatus]	diamond	897	54.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
31042150	31042150	PRJNA700095_P_NODE_32855_length_297_cov_3.272321_g31591_i0	PRJNA700095	32855	297	3.272321	9.71879337	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	106	2.01e-24	NR	KAK2188786.1	27915	g31591	i0	62.5	6.77777777777778	80	30	80.8	0	242	3	3	82	KAK2188786.1 hypothetical protein NP493_121g01009 [Ridgeia piscesae]	diamond	2013	107	0.990654205607477	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31104856	31104856	PRJNA700095_P_NODE_5735_length_826_cov_2.347942_g4690_i0	PRJNA700095	5735	826	2.347942	19.39400092	Metazoa	33208	Annelida	Annelida	185	4.39e-51	NR	CAH1780581.1	6347	g4690	i0	56	3.05084745762712	166	67	60.3	1	327	824	70	229	CAH1780581.1 unnamed protein product [Owenia fusiformis]	diamond	2520	186	0.99462365591397806	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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