contig_metadata
20 rows where bioproject = "PRJNA813520" and tax_phylum = "Streptophyta"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 815053 | 815053 | PRJNA813520_S_NODE_2341_length_238_cov_5.732057_g2294_i0 | PRJNA813520 | 2341 | 238 | 5.732057 | 13.64229566 | Cucumis melo | 3656 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|733594520|emb|LN681835.1| | 3656 | g2294 | i0 | 100 | 0.382352941176471 | 30 | 0 | 13 | 0 | 37 | 66 | 119592 | 119563 | Cucumis melo genomic scaffold, anchoredscaffold00064 | blastn | 91 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 2090714 | 2090714 | PRJNA813520_S_NODE_1022_length_346_cov_88.706625_g975_i0 | PRJNA813520 | 1022 | 346 | 88.706625 | 306.9249225 | Picea abies | 3329 | Plants | Plants | 60.2 | 1.96e-4 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g975 | i0 | 92.857 | 0.121387283236994 | 42 | 1 | 12 | 2 | 28 | 68 | 20 | 60 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 42 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 2500886 | 2500886 | PRJNA813520_S_NODE_1502_length_295_cov_6.187970_g1455_i0 | PRJNA813520 | 1502 | 295 | 6.18797 | 18.2545115 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g1455 | i0 | 100 | 0.284745762711864 | 28 | 0 | 9 | 0 | 4 | 31 | 6 | 33 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 3365903 | 3365903 | PRJNA813520_S_NODE_263_length_624_cov_8.522689_g229_i0 | PRJNA813520 | 263 | 624 | 8.522689 | 53.18157936 | Arabidopsis thaliana | 3702 | Plants | Plants | 54.7 | 0.017 | NTclustered | gi|1862939915|emb|LR797790.1| | 3702 | g229 | i0 | 96.875 | 0.153846153846154 | 32 | 1 | 5 | 0 | 423 | 454 | 7489738 | 7489769 | Arabidopsis thaliana genome assembly, chromosome: 4 | blastn | 96 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 3365927 | 3365927 | PRJNA813520_S_NODE_703_length_407_cov_9.230159_g656_i0 | PRJNA813520 | 703 | 407 | 9.230159 | 37.56674713 | Picea abies | 3329 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g656 | i0 | 100 | 0.14004914004914 | 29 | 0 | 7 | 0 | 379 | 407 | 57 | 29 | Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 3777243 | 3777243 | PRJNA813520_S_NODE_1023_length_346_cov_87.369085_g976_i0 | PRJNA813520 | 1023 | 346 | 87.369085 | 302.2970341 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.033 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g976 | i0 | 100 | 0.173410404624277 | 28 | 0 | 8 | 0 | 4 | 31 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 60 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 3777251 | 3777251 | PRJNA813520_S_NODE_623_length_428_cov_13.436090_g576_i0 | PRJNA813520 | 623 | 428 | 13.43609 | 57.5064652 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.041 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g576 | i0 | 100 | 0.130841121495327 | 28 | 0 | 7 | 0 | 398 | 425 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 5918382 | 5918382 | PRJNA813520_S_NODE_2845_length_216_cov_159.251337_g2798_i0 | PRJNA813520 | 2845 | 216 | 159.251337 | 343.98288792 | Picea abies | 3329 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g2798 | i0 | 94.595 | 0.300925925925926 | 37 | 0 | 17 | 2 | 154 | 189 | 55 | 20 | Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds | blastn | 65 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 7603476 | 7603476 | PRJNA813520_S_NODE_2886_length_215_cov_29.177419_g2839_i0 | PRJNA813520 | 2886 | 215 | 29.177419 | 62.73145085 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.019 | NTclustered | gi|2835530366|dbj|LC777195.1| | 3329 | g2839 | i0 | 100 | 0.911627906976744 | 28 | 0 | 13 | 0 | 4 | 31 | 28 | 55 | Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds | blastn | 196 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 8468036 | 8468036 | PRJNA813520_S_NODE_7_length_2527_cov_36.901521_g6_i0 | PRJNA813520 | 7 | 2527 | 36.901521 | 932.50143567 | Picea abies | 3329 | Plants | Plants | 60.2 | 0.002 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g6 | i0 | 91.304 | 0.0182034032449545 | 46 | 0 | 2 | 4 | 28 | 70 | 20 | 64 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 46 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 8878506 | 8878506 | PRJNA813520_S_NODE_4227_length_177_cov_19.587838_g4180_i0 | PRJNA813520 | 4227 | 177 | 19.587838 | 34.67047326 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.015 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g4180 | i0 | 100 | 0.31638418079096 | 28 | 0 | 16 | 0 | 4 | 31 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 10153962 | 10153962 | PRJNA813520_S_NODE_3408_length_198_cov_8.887574_g3361_i0 | PRJNA813520 | 3408 | 198 | 8.887574 | 17.59739652 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.017 | NTclustered | gi|2835530370|dbj|LC777197.1| | 3329 | g3361 | i0 | 100 | 0.707070707070707 | 28 | 0 | 14 | 0 | 168 | 195 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 13568658 | 13568658 | PRJNA813520_S_NODE_391_length_526_cov_25.525151_g350_i0 | PRJNA813520 | 391 | 526 | 25.525151 | 134.26229426 | Jacobaea vulgaris | 98722 | Plants | Plants | 58.4 | 0.001 | NTclustered | gi|2918395481|emb|OZ238157.1| | 98722 | g350 | i0 | 100 | 0.11787072243346 | 31 | 0 | 6 | 0 | 298 | 328 | 17123696 | 17123726 | Jacobaea vulgaris genome assembly, chromosome: 9 | blastn | 62 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Jacobaea | Jacobaea vulgaris | |
| 17393414 | 17393414 | PRJNA813520_S_NODE_3114_length_207_cov_149.544944_g3067_i0 | PRJNA813520 | 3114 | 207 | 149.544944 | 309.55803408 | Picea abies | 3329 | Plants | Plants | 62.1 | 3.01e-5 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g3067 | i0 | 93.182 | 0.21256038647343 | 44 | 0 | 21 | 3 | 138 | 180 | 61 | 20 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 44 | 62.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 17393431 | 17393431 | PRJNA813520_S_NODE_5254_length_158_cov_3.217054_g5207_i0 | PRJNA813520 | 5254 | 158 | 3.217054 | 5.08294532 | Brassica rapa | 3711 | Plants | Plants | 52.8 | 0.013 | NTclustered | gi|1516534800|emb|LR031575.1| | 3711 | g5207 | i0 | 100 | 0.177215189873418 | 28 | 0 | 18 | 0 | 49 | 76 | 14587292 | 14587265 | Brassica rapa genome, scaffold: A08 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 18666492 | 18666492 | PRJNA813520_S_NODE_115_length_921_cov_84.159193_g95_i0 | PRJNA813520 | 115 | 921 | 84.159193 | 775.10616753 | Picea abies | 3329 | Plants | Plants | 56.5 | 0.007 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g95 | i0 | 94.595 | 0.0401737242128122 | 37 | 0 | 4 | 2 | 859 | 894 | 55 | 20 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 37 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 21217147 | 21217147 | PRJNA813520_S_NODE_177_length_751_cov_26.626039_g149_i0 | PRJNA813520 | 177 | 751 | 26.626039 | 199.96155289 | Malania oleifera | 397392 | Plants | Plants | 58.4 | 0.002 | NTclustered | gi|2532233495|ref|XR_009133862.1| | 397392 | g149 | i0 | 94.595 | 0.0492676431424767 | 37 | 2 | 5 | 0 | 482 | 518 | 540 | 504 | PREDICTED: Malania oleifera uncharacterized LOC131144648 (LOC131144648), ncRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Ximeniaceae | Malania | Malania oleifera | |
| 22491850 | 22491850 | PRJNA813520_S_NODE_378_length_535_cov_62.292490_g337_i0 | PRJNA813520 | 378 | 535 | 62.29249 | 333.2648215 | Picea abies | 3329 | Plants | Plants | 60.2 | 3.14e-4 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g337 | i0 | 94.872 | 0.0728971962616822 | 39 | 0 | 7 | 2 | 28 | 65 | 20 | 57 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 39 | 60.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 25452051 | 25452051 | PRJNA813520_S_NODE_1840_length_268_cov_12.874477_g1793_i0 | PRJNA813520 | 1840 | 268 | 12.874477 | 34.50359836 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.025 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g1793 | i0 | 100 | 0.313432835820896 | 28 | 0 | 10 | 0 | 238 | 265 | 33 | 6 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 25452056 | 25452056 | PRJNA813520_S_NODE_520_length_467_cov_18.452055_g473_i0 | PRJNA813520 | 520 | 467 | 18.452055 | 86.17109685 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.045 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g473 | i0 | 100 | 0.119914346895075 | 28 | 0 | 6 | 0 | 437 | 464 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies |
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);;