metadata: contig_metadata: 6 rows where bioproject = "PRJNA330616", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA330616", tax_kingdom = "Metazoa" 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
17646811	17646811	PRJNA330616_P_NODE_11074_length_248_cov_2.748744_g10665_i0	PRJNA330616	11074	248	2.748744	6.81688512	Metazoa	33208	Annelida	Annelida	351	1.97e-92	NTclustered	gi\|61652090\|gb\|AY838861.1\|	167828	g10665	i0	92.308	99.5604838709677	247	19	99	0	2	248	3149	2903	Marphysa sanguinea 28S ribosomal RNA gene, partial sequence	blastn	24691	351	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Eunicida	Eunicidae	Marphysa	Marphysa sanguinea
23341744	23341744	PRJNA330616_P_NODE_3739_length_444_cov_2.989873_g3332_i0	PRJNA330616	3739	444	2.989873	13.27503612	Opisthokonta	33154	Annelida	Annelida	246	1.33e-79	NR	ABW23138.1	6344	g3332	i0	76.2	31.7837837837838	147	35	99.3	0	443	3	88	234	ABW23138.1 ribosomal protein rps4, partial [Arenicola marina]	diamond	14112	246	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
26807133	26807133	PRJNA330616_P_NODE_6061_length_340_cov_2.189003_g5652_i0	PRJNA330616	6061	340	2.189003	7.4426102	Opisthokonta	33154	Annelida	Annelida	150	1.27e-44	NR	ADY18402.1	104710	g5652	i0	75.8	6.22058823529412	91	22	80.3	0	338	66	12	102	ADY18402.1 ribosomal protein rps3, partial [Glycera tridactyla]	diamond	2115	150	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Glyceridae	Glycera	Glycera tridactyla
27912944	27912944	PRJNA330616_P_NODE_17685_length_200_cov_0.754967_g17276_i0	PRJNA330616	17685	200	0.754967	1.509934	Metazoa	33208	Annelida	Annelida	74.3	3.81e-15	NR	QFU47562.1	6398	g17276	i0	68.8	12.48	64	20	96	0	199	8	16	79	QFU47562.1 histone H3, partial [Lumbricus terrestris]	diamond	2496	74.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Lumbricus	Lumbricus terrestris
28559080	28559080	PRJNA330616_P_NODE_13927_length_223_cov_1.367816_g13518_i0	PRJNA330616	13927	223	1.367816	3.05022968	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	51.2	3.02e-5	NR	CAD5119760.1	2664684	g13518	i0	42	1.86995515695067	69	40	92.8	0	14	220	149	217	CAD5119760.1 DgyrCDS8355 [Dimorphilus gyrociliatus]	diamond	417	51.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus
29491824	29491824	PRJNA330616_P_NODE_18250_length_197_cov_1.277027_g17841_i0	PRJNA330616	18250	197	1.277027	2.51574319	Opisthokonta	33154	Annelida	Annelida	62	2.08e-10	NR	ADY18398.1	104710	g17841	i0	57.9	4.30964467005076	57	21	86.8	1	26	196	10	63	ADY18398.1 ribosomal protein rps25, partial [Glycera tridactyla]	diamond	849	62	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Glyceridae	Glycera	Glycera tridactyla

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