metadata: contig_metadata: 8 rows where bioproject = "PRJNA436017", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA436017", tax_kingdom = "Metazoa" 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
5534333	5534333	PRJNA436017_P_NODE_12365_length_240_cov_3.413793_g12067_i0	PRJNA436017	12365	240	3.413793	8.1931032	Pantachogon haeckeli	168769	Cnidaria	other_Eukaryota	145	3.46e-30	NTclustered	gi\|270271848\|gb\|GQ120079.1\|	168769	g12067	i0	82.249	68.325	169	28	70	2	1	168	535	702	Pantachogon haeckeli cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	16398	145	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Trachymedusae	Rhopalonematidae	Pantachogon	Pantachogon haeckeli
10634733	10634733	PRJNA436017_P_NODE_25769_length_160_cov_4.024390_g25471_i0	PRJNA436017	25769	160	4.02439	6.439024	Stylobates loisetteae	2601840	Cnidaria	other_Eukaryota	169	1.26e-37	NTclustered	gi\|1720101249\|gb\|MN266882.1\|	2601840	g25471	i0	86.452	9.7125	155	20	96	1	7	160	2935	2781	Stylobates loisetteae isolate Stylo large subunit ribosomal RNA gene, partial sequence	blastn	1554	169	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Stylobates	Stylobates loisetteae
15116810	15116810	PRJNA436017_P_NODE_15752_length_208_cov_1.824561_g15454_i0	PRJNA436017	15752	208	1.824561	3.79508688	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	6.539999999999999e-31	NR	QUL61907.1	6145	g15454	i0	83.8	39.2451923076923	68	11	98.1	0	1	204	52	119	QUL61907.1 cytochrome c oxidase subunit I, partial [Aurelia aurita]	diamond	8163	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Semaeostomeae	Ulmaridae	Aurelia	Aurelia aurita
18940478	18940478	PRJNA436017_P_NODE_15135_length_213_cov_1.943182_g14837_i0	PRJNA436017	15135	213	1.943182	4.13897766	Rhizostomeae	37535	Cnidaria	other_Eukaryota	132	2.34e-26	NTclustered	gi\|2862235116\|gb\|PQ647263.1\|	880218	g14837	i0	89.091	47.4647887323944	110	7	51	5	17	124	6892	6786	Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	10110	132	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Cepheidae	Cephea	Cephea cephea
22107427	22107427	PRJNA436017_P_NODE_24618_length_164_cov_2.070866_g24320_i0	PRJNA436017	24618	164	2.070866	3.39622024	Clytia sp. JRH-2014	1483203	Cnidaria	other_Eukaryota	159	7.84e-35	NTclustered	gi\|608606329\|gb\|KF962101.1\|	1483203	g24320	i0	86.486	90.9939024390244	148	16	89	4	1	146	282	137	Clytia sp. JRH-2014 voucher XMCL1 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	14923	159	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia sp. JRH-2014
27960203	27960203	PRJNA436017_P_NODE_17705_length_195_cov_1.221519_g17407_i0	PRJNA436017	17705	195	1.221519	2.38196205	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	87.4	1.64e-20	NR	XP_020914455.1	2652724	g17407	i0	71.4	10.5692307692308	63	18	96.9	0	194	6	33	95	XP_020914455.1 60S ribosomal protein L36 [Exaiptasia diaphana]	diamond	2061	87.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
28797381	28797381	PRJNA436017_P_NODE_23567_length_168_cov_1.290076_g23269_i0	PRJNA436017	23567	168	1.290076	2.16732768	Metazoa	33208	Cnidaria	other_Eukaryota	92	1.19e-20	NR	XP_031558145.1	6105	g23269	i0	80	8.83928571428571	55	11	98.2	0	167	3	13	67	XP_031558145.1 ADP,ATP carrier protein-like [Actinia tenebrosa]	diamond	1485	92.4	0.995670995670996	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
30297518	30297518	PRJNA436017_P_NODE_13152_length_231_cov_3.206186_g12854_i0	PRJNA436017	13152	231	3.206186	7.40628966	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	57.4	1.42e-7	NR	XP_001633436.1	45351	g12854	i0	84.8	0.428571428571429	33	5	42.9	0	99	1	90	122	XP_001633436.1 60S ribosomal protein L6 [Nematostella vectensis]	diamond	99	57.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis

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