metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
2730389	2730389	PRJNA1063685_S_NODE_7663_length_669_cov_17.001678_g7172_i0	PRJNA1063685	7663	669	17.001678	113.74122582	Hirudo verbana	311461	Annelida	Annelida	65.8	8.56e-6	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g7172	i0	100	3.33931240657698	35	0	5	0	467	501	9025701	9025667	Hirudo verbana genome assembly, chromosome: 12	blastn	2234	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6557612	6557612	PRJNA1063685_S_NODE_4546_length_746_cov_477.161961_g4125_i0	PRJNA1063685	4546	746	477.161961	3559.62822906	Hirudo verbana	311461	Annelida	Annelida	60.2	4.47e-4	NTclustered	gi\|2918369702\|emb\|OZ237787.1\|	311461	g4125	i0	94.737	0.592493297587131	38	2	5	0	585	622	1192910	1192873	Hirudo verbana genome assembly, chromosome: 9	blastn	442	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
6557731	6557731	PRJNA1063685_S_NODE_62146_length_273_cov_1.325000_g61603_i0	PRJNA1063685	62146	273	1.325	3.61725	Hirudo verbana	311461	Annelida	Annelida	54.7	0.007	NTclustered	gi\|2918369616\|emb\|OZ237781.1\|	311461	g61603	i0	100	0.106227106227106	29	0	11	0	47	75	12366435	12366407	Hirudo verbana genome assembly, chromosome: 3	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
7832216	7832216	PRJNA1063685_S_NODE_37627_length_381_cov_2.769481_g37084_i0	PRJNA1063685	37627	381	2.769481	10.55172261	Hirudo verbana	311461	Annelida	Annelida	52.8	0.036	NTclustered	gi\|2918369643\|emb\|OZ237784.1\|	311461	g37084	i0	100	0.073490813648294	28	0	7	0	257	284	504391	504418	Hirudo verbana genome assembly, chromosome: 6	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
12933331	12933331	PRJNA1063685_S_NODE_37071_length_384_cov_3.819936_g36528_i0	PRJNA1063685	37071	384	3.819936	14.66855424	Hirudo verbana	311461	Annelida	Annelida	52.8	0.037	NTclustered	gi\|2918369621\|emb\|OZ237783.1\|	311461	g36528	i0	100	0.21875	28	0	7	0	215	242	676105	676078	Hirudo verbana genome assembly, chromosome: 5	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
16314526	16314526	PRJNA1063685_S_NODE_66813_length_259_cov_1.424731_g66270_i0	PRJNA1063685	66813	259	1.424731	3.69005329	Leptonerilla	317905	Annelida	Annelida	207	4.76e-49	NTclustered	gi\|67541528\|gb\|AY834758.2\|	317906	g66270	i0	83.408	86.030888030888	223	37	86	0	1	223	801	1023	Leptonerilla prospera 18S ribosomal RNA gene, partial sequence	blastn	22282	207	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Nerillidae	Leptonerilla	Leptonerilla prospera
19305522	19305522	PRJNA1063685_S_NODE_6976_length_683_cov_10.911475_g6488_i0	PRJNA1063685	6976	683	10.911475	74.52537425	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.005	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g6488	i0	87.755	0.0717423133235725	49	5	7	1	350	398	14450832	14450785	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	49	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
23131717	23131717	PRJNA1063685_S_NODE_20479_length_505_cov_5.828704_g19941_i0	PRJNA1063685	20479	505	5.828704	29.4349552	Helobdella robusta	6412	Annelida	Annelida	52.8	0.049	NTclustered	gi\|675868781\|ref\|XM_009021703.1\|	6412	g19941	i0	100	0.0554455445544554	28	0	6	0	186	213	787	760	Helobdella robusta hypothetical protein partial mRNA	blastn	28	52.8	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);;