metadata: contig_metadata: 8 rows where bioproject = "PRJNA624323", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA624323", tax_clade = "Opisthokonta" and tax_phylum = "Chordata"

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
1872388	1872388	PRJNA624323_P_NODE_7302_length_263_cov_1.215789_g7140_i0	PRJNA624323	7302	263	1.215789	3.19752507	Sphaerodactylus townsendi	933632	Chordata	Chordata	52.8	0.024	NTclustered	gi\|2247582609\|ref\|XR_007243838.1\|	933632	g7140	i0	100	0.425855513307985	28	0	11	0	5	32	2705	2678	PREDICTED: Sphaerodactylus townsendi uncharacterized LOC125428457 (LOC125428457), transcript variant X1, ncRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Sphaerodactylidae	Sphaerodactylus	Sphaerodactylus townsendi
6974819	6974819	PRJNA624323_P_NODE_6706_length_276_cov_1.517241_g6544_i0	PRJNA624323	6706	276	1.517241	4.18758516	Mus musculus	10090	Chordata	Chordata	243	1.4000000000000001e-59	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g6544	i0	84.959	0.891304347826087	246	30	88	7	11	253	299	58	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	246	243	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10800634	10800634	PRJNA624323_P_NODE_8009_length_251_cov_0.865169_g7847_i0	PRJNA624323	8009	251	0.865169	2.17157419	Mus musculus	10090	Chordata	Chordata	459	1.1499999999999996e-124	NTclustered	gi\|2261542687\|ref\|NM_001164787.2\|	10090	g7847	i0	99.603	100.494023904382	252	0	100	1	1	251	2689	2940	Mus musculus small proline-rich protein 2A2 (Sprr2a2), mRNA	blastn	25224	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
10800637	10800637	PRJNA624323_P_NODE_8449_length_248_cov_0.880000_g8287_i0	PRJNA624323	8449	248	0.88	2.1824	Sus scrofa	9823	Chordata	Chordata	102	2.2e-17	NTclustered	gi\|288785395\|dbj\|AK352077.1\|	9823	g8287	i0	92.958	183.395161290323	71	4	28	1	1	70	1174	1104	Sus scrofa mRNA, clone:UTR010001G01, expressed in uterus	blastn	45482	102	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
11353594	11353594	PRJNA624323_P_NODE_9469_length_241_cov_0.916667_g9307_i0	PRJNA624323	9469	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	446	8.519999999999999e-121	NTclustered	gi\|74184268\|dbj\|AK144063.1\|	10090	g9307	i0	100	53.0414937759336	241	0	100	0	1	241	2023	1783	Mus musculus adult male kidney cDNA, RIKEN full-length enriched library, clone:F530213H18 product:hypothetical CAMP factor containing protein, full insert sequence	blastn	12783	446	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13350576	13350576	PRJNA624323_P_NODE_9231_length_243_cov_0.905882_g9069_i0	PRJNA624323	9231	243	0.905882	2.20129326	Latimeria chalumnae	7897	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2721758661\|ref\|XM_064556620.1\|	7897	g9069	i0	94.286	0.720164609053498	35	2	14	0	176	210	655	689	PREDICTED: Latimeria chalumnae cap methyltransferase 1 (CMTR1), transcript variant X3, mRNA	blastn	175	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
30270399	30270399	PRJNA624323_P_NODE_7552_length_258_cov_2.081081_g7390_i0	PRJNA624323	7552	258	2.081081	5.36918898	Erpetoichthys calabaricus	27687	Chordata	Chordata	118	5.1899999999999995e-30	NR	XP_051791274.1	27687	g7390	i0	76.8	7.62790697674419	82	18	94.2	1	16	258	115	196	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	1968	118	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
30996913	30996913	PRJNA624323_P_NODE_2394_length_476_cov_2.285360_g2233_i0	PRJNA624323	2394	476	2.28536	10.8783136	Leucoraja erinaceus	7782	Chordata	Chordata	72	1.18e-11	NR	XP_055493235.1	7782	g2233	i0	60.4	0.995798319327731	53	21	33.4	0	271	429	114	166	XP_055493235.1 uncharacterized protein LOC129698247 [Leucoraja erinaceus]	diamond	474	72	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Rajiformes	Rajidae	Leucoraja	Leucoraja erinaceus

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