metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1068513" 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
181932	181932	PRJNA1068513_S_NODE_3161_length_489_cov_3.699519_g3116_i0	PRJNA1068513	3161	489	3.699519	18.09064791	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	52.8	0.048	NTclustered	gi\|2920003456\|emb\|OZ238864.1\|	1046305	g3116	i0	100	0.0572597137014315	28	0	6	0	400	427	32058657	32058684	Ailoscolex lacteospumosus genome assembly, chromosome: 5	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
2732403	2732403	PRJNA1068513_S_NODE_3223_length_486_cov_4.094431_g3178_i0	PRJNA1068513	3223	486	4.094431	19.89893466	Acromegalomma interruptum	2023653	Annelida	Annelida	176	2.69e-39	NTclustered	gi\|1227250270\|gb\|MF145114.1\|	2023653	g3178	i0	82.439	0.839506172839506	205	33	42	3	1	203	925	1128	Acromegalomma interruptum isolate Galpha_o_Contig1351_ORF5 putative phototransduction mRNA, partial cds	blastn	408	176	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Sabellidae	Acromegalomma	Acromegalomma interruptum
12935673	12935673	PRJNA1068513_S_NODE_8111_length_318_cov_3.359184_g8065_i0	PRJNA1068513	8111	318	3.359184	10.68220512	Hirudo verbana	311461	Annelida	Annelida	52.8	0.03	NTclustered	gi\|2918369706\|emb\|OZ237788.1\|	311461	g8065	i0	100	0.352201257861635	28	0	9	0	61	88	616371	616398	Hirudo verbana genome assembly, chromosome: 10	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
15041321	15041321	PRJNA1068513_S_NODE_9632_length_289_cov_2.884259_g9586_i0	PRJNA1068513	9632	289	2.884259	8.33550851	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.027	NTclustered	gi\|675857863\|ref\|XM_009016244.1\|	6412	g9586	i0	100	2.13148788927336	28	0	10	0	243	270	620	647	Helobdella robusta hypothetical protein partial mRNA	blastn	616	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
15484643	15484643	PRJNA1068513_S_NODE_8853_length_304_cov_1.493506_g8807_i0	PRJNA1068513	8853	304	1.493506	4.54025824	Hirudo verbana	311461	Annelida	Annelida	52.8	0.028	NTclustered	gi\|2918369614\|emb\|OZ237780.1\|	311461	g8807	i0	100	0.0921052631578947	28	0	9	0	134	161	6180507	6180534	Hirudo verbana genome assembly, chromosome: 2	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana

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