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

5 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_phylum = "Cnidaria"

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
1045038	1045038	PRJNA1204310_P_NODE_35481_length_313_cov_1.625000_g35184_i0	PRJNA1204310	35481	313	1.625	5.08625	Metazoa	33208	Cnidaria	other_Eukaryota	52.8	0.029	NTclustered	gi\|2917940752\|emb\|OZ237570.1\|	6108	g35184	i0	100	0.715654952076677	28	0	9	0	159	186	10292804	10292831	Anemonia sulcata genome assembly, chromosome: 16	blastn	224	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
7982413	7982413	PRJNA1204310_P_NODE_24247_length_372_cov_2.357860_g23950_i0	PRJNA1204310	24247	372	2.35786	8.7712392	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	231	4.2299999999999995e-56	NTclustered	gi\|2782899435\|ref\|XM_067068137.1\|	252671	g23950	i0	86.603	85.3978494623656	209	28	60	0	1	209	351	559	PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA	blastn	31768	231	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
9973156	9973156	PRJNA1204310_P_NODE_50728_length_253_cov_0.866667_g50431_i0	PRJNA1204310	50728	253	0.866667	2.19266751	root	1	Root_unresolved	Root_unresolved	63.9	1.06e-5	NTclustered	gi\|2729094311\|ref\|XM_065209960.1\|	499914	g50431	i0	82.432	21.4189723320158	74	12	29	1	4	77	205	133	PREDICTED: Rhopilema esculentum uncharacterized LOC135691951 (LOC135691951), partial mRNA	blastn	5419	63.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
18896460	18896460	PRJNA1204310_P_NODE_11455_length_519_cov_1.636771_g11159_i0	PRJNA1204310	11455	519	1.636771	8.49484149	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	126	2.9499999999999994e-24	NTclustered	gi\|8101942\|gb\|AF262347.1\|	51768	g11159	i0	96.104	16.4200385356455	77	3	15	0	443	519	769	693	Alcyonium digitatum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	8522	126	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Alcyoniidae	Alcyonium	Alcyonium digitatum
18896465	18896465	PRJNA1204310_P_NODE_12115_length_506_cov_1.780600_g11818_i0	PRJNA1204310	12115	506	1.7806	9.009836	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.049	NTclustered	gi\|2917940687\|emb\|OZ237555.1\|	6108	g11818	i0	100	0.49802371541502	28	0	6	0	309	336	566531	566504	Anemonia sulcata genome assembly, chromosome: 1	blastn	252	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata

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