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

5 rows where bioproject = "PRJNA1074407", 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
2741517	2741517	PRJNA1074407_P_NODE_92903_length_374_cov_3.328904_g89066_i0	PRJNA1074407	92903	374	3.328904	12.45010096	Hirudo verbana	311461	Annelida	Annelida	52.8	0.036	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g89066	i0	100	0.224598930481283	28	0	7	0	98	125	1915676	1915649	Hirudo verbana genome assembly, chromosome: 9	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6566473	6566473	PRJNA1074407_P_NODE_124886_length_274_cov_1.776119_g121048_i0	PRJNA1074407	124886	274	1.776119	4.86656606	Enchytraeus albidus	6390	Annelida	Annelida	219	2.3399999999999994e-52	NTclustered	gi\|1068288339\|gb\|KU728752.1\|	6390	g121048	i0	81.159	30.8649635036496	276	48	100	4	1	274	911	638	Enchytraeus albidus mitochondrial ATP synthase subunit alpha precursor, mRNA, complete cds; nuclear gene for mitochondrial product	blastn	8457	219	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Enchytraeus	Enchytraeus albidus
9115951	9115951	PRJNA1074407_P_NODE_116568_length_297_cov_0.808036_g112730_i0	PRJNA1074407	116568	297	0.808036	2.39986692	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.028	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g112730	i0	96.774	0.104377104377104	31	1	10	0	260	290	3731437	3731407	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
26940766	26940766	PRJNA1074407_P_NODE_141082_length_244_cov_1.216374_g137244_i0	PRJNA1074407	141082	244	1.216374	2.96795256	Paralvinella palmiformis	53620	Annelida	Annelida	76.3	4.83e-14	NR	KAK2164245.1	53620	g137244	i0	45.3	3.71311475409836	64	33	78.7	1	2	193	291	352	KAK2164245.1 hypothetical protein LSH36_67g04005 [Paralvinella palmiformis]	diamond	906	76.3	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30415326	30415326	PRJNA1074407_P_NODE_134033_length_251_cov_1.561798_g130195_i0	PRJNA1074407	134033	251	1.561798	3.92011298	Helobdella robusta	6412	Annelida	Annelida	127	9.399999999999999e-32	NR	XP_009031746.1	6412	g130195	i0	65.9	15.7290836653386	82	28	98	0	6	251	752	833	XP_009031746.1 hypothetical protein HELRODRAFT_194672 [Helobdella robusta]	diamond	3948	127	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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