metadata: contig_metadata: 5 rows where bioproject = "PRJNA994052", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA994052", 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
8629684	8629684	PRJNA994052_P_NODE_60987_length_224_cov_93.443709_g59731_i0	PRJNA994052	60987	224	93.443709	209.31390816	Rhiphaeodrilus diplotetrathecus	2902654	Annelida	Annelida	174	4.07e-39	NTclustered	gi\|2898690811\|gb\|PP868406.1\|	2902654	g59731	i0	83.417	78.03125	199	21	86	12	33	224	11969	11776	Rhiphaeodrilus diplotetrathecus mitochondrion, partial genome	blastn	17479	174	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Rhiphaeodrilus	Rhiphaeodrilus diplotetrathecus
11476947	11476947	PRJNA994052_P_NODE_6869_length_378_cov_14.285246_g5797_i0	PRJNA994052	6869	378	14.285246	53.99822988	Aeolosomatidae	55815	Annelida	Annelida	682	0	NTclustered	gi\|46487598\|gb\|AY527049.1\|	272727	g5797	i0	99.206	99.537037037037	378	3	100	0	1	378	772	1149	Rheomorpha neiswestonovae 18S ribosomal RNA gene, partial sequence	blastn	37625	682	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Rheomorpha	Rheomorpha neiswestonovae
18828713	18828713	PRJNA994052_P_NODE_935_length_628_cov_63.693694_g538_i0	PRJNA994052	935	628	63.693694	399.99639832	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	359	3.28e-94	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g538	i0	81.25	26.3312101910828	464	70	72	12	51	502	14	472	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	16536	359	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
24224644	24224644	PRJNA994052_P_NODE_11439_length_327_cov_5.826772_g10223_i0	PRJNA994052	11439	327	5.826772	19.05354444	Naididae	2109251	Annelida	Annelida	274	6.03e-69	NTclustered	gi\|94467836\|gb\|DQ459984.1\|	66488	g10223	i0	99.338	90.8073394495413	151	1	92	0	1	151	567	717	Dero digitata 18S ribosomal RNA gene, partial sequence	blastn	29694	274	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Dero	Dero digitata
30974493	30974493	PRJNA994052_P_NODE_65674_length_218_cov_16.344828_g64418_i0	PRJNA994052	65674	218	16.344828	35.63172504	Eurythoe complanata	167815	Annelida	Annelida	80.1	2.07e-16	NR	ABW23216.1	167815	g64418	i0	86.8	0.522935779816514	38	5	52.3	0	218	105	176	213	ABW23216.1 ribosomal protein rpl10 [Eurythoe complanata]	diamond	114	80.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Eunicida	Amphinomidae	Eurythoe	Eurythoe complanata

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