metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
3273334	3273334	PRJNA743294_P_NODE_283_length_1995_cov_3.218522_g216_i0	PRJNA743294	283	1995	3.218522	64.2095139	Helobdella robusta	6412	Annelida	Annelida	67.6	7.36e-6	NTclustered	gi\|675847207\|ref\|XM_009010916.1\|	6412	g216	i0	91.837	0.0245614035087719	49	2	2	2	1325	1373	676	630	Helobdella robusta hypothetical protein mRNA	blastn	49	67.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
3273545	3273545	PRJNA743294_P_NODE_54783_length_244_cov_0.912281_g54327_i0	PRJNA743294	54783	244	0.912281	2.22596564	Helobdella robusta	6412	Annelida	Annelida	58.4	4.73e-4	NTclustered	gi\|675892221\|ref\|XM_009033365.1\|	6412	g54327	i0	92.5	0.323770491803279	40	3	16	0	48	87	2050	2089	Helobdella robusta hypothetical protein partial mRNA	blastn	79	58.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
7576270	7576270	PRJNA743294_P_NODE_33486_length_290_cov_1.124424_g33030_i0	PRJNA743294	33486	290	1.124424	3.2608296	Metazoa	33208	Annelida	Annelida	60.2	1.6e-4	NTclustered	gi\|675851267\|ref\|XM_009012946.1\|	6412	g33030	i0	90.909	12.0862068965517	44	4	15	0	46	89	4532	4489	Helobdella robusta hypothetical protein partial mRNA	blastn	3505	60.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
8375196	8375196	PRJNA743294_P_NODE_11627_length_465_cov_3.193878_g11171_i0	PRJNA743294	11627	465	3.193878	14.8515327	Bradabyssa aff. villosa CMC02	868096	Annelida	Annelida	152	4.33e-32	NTclustered	gi\|304269376\|gb\|HM473202.1\|	868096	g11171	i0	78.205	47.047311827957	234	45	50	4	1	234	684	457	Brada villosa CMC02 voucher BIOUG<CAN>:BAMPOL0433 28S ribosomal RNA gene, partial sequence	blastn	21877	152	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Flabelligeridae	Bradabyssa	Bradabyssa aff. villosa CMC02
13476111	13476111	PRJNA743294_P_NODE_6731_length_601_cov_1.732955_g6279_i0	PRJNA743294	6731	601	1.732955	10.41505955	Helobdella robusta	6412	Annelida	Annelida	54.7	0.017	NTclustered	gi\|675849915\|ref\|XM_009012270.1\|	6412	g6279	i0	100	0.0482529118136439	29	0	5	0	545	573	324	296	Helobdella robusta hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
18573849	18573849	PRJNA743294_P_NODE_4595_length_709_cov_3.100629_g4176_i0	PRJNA743294	4595	709	3.100629	21.98345961	Theromyzon tessulatum	13286	Annelida	Annelida	255	5.03e-63	NTclustered	gi\|23344733\|gb\|AF542132.1\|	13286	g4176	i0	96.732	0.811001410437236	153	5	22	0	1	153	1127	975	Theromyzon tessulatum cathepsin L mRNA, complete cds	blastn	575	255	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
22399664	22399664	PRJNA743294_P_NODE_54638_length_244_cov_0.912281_g54182_i0	PRJNA743294	54638	244	0.912281	2.22596564	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	67.6	7.86e-7	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g54182	i0	93.478	4.57786885245902	46	1	18	2	198	241	21139892	21139937	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	1117	67.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus

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