metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA345071" 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
1070390	1070390	PRJNA345071_P_NODE_8161_length_251_cov_0.876404_g8121_i0	PRJNA345071	8161	251	0.876404	2.19977404	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|31335544\|emb\|BX000698.11\|	10090	g8121	i0	100	0.223107569721116	28	0	11	0	175	202	52058	52031	Mouse DNA sequence from clone RP23-460G6 on chromosome X, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
1668124	1668124	PRJNA345071_P_NODE_9902_length_245_cov_0.906977_g9862_i0	PRJNA345071	9902	245	0.906977	2.22209365	Pithys albifrons	265642	Chordata	Chordata	237	5.69e-58	NTclustered	gi\|2917191626\|ref\|XM_071579071.1\|	3385563	g9862	i0	85.043	113.481632653061	234	33	95	2	13	245	804	1036	PREDICTED: Pithys albifrons albifrons methionine adenosyltransferase 2A (MAT2A), mRNA	blastn	27803	237	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Thamnophilidae	Pithys	Pithys albifrons
2943968	2943968	PRJNA345071_P_NODE_2703_length_358_cov_1.438596_g2663_i0	PRJNA345071	2703	358	1.438596	5.15017368	Xenopus laevis	8355	Chordata	Chordata	241	6.74e-59	NTclustered	gi\|148224669\|ref\|NM_001097658.1\|	8355	g2663	i0	78.947	22.9860335195531	361	70	100	5	1	358	467	110	Xenopus laevis uncharacterized LOC100036877 (LOC100036877), mRNA	blastn	8229	241	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
2944126	2944126	PRJNA345071_P_NODE_9983_length_245_cov_0.906977_g9943_i0	PRJNA345071	9983	245	0.906977	2.22209365	Mus musculus	10090	Chordata	Chordata	248	2.6299999999999997e-61	NTclustered	gi\|53384972\|gb\|AC134555.4\|	10090	g9943	i0	100	58.8122448979592	134	0	55	0	112	245	35085	34952	Mus musculus BAC clone RP24-320K4 from 17, complete sequence	blastn	14409	248	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4220700	4220700	PRJNA345071_P_NODE_8424_length_250_cov_0.881356_g8384_i0	PRJNA345071	8424	250	0.881356	2.20339	Mus musculus	10090	Chordata	Chordata	462	8.83e-126	NTclustered	gi\|82734402\|gb\|AC139295.5\|	10090	g8384	i0	100	2	250	0	100	0	1	250	164341	164590	Mus musculus BAC clone RP24-131B6 from chromosome 1, complete sequence	blastn	500	462	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
6770953	6770953	PRJNA345071_P_NODE_3526_length_327_cov_1.228346_g3486_i0	PRJNA345071	3526	327	1.228346	4.01669142	Lethenteron reissneri	7753	Chordata	Chordata	152	2.9499999999999997e-32	NTclustered	gi\|2635911409\|ref\|XM_061576725.1\|	7753	g3486	i0	82.286	1.09174311926605	175	31	54	0	133	307	434	260	PREDICTED: Lethenteron reissneri cytochrome c (LOC133358403), mRNA	blastn	357	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
6771070	6771070	PRJNA345071_P_NODE_8286_length_251_cov_0.870787_g8246_i0	PRJNA345071	8286	251	0.870787	2.18567537	Lepidochelys kempii	8472	Chordata	Chordata	320	5.65e-83	NTclustered	gi\|2911445960\|emb\|OZ223573.1\|	8472	g8246	i0	90.535	2.90438247011952	243	21	96	2	10	251	32233366	32233607	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 15	blastn	729	320	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
8046731	8046731	PRJNA345071_P_NODE_9107_length_248_cov_0.891429_g9067_i0	PRJNA345071	9107	248	0.891429	2.21074392	Mus musculus	10090	Chordata	Chordata	459	1.13e-124	NTclustered	gi\|50540835\|gb\|AC132832.13\|	10090	g9067	i0	100	1	248	0	100	0	1	248	143898	143651	Mus musculus chromosome 9, clone RP23-48D19, complete sequence	blastn	248	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9321247	9321247	PRJNA345071_P_NODE_10028_length_244_cov_3.099415_g9988_i0	PRJNA345071	10028	244	3.099415	7.5625726	Mus musculus	10090	Chordata	Chordata	451	1.86e-122	NTclustered	gi\|45504235\|gb\|AC025794.9\|	10090	g9988	i0	100	3	244	0	100	0	1	244	155138	155381	Mus musculus chromosome 19, clone RP23-62O7, complete sequence	blastn	732	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9321251	9321251	PRJNA345071_P_NODE_10248_length_244_cov_0.912281_g10208_i0	PRJNA345071	10248	244	0.912281	2.22596564	Canis lupus	9612	Chordata	Chordata	54.7	0.006	NTclustered	gi\|124378292\|gb\|AC187984.8\|	9615	g10208	i0	100	0.118852459016393	29	0	12	0	91	119	24983	25011	Canis Familiaris chromosome 11, clone XX-488H24, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
10596991	10596991	PRJNA345071_P_NODE_11069_length_235_cov_2.314815_g11029_i0	PRJNA345071	11069	235	2.314815	5.43981525	Pyrrhula murina	928672	Chordata	Chordata	58.4	4.53e-4	NTclustered	gi\|2920008285\|emb\|OZ239018.1\|	928672	g11029	i0	81.333	8.97872340425532	75	11	31	2	162	233	6587721	6587647	Pyrrhula murina genome assembly, chromosome: 23	blastn	2110	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Pyrrhula	Pyrrhula murina
10597009	10597009	PRJNA345071_P_NODE_1549_length_444_cov_2.040431_g1509_i0	PRJNA345071	1549	444	2.040431	9.05951364	Rattus norvegicus	10116	Chordata	Chordata	316	1.38e-81	NTclustered	gi\|298899322\|emb\|FQ215683.1\|	10116	g1509	i0	80.583	77.9481981981982	412	78	93	2	27	437	66	476	Rattus norvegicus TL0ACA47YD07 mRNA sequence	blastn	34609	316	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Rattus	Rattus norvegicus
11871982	11871982	PRJNA345071_P_NODE_4390_length_303_cov_1.260870_g4350_i0	PRJNA345071	4390	303	1.26087	3.8204361	Mus musculus	10090	Chordata	Chordata	52.8	0.028	NTclustered	gi\|49615225\|gb\|AC115787.6\|	10090	g4350	i0	100	0.0924092409240924	28	0	9	0	223	250	55087	55060	Mus musculus chromosome 16, clone RP23-212P1, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
11872069	11872069	PRJNA345071_P_NODE_9070_length_248_cov_0.891429_g9030_i0	PRJNA345071	9070	248	0.891429	2.21074392	Mus musculus	10090	Chordata	Chordata	52.8	0.022	NTclustered	gi\|68131788\|gb\|AC102011.9\|	10090	g9030	i0	100	0.225806451612903	28	0	11	0	69	96	138319	138292	Mus musculus chromosome 5, clone RP24-536B19, complete sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
13146910	13146910	PRJNA345071_P_NODE_1651_length_433_cov_1.811111_g1611_i0	PRJNA345071	1651	433	1.811111	7.84211063	Latimeria chalumnae	7897	Chordata	Chordata	82.4	5.33e-11	NTclustered	gi\|2721753609\|ref\|XR_010400111.1\|	7897	g1611	i0	84.884	1.68360277136259	86	7	19	5	52	134	271	353	PREDICTED: Latimeria chalumnae uncharacterized LOC102351378 (LOC102351378), transcript variant X1, ncRNA	blastn	729	82.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
14422191	14422191	PRJNA345071_P_NODE_8412_length_250_cov_0.881356_g8372_i0	PRJNA345071	8412	250	0.881356	2.20339	Mus musculus	10090	Chordata	Chordata	239	1.62e-58	NTclustered	gi\|26098250\|dbj\|AK079052.1\|	10090	g8372	i0	100	5.804	129	0	52	0	122	250	3096	3224	Mus musculus adult male diencephalon cDNA, RIKEN full-length enriched library, clone:9330106H21 product:unclassifiable, full insert sequence	blastn	1451	239	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14422216	14422216	PRJNA345071_P_NODE_9852_length_245_cov_0.906977_g9812_i0	PRJNA345071	9852	245	0.906977	2.22209365	Mus musculus	10090	Chordata	Chordata	448	2.41e-121	NTclustered	gi\|33284912\|emb\|AL929452.9\|	10090	g9812	i0	99.592	1	245	1	100	0	1	245	61618	61862	Mouse DNA sequence from clone RP23-345L15 on chromosome X, complete sequence	blastn	245	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16970784	16970784	PRJNA345071_P_NODE_6934_length_261_cov_1.404255_g6894_i0	PRJNA345071	6934	261	1.404255	3.66510555	Oryctolagus cuniculus	9986	Chordata	Chordata	477	3.3099999999999986e-130	NTclustered	gi\|129270089\|ref\|NM_001082406.2\|	9986	g6894	i0	99.617	2	261	1	100	0	1	261	683	943	Oryctolagus cuniculus crystallin alpha A (CRYAA), mRNA	blastn	522	477	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
18244962	18244962	PRJNA345071_P_NODE_6055_length_273_cov_1.560000_g6015_i0	PRJNA345071	6055	273	1.56	4.2588	Lacerta agilis	80427	Chordata	Chordata	250	8.28e-62	NTclustered	gi\|1825684958\|ref\|XM_033159138.1\|	80427	g6015	i0	83.212	67.4505494505494	274	44	100	2	1	273	862	590	PREDICTED: Lacerta agilis protein phosphatase 1 catalytic subunit alpha (PPP1CA), mRNA	blastn	18414	250	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Lacerta	Lacerta agilis
22069834	22069834	PRJNA345071_P_NODE_4838_length_293_cov_1.981818_g4798_i0	PRJNA345071	4838	293	1.981818	5.80672674	Sorex fumeus	62283	Chordata	Chordata	161	4.33e-35	NTclustered	gi\|2506753746\|ref\|XM_056126147.1\|	62283	g4798	i0	82.873	4.86006825938567	181	29	61	2	73	252	385	206	PREDICTED: Sorex fumeus dynein light chain Tctex-type 1 (DYNLT1), mRNA	blastn	1424	161	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex fumeus
22747328	22747328	PRJNA345071_P_NODE_8778_length_249_cov_0.886364_g8738_i0	PRJNA345071	8778	249	0.886364	2.20704636	Petromyzontidae	7746	Chordata	Chordata	154	6.01e-33	NTclustered	gi\|2635856482\|ref\|XM_061562021.1\|	7753	g8738	i0	89.344	41.0240963855422	122	13	49	0	126	247	849	728	PREDICTED: Lethenteron reissneri 14-3-3 protein epsilon-like (LOC133348908), mRNA	blastn	10215	154	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
23345237	23345237	PRJNA345071_P_NODE_3239_length_337_cov_1.094697_g3199_i0	PRJNA345071	3239	337	1.094697	3.68912889	Stegostoma tigrinum	3053191	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2249234270\|ref\|XM_048531035.1\|	3053191	g3199	i0	90.476	1.46587537091988	42	4	12	0	279	320	18	59	PREDICTED: Stegostoma tigrinum DEAD (Asp-Glu-Ala-Asp) box polypeptide 43 (ddx43), mRNA	blastn	494	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Stegostomatidae	Stegostoma	Stegostoma tigrinum
24022182	24022182	PRJNA345071_P_NODE_6679_length_264_cov_1.633508_g6639_i0	PRJNA345071	6679	264	1.633508	4.31246112	Chordata	7711	Chordata	Chordata	89.8	1.84e-13	NTclustered	gi\|2487323182\|ref\|XM_055137610.1\|	42254	g6639	i0	92.063	26.030303030303	63	5	24	0	14	76	2873	2811	PREDICTED: Sorex araneus myosin heavy chain 7B (MYH7B), transcript variant X2, mRNA	blastn	6872	89.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex araneus
25296596	25296596	PRJNA345071_P_NODE_11080_length_234_cov_4.186335_g11040_i0	PRJNA345071	11080	234	4.186335	9.7960239	Lethenteron	94988	Chordata	Chordata	148	2.6e-31	NTclustered	gi\|2635924864\|ref\|XM_061580142.1\|	7753	g11040	i0	81.868	42.2094017094017	182	27	76	6	56	234	152	330	PREDICTED: Lethenteron reissneri ribosomal protein L5 (RPL5), mRNA	blastn	9877	148	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
25296622	25296622	PRJNA345071_P_NODE_800_length_579_cov_1.837945_g760_i0	PRJNA345071	800	579	1.837945	10.64170155	Muscicapidae	36291	Chordata	Chordata	228	8.849999999999999e-55	NTclustered	gi\|1020959124\|ref\|XM_005056511.2\|	59894	g760	i0	85.52	8.87564766839378	221	28	38	3	311	529	857	639	PREDICTED: Ficedula albicollis tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein gamma (YWHAG), mRNA	blastn	5139	228	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Muscicapidae	Ficedula	Ficedula albicollis

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